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 List<String>	findSequences(String tableName, Connection conn)
protected String	getColumnTypeSql(SFieldScalar field)
String	qc()
protected void	sqlDefinition_CreateForeignKeys(List<String> commands, List<Table.ForeignKey> fks)	Should create the sql for adding the foreign keys and add them to the "commands" list
protected 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 Details

HsqlTable

public HsqlTable()

Method Details

findSequences

protected List<String> findSequences(String tableName,
 Connection conn)
                              throws SQLException

Specified by:

findSequences in class Table

Throws:

SQLException

qc

public String qc()

Overrides:

qc in class Table

sqlDefinition_Table

protected 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(List<String> commands,
 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 String getColumnTypeSql(SFieldScalar field)

Overrides:

getColumnTypeSql in class Table