.js

const generateTable = (table_name, columns, data) => {
  return knex.transaction((trx) => {
    return trx.schema.dropTableIfExists(table_name)
    .then(() => {
      return trx.schema.createTable(table_name, (tbl) => {
        tbl.increments('id')
        columns.map(key => {
          key === 'user_id' 
            ? tbl.integer(key)
            : tbl.string(key)
        })
      })
    })
    .then(() => {
      console.log(`${table_name} has been created with colums: [${columns}]`)
      // # populate the table
      let insert_jobs = []

      data.map(row => {
        insert_jobs.push(trx.insert(row).into(table_name))
      })

      return Promise.all(insert_jobs).then(() => console.log(`${table_name} has been populated`))
    })
  })
}