Package com.inductiveautomation.ignition.gateway.localdb.sqlite

Class SQLiteTable

java.lang.Object

com.inductiveautomation.ignition.gateway.localdb.Table

com.inductiveautomation.ignition.gateway.localdb.sqlite.SQLiteTable

public class SQLiteTable
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
SQLiteTable()

Method Summary

Modifier and Type	Method	Description
boolean	canAlterFrom(Table existing)	Returns true if all of the modifications required can be handled through altering.
String	colQC()
protected List<String>	findSequences(String tableName, Connection connection)
protected String	getColumnTypeSql(SFieldScalar field)
protected String	sqlDefinition_CreateSequence(String sequence, String table)	Returns the full "CREATE SEQUENCE seqName"
protected String	sqlDefinition_DropIndex(String indexName)
protected boolean	supportsConstraintModification()
protected boolean	supportsDropColumn()
protected String	valueToQueryLiteral(Object value, String columnType)
protected String	valueToQueryLiteral(Object value, SFieldScalar field)	In some cases, we put the value of the column directly into the query.

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

buildFor, buildFor, buildFor, buildNew, findColumn, getColumnDdl, getColumns, getConstraintDdl, getForeignKeys, getIndexName, getPhase1AlterDdl, getPhase1Transfer, getPhase2AlterDdl, getPhase2Transfer, getPrimaryKey, getTableCreateDdl, getTableName, getTransferCommand, qc, sqlDefinition_CreateForeignKeys, sqlDefinition_CreateIndex, sqlDefinition_Table, tableExists

Methods inherited from class java.lang.Object

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

Constructor Details

SQLiteTable

public SQLiteTable()

Method Details

supportsConstraintModification

protected boolean supportsConstraintModification()

Overrides:

supportsConstraintModification in class Table

colQC

public String colQC()

Overrides:

colQC in class Table

findSequences

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

Specified by:

findSequences in class Table

Throws:

SQLException

sqlDefinition_CreateSequence

protected String sqlDefinition_CreateSequence(String sequence,
 String table)

Description copied from class: Table

Returns the full "CREATE SEQUENCE seqName"

Overrides:

sqlDefinition_CreateSequence in class Table

sqlDefinition_DropIndex

protected String sqlDefinition_DropIndex(String indexName)

Overrides:

sqlDefinition_DropIndex in class Table

getColumnTypeSql

protected String getColumnTypeSql(SFieldScalar field)

Overrides:

getColumnTypeSql in class Table

supportsDropColumn

protected boolean supportsDropColumn()

Overrides:

supportsDropColumn in class Table

valueToQueryLiteral

protected String valueToQueryLiteral(Object value,
 SFieldScalar field)

Description copied from class: Table

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.

Overrides:

valueToQueryLiteral in class Table

valueToQueryLiteral

protected String valueToQueryLiteral(Object value,
 String columnType)

Overrides:

valueToQueryLiteral in class Table

canAlterFrom

public boolean canAlterFrom(Table existing)

Description copied from class: Table

Returns true if all of the modifications required can be handled through altering. If not, a new version of the table will be made.

Overrides:

canAlterFrom in class Table