Difference between revisions of "ROLLBACK TIMELINE"
Yvonnemilne (Talk | contribs) |
Yvonnemilne (Talk | contribs) |
||
| Line 1: | Line 1: | ||
{{YLM to do}} | {{YLM to do}} | ||
| + | ==Purpose== | ||
| + | Rolls back transactions database timeline transaction information | ||
| + | |||
| + | |||
| + | ==Syntax== | ||
| + | ROLLBACK TIMELINE [RANGE <expC1> [, <expC2>]] [FOR <expL>] | ||
| + | |||
==See Also== | ==See Also== | ||
| − | [[CLEAR TIMELINE]], [[LIST TIMELINE]], [[SET TIMELINE]], [[SET TIMESTAMP]], [[SYSTIMELINE]] | + | [[CLEAR TIMELINE]], [[DTOS()]], [[DISPLAY TIMELINE]], [[LIST TIMELINE]], [[SET TIMELINE]], [[SET TIMESTAMP]], [[SYSTIMELINE]] |
| + | |||
| + | |||
| + | ==Description== | ||
| + | DISPLAY TIMELINE displays database timeline transaction information. Database timelines provide row versioning for Recital database applications. Whenever a change is made to a table that is timeline enabled, delta changes are automatically recorded for each transaction. | ||
| + | |||
| + | DISPLAY TIMELINE differs from the LIST TIMELINE command in that it pauses every 17 lines until a key is pressed. | ||
| + | |||
| + | The optional RANGE <expC1> [, <expC2>] clause allows the display to be restricted to transactions from a particular date <expC1> or transactions that fall between two inclusive dates: <expC1> and <expC2>. The dates must be specified as strings in the format YYYYMMDD. The [[DTOS()]] function can be used to convert date data type values to this format. | ||
| + | |||
| + | The optional FOR <expL> clause, where <expL> is a valid logical expression, can also be used to restrict the output. For a structure listing of the database timeline storage table, please see [[SYSTIMELINE]]. | ||
| + | |||
| + | Transactions are displayed grouped by transaction date and include the following: | ||
| + | |||
| + | * Time of transaction | ||
| + | * Table name | ||
| + | * Row number | ||
| + | * Changed by user@hostname | ||
| + | * Command | ||
| + | * Field old and new values | ||
| + | |||
| + | To enable database timelines simply issue the SET TIMELINE ON command in your Recital configuration file. SET TIMELINE is OFF by default. | ||
| + | |||
| + | |||
| + | ==Example== | ||
| + | <code lang="recital"> | ||
| + | display timeline range dtos(date()-10), dtos(date()) for table = "example" | ||
| + | </code> | ||
| + | |||
| + | |||
| + | ==Products== | ||
| + | Recital, Recital Server | ||
| + | [[Category:Documentation]] | ||
| + | [[Category:Commands]] | ||
| + | [[Category:Database Timelines]] | ||
| + | [[Category:Database Timelines Commands]] | ||
Revision as of 17:02, 30 November 2009
Purpose
Rolls back transactions database timeline transaction information
Syntax
ROLLBACK TIMELINE [RANGE <expC1> [, <expC2>]] [FOR <expL>]
See Also
CLEAR TIMELINE, DTOS(), DISPLAY TIMELINE, LIST TIMELINE, SET TIMELINE, SET TIMESTAMP, SYSTIMELINE
Description
DISPLAY TIMELINE displays database timeline transaction information. Database timelines provide row versioning for Recital database applications. Whenever a change is made to a table that is timeline enabled, delta changes are automatically recorded for each transaction.
DISPLAY TIMELINE differs from the LIST TIMELINE command in that it pauses every 17 lines until a key is pressed.
The optional RANGE <expC1> [, <expC2>] clause allows the display to be restricted to transactions from a particular date <expC1> or transactions that fall between two inclusive dates: <expC1> and <expC2>. The dates must be specified as strings in the format YYYYMMDD. The DTOS() function can be used to convert date data type values to this format.
The optional FOR <expL> clause, where <expL> is a valid logical expression, can also be used to restrict the output. For a structure listing of the database timeline storage table, please see SYSTIMELINE.
Transactions are displayed grouped by transaction date and include the following:
- Time of transaction
- Table name
- Row number
- Changed by user@hostname
- Command
- Field old and new values
To enable database timelines simply issue the SET TIMELINE ON command in your Recital configuration file. SET TIMELINE is OFF by default.
Example
display timeline range dtos(date()-10), dtos(date()) for table = "example"
Products
Recital, Recital Server
