28 lines
607 B
JavaScript
28 lines
607 B
JavaScript
import dotenv from 'dotenv';
|
|
|
|
dotenv.config({ quiet: true });
|
|
|
|
const ssl = process.env.DB_SSL === 'true' ? { rejectUnauthorized: true } : undefined;
|
|
|
|
/** @type {import('knex').Knex.Config} */
|
|
const config = {
|
|
client: 'mysql2',
|
|
connection: {
|
|
host: process.env.DB_HOST,
|
|
port: process.env.DB_PORT ? Number(process.env.DB_PORT) : 3306,
|
|
user: process.env.DB_USER,
|
|
password: process.env.DB_PASSWORD,
|
|
database: process.env.DB_NAME,
|
|
ssl,
|
|
dateStrings: true,
|
|
},
|
|
migrations: {
|
|
directory: './migrations',
|
|
},
|
|
seeds: {
|
|
directory: './seeds',
|
|
},
|
|
};
|
|
|
|
export default config;
|