com.inductiveautomation.ignition.gateway.localdb

Class Table

java.lang.Object

com.inductiveautomation.ignition.gateway.localdb.Table

Direct Known Subclasses:

HSQLTable, SQLiteTable

public abstract class Table
extends java.lang.Object

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
class	Table.Column
protected class	Table.ForeignKey

Field Summary

Fields

Modifier and Type	Field and Description
protected java.lang.String	name The name of the table

Constructor Summary

Constructors

Constructor and Description
Table()

Method Summary

Modifier and Type	Method and Description
Table	buildFor(SRecordMeta<? extends SRecordInstance> meta)
Table	buildFor(java.lang.String tableName, javax.sql.DataSource db)
Table	buildFor(Table other)
Table	buildNew(java.lang.String name)
java.lang.String	colQC()
protected abstract java.util.List<java.lang.String>	findSequences(java.lang.String tableName, java.sql.Connection conn)
protected java.lang.String	getColumnDDL(Table.Column col)
java.util.List<Table.Column>	getColumns()
protected java.lang.String	getColumnTypeSQL(SFieldScalar field)
java.util.List<java.lang.String>	getConstraintDDL()
java.util.List<java.lang.String>	getPhase1AlterDDL(Table existing) Does all alter column statements
java.util.List<java.lang.String>	getPhase2AlterDDL(Table existing) Does all constraint and sequence modification
java.lang.String	getTableCreateDDL()
java.lang.String	getTableName()
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_CreateIndex(java.lang.String indexName, java.lang.String tableName, java.lang.String columnName)
protected java.lang.String	sqlDefinition_CreateSequence(java.lang.String sequence, java.lang.String table) Returns the full "CREATE SEQUENCE seqName"
protected java.lang.String	sqlDefinition_DropIndex(java.lang.String indexName)
protected java.lang.String	sqlDefinition_Table() Returns the keyword(s) to use for create TABLE.
protected boolean	supportsConstraintModification()
protected boolean	supportsDropColumn()
boolean	tableExists()
protected java.lang.String	valueToQueryLiteral(java.lang.Object value, SFieldScalar field) In some cases, we put the value of the column directly into the query.
protected java.lang.String	valueToQueryLiteral(java.lang.Object value, java.lang.String columnType)

Methods inherited from class java.lang.Object

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

Field Detail

name

protected java.lang.String name

The name of the table

Constructor Detail

Table

public Table()

Method Detail

tableExists

public boolean tableExists()

buildFor

public Table buildFor(Table other)

buildFor

public Table buildFor(SRecordMeta<? extends SRecordInstance> meta)

buildFor

public Table buildFor(java.lang.String tableName,
                      javax.sql.DataSource db)
               throws java.sql.SQLException

Throws:

java.sql.SQLException

buildNew

public Table buildNew(java.lang.String name)

colQC

public java.lang.String colQC()

qc

public java.lang.String qc()

supportsConstraintModification

protected boolean supportsConstraintModification()

findSequences

protected abstract java.util.List<java.lang.String> findSequences(java.lang.String tableName,
                                                                  java.sql.Connection conn)
                                                           throws java.sql.SQLException

Throws:

java.sql.SQLException

getTableName

public java.lang.String getTableName()

getPhase1AlterDDL

public java.util.List<java.lang.String> getPhase1AlterDDL(Table existing)

Does all alter column statements

getPhase2AlterDDL

public java.util.List<java.lang.String> getPhase2AlterDDL(Table existing)

Does all constraint and sequence modification

sqlDefinition_Table

protected java.lang.String sqlDefinition_Table()

Returns the keyword(s) to use for create TABLE. Default is "TABLE", but HSQL would use "CACHED TABLE"

sqlDefinition_CreateSequence

protected java.lang.String sqlDefinition_CreateSequence(java.lang.String sequence,
                                                        java.lang.String table)

Returns the full "CREATE SEQUENCE seqName"

sqlDefinition_CreateIndex

protected java.lang.String sqlDefinition_CreateIndex(java.lang.String indexName,
                                                     java.lang.String tableName,
                                                     java.lang.String columnName)

sqlDefinition_DropIndex

protected java.lang.String sqlDefinition_DropIndex(java.lang.String indexName)

supportsDropColumn

protected boolean supportsDropColumn()

getColumns

public java.util.List<Table.Column> getColumns()

getColumnDDL

protected java.lang.String getColumnDDL(Table.Column col)

getTableCreateDDL

public java.lang.String getTableCreateDDL()

getConstraintDDL

public java.util.List<java.lang.String> getConstraintDDL()

sqlDefinition_CreateForeignKeys

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

getColumnTypeSQL

protected java.lang.String getColumnTypeSQL(SFieldScalar field)

valueToQueryLiteral

protected java.lang.String valueToQueryLiteral(java.lang.Object value,
                                               SFieldScalar field)

In some cases, we put the value of the column directly into the query. This allows us to override how it is represented in the query.

valueToQueryLiteral

protected java.lang.String valueToQueryLiteral(java.lang.Object value,
                                               java.lang.String columnType)