sirius.db.jdbc.schema

Class ClickhouseDatabaseDialect

java.lang.Object

sirius.db.jdbc.schema.BasicDatabaseDialect

sirius.db.jdbc.schema.ClickhouseDatabaseDialect

All Implemented Interfaces:

DatabaseDialect

public class ClickhouseDatabaseDialect
extends BasicDatabaseDialect

Defines the dialect used to sync the schema against a MySQL database.

Field Summary

Fields inherited from class sirius.db.jdbc.schema.BasicDatabaseDialect

DEFAULT_MAX_CONSTRAINT_NAME_LENGTH, KEY_CURRENT, KEY_TARGET

Constructor Summary

Constructors

Constructor and Description
ClickhouseDatabaseDialect()

Method Summary

Modifier and Type	Method and Description
String	generateAddColumn(Table table, TableColumn col) Generates an alter statement to add the given column.
String	generateAddForeignKey(Table table, ForeignKey key) Alters the table so that the given foreign key is added
String	generateAddKey(Table table, Key key) Alters the table so that the given key is added
List<String>	generateAlterColumnTo(Table table, String oldName, TableColumn toColumn) Alters the given column.
List<String>	generateAlterForeignKey(Table table, ForeignKey from, ForeignKey to) Alters the table so that the given foreign key is updated * @param table the table to alter
List<String>	generateAlterKey(Table table, Key from, Key to) Alters the table so that the given key is updated
List<String>	generateAlterPrimaryKey(Table table) Alters the table so that the PK is updated.
String	generateCreateTable(Table table) Builds a CREATE TABLE statement.
String	generateDropColumn(Table table, TableColumn col) Generates an alter statement to drop the given column.
String	generateDropForeignKey(Table table, ForeignKey key) Alters the table so that the given foreign key is dropped
String	generateDropKey(Table table, Key key) Alters the table so that the given key is dropped
protected String	getTypeName(TableColumn column)
boolean	isColumnCaseSensitive() Determines whether casing of columns should be fixed.
boolean	shouldDropKey(Table targetTable, Table currentTable, Key key) Determines if the given key should be dropped.

Methods inherited from class sirius.db.jdbc.schema.BasicDatabaseDialect

areColumnsEqual, areDefaultsDifferent, areTypesEqual, checkColumnSettings, checkForEquality, completeTableInfos, ensurePositiveLength, equalValue, generateDropTable, getConstraintCharacterLimit, getDefaultValueAsString, getEffectiveKeyName, getEngine, getJDBCType, hasEscapedDefaultValue, in, isNeedsQuotation, resolveType, translateColumnName

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

ClickhouseDatabaseDialect

public ClickhouseDatabaseDialect()

Method Detail

generateCreateTable

public String generateCreateTable(Table table)

Description copied from interface: DatabaseDialect

Builds a CREATE TABLE statement.

Parameters:

table - the table to create

Returns:

the generated SQL statement

getTypeName

protected String getTypeName(TableColumn column)

Overrides:

getTypeName in class BasicDatabaseDialect

generateAlterColumnTo

public List<String> generateAlterColumnTo(Table table,
                                          @Nullable
                                          String oldName,
                                          TableColumn toColumn)

Description copied from interface: DatabaseDialect

Alters the given column.

Parameters:

table - the table to alter

oldName - the old name of the column (if it was renamed)

toColumn - the column as expected in the schema

Returns:

the generated SQL statement

generateAddColumn

public String generateAddColumn(Table table,
                                TableColumn col)

Description copied from interface: DatabaseDialect

Generates an alter statement to add the given column.

Parameters:

table - the table to alter

col - the column to create

Returns:

the generated SQL statement

generateAddForeignKey

public String generateAddForeignKey(Table table,
                                    ForeignKey key)

Description copied from interface: DatabaseDialect

Alters the table so that the given foreign key is added

Specified by:

generateAddForeignKey in interface DatabaseDialect

Overrides:

generateAddForeignKey in class BasicDatabaseDialect

Parameters:

table - the table to alter

key - the key to add

Returns:

the generated SQL statement

generateAddKey

public String generateAddKey(Table table,
                             Key key)

Description copied from interface: DatabaseDialect

Alters the table so that the given key is added

Specified by:

generateAddKey in interface DatabaseDialect

Overrides:

generateAddKey in class BasicDatabaseDialect

Parameters:

table - the table to alter

key - the key to add

Returns:

the generated SQL statement

generateAlterForeignKey

public List<String> generateAlterForeignKey(Table table,
                                            ForeignKey from,
                                            ForeignKey to)

Description copied from interface: DatabaseDialect

Alters the table so that the given foreign key is updated * @param table the table to alter

Specified by:

generateAlterForeignKey in interface DatabaseDialect

Overrides:

generateAlterForeignKey in class BasicDatabaseDialect

Parameters:

table - the table to alter

from - the key as currently present in the database

to - the key as defined in the schema

Returns:

the generated SQL statements

generateAlterKey

public List<String> generateAlterKey(Table table,
                                     Key from,
                                     Key to)

Description copied from interface: DatabaseDialect

Alters the table so that the given key is updated

Specified by:

generateAlterKey in interface DatabaseDialect

Overrides:

generateAlterKey in class BasicDatabaseDialect

Parameters:

table - the table to alter

from - the key as currently present in the database

to - the key as defined in the schema

Returns:

the generated SQL statement

generateAlterPrimaryKey

public List<String> generateAlterPrimaryKey(Table table)

Description copied from interface: DatabaseDialect

Alters the table so that the PK is updated.

Specified by:

generateAlterPrimaryKey in interface DatabaseDialect

Overrides:

generateAlterPrimaryKey in class BasicDatabaseDialect

Parameters:

table - the table to alter

Returns:

the generated SQL statement

generateDropColumn

public String generateDropColumn(Table table,
                                 TableColumn col)

Description copied from interface: DatabaseDialect

Generates an alter statement to drop the given column.

Specified by:

generateDropColumn in interface DatabaseDialect

Overrides:

generateDropColumn in class BasicDatabaseDialect

Parameters:

table - the table to alter

col - the column to drop

Returns:

the generated SQL statement

generateDropForeignKey

public String generateDropForeignKey(Table table,
                                     ForeignKey key)

Description copied from interface: DatabaseDialect

Alters the table so that the given foreign key is dropped

Specified by:

generateDropForeignKey in interface DatabaseDialect

Overrides:

generateDropForeignKey in class BasicDatabaseDialect

Parameters:

table - the table to alter

key - the key to drop

Returns:

the generated SQL statement

generateDropKey

public String generateDropKey(Table table,
                              Key key)

Description copied from interface: DatabaseDialect

Alters the table so that the given key is dropped

Specified by:

generateDropKey in interface DatabaseDialect

Overrides:

generateDropKey in class BasicDatabaseDialect

Parameters:

table - the table to alter

key - the key to drop

Returns:

the generated SQL statement

isColumnCaseSensitive

public boolean isColumnCaseSensitive()

Description copied from interface: DatabaseDialect

Determines whether casing of columns should be fixed.

Returns:

true if column names are case sensitive

shouldDropKey

public boolean shouldDropKey(Table targetTable,
                             Table currentTable,
                             Key key)

Description copied from interface: DatabaseDialect

Determines if the given key should be dropped.

Parameters:

targetTable - the table being referenced

currentTable - the table referencing another

key - the key which defines the reference

Returns:

true if the key should be dropped, false otherwise