public static class TagHistoryTables.PartitionIndex
extends java.lang.Object
Modifier and Type | Field and Description |
---|---|
static java.lang.String |
BLOCKSIZE |
static java.lang.String |
DRV_ID |
static java.lang.String |
END |
static java.lang.String |
FLAGS |
static java.lang.String |
PNAME |
static java.lang.String |
START |
static java.lang.String |
TABLE_NAME |
Constructor and Description |
---|
PartitionIndex() |
Modifier and Type | Method and Description |
---|---|
static java.lang.String |
queryClosePartition()
Update partition set end=? where pname=? and drvid=? and end=?
|
static java.lang.String |
queryCreatePartition()
INSERT name, start, end
|
static java.lang.String |
queryDeleteOldPartition()
Delete partition row where drvid=? and name=?
|
static java.lang.String |
queryNextPartitionExactResolution()
Selects partitions with resolutions equal to that requested.
|
static java.lang.String |
queryNextPartitionRaw()
Selects partitions with resolutions equal to that requested.
|
static java.lang.String |
queryOldPartitions()
SELECT name, start, end WHERE drv_id=? and end<=? ORDER BY start ASC
|
static java.lang.String |
queryPartitionByName()
SELECT name, start, end, blocksize WHERE drv_id=? and pname=? ORDER BY start DESC
|
static java.lang.String |
queryPartitionExactResolution()
Selects partitions with resolutions equal to that requested.
|
static java.lang.String |
queryPartitionRawResolution()
Selects partitions with null or 0 resolution.
|
static java.lang.String |
queryPartitionWithResolution()
Selects partitons with resolutions more fine grained than requested.
|
static java.lang.String |
queryPreviousPartitions()
SELECT name, start, end, blocksize, flags WHERE drv_id={?:DRIVERID} and start<{?:STARTTIME} and (blocksize is
null or blocksize<={?:BLOCKSIZE}) ORDER BY end DESC
|
static java.lang.String |
queryRecentPartitions()
SELECT name, start, end, blocksize WHERE drv_id=? and blocksize=? ORDER BY start DESC
|
public static final java.lang.String TABLE_NAME
public static final java.lang.String PNAME
public static final java.lang.String START
public static final java.lang.String END
public static final java.lang.String DRV_ID
public static final java.lang.String BLOCKSIZE
public static final java.lang.String FLAGS
public static java.lang.String queryPartitionExactResolution()
public static java.lang.String queryPartitionRawResolution()
public static java.lang.String queryPartitionWithResolution()
public static java.lang.String queryOldPartitions()
public static java.lang.String queryPreviousPartitions()
public static java.lang.String queryRecentPartitions()
public static java.lang.String queryNextPartitionExactResolution()
public static java.lang.String queryNextPartitionRaw()
public static java.lang.String queryDeleteOldPartition()
public static java.lang.String queryCreatePartition()
public static java.lang.String queryClosePartition()
public static java.lang.String queryPartitionByName()