In this lesson, you’ll learn how to group multiple database operations into a single atomic "transaction" to ensure your data remains consistent.
The Concept of Atomicity
When building applications, you often need to perform a series of related operations. For example, if a user transfers money, your ORM must subtract the amount from one account and add it to another. If the system crashes after the subtraction but before the addition, money vanishes into thin air.
A transaction prevents this by wrapping these operations in an "all-or-nothing" block. If every step succeeds, the ORM "commits" the changes to the database. If any step fails, the ORM "rolls back" the entire process, reverting the database to the state it was in before the transaction started.
Implementing Transactions with ORMs
Most modern ORMs provide a standard interface to handle these blocks. Here is how a typical transaction looks using an ORM like Sequelize or TypeORM:
await sequelize.transaction(async (t) => {
// Perform operations using the transaction object 't'
await Account.decrement('balance', { by: 100, where: { id: 1 }, transaction: t });
await Account.increment('balance', { by: 100, where: { id: 2 }, transaction: t });
// If no errors occur, the ORM automatically commits here.
// If an error is thrown, the ORM automatically rolls back.
});
Why it Matters
By using transactions, you protect your application from "partial updates." Without them, your database could end up in a corrupted state where some related data is updated while other pieces are left behind.
When you pass the transaction object (often denoted as t) into your ORM queries, you are telling the database to keep these commands isolated from other concurrent processes until the block finishes. This ensures that other users don't see the "half-finished" result of your operation, maintaining total data integrity.
Key Takeaway: Use transaction blocks to ensure that multiple related database operations either all succeed together or all fail together, preventing partial data updates and corruption.