com.aspc.commander.sql

Class TransactionCommand

java.lang.Object

com.aspc.commander.Command

com.aspc.commander.sql.SQLCommand

com.aspc.commander.sql.TransactionCommand

All Implemented Interfaces:

CommandBuildResultsPlugin

public class TransactionCommand
extends SQLCommand

Query the transaction table.

FIELD -- In the format Class:field
FROM -- Time stamp to scan from.
TO -- Time stamp to scan until.
LIKE -- Only records that match
SORT -- 'trans_ms' or 'row_uid' with option of 'DESC' or 'ASC'
CLASS -- List of classes
FROM -- Time stamp to scan from.
TO -- Time stamp to scan until.
USER -- Only transactions for this user
START -- A specific transaction to scan from
RECORD - List of transactions for a record
HEAD - The header details for a transaction
LIST - The list of records changed for a transaction
VALUES - List of values changed for a trans/record
Syntax

  TRANSACTION [
      FIELD field_path 
        [KEY global_key] 
        [FROM from_date]
        [TO to_date]
        [LIKE value]
        [SORT order]
      ] |
      [ 
        CLASS class_name [,...]
        [FROM from_date]
        [TO to_date]
        [USER user]
        [START start_transaction_nr]
      ] |
      [RECORD class_name, row_uid] |
      [HEAD trans_id [,layer_id]] |
      [ERASE trans_id [,layer_id]] |
      [LIST trans_id [,layer_id]] |  
      [VALUES row_uid, trans_id [,layer_id]]
  

Usage

  /* Search for a Folder EVER name 'abc' */
  TRANSACTION FIELD DBFolder:name LIKE 'abc';
  
  /* Lists the transactions for a record */
  TRANSACTION RECORD person, 1923373;
  
  /* Lists the records changed in a transaction */
  TRANSACTION LIST 123;
  

THREAD MODE: SINGLE THREADED command

Since:

3 December 2003

Author:

Nigel Leck

Field Summary

Fields inherited from class com.aspc.commander.sql.SQLCommand

CURSOR_SIZE

Constructor Summary

Constructors

Constructor and Description
TransactionCommand(Connection connection, Pattern pattern) std.

Method Summary

Modifier and Type	Method and Description
protected void	execute(Parser p) execute the command.
java.lang.String	getColumnName(int col) the column name
java.lang.String	getColumnType(int col) Gets the column type for the given column index, starting at one
java.lang.String	getRecordID(int row) the record ID
java.lang.Object	getValue(int row, int col) the value for this row, column

Methods inherited from class com.aspc.commander.sql.SQLCommand

appendResult, appendResult, getCursorName, getRecordKey, isExecuteOnly

Methods inherited from class com.aspc.commander.Command

execute, extMakeThreadName, getConnection, getPattern, getRawTitle, getTitle, makeThreadName, recordCall, setTitle

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Methods inherited from interface com.aspc.commander.sql.results.CommandBuildResultsPlugin

getRawTitle

Constructor Detail

TransactionCommand

public TransactionCommand(Connection connection,
                          Pattern pattern)

std. Command.

Parameters:

connection - the connection

pattern - the pattern

Method Detail

execute

protected void execute(Parser p)
                throws java.lang.Exception

execute the command.

Specified by:

execute in class Command

Parameters:

p - The parser

Throws:

java.lang.Exception - A serious problem

getColumnName

public java.lang.String getColumnName(int col)

the column name

Parameters:

col - the column

Returns:

the name

getColumnType

public java.lang.String getColumnType(int col)

Gets the column type for the given column index, starting at one

Parameters:

col - the column index

Returns:

the column index

getRecordID

public java.lang.String getRecordID(int row)

the record ID

Parameters:

row - the row index

Returns:

the record ID

getValue

public java.lang.Object getValue(int row,
                                 int col)

the value for this row, column

Parameters:

row - the row index

col - the column

Returns:

Object the value for the given row and column