public interface SQLFilter
This interface should be used when full control over the SQL syntax is required.
JDBCContext
,
JDBCTypeSettings
,
BasicSQLFilter
Modifier and Type | Method and Description |
---|---|
java.lang.String |
formatCatalogName(java.lang.String name)
Formats a catalog name.
|
java.lang.String |
formatColumn(java.lang.String column,
java.lang.String tableAlias)
Formats a column expression used in a SELECT, WHERE, GROUP BY or HAVING
clause.
|
java.lang.String |
formatColumnAlias(java.lang.String name)
Formats a column alias to be used in a SELECT clause.
|
java.lang.String |
formatColumnList(java.lang.String[] columns,
java.lang.String[] types)
Returns SQL for a list column list in a CREATE TABLE statement.
|
java.lang.String |
formatColumnName(java.lang.String name)
Formats a column name.
|
java.lang.String |
formatConditionExpression(java.lang.String expr,
java.lang.Class type)
Formats a condition expression to be used in a WHERE clause.
|
java.lang.String[] |
formatCreateTableSQL(java.lang.String table,
java.lang.String[] columns,
java.lang.String[] types)
Returns SQL for creating a temporary table.
|
java.lang.String[] |
formatDropTableSQL(java.lang.String table)
Returns SQL for dropping a temporary table.
|
java.lang.String |
formatHints(java.lang.String query,
java.lang.String[] hints)
Formats an SQL query to include hints.
|
java.lang.String |
formatInsertValuesSQL(java.lang.String table,
java.lang.String[] values)
Return the SQL for inserting a row into a temporary table.
|
java.lang.String |
formatLiteral(java.lang.String literal,
java.lang.Class type) |
java.lang.String |
formatProcedure(java.lang.String catalog,
java.lang.String schema,
java.lang.String procedure)
Returns the SQL for a procedure expression in a FROM clause.
|
java.lang.String |
formatQuery(java.lang.String query,
java.util.List preCommands,
java.util.List postCommands)
Formats an SQL query.
|
java.lang.String |
formatSchemaName(java.lang.String name)
Formats a schema name.
|
java.lang.String |
formatTable(java.lang.String catalog,
java.lang.String schema,
java.lang.String table)
Returns the SQL for a table expression in a FROM clause.
|
java.lang.String |
formatTableName(java.lang.String name)
Formats a table name.
|
java.lang.String |
formatTempTableName(java.lang.String name)
Formats a temporary table name.
|
JDBCContext |
getContext()
Returns the
JDBCContext . |
java.lang.String |
getSQLAggregateFuntion(java.lang.String datAggregateFuntion) |
java.lang.String |
getSQLType(java.lang.Class type,
int length)
Returns the SQL type for a given Java type.
|
void |
setContext(JDBCContext context)
Sets the
JDBCContext . |
void setContext(JDBCContext context)
JDBCContext
.context
- a JDBCContext
instanceJDBCContext getContext()
JDBCContext
.JDBCContext
instancejava.lang.String[] formatCreateTableSQL(java.lang.String table, java.lang.String[] columns, java.lang.String[] types)
table
- a table namecolumns
- a list of column namestypes
- a list of column typesSQLFilter.formatColumnList(java.lang.String[], java.lang.String[])
java.lang.String[] formatDropTableSQL(java.lang.String table)
table
- a table namejava.lang.String formatInsertValuesSQL(java.lang.String table, java.lang.String[] values)
table
- a table namevalues
- a list of values, may be ?
for a prepared
statementjava.lang.String formatColumnList(java.lang.String[] columns, java.lang.String[] types)
columns
- a list of column namestypes
- a list of column typesSQLFilter.formatCreateTableSQL(java.lang.String, java.lang.String[], java.lang.String[])
java.lang.String getSQLType(java.lang.Class type, int length)
type
- a Java typelength
- the length when type
is String
JDBCTypeSettings.getSQLType(java.lang.Class)
java.lang.String getSQLAggregateFuntion(java.lang.String datAggregateFuntion)
datAggregateFuntion
- datAggregateFunctionjava.lang.String formatTable(java.lang.String catalog, java.lang.String schema, java.lang.String table)
catalog
- a catalog name, may be null
schema
- a schema name, may be null
table
- a table nameSQLFilter.formatCatalogName(java.lang.String)
,
SQLFilter.formatSchemaName(java.lang.String)
,
SQLFilter.formatTableName(java.lang.String)
java.lang.String formatProcedure(java.lang.String catalog, java.lang.String schema, java.lang.String procedure)
catalog
- a catalog name, may be null
schema
- a schema name, may be null
procedure
- a procedure nameSQLFilter.formatCatalogName(java.lang.String)
,
SQLFilter.formatSchemaName(java.lang.String)
java.lang.String formatColumn(java.lang.String column, java.lang.String tableAlias)
column
- a column nametableAlias
- a table aliasSQLFilter.formatColumnName(java.lang.String)
java.lang.String formatColumnName(java.lang.String name)
name
- a column nameJDBCTypeSettings.getColumnNamePattern()
java.lang.String formatTableName(java.lang.String name)
name
- a table nameJDBCTypeSettings.getTableNamePattern()
java.lang.String formatTempTableName(java.lang.String name)
name
- a table nameJDBCTypeSettings.getTempTableNamePattern()
java.lang.String formatSchemaName(java.lang.String name)
name
- a schema nameJDBCTypeSettings.getSchemaNamePattern()
java.lang.String formatCatalogName(java.lang.String name)
name
- a catalog nameJDBCTypeSettings.getCatalogNamePattern()
java.lang.String formatColumnAlias(java.lang.String name)
name
- a column aliasJDBCTypeSettings.getColumnAliasPattern()
java.lang.String formatLiteral(java.lang.String literal, java.lang.Class type)
literal
- a literal expressiontype
- a column typeJDBCTypeSettings.getStringLiteralQuote()
java.lang.String formatConditionExpression(java.lang.String expr, java.lang.Class type)
expr
- a condition expressiontype
- a column typeJDBCTypeSettings.getDateFormatExpression()
,
JDBCTypeSettings.getTimeFormatExpression()
,
JDBCTypeSettings.getDateTimeFormatExpression()
java.lang.String formatHints(java.lang.String query, java.lang.String[] hints)
query
- an SQL queryhints
- a list of hintsjava.lang.String formatQuery(java.lang.String query, java.util.List preCommands, java.util.List postCommands)
query
- an SQL querypreCommands
- add to this list any commands to be executed before the
querypostCommands
- add to this list any commands to be executed after the
queryCopyright © 2000-2020 TIBCO Software Inc. All Rights Reserved.