How can I manage transactions in Sequelize with Node.js?

How can I manage transactions in Sequelize with Node.js?

You can manage transactions in Sequelize by using the transaction method. This allows you to execute multiple operations in a single transaction.

Can you show me a code example of using transactions?

Sure! Here's a simple example:

const { Sequelize, Transaction } = require('sequelize');
const sequelize = new Sequelize('database', 'username', 'password', { dialect: 'mysql' });

async function performTransaction() {
    const t = await sequelize.transaction();
    try {
        const user = await User.create({ name: 'John' }, { transaction: t });
        const profile = await Profile.create({ userId: user.id }, { transaction: t });
        await t.commit();
    } catch (error) {
        await t.rollback();
        throw error;
    }
}

This code creates a user and a profile in a single transaction.

What happens if one of the operations fails?

If one of the operations fails, the transaction will be rolled back, meaning none of the changes will be saved to the database.

Are there any best practices for using transactions?

Yes, some best practices include keeping transactions short, avoiding user input during transactions, and handling errors properly.