事务

ThinkORM目前支持Mysql、postgreSQL的事务操作，代码示例：

  2. //实例化模型
  3. let model = new user(config);
  5. //开始事务
  6. return model.transaction(async function (t) {
  7. //同步模式
  8. // for (var i = 1; i < 5; i++) {
  9. // await model.add({name: 'rrrrrrrrrrrrr'});
  10. // await model.add({name: 'rrrrrrr'});
  11. // await model.add({name: 'rrrrrrrrrrrrr'});
  12. // }
  14. //Promise.all并行模式
  15. //var ps = [];
  16. //for (var i = 1; i < 5; i++) {
  17. // ps.push(model.add({name: 'rrrrrrrrrrrrr'}));
  18. // ps.push(model.add({name: 'rrrr'}));
  19. // ps.push(model.add({name: 'rrrrrrrrrrrrr'}));
  20. //}
  21. //return Promise.all(ps);
  23.     //跨模型执行
  24.     await model.add({name: 'rrrrrrrrrrrrr'}); //主模型写入数据
  25.     let profileModel = await THINK.model('Common/Profile', {}).initDB(t);//实例化profile模型
  26.     return profileModel.add({test: ['rrrtest']});//profile模型写入数据
  27. }).then(data => {
  28. console.log(data);//事务commit后打印
  29. });