egg插件sequelize：事务

Z时代
2024-01-10
分类：综合

用户表，id自增主键：

user

username

create_time

admin

1594562489

用户信息表，id为主键：

user_info

mobile

18888888888

admin@168.com

添加数据：

const userData = {
    username: "qqzhxl",
    create_time: 1594562500
};
const userInfoData = {
    email: "qqzhxl@126.com",
    mobile: "16666666666"
};
const t = await this.app.model.transaction();
try {
    const userRes = await this.ctx.model.User.create(userData, {
        raw: true,
        transaction: t
    });
    userInfoData.id = userRes.id;
    const userInfoRes = await this.ctx.model.Userinfo.create(userInfoData, {
        raw: true,
        transaction: t
    });
    if (userRes && userInfoRes) {
        t.commit();
        return true;
    }
    t.rollback();
} catch (e) {
    t.rollback();}