'use strict'

const Mysql = require('@wac/mysql-client')

const client = new Mysql({
  host: 'localhost',
  user: 'root',
  database: 'test'
})

const results = await client.query('select * from table')

const tran = await client.beginTransaction()

await tran.query('update table set name = `Tony` where id = 101')
await tran.query('update table set name = `Rick` where id = 102')

await tran.commit()

const tran = await client.beginTransaction()

try {
  await tran.query('update table set name = `Tony` where id = 101')
  await tran.commit()
} catch (err) {
  await tran.rollback()
}