JavaScript fixture loading into MySQL

load-fixture.js

const queries = [
  ["SET FOREIGN_KEY_CHECKS=0", []],
  ["TRUNCATE TABLE foo", []],
  ["INSERT INTO foo (id, name) VALUES (?, ?)", [1, "foooo"]],
  ["TRUNCATE TABLE bar", []],
  ["INSERT INTO bar (id, name) VALUES (?, ?)", [2, "baaaar"]],
  ["SET FOREIGN_KEY_CHECKS=1", []]
]

const db = mysql.createConnection(...)
                                  
const executeQueries = (db, queries = [], callback) => {
  if (!queries.length) return callback()
  
  const p = new Promise((resolve, reject) => {
    db.execute(
      queries[0][0],
      queries[0][1],
      (err, res) => err ? reject(err) : resolve(res)
    )
  })
  p.then(res => executeQueries(db, queries.splice(1), callback))
  p.catch(err => { throw err })
}

executeQueries(db, queries, () => db.close())