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(). Would you like an example?

Yes, please provide an example of using a transaction.

Sure! Here's a simple example:

const { Sequelize, DataTypes } = require('sequelize');
const sequelize = new Sequelize('database', 'username', 'password', {
  host: 'localhost',
  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();
    console.error('Transaction failed:', error);
  }
}

This code creates a user and a profile within a 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. This ensures data integrity.