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

Class SQLiteDriver

java.lang.Object

simpleorm.sessionjdbc.SDriver

com.inductiveautomation.ignition.gateway.localdb.sqlite.SQLiteDriver

public class SQLiteDriver
extends SDriver

Created by colby.clegg on 11/12/2015.

Nested Class Summary

Nested Classes

Modifier and Type	Class	Description
static class	SQLiteDriver.SequenceTable	Created by colby.clegg on 11/13/2015.

Nested classes/interfaces inherited from class simpleorm.sessionjdbc.SDriver

SDriver.OffsetStrategy

Constructor Summary

Constructors

Constructor	Description
SQLiteDriver()

Method Summary

Modifier and Type	Method	Description
static String	columnTypeSql(SFieldScalar field)
protected String	driverName()	The driver name to be compared to getMetaData().getDriverName()
protected long	generateKeySequence(SRecordMeta<?> rec, SFieldScalar keyFld)
boolean	supportsKeySequences()
boolean	supportsLocking()	Notes: - I'm not sure if sqlite "supports locking" exactly, but this property is used in forUpdateSQL to add the "FOR UPDATE" to the end, which isn't supported.

Methods inherited from class simpleorm.sessionjdbc.SDriver

addNull, alterTableAddColumnSQL, alterTableDropColumnSQL, appendColumnName, appendQuotedIdentifier, appendQuotedIdentifier, appendTableName, clauseSeparator, columnTypeSQL, createSequenceDDL, createTableSQL, deleteSQL, dropSequenceDDL, dropTableNoError, foreignKeysSQL, forUpdateSQL, fromSQL, generateKeySelectMax, getLogger, getOffsetStrategy, getSession, indexKeySQL, insertSQL, joinSQL, limitSQL, makeForeignKeyIndexSQL, mapForeignKeys, maxIdentNameLength, postColumnSQL, postFromSQL, postTablePostParenSQL, postTablePreParenSQL, primaryKeySQL, queryExecuteFactory, registerDriver, selectSQL, selectSQL, updateSQL, whereSQL, wholeColumnSQL

Methods inherited from class java.lang.Object

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

Constructor Details

SQLiteDriver

public SQLiteDriver()

Method Details

columnTypeSql

public static String columnTypeSql(SFieldScalar field)

driverName

protected String driverName()

Description copied from class: SDriver

The driver name to be compared to getMetaData().getDriverName()

Overrides:

driverName in class SDriver

supportsLocking

public boolean supportsLocking()

Notes: - I'm not sure if sqlite "supports locking" exactly, but this property is used in forUpdateSQL to add the "FOR UPDATE" to the end, which isn't supported.

Overrides:

supportsLocking in class SDriver

generateKeySequence

protected long generateKeySequence(SRecordMeta<?> rec,
 SFieldScalar keyFld)

Overrides:

generateKeySequence in class SDriver

supportsKeySequences

public boolean supportsKeySequences()

Overrides:

supportsKeySequences in class SDriver