Database migration and seeding

1 files changed, 21 insertions, 0 deletions

diff --git a/knexfile.js b/knexfile.js
new file mode 100644
index 0000000..e92fe20
--- /dev/null
+++ b/knexfile.js
@@ -0,0 +1,21 @@
+require('dotenv').config();
+
+module.exports = {
+	client: process.env.DB_CLIENT,
+	connection: {
+		host: process.env.DB_HOST,
+		user: process.env.DB_USER,
+		password: process.env.DB_PASSWORD,
+		database: process.env.DB_DATABASE
+	},
+	pool: {
+		min: process.env.DATABASE_POOL_MIN || 2,
+		max: process.env.DATABASE_POOL_MAX || 10
+	},
+	migrations: {
+		directory: 'src/api/database/migrations'
+	},
+	seeds: {
+		directory: 'src/api/database/seeds'
+	}
+};