Queries
This table shows query types:
Tcl proc | Description | |
---|---|---|
1 DTC/user | delete from stage where xid = ?
|
Delete Keyspace. Used at Stop transaction. |
2 DTC | select state, step from stage
where keyspace = ?
|
Used at rollback transaction. |
3 DTC | select ifnull(max(step), 0)+1
from stage where keyspace = ?
|
Get next step value when entering a state. |
4 DTC/user | Insert into stage (keyspace,
timestamp, datatype, data, metadata, state, step) values
(?,?,?,?,?,?,?,?)
|
Add key,value to a keyspace Keyspace: XID, global or user defined. key:
timestamp: Use SQLite’s
datatype:
data:
|
Select data from stage where
keyspace = ? and key = ? and datatype = ‘DAT’ |
Get value by key from a keyspace. | |
Select data, metadata from
stage where keyspace = ? and key = ? and datatype =
‘MSG’
|
Get message by key from a keyspace. |