Knex: create table if not exists

Knex_create_table_if_not_exists.md

Knex: Create table if not exists

const Knex = require('knex')
const config = require('./config')
const knex = Knex(config.knex)

async function createSchema () {
  const hasTable = await knex.schema.hasTable('videoRequests')
  if (!hasTable) {
    return knex.migrate.latest()
      .then(() => {
        __logger.info(`Server was successfully creates initial table in '${config.knex.connection.database}' database`)
      }).catch(error => {
        throw Error(`Initial schema creation was fail ${error}`)
      })
  } else {
    __logger.info(`'${config.knex.connection.database}' database already has required schema`)
  }
}

module.exports = createSchema

great, tahnks!