knexfile.js

require('dotenv').config();
let fs = require('fs-extra');

let productionConnection = {};
if (process.env.NODE_ENV === 'production') {
  let dbHost, dbUser, dbPass;

  if (process.env.DB_HOST_FILE) {
    dbHost = fs.readFileSync(process.env.DB_HOST_FILE, 'utf8').trim();
  } else {
    dbHost = process.env.DB_HOST;
  }

  if (process.env.DB_USER_FILE) {
    dbUser = fs.readFileSync(process.env.DB_USER_FILE, 'utf8').trim();
  } else {
    dbUser = process.env.DB_USER;
  }

  if (process.env.DB_PASSWORD_FILE) {
    dbPass = fs
      .readFileSync(process.env.DB_PASSWORD_FILE, 'utf8')
      .trim();
  } else {
    dbPass = process.env.DB_PASSWORD;
  }

  productionConnection = {
    host: dbHost,
    user: dbUser,
    password: dbPass,
    database: process.env.DB_DATABASE,
    port: process.env.DB_PORT,
    ssl: {
      ca: fs.readFileSync(
        '/etc/ssl/certs/' + process.env.DB_CERT_FILENAME,
      ),
    },
  };
}

module.exports = {
  test: {
    client: 'sqlite3',
    connection: {
      filename: './test/test.sqlite3',
    },
    useNullAsDefault: true,
    migrations: {
      tableName: process.env.DB_MIGRATIONS_TABLE,
    },
    seeds: {
      directory: './seeds/test',
    },
  },

  development: {
    client: 'mysql2',
    connection: {
      host: process.env.DB_HOST,
      user: process.env.DB_USER,
      password: process.env.DB_PASSWORD,
      database: process.env.DB_DATABASE,
      port: process.env.DB_PORT,
    },
    migrations: {
      tableName: process.env.DB_MIGRATIONS_TABLE,
    },
    seeds: {
      directory: './seeds/development',
    },
  },

  production: {
    client: 'mysql2',
    connection: productionConnection,
    migrations: {
      tableName: process.env.DB_MIGRATIONS_TABLE,
    },
    seeds: {
      directory: './seeds/production',
    },
  },
};