const path = require('path');
const { knexSnakeCaseMappers } = require('objection');

const dotEnvPath = path.join(__dirname, '..', '.env');
const dotenv = require('dotenv').config({ path: dotEnvPath });
const { db } = require('../config.json');


module.exports = {
  development: {
    client: 'postgres',
    connection: {
      port: dotenv.DATABASE_PORT,
      host: dotenv.DATABASE_HOST,
      database: dotenv.DATABASE_NAME,
      user: dotenv.DATABASE_USER,
      password: dotenv.DATABASE_PASSWORD,
    },
    ...knexSnakeCaseMappers(),
    searchPath: 'public',
    debug: true,
    pool: {
      min: dotenv.DATABASE_POOL_MIN,
      max: dotenv.DATABASE_POOL_MAX,
    },
    migrations: {
      tableName: 'knex_migrations',
      directory: path.join(__dirname, '/migrations'),
    },
    seeds: {
      directory: path.join(__dirname, '/seeds/'),
    },
  },

  /*
  staging: This is the release candidate, and this environment is normally
  a mirror of the production environment.
  The staging area contains the "next" version of the application and is
  used for final stress testing and client/manager approvals before going live.
  */
  testing: {
    client: 'postgres',
    connection: {
      port: dotenv.DATABASE_PORT,
      host: dotenv.DATABASE_HOST,
      database: dotenv.DATABASE_NAME,
      user: dotenv.DATABASE_USER,
      password: dotenv.DATABASE_PASSWORD,
    },
    ...knexSnakeCaseMappers(),
    searchPath: 'public',
    debug: false,
    pool: {
      min: dotenv.DATABASE_POOL_MIN,
      max: dotenv.DATABASE_POOL_MAX,
    },
    migrations: {
      tableName: 'knex_migrations',
      directory: path.join(__dirname, '/migrations'),
    },
    seeds: {
      directory: path.join(__dirname, '/seeds/'),
    },
  },


  production: {
    client: 'postgres',
    connection: {
      port: db.PORT,
      host: db.HOST,
      database: db.DATABASE,
      user: db.USER,
      password: db.PASSWORD,
    },
    ...knexSnakeCaseMappers(),
    searchPath: 'public',
    debug: false,
    pool: {
      min: dotenv.DATABASE_POOL_MIN,
      max: dotenv.DATABASE_POOL_MAX,
    },
    migrations: {
      tableName: 'knex_migrations',
      directory: path.join(__dirname, '/migrations'),
    },
    seeds: {
      directory: path.join(__dirname, '/seeds/'),
    },
  },


};