PokeBattle-Backend/knexfile.js at main · ajg7/PokeBattle-Backend · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
const dotenv = require("dotenv");
dotenv.config();

module.exports = {
	development: {
		client: "pg",
		connection: process.env.DATABASE_URL,
		migrations: {
			directory: "./server/db/migrations",
		},
		seeds: {
			directory: "./server/db/seeds",
		},
	},

	test: {
		client: "pg",
		connection: process.env.DATABASE_URL,
		migrations: {
			directory: "./server/db/migrations",
		},
		seeds: {
			directory: "./server/db/seeds",
		},
	},

	production: {
		client: "pg",
		connection: `${process.env.DATABASE_URL}?ssl=true`,
		sslmode: require,
		pool: {
			min: 2,
			max: 10,
		},
		migrations: {
			directory: "./server/db/migrations",
		},
		seeds: {
			directory: "./server/db/seeds",
		},
	},
};