How do I use transactions in Sequelize?

How do I use transactions in Sequelize?

In Sequelize, you can use transactions to ensure that a series of operations either all succeed or all fail. You can create a transaction using sequelize.transaction().

Can you show me a code example?

Sure! Here's a simple example:

const { sequelize } = require('./models');

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();
        console.error('Transaction failed:', error);
    }
}

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.