Chapter 12.4. SQLObject and Transactions

A DB transaction is a series of basic operations that must all succeed or fail to preserve the integrity of the DB. The best example is moving an entity from one table to another. It requires deleting the object from one table and inserting it into the other table. If one of these operations fails, you end up with no object or with two objects. Most databases support transactions and provide a way to start transactions and roll back or commit a transaction.

Get Rapid Web Applications with TurboGears: Using Python to Create Ajax-Powered Sites now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.