'use strict';
const Controller = require('egg').Controller;
class HomeController extends Controller {
async index() {
const { ctx } = this;
try {
var transaction = await ctx.model.transaction();
let i = 4;
// 这一条会成功
await ctx.model.Address.create({
id: i + 1,
address: '测试鸭'
}, {
transaction
})
// 这一条会成功
await ctx.model.Address.create({
id: i + 2,
address: '测试鸭'
}, {
transaction
})
// 这一条会失败
var res = await ctx.model.Addr.create({
addr_no: i+6,
addr_name: '测试鸭',
addr_pos: 96,
}, {
transaction
})
await transaction.commit();
} catch (err) {
await transaction.rollback();
}
console.log(res);
if (!res) {
ctx.body = '执行失败';
} else {
ctx.body = '执行成功' + JSON.stringify(res.dataValues)
}
}
}
module.exports = HomeController;
数据库也没有写入任何记录