Package lu.kbra.pclib.db.domain.dialect

Interface SQLStructureVisitor

All Superinterfaces:

SQLStructureVisitorOptionsOwner

All Known Implementing Classes:

AbstractSQLStructureVisitor, MySQLStructureVisitor, PostgreSQLStructureVisitor, SQLiteStructureVisitor

public interface SQLStructureVisitor
extends SQLStructureVisitorOptionsOwner

Method Summary

Modifier and Type	Method	Description
String	buildQuerySql(SQLQueryable<?> instance, Object[] params, QueryStructure queryStructure)
String[]	buildTransactionOptions(Set<TransactionOption> options)
<B extends SQLQueryable<T>, T extends DatabaseEntry> String	count(B queryable)
String	create(DatabaseStructure db)
String[]	create(TableStructure table)
String	create(TableStructure table, ColumnData column)
String[]	create(ViewStructure view)
String	drop(DatabaseStructure databaseStructure)
String	drop(TableStructure tableStructure)
String	drop(ViewStructure tableStructure)
Map<DbmsCapability,Boolean>	getCapabilities()
String	getQueryableName(Class<? extends SQLQueryable<?>> tableClass, Map<String,Object> queryableHints)
String[]	getQueryableNameParts(Class<? extends SQLQueryable<?>> tableClazz, Map<String,Object> queryableHints)
<T extends DatabaseEntry> String	getTruncateSQL(AbstractDBTable<T> queryable)
default @Qualified String	lastQualifiedName(@Qualified String qualifiedName)
default String	lastUnqualifiedName(@Qualified String qualifiedName)
String	lockModeToString(LockMode lockMode)
default String	memberToColumnName(String name)
Map<MigrationPhase,List<String>>	migrate(SchemaDelta delta)
@Qualified String	qualifiedName(Class<? extends SQLQueryable<?>> clazz, Map<String,Object> queryableHints)
@Qualified String	qualifiedName(String name)
default @Qualified String	qualifiedName(String... names)
<B extends AbstractDBTable<T>, T extends DatabaseEntry> String	safeDelete(B table, String[] whereColumns)
<B extends AbstractDBTable<T>, T extends DatabaseEntry> String	safeDelete(B table, String[] whereColumns, int count)
<B extends AbstractDBTable<T>, T extends DatabaseEntry> String	safeInsert(B table, String[] columns)
<B extends SQLQueryable<T>, T extends DatabaseEntry> String	safeSelect(B table, String[] whereColumns)
<B extends SQLQueryable<T>, T extends DatabaseEntry> String	safeSelect(B table, String[] whereColumns, int count)
<B extends SQLQueryable<T>, T extends DatabaseEntry> String	safeSelect(B table, String[] columns, String[] whereColumns)
<B extends SQLQueryable<T>, T extends DatabaseEntry> String	safeSelect(B table, String[] columns, String[] whereColumns, int count)
<B extends SQLQueryable<T>, T extends DatabaseEntry> String	safeSelect(B table, String[] columns, String[] whereColumns, LockMode lockMode)
<B extends SQLQueryable<T>, T extends DatabaseEntry> String	safeSelect(B table, String[] columns, String[] whereColumns, LockMode lockMode, int count)
<B extends SQLQueryable<T>, T extends DatabaseEntry> String	safeSelect(SQLQueryable<T> instance, String[] cols, boolean limit, boolean offset)
<B extends SQLQueryable<T>, T extends DatabaseEntry> String	safeSelect(SQLQueryable<T> instance, String[] columns, String[] whereColumns, boolean limit, boolean offset)
<B extends SQLQueryable<T>, T extends DatabaseEntry> String	safeSelectCountUniqueCollision(B instance, String[][] uniqueKeys, boolean[][] nullable)
<B extends SQLQueryable<T>, T extends DatabaseEntry> String	safeSelectUniqueCollision(B instance, String[][] uniqueKeys, boolean[][] nullable)
<B extends AbstractDBTable<T>, T extends DatabaseEntry> String	safeUpdate(B table, String[] setColumns, String[] whereColumns)
<B extends AbstractDBTable<T>, T extends DatabaseEntry> String	safeUpdateExpr(B table, String[] setColumns, String[] whereColumns)
default <B extends SQLQueryable<T>, T extends DatabaseEntry> String	schemaName(B table)
String	statementToString(Statement stmt)
default boolean	supports(DbmsCapability capability)
String[]	unqualifyName(@Qualified String qualifiedName)

Methods inherited from interface lu.kbra.pclib.db.domain.dialect.SQLStructureVisitorOptionsOwner

getOption, getOptionOrDefault, getOptionOrDefault, getOptions, hasOption, setOption, unsertOption

Method Details

count

<B extends SQLQueryable<T>,
T extends DatabaseEntry>
String count(B queryable)

create

String create(DatabaseStructure db)

create

String[] create(TableStructure table)

create

String create(TableStructure table,
 ColumnData column)

create

String[] create(ViewStructure view)

drop

String drop(DatabaseStructure databaseStructure)

drop

String drop(TableStructure tableStructure)

drop

String drop(ViewStructure tableStructure)

memberToColumnName

default String memberToColumnName(String name)

getQueryableName

String getQueryableName(Class<? extends SQLQueryable<?>> tableClass,
 Map<String,Object> queryableHints)

getQueryableNameParts

String[] getQueryableNameParts(Class<? extends SQLQueryable<?>> tableClazz,
 Map<String,Object> queryableHints)

getTruncateSQL

<T extends DatabaseEntry> String getTruncateSQL(AbstractDBTable<T> queryable)

unqualifyName

String[] unqualifyName(@Qualified String qualifiedName)

lastUnqualifiedName

default String lastUnqualifiedName(@Qualified String qualifiedName)

lastQualifiedName

default @Qualified String lastQualifiedName(@Qualified String qualifiedName)

qualifiedName

@Qualified String qualifiedName(Class<? extends SQLQueryable<?>> clazz,
 Map<String,Object> queryableHints)

qualifiedName

@Qualified String qualifiedName(String name)

qualifiedName

default @Qualified String qualifiedName(String... names)

safeDelete

<B extends AbstractDBTable<T>,
T extends DatabaseEntry>
String safeDelete(B table,
 String[] whereColumns)

safeDelete

<B extends AbstractDBTable<T>,
T extends DatabaseEntry>
String safeDelete(B table,
 String[] whereColumns,
 int count)

safeInsert

<B extends AbstractDBTable<T>,
T extends DatabaseEntry>
String safeInsert(B table,
 String[] columns)

safeSelect

<B extends SQLQueryable<T>,
T extends DatabaseEntry>
String safeSelect(B table,
 String[] whereColumns)

safeSelect

<B extends SQLQueryable<T>,
T extends DatabaseEntry>
String safeSelect(B table,
 String[] whereColumns,
 int count)

safeSelect

<B extends SQLQueryable<T>,
T extends DatabaseEntry>
String safeSelect(B table,
 String[] columns,
 String[] whereColumns)

safeSelect

<B extends SQLQueryable<T>,
T extends DatabaseEntry>
String safeSelect(B table,
 String[] columns,
 String[] whereColumns,
 int count)

safeSelect

<B extends SQLQueryable<T>,
T extends DatabaseEntry>
String safeSelect(B table,
 String[] columns,
 String[] whereColumns,
 LockMode lockMode)

safeSelect

<B extends SQLQueryable<T>,
T extends DatabaseEntry>
String safeSelect(B table,
 String[] columns,
 String[] whereColumns,
 LockMode lockMode,
 int count)

safeSelect

<B extends SQLQueryable<T>,
T extends DatabaseEntry>
String safeSelect(SQLQueryable<T> instance,
 String[] cols,
 boolean limit,
 boolean offset)

safeSelect

<B extends SQLQueryable<T>,
T extends DatabaseEntry>
String safeSelect(SQLQueryable<T> instance,
 String[] columns,
 String[] whereColumns,
 boolean limit,
 boolean offset)

safeSelectCountUniqueCollision

<B extends SQLQueryable<T>,
T extends DatabaseEntry>
String safeSelectCountUniqueCollision(B instance,
 String[][] uniqueKeys,
 boolean[][] nullable)

safeSelectUniqueCollision

<B extends SQLQueryable<T>,
T extends DatabaseEntry>
String safeSelectUniqueCollision(B instance,
 String[][] uniqueKeys,
 boolean[][] nullable)

safeUpdate

<B extends AbstractDBTable<T>,
T extends DatabaseEntry>
String safeUpdate(B table,
 String[] setColumns,
 String[] whereColumns)

safeUpdateExpr

<B extends AbstractDBTable<T>,
T extends DatabaseEntry>
String safeUpdateExpr(B table,
 String[] setColumns,
 String[] whereColumns)

schemaName

default <B extends SQLQueryable<T>,
T extends DatabaseEntry>
String schemaName(B table)

lockModeToString

String lockModeToString(LockMode lockMode)

buildQuerySql

String buildQuerySql(SQLQueryable<?> instance,
 Object[] params,
 QueryStructure queryStructure)

getCapabilities

Map<DbmsCapability,Boolean> getCapabilities()

supports

default boolean supports(DbmsCapability capability)

statementToString

String statementToString(Statement stmt)

buildTransactionOptions

String[] buildTransactionOptions(Set<TransactionOption> options)

migrate

Map<MigrationPhase,List<String>> migrate(SchemaDelta delta)