Knex Reset Postgresql Database

prepare-database.js

import knex from 'knex'
import knexConfig from 'SUMWHERE'

const prepareDatabase = async () => {
  const migrationTables = [`knex_migrations`, `knex_migrations_lock`]
  const knexInstance = knex(knexConfig)
  const closeConnection = pify(knexInstance.destroy)
  const tableNames = await knexInstance(`pg_tables`)
    .select(`tablename`)
    .where(`schemaname`, `public`)
    .then(tables => tables.map(r => r.tablename))
    .then(tables => tables.filter(name => !migrationTables.includes(name)))

  if (tableNames.length) {
    await knexInstance.raw(
      `TRUNCATE TABLE ${tableNames.join(',')} RESTART IDENTITY`
    )
  }

  return { knex: knexInstance, close: closeConnection }
}