与NodeJS和Informix DB一起使用的最好的ORM框架是什么？还支持事务管理

npm install sequelize sequelize-informix

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

const sequelize = new Sequelize('database', 'username', 'password', {
  host: 'hostname',
  dialect: 'informix',
  dialectOptions: {
    informix: {
      database: 'your_informix_database',
      host: 'your_informix_host',
      port: your_informix_port,
      user: 'your_informix_user',
      password: 'your_informix_password'
    }
  }
});

(async () => {
  try {
    await sequelize.authenticate();
    console.log('Connection has been established successfully.');
  } catch (error) {
    console.error('Unable to connect to the database:', error);
  }
})();

(async () => {
  const transaction = await sequelize.transaction();

  try {
    // 在事务中执行数据库操作
    const user = await User.create({ name: 'John Doe' }, { transaction });
    const profile = await Profile.create({ userId: user.id, bio: 'A developer' }, { transaction });

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

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

    console.error('Transaction rolled back due to error:', error);
  }
})();