db stuff and initial app scaffold

1 files changed, 56 insertions, 0 deletions

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'
+    }
+  }
+
+};
+