Database Timelines

From Recital Documentation Wiki
Revision as of 06:35, 2 November 2009 by Barrymavin (Talk | contribs)

Jump to: navigation, search

Database Timelines

What are Database Timelines?

Database timelines provide row versioning for Recital database applications. Whenever a change is made to a table that is timeline enabled then delta changes are automatically recorded for each transaction. Changes made to any tables that are timeline enabled can be undone much like you would undo changes to program code that you edit in a text editor.

Using Database Timelines

To enable database timelines all you need to do is issue the SET TIMELINE ON command in your Recital configuration file.

SET TIMELINE ON

Viewing a timeline

There are 2 ways to view a timeline.

  • The LIST TIMELINE command
  • The SELECT * FROM SYSTIMELINE command
LIST TIMELINE [RANGE begin [,end]] [FOR condition] [TO FILE filename]

To view a timeline for a particular table e.g.

LIST TIMELINE FOR table = "customers"

To view a timeline since a certain date use the RANGE keyword. Notice that the date range is encoded as a string in the format "YYYYMMDDHH:MM:SS:" e.g.

// list the timeline since 1st october 2009
LIST TIMELINE RANGE "20091001" 

// list the timeline between the 1st and 7th of october 2009 
LIST TIMELINE RANGE "20091001","20091007" 

Undoing database changes

You can undo database changes with the ROLLBACK TIMELINE command.

ROLLBACK TIMELINE [RANGE begin [, end]] [FOR condition]

Clearing a timeline

The CLEAR TIMELINE command will reset a timeline.

CLEAR TIMELINE