const faker = require('faker')
const mysql = require('mysql2/promise')


// function createRow () {
//   return {
//     column: faker.database.column(),
//     type: faker.database.type(),
//     collation: faker.database.collation(),
//     engine: faker.database.engine()
//   }
// }

async function main () {
// create the connection to database
  const connection = await mysql.createConnection({
    host: '',
    user: '',
    database: '',
    password: ''
  })

  // const ok = await connection.query('UPDATE `test` SET field = ? WHERE id >= ?', ['hello', 1000])
  // const ok = await connection.query('DELETE FROM `test` WHERE id >= ?', [1000])
  const ok = await connection.query('INSERT INTO `test` SET ?', { id: 1001, field: 'hello' })

  // const [ rows ] = await connection.execute('SELECT * FROM `test`')
  return 'listening to port *:3000'
}

main()
.then(console.log)
.catch(console.error)