yinrong / node-sqlx Goto Github PK

where: {
 field1: '1 ) or 1 = 1 ('
}

const client = sqlx.createClient({
  promise: true,
  ...
})

...
let result = await conn.insert('table7', {a:1, b:2})
console.log(result.rows)

conn_timeout = conn.timeout(30 * 1000) // 30 seconds
conn_timeout.insert(...) // will timeout in 30 seconds
conn.insert(...) // will not timeout or inherit default config

async.waterfall([
(next) => {
  conn.beginTransaction(next) // new interface
},
(next) => {
  conn.insert('table7', {id: 100, data: 2}, next)
},
(rows, info, next) => {
  console.log(rows, info)
  conn.commit(next) // new interface
},
(next) => {
   // (a)
  console.log('success')
},
], err => { 
  console.log('fail')
})