Search
 
SCRIPT & CODE EXAMPLE
 

JAVASCRIPT

perform database transaction with sequelize

// First, we start a transaction and save it into a variable
const t = await sequelize.transaction();

try {

  // Then, we do some calls passing this transaction as an option:

  const user = await User.create({
    firstName: 'Bart',
    lastName: 'Simpson'
  }, { transaction: t });

  await user.addSibling({
    firstName: 'Lisa',
    lastName: 'Simpson'
  }, { transaction: t });

  // If the execution reaches this line, no errors were thrown.
  // We commit the transaction.
  await t.commit();

} catch (error) {

  // If the execution reaches this line, an error was thrown.
  // We rollback the transaction.
  await t.rollback();

}
Comment

sequelize transaction util

//TransactionExecutor.js
import { DbConnection } from './dataSource';
const { Transaction } = require('sequelize');
const executeTransaction = (callBack) => {
   return DbConnection().transaction({
        isolationLevel: Transaction.ISOLATION_LEVELS.READ_COMMITTED,
   }, (t) => callBack(t));
};
export {
   executeTransaction,
};
Comment

how to perform transaction with sequelize

return sequelize.transaction().then(function (t) {
  return User.create({
    firstName: 'Homer',
    lastName: 'Simpson'
  }, {transaction: t}).then(function (user) {
    return user.addSibling({
      firstName: 'Lisa',
      lastName: 'Simpson'
    }, {transaction: t});
  }).then(function () {
    return t.commit();
  }).catch(function (err) {
    return t.rollback();
  });
});
Comment

perform database transaction with sequelize

try {

  const result = await sequelize.transaction(async (t) => {

    const user = await User.create({
      firstName: 'Abraham',
      lastName: 'Lincoln'
    }, { transaction: t });

    await user.setShooter({
      firstName: 'John',
      lastName: 'Boothe'
    }, { transaction: t });

    return user;

  });

  // If the execution reaches this line, the transaction has been committed successfully
  // `result` is whatever was returned from the transaction callback (the `user`, in this case)

} catch (error) {

  // If the execution reaches this line, an error occurred.
  // The transaction has already been rolled back automatically by Sequelize!

}
Comment

PREVIOUS NEXT
Code Example
Javascript :: how to pick date from datepicker in selenium 
Javascript :: functional component react 
Javascript :: angular start command 
Javascript :: node fetch response body 
Javascript :: ckeditor inline editor example 
Javascript :: value of javascript 
Javascript :: Random number given a range js 
Javascript :: how to give custom name to collection in mongoose 
Javascript :: angular local storage ionic 
Javascript :: angular schematics 
Javascript :: angular 8 enable routing 
Javascript :: image upload using jquery ajax 
Javascript :: remove object from array javascript 
Javascript :: how to run the sonar scanner 
Javascript :: javascript create object empty 
Javascript :: reduce method in javascript array of bjects 
Javascript :: js set 
Javascript :: nodejs express flash message 
Javascript :: how to go to last page after authentication 
Javascript :: javascript parse date in current timezone 
Javascript :: Aug 25 2020 00:00:00 GMT+0530 
Javascript :: get index of selector jquery 
Javascript :: Sort() functions 
Javascript :: export json / array to excel in javascript 
Javascript :: axios js 
Javascript :: hoisting in javascript 
Javascript :: react native update state array of objects 
Javascript :: streami node js 
Javascript :: moment.js format 
Javascript :: how to add array object in javascript 
ADD CONTENT
Topic
Content
Source link
Name
9+9 =