Class HsqlTable
- java.lang.Object
-
- com.inductiveautomation.ignition.gateway.localdb.Table
-
- com.inductiveautomation.ignition.gateway.localdb.hsql.HsqlTable
-
public class HsqlTable extends Table
Created by colby.clegg on 11/12/2015.
-
-
Nested Class Summary
-
Nested classes/interfaces inherited from class com.inductiveautomation.ignition.gateway.localdb.Table
Table.Column, Table.ForeignKey, Table.PrimaryKey
-
-
Constructor Summary
Constructors Constructor Description HsqlTable()
-
Method Summary
All Methods Instance Methods Concrete Methods Modifier and Type Method Description protected java.util.List<java.lang.String>
findSequences(java.lang.String tableName, java.sql.Connection conn)
protected java.lang.String
getColumnTypeSql(SFieldScalar field)
java.lang.String
qc()
protected void
sqlDefinition_CreateForeignKeys(java.util.List<java.lang.String> commands, java.util.List<Table.ForeignKey> fks)
Should create the sql for adding the foreign keys and add them to the "commands" listprotected java.lang.String
sqlDefinition_Table()
Returns the keyword(s) to use for create TABLE.-
Methods inherited from class com.inductiveautomation.ignition.gateway.localdb.Table
buildFor, buildFor, buildFor, buildNew, canAlterFrom, colQC, findColumn, getColumnDdl, getColumns, getConstraintDdl, getForeignKeys, getIndexName, getPhase1AlterDdl, getPhase1Transfer, getPhase2AlterDdl, getPhase2Transfer, getPrimaryKey, getTableCreateDdl, getTableName, getTransferCommand, sqlDefinition_CreateIndex, sqlDefinition_CreateSequence, sqlDefinition_DropIndex, supportsConstraintModification, supportsDropColumn, tableExists, valueToQueryLiteral, valueToQueryLiteral
-
-
-
-
Method Detail
-
findSequences
protected java.util.List<java.lang.String> findSequences(java.lang.String tableName, java.sql.Connection conn) throws java.sql.SQLException
- Specified by:
findSequences
in classTable
- Throws:
java.sql.SQLException
-
sqlDefinition_Table
protected java.lang.String sqlDefinition_Table()
Description copied from class:Table
Returns the keyword(s) to use for create TABLE. Default is "TABLE", but HSQL would use "CACHED TABLE"- Overrides:
sqlDefinition_Table
in classTable
-
sqlDefinition_CreateForeignKeys
protected void sqlDefinition_CreateForeignKeys(java.util.List<java.lang.String> commands, java.util.List<Table.ForeignKey> fks)
Description copied from class:Table
Should create the sql for adding the foreign keys and add them to the "commands" list- Overrides:
sqlDefinition_CreateForeignKeys
in classTable
-
getColumnTypeSql
protected java.lang.String getColumnTypeSql(SFieldScalar field)
- Overrides:
getColumnTypeSql
in classTable
-
-