在nodejs中，如何在事务中使用async/await而不是通过‘then’解析承诺？

npm install sequelize

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

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

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

// 测试数据库连接
(async () => {
  try {
    await sequelize.authenticate();
    console.log('Connection has been established successfully.');
  } catch (error) {
    console.error('Unable to connect to the database:', error);
  }
})();

// 在事务中使用async/await
try {
  await sequelize.transaction(async (transaction) => {
    // 在事务中执行数据库操作
    const user = await User.create({ name: 'John Doe' }, { transaction });
    // ...
  });
} catch (error) {
  console.error('Transaction failed:', error);
}