siimee/backend/knexfile.js

require('dotenv').config()
const fs = require('fs')

const useLocalDb = () => process.env.USE_LOCAL_DB == 'true'

const local = {
    host: process.env.DB_HOST,
    user: process.env.DB_USER,
    password: process.env.DB_ROOT_PASSWORD,
    database: process.env.DB_NAME,
    port: process.env.DB_PORT,
}
const pscale = {
    ssl: true,
    host: process.env.PSCALE_DB_HOST ? process.env.PSCALE_DB_HOST : '127.0.0.1',
    user: process.env.PSCALE_DB_USER ? process.env.PSCALE_DB_USER : 'root',
    password: process.env.PSCALE_DB_PASSWORD
        ? process.env.PSCALE_DB_PASSWORD
        : '',
    database: process.env.PSCALE_DB_NAME,
    port: process.env.PSCALE_DB_PORT ? process.env.PSCALE_DB_PORT : 3306,
}

module.exports = {
    development: {
        client: process.env.DB_TYPE,
        connection: useLocalDb() ? local : pscale,
        pool: {
            min: 2,
            max: 10,
        },
        migrations: {
            directory: './db/migrations',
        },
        seeds: {
            directory: './db/seeds',
        },
        ssl: useLocalDb()
            ? {}
            : {
                  ca: fs.readFileSync('/etc/ssl/certs/ca-certificates.crt'),
              },
    },
}