使用Sequelize在多个表中插入数据

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

const User = sequelize.define('User', {
  name: {
    type: DataTypes.STRING,
    allowNull: false
  },
  email: {
    type: DataTypes.STRING,
    allowNull: false,
    unique: true
  }
});

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

User.hasMany(Order); // 定义一对多关系

module.exports = { User, Order };

const { User, Order } = require('./models');

async function insertData() {
  try {
    await sequelize.sync(); // 同步模型到数据库

    const user = await User.create({
      name: 'John Doe',
      email: 'john@example.com'
    });

    const order = await Order.create({
      amount: 100,
      status: 'pending',
      UserId: user.id // 关联用户和订单
    });

    console.log('Data inserted successfully');
  } catch (error) {
    console.error('Error inserting data:', error);
  } finally {
    await sequelize.close(); // 关闭数据库连接
  }
}

insertData();