How to execute a certain code after a function call?

Question

JavaScript

There is a code:

exports.prepareTransaction = () => {
    return new Promise((resolve, reject) => {
        pool.getConnection((err, connection) => {
          if (err) throw err;

          const beginTransaction = promisify(connection.beginTransaction).bind(connection);
          const query = promisify(connection.query).bind(connection);
          
          const commit = promisify(connection.commit).bind(connection);
          const rollback = promisify(connection.rollback).bind(connection);

          resolve({beginTransaction, query, commit, rollback});
        });
    });
};

I work with it like this:

let transaction = await connection.prepareTransaction();	

try {
  await transaction.beginTransaction();
  ...
  await transaction.commit();
}

I need that when transaction.commit() is called, after it is executed, connection.release() is executed inside my promise, that is, I must somehow pass the connection context to my promise. It should turn out something like:

const commit = promisify(connection.commit( () => connection.release() )).bind(connection);

Only it doesn't work. How to do it right?

Answer 1

Why can't you write
await connection.release(); after await transaction.commit();?