Package com.inductiveautomation.ignition.gateway.localdb.hsql

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

Field Summary

Fields inherited from class com.inductiveautomation.ignition.gateway.localdb.Table

columns, fks, name, pk, sequences

Constructor Summary

Constructors

Constructor	Description
HsqlTable()

Method Summary

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" list
protected 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

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

HsqlTable

public HsqlTable()

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 class Table

Throws:

java.sql.SQLException

qc

public java.lang.String qc()

Overrides:

qc in class Table

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 class Table

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 class Table

getColumnTypeSql

protected java.lang.String getColumnTypeSql(SFieldScalar field)

Overrides:

getColumnTypeSql in class Table