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 abstract String	buildDeferrableForeignKey(ForeignKey.DeferMode deferMode)
protected String	buildForeignKey(ForeignKeyData fk)
protected String	buildGeneratedColumn(ColumnData column)
String	buildQuerySql(SQLQueryable<?> instance, Object[] params, QueryStructure queryStructure)
protected String	buildSelectBody(ViewStructure view)
protected void	buildTransactionOption(TransactionOption option, Set<TransactionOption> options2, List<String> lines)
String[]	buildTransactionOptions(Set<TransactionOption> options)
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(Table.Type joinType)
String	lockModeToString(LockMode lockMode)
@Qualified String	qualifiedName(Class<? extends SQLQueryable<?>> tableClass, Map<String,Object> queryableHints)
@Qualified String	qualifiedName(String value)
<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[] 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[][] 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)
protected final void	setCapability(DbmsCapability capability, boolean supported)
String[]	unqualifyName(@Qualified String qualifiedName)

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, lastQualifiedName, lastUnqualifiedName, memberToColumnName, qualifiedName, schemaName, statementToString, 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

buildTransactionOptions

public String[] buildTransactionOptions(Set<TransactionOption> options)

Specified by:

buildTransactionOptions in interface SQLStructureVisitor

buildTransactionOption

protected void buildTransactionOption(TransactionOption option,
 Set<TransactionOption> options2,
 List<String> lines)

buildQuerySql

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

Specified by:

buildQuerySql 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 @Qualified String qualifiedName(Class<? extends SQLQueryable<?>> tableClass,
 Map<String,Object> queryableHints)

Specified by:

qualifiedName in interface SQLStructureVisitor

qualifiedName

public @Qualified String qualifiedName(String value)

Specified by:

qualifiedName in interface SQLStructureVisitor

unqualifyName

public String[] unqualifyName(@Qualified String qualifiedName)

Specified by:

unqualifyName 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,
 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,
 LockMode lockMode,
 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(B table,
 String[] columns,
 String[] whereColumns,
 LockMode lockMode)

Specified by:

safeSelect in interface SQLStructureVisitor

lockModeToString

public String lockModeToString(LockMode lockMode)

Specified by:

lockModeToString 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[][] uniqueKeys,
 boolean[][] nullable)

Specified by:

safeSelectCountUniqueCollision in interface SQLStructureVisitor

safeSelectUniqueCollision

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

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)

buildDeferrableForeignKey

protected abstract String buildDeferrableForeignKey(ForeignKey.DeferMode deferMode)

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(Table.Type joinType)

setCapability

protected final void setCapability(DbmsCapability capability,
 boolean supported)