Constructor and Description |
---|
BasicSQLFilter()
Creates a new
BasicSQLFilter instance. |
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 |
formatPattern(java.lang.String pattern,
java.lang.String[] keys,
java.lang.String[] values)
Replaces, in a pattern string, all occurrences of the specified keys with
the associated values.
|
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 |
formatProcedureName(java.lang.String name) |
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 datAggregateFunction) |
java.lang.String |
getSQLType(java.lang.Class c,
int length)
Returns the SQL type for a given Java type.
|
void |
setContext(JDBCContext c)
Sets the
JDBCContext . |
public BasicSQLFilter()
BasicSQLFilter
instance.public void setContext(JDBCContext c)
SQLFilter
JDBCContext
.setContext
in interface SQLFilter
c
- a JDBCContext
instancepublic JDBCContext getContext()
SQLFilter
JDBCContext
.getContext
in interface SQLFilter
JDBCContext
instancepublic java.lang.String[] formatCreateTableSQL(java.lang.String table, java.lang.String[] columns, java.lang.String[] types)
SQLFilter
formatCreateTableSQL
in interface SQLFilter
table
- a table namecolumns
- a list of column namestypes
- a list of column typesSQLFilter.formatColumnList(java.lang.String[], java.lang.String[])
public java.lang.String[] formatDropTableSQL(java.lang.String table)
SQLFilter
formatDropTableSQL
in interface SQLFilter
table
- a table namepublic java.lang.String formatInsertValuesSQL(java.lang.String table, java.lang.String[] values)
SQLFilter
formatInsertValuesSQL
in interface SQLFilter
table
- a table namevalues
- a list of values, may be ?
for a prepared
statementpublic java.lang.String formatColumnList(java.lang.String[] columns, java.lang.String[] types)
SQLFilter
formatColumnList
in interface SQLFilter
columns
- a list of column namestypes
- a list of column typesSQLFilter.formatCreateTableSQL(java.lang.String, java.lang.String[], java.lang.String[])
public java.lang.String getSQLType(java.lang.Class c, int length)
SQLFilter
getSQLType
in interface SQLFilter
c
- a Java typelength
- the length when type
is String
JDBCTypeSettings.getSQLType(java.lang.Class)
public java.lang.String getSQLAggregateFuntion(java.lang.String datAggregateFunction)
getSQLAggregateFuntion
in interface SQLFilter
datAggregateFunction
- datAggregateFunctionpublic java.lang.String formatTable(java.lang.String catalog, java.lang.String schema, java.lang.String table)
SQLFilter
formatTable
in interface SQLFilter
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)
public java.lang.String formatProcedure(java.lang.String catalog, java.lang.String schema, java.lang.String procedure)
SQLFilter
formatProcedure
in interface SQLFilter
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)
public java.lang.String formatColumn(java.lang.String column, java.lang.String tableAlias)
SQLFilter
formatColumn
in interface SQLFilter
column
- a column nametableAlias
- a table aliasSQLFilter.formatColumnName(java.lang.String)
public java.lang.String formatColumnName(java.lang.String name)
SQLFilter
formatColumnName
in interface SQLFilter
name
- a column nameJDBCTypeSettings.getColumnNamePattern()
public java.lang.String formatTableName(java.lang.String name)
SQLFilter
formatTableName
in interface SQLFilter
name
- a table nameJDBCTypeSettings.getTableNamePattern()
public java.lang.String formatTempTableName(java.lang.String name)
SQLFilter
formatTempTableName
in interface SQLFilter
name
- a table nameJDBCTypeSettings.getTempTableNamePattern()
public java.lang.String formatSchemaName(java.lang.String name)
SQLFilter
formatSchemaName
in interface SQLFilter
name
- a schema nameJDBCTypeSettings.getSchemaNamePattern()
public java.lang.String formatCatalogName(java.lang.String name)
SQLFilter
formatCatalogName
in interface SQLFilter
name
- a catalog nameJDBCTypeSettings.getCatalogNamePattern()
public java.lang.String formatProcedureName(java.lang.String name)
name
- namepublic java.lang.String formatColumnAlias(java.lang.String name)
SQLFilter
formatColumnAlias
in interface SQLFilter
name
- a column aliasJDBCTypeSettings.getColumnAliasPattern()
public java.lang.String formatLiteral(java.lang.String literal, java.lang.Class type)
formatLiteral
in interface SQLFilter
literal
- a literal expressiontype
- a column typeJDBCTypeSettings.getStringLiteralQuote()
public java.lang.String formatConditionExpression(java.lang.String expr, java.lang.Class type)
SQLFilter
formatConditionExpression
in interface SQLFilter
expr
- a condition expressiontype
- a column typeJDBCTypeSettings.getDateFormatExpression()
,
JDBCTypeSettings.getTimeFormatExpression()
,
JDBCTypeSettings.getDateTimeFormatExpression()
public java.lang.String formatHints(java.lang.String query, java.lang.String[] hints)
SQLFilter
formatHints
in interface SQLFilter
query
- an SQL queryhints
- a list of hintspublic java.lang.String formatQuery(java.lang.String query, java.util.List preCommands, java.util.List postCommands)
SQLFilter
formatQuery
in interface SQLFilter
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
querypublic java.lang.String formatPattern(java.lang.String pattern, java.lang.String[] keys, java.lang.String[] values)
pattern
- the string in which to do the substitutionkeys
- a list of keys to substitutevalues
- a list of valuesCopyright © 2000-2020 TIBCO Software Inc. All Rights Reserved.