Package com.inductiveautomation.gateway.tsdb.historians

Class SQLiteHistorian.Tables.Annotations

java.lang.Object

com.inductiveautomation.gateway.tsdb.historians.SQLiteHistorian.Tables.Annotations

Enclosing class:

SQLiteHistorian.Tables

protected static class SQLiteHistorian.Tables.Annotations
extends java.lang.Object

Field Summary

Fields

Modifier and Type	Field	Description
static java.lang.String	ANNOTATIONID
static java.lang.String	DATA
static java.lang.String	DELETED
static java.lang.String	ID
static java.lang.String	Q_DELETE
static java.lang.String	Q_DELETE_OLDER
static java.lang.String	Q_ID
static java.lang.String	Q_INSERT
static java.lang.String	Q_SELECT_CUR_SYNCID
static java.lang.String	Q_SELECT_QUERY_SYNCID
static java.lang.String	Q_SELECT_SYNC_DATACOUNT
static java.lang.String	Q_SYNC_READ
static java.lang.String	Q_UPDATE_DATA
static java.lang.String	Q_UPDATE_DELETE
static java.lang.String	RANGEEND
static java.lang.String	RANGESTART
static java.lang.String	SYNCID
static java.lang.String	TABLE
static java.lang.String	TAGID
static java.lang.String	TYPE

Method Summary

Modifier and Type	Method	Description
static java.lang.String	getReadQuery(int tagCounts)	SELECT id, annotationid, tagid, type, start, end, data WHERE ((start>=? AND start<=?) OR (end>=? AND end<=?)) AND deleted=? AND tagid in (?)
static java.lang.String	getUpgradeQuery()	UPDATE table SET annotationid WHERE id

Methods inherited from class java.lang.Object

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

Field Detail

TABLE

public static final java.lang.String TABLE

See Also:

Constant Field Values

ID

public static final java.lang.String ID

See Also:

Constant Field Values

TAGID

public static final java.lang.String TAGID

See Also:

Constant Field Values

TYPE

public static final java.lang.String TYPE

See Also:

Constant Field Values

RANGESTART

public static final java.lang.String RANGESTART

See Also:

Constant Field Values

RANGEEND

public static final java.lang.String RANGEEND

See Also:

Constant Field Values

DATA

public static final java.lang.String DATA

See Also:

Constant Field Values

SYNCID

public static final java.lang.String SYNCID

See Also:

Constant Field Values

ANNOTATIONID

public static final java.lang.String ANNOTATIONID

See Also:

Constant Field Values

DELETED

public static final java.lang.String DELETED

See Also:

Constant Field Values

Q_INSERT

public static final java.lang.String Q_INSERT

See Also:

Constant Field Values

Q_DELETE

public static final java.lang.String Q_DELETE

See Also:

Constant Field Values

Q_DELETE_OLDER

public static final java.lang.String Q_DELETE_OLDER

See Also:

Constant Field Values

Q_UPDATE_DATA

public static final java.lang.String Q_UPDATE_DATA

See Also:

Constant Field Values

Q_UPDATE_DELETE

public static final java.lang.String Q_UPDATE_DELETE

See Also:

Constant Field Values

Q_ID

public static final java.lang.String Q_ID

See Also:

Constant Field Values

Q_SELECT_CUR_SYNCID

public static final java.lang.String Q_SELECT_CUR_SYNCID

See Also:

Constant Field Values

Q_SELECT_QUERY_SYNCID

public static final java.lang.String Q_SELECT_QUERY_SYNCID

See Also:

Constant Field Values

Q_SELECT_SYNC_DATACOUNT

public static final java.lang.String Q_SELECT_SYNC_DATACOUNT

See Also:

Constant Field Values

Q_SYNC_READ

public static final java.lang.String Q_SYNC_READ

See Also:

Constant Field Values

Method Detail

getReadQuery

public static java.lang.String getReadQuery(int tagCounts)

SELECT id, annotationid, tagid, type, start, end, data WHERE ((start>=? AND start<=?) OR (end>=? AND end<=?)) AND deleted=? AND tagid in (?)

getUpgradeQuery

public static java.lang.String getUpgradeQuery()

UPDATE table SET annotationid WHERE id