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

Class AbstractSQLStructureVisitor

java.lang.Object

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

All Implemented Interfaces:

SQLStructureVisitor

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, List<String> groupBy, List<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(GeneratedColumnData column)
protected String	buildSelectBody(ViewStructure view)
protected String	buildUnionSQL(UnionTableStructure table)
protected String	buildWithSQL(ViewCommonTableExpressionStructure with)
<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 abstract String	escapeStart()
protected ColumnData	findInlinePrimaryKey(TableStructure table)
protected final Map<DbmsCapability,Boolean>	getCapabilities()
<B extends SQLQueryable<T>, T extends DataBaseEntry> String	getQueryableName(Class<B> tableClass, Map<String,Object> queryableHints)
boolean	isRawExpression(String identifier)
protected String	joinKeyword(ViewJoinType joinType)
<B extends SQLQueryable<T>, T extends DataBaseEntry> String	qualifiedName(Class<B> 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[] pkNames)
<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[] 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)
protected final void	setCapability(DbmsCapability capability, boolean supported)
protected final boolean	supports(DbmsCapability capability)

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, qualifiedName, schemaName

Constructor Details

AbstractSQLStructureVisitor

protected AbstractSQLStructureVisitor()

Method Details

count

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

Specified by:

count in interface SQLStructureVisitor

qualifiedName

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

Specified by:

qualifiedName in interface SQLStructureVisitor

create

public String[] create(TableStructure table)

Specified by:

create in interface SQLStructureVisitor

qualifiedStructureName

protected String qualifiedStructureName(TableStructure table)

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

qualifiedStructureName

protected String qualifiedStructureName(ViewStructure view)

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

isRawExpression

public boolean isRawExpression(String identifier)

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

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

appendWhereGroupOrder

protected void appendWhereGroupOrder(StringBuilder sql,
 String condition,
 List<String> groupBy,
 List<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(GeneratedColumnData 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)

escapeStart

protected abstract String escapeStart()

findInlinePrimaryKey

protected ColumnData findInlinePrimaryKey(TableStructure table)

getCapabilities

protected final Map<DbmsCapability,Boolean> getCapabilities()

joinKeyword

protected String joinKeyword(ViewJoinType joinType)

setCapability

protected final void setCapability(DbmsCapability capability,
 boolean supported)

supports

protected final boolean supports(DbmsCapability capability)

getQueryableName

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

Specified by:

getQueryableName in interface SQLStructureVisitor