In some cases, a sequence of several operations must be performed as a single operation: interrupting the sequence of such operations halfway would leave the data in an invalid state. While the sequence is in progress, other processes accessing the database will not see the partial results until the transaction is complete. The sequence make include data queries and manipulations.
In such cases, the sequence of operations may be enclosed in a transaction.
Transactions are formed using the methods
commitTransaction of a connection object.
A connection object may obtained from any table object.
For example, the following code inserts matching entries for the master table
Session and its part table
% get the connection object session = Session connection = session.conn % insert Session and Session.Experimenter entries in a transaction connection.startTransaction try key.subject_id = animal_id; key.session_time = session_time; session_entry = key; session_entry.brain_region = region; insert(Session, session_entry) experimenter_entry = key; experimenter_entry.experimenter = username; insert(SessionExperimenter, experiment_entry) connection.commitTransaction catch connection.cancelTransaction end
Here, to external observers, both inserts will take effect together only upon exiting from the
try-catch block or will not have any effect at all.
For example, if the second insert fails due to an error, the first insert will be rolled back.