From 06ecdf2af182034496e2123852deee4a58de1043 Mon Sep 17 00:00:00 2001 From: Jules Laplace Date: Sun, 17 Oct 2021 02:52:05 +0200 Subject: making a shoebox --- knexfile.js | 60 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 60 insertions(+) create mode 100644 knexfile.js (limited to 'knexfile.js') diff --git a/knexfile.js b/knexfile.js new file mode 100644 index 0000000..2802f62 --- /dev/null +++ b/knexfile.js @@ -0,0 +1,60 @@ +/* eslint { id-length: 0 } */ + +/** + * Knex configuration file + */ + +require("dotenv").config(); + +const options = { + client: "pg", + pool: { + min: 2, + max: 10, + }, + migrations: { + tableName: "knex_migrations", + directory: "./src/migrations", + }, + seeds: { + directory: "./src/seeds", + }, +}; + +module.exports = { + development: { + ...options, + connection: { + database: process.env.DEVELOPMENT_DB_NAME, + user: process.env.DEVELOPMENT_DB_USER, + password: process.env.DEVELOPMENT_DB_PASS, + }, + }, + + staging: { + ...options, + connection: { + database: process.env.STAGING_DB_NAME, + user: process.env.STAGING_DB_USER, + password: process.env.STAGING_DB_PASS, + }, + }, + + test: { + ...options, + connection: { + database: process.env.TEST_DB_NAME, + user: process.env.TEST_DB_USER, + password: process.env.TEST_DB_PASS, + }, + }, + + production: { + ...options, + connection: { + database: process.env.PRODUCTION_DB_NAME, + user: process.env.PRODUCTION_DB_USER, + password: process.env.PRODUCTION_DB_PASS, + }, + }, +}; -- cgit v1.2.3-70-g09d2