使用sequelize插入到mysql中的两个相关表中

npm install sequelize mysql2

const Sequelize = require('sequelize');
const mysql = require('mysql2');

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

const TableA = sequelize.define('TableA', {
  // 定义TableA的字段
});

const TableB = sequelize.define('TableB', {
  // 定义TableB的字段
});

// 定义TableA和TableB之间的关联关系
TableA.hasMany(TableB);
TableB.belongsTo(TableA);

sequelize.transaction((t) => {
  return TableA.create({
    // 设置TableA的字段值
  }, { transaction: t })
  .then((tableA) => {
    return TableB.create({
      // 设置TableB的字段值
      TableAId: tableA.id, // 设置外键关联
    }, { transaction: t });
  });
})
.then(() => {
  console.log('数据插入成功');
})
.catch((error) => {
  console.error('数据插入失败', error);
});