making a shoebox

1 files changed, 60 insertions, 0 deletions

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