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

Interface SQLStructureVisitor

All Known Implementing Classes:

AbstractSQLStructureVisitor, MySQLStructureVisitor, PostgreSQLStructureVisitor, SQLiteStructureVisitor

public interface SQLStructureVisitor

Method Summary

Modifier and Type	Method	Description
<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)
<B extends SQLQueryable<T>, T extends DataBaseEntry> String	getQueryableName(Class<B> tableClass, Map<String,Object> queryableHints)
<B extends SQLQueryable<T>, T extends DataBaseEntry> String	qualifiedName(Class<B> clazz, Map<String,Object> queryableHints)
String	qualifiedName(String name)
default String	qualifiedName(String... names)
default <T extends DataBaseEntry> String	qualifiedName(SQLQueryable<T> table)
<B extends AbstractDBTable<T>, T extends DataBaseEntry> String	safeDelete(B table, String[] whereColumns)
<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[] 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)
default <B extends SQLQueryable<T>, T extends DataBaseEntry> String	schemaName(B table)

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

<B extends SQLQueryable<T>,
T extends DataBaseEntry>
String getQueryableName(Class<B> tableClass,
 Map<String,Object> queryableHints)

qualifiedName

<B extends SQLQueryable<T>,
T extends DataBaseEntry>
String qualifiedName(Class<B> clazz,
 Map<String,Object> queryableHints)

qualifiedName

default <T extends DataBaseEntry> String qualifiedName(SQLQueryable<T> table)

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)

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[] 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)

schemaName

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