public class HsqlDialect extends GenericSqlDialect
Copyright 2009 Partner Software, Inc.
| Constructor and Description |
|---|
HsqlDialect()
Creates a new HsqlDialect.
|
| Modifier and Type | Method and Description |
|---|---|
java.lang.String |
addColumn(java.lang.String tableName,
CogStructureField newField,
CogType newFieldType)
Returns complete Sql to add a column.
|
java.lang.String |
alterColumn(java.lang.String tableName,
CogStructureField newField,
CogType newFieldType)
Returns complete Sql to alter a column.
|
java.lang.String |
cogTypeToSqlType(CogType type)
Helper for converting from a CogType to a Sql flavor specific data type.
|
java.lang.String |
createTable(CogSchema schema,
CogStructureType tableType)
Returns complete Sql create table statement.
|
java.lang.String |
dropColumn(java.lang.String tableName,
java.lang.String fieldName)
Returns complete Sql to drop a column.
|
java.lang.String |
selectSql(DataRecordQuery query,
CogStructureType tableType)
Returns complete Sql select statement.
|
createTableFromSelect, dbToObject, describeTable, describleTableColumnKey, describleTableTypeKey, handleSorts, isAlterColumnSupported, isDescribeTableSupported, isListDatabasesSupported, isListTablesSupported, listDatabases, listFields, listTables, objectToDb, objectToDbSql, parseFilter, renameTable, sqlTypeToCogTypepublic java.lang.String selectSql(DataRecordQuery query, CogStructureType tableType)
SqlDialectselectSql in interface SqlDialectselectSql in class GenericSqlDialectquery - - Query describing select statement.tableType - - CogStructureType defining table. Type name is assumed to be table name.public java.lang.String createTable(CogSchema schema, CogStructureType tableType)
SqlDialectcreateTable in interface SqlDialectcreateTable in class GenericSqlDialectschema - - Schema defining column types.tableType - - CogStructureType defining table. Type name is assumed to be table name.public java.lang.String addColumn(java.lang.String tableName,
CogStructureField newField,
CogType newFieldType)
SqlDialectaddColumn in interface SqlDialectaddColumn in class GenericSqlDialecttableName - - Name of table to add a column to.newField - - Field to add.newFieldType - - CogType of field to add.public java.lang.String alterColumn(java.lang.String tableName,
CogStructureField newField,
CogType newFieldType)
SqlDialectalterColumn in interface SqlDialectalterColumn in class GenericSqlDialecttableName - - Name of table to alter column in.newField - - Field to change.newFieldType - - CogType for the passed field.public java.lang.String cogTypeToSqlType(CogType type)
SqlDialectcogTypeToSqlType in interface SqlDialectcogTypeToSqlType in class GenericSqlDialecttype - - CogType to convert to Sql type.public java.lang.String dropColumn(java.lang.String tableName,
java.lang.String fieldName)
SqlDialectdropColumn in interface SqlDialectdropColumn in class GenericSqlDialecttableName - - Name of table to drop column from.fieldName - - Name of field to drop.