org.projectnessie.versioned.persist.tx.SqlStatements Maven / Gradle / Ivy
/*
* Copyright (C) 2020 Dremio
*
* Licensed under the Apache License, Version 2.0 (the "License");
* you may not use this file except in compliance with the License.
* You may obtain a copy of the License at
*
* http://www.apache.org/licenses/LICENSE-2.0
*
* Unless required by applicable law or agreed to in writing, software
* distributed under the License is distributed on an "AS IS" BASIS,
* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
* See the License for the specific language governing permissions and
* limitations under the License.
*/
package org.projectnessie.versioned.persist.tx;
public final class SqlStatements {
public static final String TABLE_REPO_DESCRIPTION = "repo_desc";
public static final String DELETE_REPO_DESCRIPTIONE_ALL =
String.format("DELETE FROM %s WHERE \"repo_id\" = ?", TABLE_REPO_DESCRIPTION);
public static final String UPDATE_REPO_DESCRIPTION =
String.format(
"UPDATE %s SET \"repo_desc\" = ? WHERE \"repo_id\" = ? AND \"repo_desc\" = ?",
TABLE_REPO_DESCRIPTION);
public static final String INSERT_REPO_DESCRIPTION =
String.format(
"INSERT INTO %s (\"repo_id\", \"repo_desc\") VALUES (?, ?)", TABLE_REPO_DESCRIPTION);
public static final String SELECT_REPO_DESCRIPTION =
String.format("SELECT \"repo_desc\" FROM %s WHERE \"repo_id\" = ?", TABLE_REPO_DESCRIPTION);
public static final String CREATE_TABLE_REPO_DESCRIPTION =
String.format(
"CREATE TABLE %s (\n"
+ " \"repo_id\" {2},\n"
+ " \"repo_desc\" {0},\n"
+ " PRIMARY KEY (\"repo_id\")\n"
+ ")",
TABLE_REPO_DESCRIPTION);
public static final String TABLE_NAMED_REFERENCES = "named_refs";
public static final String DELETE_NAMED_REFERENCE_ALL =
String.format("DELETE FROM %s WHERE \"repo_id\" = ?", TABLE_NAMED_REFERENCES);
public static final String UPDATE_NAMED_REFERENCE =
String.format(
"UPDATE %s SET \"hash\" = ? WHERE \"repo_id\" = ? AND \"ref\" = ? AND \"hash\" = ?",
TABLE_NAMED_REFERENCES);
public static final String INSERT_NAMED_REFERENCE =
String.format(
"INSERT INTO %s (\"repo_id\", \"ref\", \"ref_type\", \"hash\") VALUES (?, ?, ?, ?)",
TABLE_NAMED_REFERENCES);
public static final String DELETE_NAMED_REFERENCE =
String.format(
"DELETE FROM %s WHERE \"repo_id\" = ? AND \"ref\" = ? AND \"hash\" = ?",
TABLE_NAMED_REFERENCES);
public static final String SELECT_NAMED_REFERENCES =
String.format(
"SELECT \"ref_type\", \"ref\", \"hash\" FROM %s WHERE \"repo_id\" = ?",
TABLE_NAMED_REFERENCES);
public static final String SELECT_NAMED_REFERENCE_NAME =
String.format(
"SELECT \"hash\" FROM %s WHERE \"repo_id\" = ? AND \"ref\" = ?", TABLE_NAMED_REFERENCES);
public static final String SELECT_NAMED_REFERENCE =
String.format(
"SELECT \"hash\" FROM %s WHERE \"repo_id\" = ? AND \"ref\" = ? AND \"ref_type\" = ?",
TABLE_NAMED_REFERENCES);
public static final String SELECT_NAMED_REFERENCE_ANY =
String.format(
"SELECT \"ref_type\", \"hash\" FROM %s WHERE \"repo_id\" = ? AND \"ref\" = ?",
TABLE_NAMED_REFERENCES);
public static final String CREATE_TABLE_NAMED_REFERENCES =
String.format(
"CREATE TABLE %s (\n"
+ " \"repo_id\" {2},\n"
+ " \"ref\" {4},\n"
+ " \"ref_type\" {5},\n"
+ " \"hash\" {1},\n"
+ " PRIMARY KEY (\"repo_id\", \"ref\")\n"
+ ")",
TABLE_NAMED_REFERENCES);
public static final String TABLE_GLOBAL_STATE = "global_state";
public static final String DELETE_GLOBAL_STATE_ALL =
String.format("DELETE FROM %s WHERE \"repo_id\" = ?", TABLE_GLOBAL_STATE);
public static final String SELECT_GLOBAL_STATE_MANY =
String.format(
"SELECT \"cid\", \"value\" FROM %s WHERE \"repo_id\" = ? AND \"cid\" IN (%%s)",
TABLE_GLOBAL_STATE);
public static final String CREATE_TABLE_GLOBAL_STATE =
String.format(
"CREATE TABLE %s (\n"
+ " \"repo_id\" {2},\n"
+ " \"cid\" {6},\n"
+ " \"chksum\" {1},\n"
+ " \"value\" {0},\n"
+ " \"created_at\" {7},\n"
+ " PRIMARY KEY (\"repo_id\", \"cid\")\n"
+ ")",
TABLE_GLOBAL_STATE);
public static final String TABLE_COMMIT_LOG = "commit_log";
public static final String DELETE_COMMIT_LOG_ALL =
String.format("DELETE FROM %s WHERE \"repo_id\" = ?", TABLE_COMMIT_LOG);
public static final String INSERT_COMMIT_LOG =
String.format(
"INSERT INTO %s (\"repo_id\", \"hash\", \"value\") VALUES (?, ?, ?)", TABLE_COMMIT_LOG);
public static final String UPDATE_COMMIT_LOG =
String.format(
"UPDATE %s SET \"value\" = ? WHERE \"repo_id\" = ? AND \"hash\" = ?", TABLE_COMMIT_LOG);
public static final String SELECT_COMMIT_LOG_FULL =
String.format("SELECT \"value\" FROM %s WHERE \"repo_id\" = ?", TABLE_COMMIT_LOG);
public static final String SELECT_COMMIT_LOG_MANY =
String.format(
"SELECT \"value\" FROM %s WHERE \"repo_id\" = ? AND \"hash\" IN (%%s)", TABLE_COMMIT_LOG);
public static final String SELECT_COMMIT_LOG =
String.format(
"SELECT \"value\" FROM %s WHERE \"repo_id\" = ? AND \"hash\" = ?", TABLE_COMMIT_LOG);
public static final String CREATE_TABLE_COMMIT_LOG =
String.format(
"CREATE TABLE %s (\n"
+ " \"repo_id\" {2},\n"
+ " \"hash\" {1},\n"
+ " \"value\" {0},\n"
+ " PRIMARY KEY (\"repo_id\", \"hash\")\n"
+ ")",
TABLE_COMMIT_LOG);
public static final String TABLE_KEY_LIST = "key_list";
public static final String DELETE_KEY_LIST_ALL =
String.format("DELETE FROM %s WHERE \"repo_id\" = ?", TABLE_KEY_LIST);
public static final String SELECT_KEY_LIST_MANY =
String.format(
"SELECT \"id\", \"value\" FROM %s WHERE \"repo_id\" = ? AND \"id\" IN (%%s)",
TABLE_KEY_LIST);
public static final String INSERT_KEY_LIST =
String.format(
"INSERT INTO %s (\"repo_id\", \"id\", \"value\") VALUES (?, ?, ?)", TABLE_KEY_LIST);
public static final String CREATE_TABLE_KEY_LIST =
String.format(
"CREATE TABLE %s (\n"
+ " \"repo_id\" {2},\n"
+ " \"id\" {1},\n"
+ " \"value\" {0},\n"
+ " PRIMARY KEY (\"repo_id\", \"id\")\n"
+ ")",
TABLE_KEY_LIST);
public static final String TABLE_REF_LOG = "ref_log";
public static final String INSERT_REF_LOG =
String.format(
"INSERT INTO %s (\"repo_id\", \"hash\", \"value\") VALUES (?, ?, ?)", TABLE_REF_LOG);
public static final String DELETE_REF_LOG_ALL =
String.format("DELETE FROM %s WHERE \"repo_id\" = ?", TABLE_REF_LOG);
public static final String SELECT_REF_LOG =
String.format(
"SELECT \"value\" FROM %s WHERE \"repo_id\" = ? AND \"hash\" = ?", TABLE_REF_LOG);
public static final String SELECT_REF_LOG_MANY =
String.format(
"SELECT \"value\" FROM %s WHERE \"repo_id\" = ? AND \"hash\" IN (%%s)", TABLE_REF_LOG);
public static final String CREATE_TABLE_REF_LOG =
// here 'hash' is ref_log_id, 'value' is proto serialized RefLogEntry
String.format(
"CREATE TABLE %s (\n"
+ " \"repo_id\" {2},\n"
+ " \"hash\" {1},\n"
+ " \"value\" {0},\n"
+ " PRIMARY KEY (\"repo_id\", \"hash\")\n"
+ ")",
TABLE_REF_LOG);
public static final String TABLE_REF_LOG_HEAD = "ref_log_head";
public static final String UPDATE_REF_LOG_HEAD =
String.format(
"UPDATE %s SET \"id\" = ?, \"parents\" = ? WHERE \"repo_id\" = ? AND \"id\" = ?",
TABLE_REF_LOG_HEAD);
public static final String INSERT_REF_LOG_HEAD =
String.format(
"INSERT INTO %s (\"repo_id\", \"id\", \"parents\") VALUES (?, ?, ?)", TABLE_REF_LOG_HEAD);
public static final String DELETE_REF_LOG_HEAD_ALL =
String.format("DELETE FROM %s WHERE \"repo_id\" = ?", TABLE_REF_LOG_HEAD);
public static final String SELECT_REF_LOG_HEAD =
String.format("SELECT \"id\", \"parents\" FROM %s WHERE \"repo_id\" = ?", TABLE_REF_LOG_HEAD);
public static final String CREATE_TABLE_REF_LOG_HEAD =
String.format(
"CREATE TABLE %s (\n"
+ " \"repo_id\" {2},\n"
+ " \"id\" {1},\n"
+ " \"parents\" {0},\n"
+ " PRIMARY KEY (\"repo_id\", \"id\")\n"
+ ")",
TABLE_REF_LOG_HEAD);
public static final String TABLE_ATTACHMENTS = "atts";
public static final String INSERT_ATTACHMENT =
String.format(
"INSERT INTO %s (\"repo_id\", \"id\", \"value\", \"ver\") VALUES (?, ?, ?, ?)",
TABLE_ATTACHMENTS);
public static final String UPDATE_ATTACHMENT =
String.format(
"UPDATE %s SET \"value\" = ?, \"ver\" = ? WHERE \"repo_id\" = ? AND \"id\" = ? AND \"ver\" = ?",
TABLE_ATTACHMENTS);
public static final String DELETE_ATTACHMENTS_ALL =
String.format("DELETE FROM %s WHERE \"repo_id\" = ?", TABLE_ATTACHMENTS);
public static final String DELETE_ATTACHMENTS =
String.format("DELETE FROM %s WHERE \"repo_id\" = ? AND \"id\" IN (%%s)", TABLE_ATTACHMENTS);
public static final String SELECT_ATTACHMENTS =
String.format(
"SELECT \"id\", \"value\" FROM %s WHERE \"repo_id\" = ? AND \"id\" IN (%%s)",
TABLE_ATTACHMENTS);
public static final String SELECT_ATTACHMENTS_KEYS =
String.format(
"SELECT \"id\" FROM %s WHERE \"repo_id\" = ? AND \"id\" > ? ORDER BY \"id\"",
TABLE_ATTACHMENTS);
public static final String CREATE_TABLE_ATTACHMENTS =
String.format(
"CREATE TABLE %s (\n"
+ " \"repo_id\" {2},\n"
+ " \"id\" {3},\n"
+ " \"value\" {0},\n"
+ " \"ver\" {1},\n"
+ " PRIMARY KEY (\"repo_id\", \"id\")\n"
+ ")",
TABLE_ATTACHMENTS);
private SqlStatements() {}
}
© 2015 - 2025 Weber Informatics LLC | Privacy Policy