如何使用带有ON冲突子句的knex链接承诺？

const knex = require('knex')({
  client: 'mysql',
  connection: {
    host: 'localhost',
    user: 'your_username',
    password: 'your_password',
    database: 'your_database'
  }
});

knex.transaction(async (trx) => {
  // 在事务中执行数据库操作
});

knex.transaction(async (trx) => {
  await trx.insert({ id: 1, name: 'John' }).into('users').onConflict('id').merge();
});

knex.transaction(async (trx) => {
  await trx.insert({ id: 1, name: 'John' }).into('users').onConflict('id').merge();
  trx.commit();
}).catch((error) => {
  console.error(error);
  trx.rollback();
});