Typescript Sequelize使用链接到事务中数据关键字创建数据

import { Sequelize, Model, DataTypes } from 'sequelize';

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

class User extends Model {}
User.init({
  username: DataTypes.STRING,
  email: DataTypes.STRING,
}, { sequelize, modelName: 'user' });

class Post extends Model {}
Post.init({
  title: DataTypes.STRING,
  content: DataTypes.TEXT,
}, { sequelize, modelName: 'post' });

sequelize.transaction(async (transaction) => {
  try {
    const user = await User.create(
      { username: 'John', email: 'john@example.com' },
      { transaction }
    );

    const post = await Post.create(
      { title: 'Hello', content: 'Welcome to my blog!' },
      { transaction }
    );

    // 使用数据关键字关联用户和帖子
    await user.addPost(post, { transaction });

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

    console.log('数据创建成功！');
  } catch (error) {
    // 回滚事务
    await transaction.rollback();

    console.error('数据创建失败：', error);
  }
});