如何遍历多行sql查询并在Knex事务中使用它们？

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

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

const rows = await trx.select('*').from('users');

rows.forEach((row) => {
  console.log(row.name);
});

rows.forEach(async (row) => {
  await trx('users').where('id', row.id).update({ age: row.age + 1 });
});

await trx.commit();

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

knex.transaction(async (trx) => {
  try {
    const rows = await trx.select('*').from('users');

    rows.forEach((row) => {
      console.log(row.name);
    });

    rows.forEach(async (row) => {
      await trx('users').where('id', row.id).update({ age: row.age + 1 });
    });

    await trx.commit();
  } catch (error) {
    console.error(error);
    await trx.rollback();
  } finally {
    knex.destroy();
  }
});