Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $
You can buy this project and download/modify it how often you want.
com.torodb.backend.AbstractStructureInterface Maven / Gradle / Ivy
/*
* ToroDB
* Copyright © 2014 8Kdata Technology (www.8kdata.com)
*
* This program is free software: you can redistribute it and/or modify
* it under the terms of the GNU Affero General Public License as published by
* the Free Software Foundation, either version 3 of the License, or
* (at your option) any later version.
*
* This program is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU Affero General Public License for more details.
*
* You should have received a copy of the GNU Affero General Public License
* along with this program. If not, see > columnList, boolean unique)
throws UserException {
if (!dbBackend.isOnDataInsertMode(schemaName)) {
Preconditions.checkArgument(!columnList.isEmpty(), "Can not create index on 0 columns");
String statement = getCreateIndexStatement(indexName, schemaName, tableName, columnList,
unique);
sqlHelper.executeUpdateOrThrow(dsl, statement, unique ? Context.ADD_UNIQUE_INDEX :
Context.CREATE_INDEX);
}
}
protected abstract String getCreateIndexStatement(String indexName, String schemaName,
String tableName, List> columnList, boolean unique);
@Override
public void dropIndex(DSLContext dsl, String schemaName, String indexName) {
String statement = getDropIndexStatement(schemaName, indexName);
sqlHelper.executeUpdate(dsl, statement, Context.DROP_INDEX);
}
@Override
public void dropAll(DSLContext dsl) {
dropUserDatabases(dsl, metaDataReadInterface);
metaDataReadInterface.getMetaTables().forEach(t -> dsl.dropTable(t).execute());
}
@Override
public void dropUserData(DSLContext dsl) {
dropUserDatabases(dsl, metaDataReadInterface);
metaDataReadInterface.getMetaTables().forEach(t ->
dsl.deleteFrom(t).execute()
);
}
/**
* This method drops all user databases (usually, db schemas).
*
* To implement this method, metainformation found on metatables can be acceded using the given
* {@link MetaDataReadInterface}.
*
* @param dsl
* @param metaReadInterface
*/
protected void dropUserDatabases(DSLContext dsl, MetaDataReadInterface metaDataReadInterface) {
metaDataReadInterface.readMetaDatabaseTable(dsl)
.forEach(dbRecord -> dropDatabase(dsl, dbRecord.getIdentifier()));
}
@Override
public Optional findTorodbSchema(DSLContext dsl, Meta jooqMeta) {
Schema torodbSchema = null;
for (Schema schema : jooqMeta.getSchemas()) {
if (identifierConstraints.isSameIdentifier(TorodbSchema.IDENTIFIER, schema.getName())) {
torodbSchema = schema;
break;
}
}
return Optional.ofNullable(torodbSchema);
}
@Override
@SuppressWarnings({"rawtypes", "unchecked"})
public void checkMetaDataTables(Schema torodbSchema) {
List> metaTables = metaDataReadInterface.getMetaTables();
for (SemanticTable metaTable : metaTables) {
String metaTableName = metaTable.getName();
boolean metaTableFound = false;
for (Table table : torodbSchema.getTables()) {
if (identifierConstraints.isSameIdentifier(table.getName(), metaTableName)) {
metaTable.checkSemanticallyEquals(table);
metaTableFound = true;
LOGGER.debug(table + " found and check");
}
}
if (!metaTableFound) {
throw new InvalidDatabaseException("The schema '" + TorodbSchema.IDENTIFIER + "'"
+ " does not contain the expected meta table '"
+ metaTableName + "'");
}
}
}
protected String getDropIndexStatement(String schemaName, String indexName) {
StringBuilder sb = new StringBuilder()
.append("DROP INDEX ")
.append("\"").append(schemaName).append("\"")
.append(".")
.append("\"").append(indexName).append("\"");
String statement = sb.toString();
return statement;
}
@Override
public void createSchema(DSLContext dsl, String schemaName) {
String statement = getCreateSchemaStatement(schemaName);
sqlHelper.executeUpdate(dsl, statement, Context.CREATE_SCHEMA);
}
protected abstract String getCreateSchemaStatement(String schemaName);
@Override
public void createRootDocPartTable(DSLContext dsl, String schemaName, String tableName,
TableRef tableRef) {
String statement = getCreateDocPartTableStatement(schemaName, tableName, metaDataReadInterface
.getInternalFields(tableRef));
sqlHelper.executeStatement(dsl, statement, Context.CREATE_TABLE);
}
@Override
public void createDocPartTable(DSLContext dsl, String schemaName, String tableName,
TableRef tableRef, String foreignTableName) {
String statement = getCreateDocPartTableStatement(schemaName, tableName, metaDataReadInterface
.getInternalFields(tableRef));
sqlHelper.executeStatement(dsl, statement, Context.CREATE_TABLE);
}
protected abstract String getCreateDocPartTableStatement(String schemaName, String tableName,
Collection> fields);
@Override
public Stream> streamRootDocPartTableIndexesCreation(
String schemaName, String tableName, TableRef tableRef) {
List> result = new ArrayList<>(1);
if (!dbBackend.isOnDataInsertMode(schemaName)) {
String primaryKeyStatement = getAddDocPartTablePrimaryKeyStatement(schemaName, tableName,
metaDataReadInterface.getPrimaryKeyInternalFields(tableRef));
result.add(dsl -> {
sqlHelper.executeStatement(dsl, primaryKeyStatement, Context.ADD_UNIQUE_INDEX);
return metaDataReadInterface.getPrimaryKeyInternalFields(tableRef).stream().map(f -> f
.getName()).collect(Collectors.joining("_")) + "_pkey";
});
}
return result.stream();
}
@Override
public Stream> streamDocPartTableIndexesCreation(String schemaName,
String tableName, TableRef tableRef, String foreignTableName) {
List> result = new ArrayList<>(4);
if (!dbBackend.isOnDataInsertMode(schemaName)) {
String primaryKeyStatement = getAddDocPartTablePrimaryKeyStatement(schemaName, tableName,
metaDataReadInterface.getPrimaryKeyInternalFields(tableRef));
result.add((dsl) -> {
sqlHelper.executeStatement(dsl, primaryKeyStatement, Context.ADD_UNIQUE_INDEX);
return "rid_pkey";
});
}
if (!dbBackend.isOnDataInsertMode(schemaName)) {
String readIndexStatement = getCreateDocPartTableIndexStatement(schemaName, tableName,
metaDataReadInterface.getReadInternalFields(tableRef));
result.add((dsl) -> {
sqlHelper.executeStatement(dsl, readIndexStatement, Context.CREATE_INDEX);
return metaDataReadInterface.getReadInternalFields(tableRef).stream()
.map(f -> f.getName()).collect(Collectors.joining("_")) + "_idx";
});
}
if (!dbBackend.isOnDataInsertMode(schemaName)) {
if (dbBackend.includeForeignKeys()) {
String foreignKeyStatement = getAddDocPartTableForeignKeyStatement(schemaName, tableName,
metaDataReadInterface.getReferenceInternalFields(tableRef),
foreignTableName, metaDataReadInterface.getForeignInternalFields(tableRef));
result.add((dsl) -> {
sqlHelper.executeStatement(dsl, foreignKeyStatement, Context.ADD_FOREIGN_KEY);
return metaDataReadInterface.getReferenceInternalFields(tableRef).stream().map(f -> f
.getName()).collect(Collectors.joining("_")) + "_fkey";
});
} else {
if (!tableRef.isRoot() && !tableRef.getParent().get().isRoot()) {
String foreignKeyIndexStatement = getCreateDocPartTableIndexStatement(
schemaName, tableName,
metaDataReadInterface.getReferenceInternalFields(tableRef));
result.add((dsl) -> {
sqlHelper.executeStatement(dsl, foreignKeyIndexStatement, Context.CREATE_INDEX);
return metaDataReadInterface.getReferenceInternalFields(tableRef).stream().map(f -> f
.getName()).collect(Collectors.joining("_")) + "_idx";
});
}
}
}
return result.stream();
}
@Override
public Stream> streamDataInsertFinishTasks(MetaDatabase db) {
return Collections.>emptySet().stream();
}
protected abstract String getAddDocPartTablePrimaryKeyStatement(String schemaName,
String tableName,
Collection> primaryKeyFields);
protected abstract String getAddDocPartTableForeignKeyStatement(String schemaName,
String tableName,
Collection> referenceFields, String foreignTableName,
Collection> foreignFields);
protected abstract String getCreateDocPartTableIndexStatement(String schemaName, String tableName,
Collection> indexedFields);
@Override
public void addColumnToDocPartTable(DSLContext dsl, String schemaName, String tableName,
String columnName, DataTypeForKv dataType) {
String statement = getAddColumnToDocPartTableStatement(schemaName, tableName, columnName,
dataType);
sqlHelper.executeStatement(dsl, statement, Context.ADD_COLUMN);
}
protected abstract String getAddColumnToDocPartTableStatement(String schemaName, String tableName,
String columnName, DataTypeForKv dataType);
}
