How do I handle transactions in Sequelize?

How do I handle transactions in Sequelize?

In Sequelize, you can handle transactions using the transaction method. Would you like a code example?

Yes, please provide a code example.

Sure! Here's a basic 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 within a transaction.

What happens if an error occurs during the transaction?

If an error occurs, the transaction will be rolled back, ensuring that no partial changes are saved to the database.