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	buildParameterQuerySql(SQLQueryable<?> instance, List<DefaultSQLQueryFunctionProvider.ParameterQueryPart> whereParts, List<String> orderByParts, DefaultSQLQueryFunctionProvider.ParameterQueryPart limitPart, DefaultSQLQueryFunctionProvider.ParameterQueryPart offsetPart, DefaultSQLQueryFunctionProvider.ReturnMapping returnMapping)
<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)
default String	fieldToColumnName(String name)
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)
String	qualifiedName(Class<? extends SQLQueryable<?>> clazz, Map<String,Object> queryableHints)
String	qualifiedName(String name)
default 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(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[][] strings)
<B extends SQLQueryable<T>, T extends DatabaseEntry> String	safeSelectUniqueCollision(B instance, String[][] uniqueKeys)
<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)
default boolean	supports(DbmsCapability capability)

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)

fieldToColumnName

default String fieldToColumnName(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)

qualifiedName

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

qualifiedName

String qualifiedName(String name)

qualifiedName

default 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(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[][] strings)

safeSelectUniqueCollision

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

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)

buildParameterQuerySql

String buildParameterQuerySql(SQLQueryable<?> instance,
 List<DefaultSQLQueryFunctionProvider.ParameterQueryPart> whereParts,
 List<String> orderByParts,
 DefaultSQLQueryFunctionProvider.ParameterQueryPart limitPart,
 DefaultSQLQueryFunctionProvider.ParameterQueryPart offsetPart,
 DefaultSQLQueryFunctionProvider.ReturnMapping returnMapping)

getCapabilities

Map<DbmsCapability,Boolean> getCapabilities()

supports

default boolean supports(DbmsCapability capability)