sequelize transaction sample

sequelize-transaction-sample.js

'use strict';

const ruo = require('ruo');

exports.complete = function *(id) {
  const t = yield ruo.transaction({autocommit: false});
  let bill;
  try {
    bill = yield ruo.models.Bill.findOne({
      where: {
        id: id,
        status: 'failed',
      },
      transaction: t,
    });

    const money = yield ruo.models.Money.findOne({
      where: {
        agentId: bill.agentId,
      },
      transaction: t,
    });

    yield money.decrement('balance', {by: bill.paid, transaction: t});

    bill = yield bill.update({status: 'success'}, {
      fileds: ['status'],
      transaction: t,
    });
  } catch (e) {
    t.rollback();
    throw e;
  }

  t.commit();
  return bill;
};