transactions arguments showing undefined

[matt-wiz]

I am trying to run a transaction but r is always showing undefined. Whether it's a SELECT or INSERT, I can't access things like r.affectedRows or r.insertId. Is it because I am using the mysql2 library?

let results = await mysql.transaction() .query('INSERT INTO table (x) VALUES(?)', [1]) .query((r) => { console.log(r.insertId)// always shows undefined but row is added. }) .commit() // execute the queries

or

let results = await mysql .transaction() .query('SELECT * FROM table WHERE name = ?', ['serverless']) .query((r) => { console.log(r.affectedRows) }) .commit() // execute the queries

[naorpeled]

Hey @matt-wiz, sorry for the big delay.

The following should work.

let results = await mysql.transaction()
.query('INSERT INTO table (x) VALUES(?)', [1])
// always shows undefined but row is added.
.query((_, r) => {
   console.log(r.insertId)
  })
// execute the queries
.commit() 

the current implementation of query in transactions lets you specify a function that its first argument is an object with a rollback function and the second argument contains the result of the previous query.

Let me know if you need anything else.

[naorpeled]

Hey, I'm closing this issue as completed. Feel free to ping me if you need anything else.