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

Class AbstractSQLStructureVisitor

java.lang.Object

lu.kbra.pclib.db.domain.dialect.AbstractSQLStructureVisitor

All Implemented Interfaces:

SQLStructureVisitor, SQLStructureVisitorOptionsOwner

Direct Known Subclasses:

MySQLStructureVisitor, PostgreSQLStructureVisitor, SQLiteStructureVisitor

public abstract class AbstractSQLStructureVisitor
extends Object
implements SQLStructureVisitor

Constructor Summary

Constructors

Modifier	Constructor	Description
protected	AbstractSQLStructureVisitor()

Method Summary

Modifier and Type	Method	Description
protected void	appendWhereGroupOrder(StringBuilder sql, String condition, String[] groupBy, ViewOrderStructure[] orderBy)
protected String	buildAlias(ViewColumnStructure column)
protected String	buildColumn(TableStructure table, ColumnData column, boolean inlinePrimaryKey)
protected String	buildColumnSQL(UnionTableStructure table, ViewColumnStructure column)
protected String	buildColumnSQL(ViewColumnStructure column)
protected String	buildColumnSQL(ViewTableStructure table, ViewColumnStructure column)
protected String	buildConstraint(ConstraintData constraint)
protected String	buildForeignKey(ForeignKeyData fk)
protected String	buildGeneratedColumn(ColumnData column)
String	buildParameterQuerySql(SQLQueryable<?> instance, List<DefaultSQLQueryFunctionProvider.ParameterQueryPart> whereParts, List<String> orderByParts, DefaultSQLQueryFunctionProvider.ParameterQueryPart limitPart, DefaultSQLQueryFunctionProvider.ParameterQueryPart offsetPart, DefaultSQLQueryFunctionProvider.ReturnMapping returnMapping)
protected String	buildSelectBody(ViewStructure view)
protected String	buildUnionSQL(UnionTableStructure table)
protected String	buildWithSQL(ViewCommonTableExpressionStructure with)
protected String	cast(EncodingType<?> encodingType)
<B extends SQLQueryable<T>, T extends DatabaseEntry> String	count(B queryable)
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)
protected abstract String	escapeEnd()
protected String	escapeList(String[] columns)
protected String	escapeList(ColumnData[] columns)
protected abstract String	escapeStart()
protected ColumnData	findInlinePrimaryKey(TableStructure table)
final Map<DbmsCapability,Boolean>	getCapabilities()
Map<String,Object>	getOptions()
String	getQueryableName(Class<? extends SQLQueryable<?>> tableClass, Map<String,Object> queryableHints)
String[]	getQueryableNameParts(Class<? extends SQLQueryable<?>> tableClass, Map<String,Object> queryableHints)
<T extends DatabaseEntry> String	getTruncateSQL(AbstractDBTable<T> queryable)
boolean	isRawExpression(String identifier)
protected String	joinKeyword(ViewTable.Type joinType)
String	qualifiedName(Class<? extends SQLQueryable<?>> tableClass, Map<String,Object> queryableHints)
String	qualifiedName(String value)
protected String	qualifiedStructureName(TableStructure table)
protected String	qualifiedStructureName(ViewStructure view)
<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[] whereColumns, 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[][] whereColumns)
<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)
protected final void	setCapability(DbmsCapability capability, boolean supported)

Methods inherited from class java.lang.Object

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

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

create, fieldToColumnName, qualifiedName, schemaName, supports

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

getOption, getOptionOrDefault, getOptionOrDefault, hasOption, setOption, unsertOption

Constructor Details

AbstractSQLStructureVisitor

protected AbstractSQLStructureVisitor()

Method Details

buildParameterQuerySql

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

Specified by:

buildParameterQuerySql in interface SQLStructureVisitor

cast

protected String cast(EncodingType<?> encodingType)

count

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

Specified by:

count in interface SQLStructureVisitor

create

public String[] create(TableStructure table)

Specified by:

create in interface SQLStructureVisitor

create

public String create(TableStructure table,
 ColumnData column)

Specified by:

create in interface SQLStructureVisitor

create

public String[] create(ViewStructure view)

Specified by:

create in interface SQLStructureVisitor

drop

public String drop(DatabaseStructure databaseStructure)

Specified by:

drop in interface SQLStructureVisitor

drop

public String drop(TableStructure tableStructure)

Specified by:

drop in interface SQLStructureVisitor

drop

public String drop(ViewStructure tableStructure)

Specified by:

drop in interface SQLStructureVisitor

getOptions

public Map<String,Object> getOptions()

Specified by:

getOptions in interface SQLStructureVisitorOptionsOwner

getQueryableName

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

Specified by:

getQueryableName in interface SQLStructureVisitor

getQueryableNameParts

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

Specified by:

getQueryableNameParts in interface SQLStructureVisitor

getTruncateSQL

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

Specified by:

getTruncateSQL in interface SQLStructureVisitor

isRawExpression

public boolean isRawExpression(String identifier)

qualifiedName

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

Specified by:

qualifiedName in interface SQLStructureVisitor

qualifiedName

public String qualifiedName(String value)

Specified by:

qualifiedName in interface SQLStructureVisitor

safeDelete

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

Specified by:

safeDelete in interface SQLStructureVisitor

safeDelete

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

Specified by:

safeDelete in interface SQLStructureVisitor

safeInsert

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

Specified by:

safeInsert in interface SQLStructureVisitor

safeSelect

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

Specified by:

safeSelect in interface SQLStructureVisitor

safeSelect

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

Specified by:

safeSelect in interface SQLStructureVisitor

safeSelect

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

Specified by:

safeSelect in interface SQLStructureVisitor

safeSelect

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

Specified by:

safeSelect in interface SQLStructureVisitor

safeSelect

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

Specified by:

safeSelect in interface SQLStructureVisitor

safeSelectCountUniqueCollision

public <B extends SQLQueryable<T>,
T extends DatabaseEntry>
String safeSelectCountUniqueCollision(B instance,
 String[][] whereColumns)

Specified by:

safeSelectCountUniqueCollision in interface SQLStructureVisitor

safeSelectUniqueCollision

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

Specified by:

safeSelectUniqueCollision in interface SQLStructureVisitor

safeUpdate

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

Specified by:

safeUpdate in interface SQLStructureVisitor

safeUpdateExpr

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

Specified by:

safeUpdateExpr in interface SQLStructureVisitor

appendWhereGroupOrder

protected void appendWhereGroupOrder(StringBuilder sql,
 String condition,
 String[] groupBy,
 ViewOrderStructure[] orderBy)

buildAlias

protected String buildAlias(ViewColumnStructure column)

buildColumn

protected String buildColumn(TableStructure table,
 ColumnData column,
 boolean inlinePrimaryKey)

buildColumnSQL

protected String buildColumnSQL(UnionTableStructure table,
 ViewColumnStructure column)

buildColumnSQL

protected String buildColumnSQL(ViewColumnStructure column)

buildColumnSQL

protected String buildColumnSQL(ViewTableStructure table,
 ViewColumnStructure column)

buildConstraint

protected String buildConstraint(ConstraintData constraint)

buildForeignKey

protected String buildForeignKey(ForeignKeyData fk)

buildGeneratedColumn

protected String buildGeneratedColumn(ColumnData column)

buildSelectBody

protected String buildSelectBody(ViewStructure view)

buildUnionSQL

protected String buildUnionSQL(UnionTableStructure table)

buildWithSQL

protected String buildWithSQL(ViewCommonTableExpressionStructure with)

escapeEnd

protected abstract String escapeEnd()

escapeList

protected String escapeList(String[] columns)

escapeList

protected String escapeList(ColumnData[] columns)

escapeStart

protected abstract String escapeStart()

findInlinePrimaryKey

protected ColumnData findInlinePrimaryKey(TableStructure table)

getCapabilities

public final Map<DbmsCapability,Boolean> getCapabilities()

Specified by:

getCapabilities in interface SQLStructureVisitor

joinKeyword

protected String joinKeyword(ViewTable.Type joinType)

qualifiedStructureName

protected String qualifiedStructureName(TableStructure table)

qualifiedStructureName

protected String qualifiedStructureName(ViewStructure view)

setCapability

protected final void setCapability(DbmsCapability capability,
 boolean supported)