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	DATA
static java.lang.String	ID
static java.lang.String	Q_DELETE
static java.lang.String	Q_ID
static java.lang.String	Q_INSERT
static java.lang.String	Q_UPDATE
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, tagid, type, start, end, data WHERE ((start>=? AND start<=?) OR (end>=? AND end<=?)) AND tagid in (?)

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

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_UPDATE

public static final java.lang.String Q_UPDATE

See Also:

Constant Field Values

Q_ID

public static final java.lang.String Q_ID

See Also:

Constant Field Values

Method Detail

getReadQuery

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

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