Package com.inductiveautomation.historian.gateway.types.internal.sqlite.tables

Class Annotations

java.lang.Object

com.inductiveautomation.historian.gateway.types.internal.sqlite.tables.Annotations

public class Annotations
extends Object

Field Summary

Fields

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

Method Summary

Modifier and Type	Method	Description
static String	getLatestReadQuery(int nodeIdCount, @Nullable Integer returnSize)
static 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 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 Details

TABLE

public static final String TABLE

See Also:

• Constant Field Values

ID

public static final String ID

See Also:

• Constant Field Values

TAGID

public static final String TAGID

See Also:

• Constant Field Values

TYPE

public static final String TYPE

See Also:

• Constant Field Values

RANGESTART

public static final String RANGESTART

See Also:

• Constant Field Values

RANGEEND

public static final String RANGEEND

See Also:

• Constant Field Values

DATA

public static final String DATA

See Also:

• Constant Field Values

SYNCID

public static final String SYNCID

See Also:

• Constant Field Values

ANNOTATIONID

public static final String ANNOTATIONID

See Also:

• Constant Field Values

DELETED

public static final String DELETED

See Also:

• Constant Field Values

Q_INSERT

public static final String Q_INSERT

See Also:

• Constant Field Values

Q_DELETE

public static final String Q_DELETE

See Also:

• Constant Field Values

Q_DELETE_OLDER

public static final String Q_DELETE_OLDER

See Also:

• Constant Field Values

Q_UPDATE_DATA

public static final String Q_UPDATE_DATA

See Also:

• Constant Field Values

Q_UPDATE_DELETE

public static final String Q_UPDATE_DELETE

See Also:

• Constant Field Values

Q_ID

public static final String Q_ID

See Also:

• Constant Field Values

Q_SELECT_CUR_SYNCID

public static final String Q_SELECT_CUR_SYNCID

See Also:

• Constant Field Values

Q_SELECT_QUERY_SYNCID

public static final String Q_SELECT_QUERY_SYNCID

See Also:

• Constant Field Values

Q_SELECT_SYNC_DATACOUNT

public static final String Q_SELECT_SYNC_DATACOUNT

See Also:

• Constant Field Values

Q_SYNC_READ

public static final String Q_SYNC_READ

See Also:

• Constant Field Values

Method Details

getReadQuery

public static 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 (?)

getLatestReadQuery

public static String getLatestReadQuery(int nodeIdCount,
 @Nullable
 @Nullable Integer returnSize)

getUpgradeQuery

public static String getUpgradeQuery()

UPDATE table SET annotationid WHERE id