使用一个API调用(sequelize/postgres/node.js)在多个表中创建多条记录的最有效方法是什么

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

// 创建Sequelize实例
const sequelize = new Sequelize('database', 'username', 'password', {
  host: 'localhost',
  dialect: 'postgres',
});

// 定义模型
const User = sequelize.define('User', {
  name: {
    type: DataTypes.STRING,
    allowNull: false,
  },
});

const Order = sequelize.define('Order', {
  amount: {
    type: DataTypes.INTEGER,
    allowNull: false,
  },
});

// 定义事务
sequelize.transaction(async (transaction) => {
  try {
    // 创建多条记录
    const user = await User.create({ name: 'John Doe' }, { transaction });
    const order = await Order.create({ amount: 100 }, { transaction });

    // 提交事务
    await transaction.commit();

    console.log('Records created successfully');
  } catch (error) {
    // 回滚事务
    await transaction.rollback();

    console.error('Failed to create records:', error);
  }
});