knexfile.js

require('dotenv').config({ path: `.env.${process.env.NODE_ENV}` });
const path = require('path');

const connection = process.env.DATABASE_URL_SEEDER;

const postgresPattern = /^postgresql:\//;
if (!postgresPattern.test(connection)) {
  throw new Error('invalid database connection url received');
}

module.exports = {
  development: {
    client: 'pg',
    connection,
    searchPath: [process.env.DATABASE_SCHEMA, 'public'],
    pool: {
      min: 1,
      max: 10,
    },
    seeds: {
      directory: path.join(__dirname, 'database', 'seeds'),
    },
    debug: process.env.NODE_LOG_LEVEL === 'debug',
  },
  test: {
    client: 'pg',
    connection,
    searchPath: [process.env.DATABASE_SCHEMA, 'public'],
    pool: {
      min: 1,
      max: 10,
    },
    seeds: {
      directory: path.join(__dirname, 'database', 'seeds'),
    },
    debug: process.env.NODE_LOG_LEVEL === 'debug',
  },
};