From a190d638c608f4352e3f01d72ed419a5ab5129ed Mon Sep 17 00:00:00 2001 From: Jules Laplace Date: Thu, 29 Jun 2017 00:14:07 +0200 Subject: db stuff and initial app scaffold --- knexfile.js | 56 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 56 insertions(+) create mode 100644 knexfile.js (limited to 'knexfile.js') diff --git a/knexfile.js b/knexfile.js new file mode 100644 index 0000000..1e7b5e9 --- /dev/null +++ b/knexfile.js @@ -0,0 +1,56 @@ +// Update with your config settings. + +require('dotenv').load() + +module.exports = { + + development: { + client: 'mysql2', + connection: { + database: process.env.DB_NAME, + user: process.env.DB_USER, + password: process.env.DB_PASS + }, + pool: { + min: 2, + max: 10 + }, + migrations: { + tableName: 'knex_migrations' + } + }, + + staging: { + client: 'mysql2', + connection: { + database: process.env.DB_NAME, + user: process.env.DB_USER, + password: process.env.DB_PASS + }, + pool: { + min: 2, + max: 10 + }, + migrations: { + tableName: 'knex_migrations' + } + }, + + production: { + client: 'mysql2', + connection: { + database: process.env.DB_NAME, + user: process.env.DB_USER, + password: process.env.DB_PASS + }, + pool: { + min: 2, + max: 10 + }, + migrations: { + tableName: 'knex_migrations' + } + } + +}; + -- cgit v1.2.3-70-g09d2