如何在使用Sequelize的节点中使用sequelize.transaction在单次api调用中更新两个表

const Sequelize = require('sequelize');
const { Model, DataTypes } = Sequelize;

// 定义模型
class User extends Model {}
User.init({
  name: DataTypes.STRING,
  email: DataTypes.STRING
}, { sequelize, modelName: 'user' });

class Order extends Model {}
Order.init({
  total: DataTypes.FLOAT,
  status: DataTypes.STRING
}, { sequelize, modelName: 'order' });

const sequelize = new Sequelize('database', 'username', 'password', {
  host: 'localhost',
  dialect: 'mysql'
});

try {
  await sequelize.transaction(async (t) => {
    // 在事务中更新表1
    await User.update({ name: 'John' }, { where: { id: 1 }, transaction: t });

    // 在事务中更新表2
    await Order.update({ status: 'completed' }, { where: { id: 1 }, transaction: t });
  });

  console.log('更新成功');
} catch (error) {
  console.error('更新失败', error);
}