public static class TagHistoryTables.TagRecord
extends java.lang.Object
Modifier and Type | Field and Description |
---|---|
static java.lang.String |
CREATED |
static java.lang.String |
DATATYPE |
static java.lang.String |
ID |
static java.lang.String |
QUERY_MODE |
static java.lang.String |
RETIRED
The retired column was added in 7.3 in order to let us start the system by loading all non-retired tags,
saving us from looking up the current tag id one-by-one as tags came in
|
static java.lang.String |
SC_ID |
static java.lang.String |
TABLE_NAME |
static java.lang.String |
TAGPATH |
Constructor and Description |
---|
TagRecord() |
Modifier and Type | Method and Description |
---|---|
static java.lang.String |
queryAllTags()
SELECT a.tagpath, b.drvid FROM sqlth_te a, sqlth_scinfo b WHERE b.id=a.scid
|
static java.lang.String |
queryGetActiveTags()
Selects all data for non-retired tags.
SELECT id, tagpath, datatype, scid, querymode, created, b.drvid FROM te a, scinfo b on a.scid=b.id WHERE (retired is null or retired=0) |
static java.lang.String |
queryGetActiveTagsForSystem(int provIdCount)
Selects all data for non-retired tags.
SELECT id, tagpath, datatype, scid, querymode, created, b.drvid FROM te a, scinfo b on a.scid=b.id WHERE (retired is null or retired=0) |
static java.lang.String |
queryGetTagInfoForScId()
SELECT id, querymode FROM table where tagpath=?, scid=?, dtype=?
|
static java.lang.String |
queryInsTag()
INSERT INTO table(TagPath, SCID, DATATYPE, QUERYMODE,CREATED,RETIRED) VALUES(?,?,?,?,?,?)
|
static java.lang.String |
queryNonRetiredTags()
SELECT a.tagpath, b.drvid FROM sqlth_te a, sqlth_scinfo b WHERE b.id=a.scid and a.retired is null
|
static java.lang.String |
queryRetireTag()
UPDATE table SET retired=? WHERE tagid=?
|
public static final java.lang.String TABLE_NAME
public static final java.lang.String ID
public static final java.lang.String TAGPATH
public static final java.lang.String DATATYPE
public static final java.lang.String SC_ID
public static final java.lang.String QUERY_MODE
public static final java.lang.String RETIRED
public static final java.lang.String CREATED
public static java.lang.String queryGetTagInfoForScId()
public static java.lang.String queryGetActiveTags()
public static java.lang.String queryGetActiveTagsForSystem(int provIdCount)
public static java.lang.String queryRetireTag()
public static java.lang.String queryInsTag()
public static java.lang.String queryAllTags()
public static java.lang.String queryNonRetiredTags()