promise-mysql-lite

A lite promise wrapper for mysql. It's just a basic version, be careful to use!!!

You should use node-promise-mysql

INSTALL

npm install @caaalabash/promise-mysql-lite -S

Example

const mysql = require('@caaalabash/promise-mysql-lite')

const config = {
  host: '10.10.5.146',
  user: 'root',
  password: '123456',
  database: 'test',
  debug: true,
  reconnect: true
}

;(async () => {
  // createPool is sync
  // createConnection is async
  const pool = mysql.createPool(config)
  const connection = await pool.getConnection()

  try {
    await connection.beginTransaction()
    // update user12's name
    await connection.query(`UPDATE tb_user SET name='calabash' WHERE id=1`)
    // delete user12
    await connection.query(`DELETE FROM tb_user WHERE id=1`)
    // update user12's money (Unknown column 'money' in 'field list')
    await connection.query(`UPDATE tb_user SET money='99999999999' WHERE id=1`)
    // Let's do it
    await connection.commit()
  } catch (e) {
    // calabash still alive！
    await connection.rollback()
  } finally {
    connection.release()
  }

  const singleConnection = await mysql.createConnection(config)
  await singleConnection.query(`SELECT * FROM tb_user`)
})()