测试事务隔离级别的代码块

测试事务隔离级别的代码块:
person.js

'use strict';
const { startTransaction, commit, rollback } = require('../utils/transaction');

module.exports = function (Person) {
    Person.fun = async function () {
        let tx;
        try {
            tx = await startTransaction(this, this.Transaction.READ_UNCOMMITTED);
            const options = { transaction: tx };

            let person = await Person.find({ where: { name: "ee" } }, options);
            person[0].age = 10000;
            await Person.upsert(person[0], options);

            if(person.length > 0){
                throw new Error("手动报错!");
            }
            await commit(tx);
        }
        catch (e) {
            console.error(e);
            if (tx)
                rollback(tx);
        }


    };

    Person.fun1 = async function () {
        let tx;
        try {
            tx = await startTransaction(this, this.Transaction.READ_UNCOMMITTED);
            const options = { transaction: tx };

            let person = await Person.find({ where: { name: "ee" } }, options);
            person[0].age = 10000;
            await Person.upsert(person[0], options);

            await commit(tx);
        }
        catch (e) {
            console.error(e);
            if (tx)
                rollback(tx);
        }


    };

}

transaction.js


module.exports = {
    startTransaction,
    commit,
    rollback
}

async function startTransaction(model, isolation) {
    return new Promise((resolved, rejected) => {
        isolation = isolation ?  isolation : model.Transaction.REPEATABLE_READ;
        model.beginTransaction({isolationLevel: isolation}, (err, tx) => {
            if(err) return rejected(err);
            resolved(tx);
        });
    });
}

async function commit(tx) {
    return new Promise((resolved, rejected) => {
        console.log('conmmit tx is active?:',tx.ensureActive(),tx.id);
        tx.commit(err => {
            // console.log('conmmit tx is active?:',tx.ensureActive(),tx.id);
            if(err) return rejected(err);
            resolved();
        });
    });
}


async function rollback(tx) {
    return new Promise((resolved, rejected) => {
        tx.rollback((err) =>  {
            if(err) return rejected(err);
            resolved();
        });
    });
}
  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值