-
Notifications
You must be signed in to change notification settings - Fork 1
/
knexfile.js
80 lines (77 loc) · 1.71 KB
/
knexfile.js
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
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
// Update with your config settings.
require("dotenv").config();
module.exports = {
development: {
client: "sqlite3",
connection: {
filename: "./data/immunize.sqlite3",
},
useNullAsDefault: true,
migrations: {
directory: "./data/migrations",
},
seeds: {
directory: "./data/seeds",
},
pool: {
afterCreate: (conn, done) => {
// runs after a connection is made to the sqlite engine
conn.run("PRAGMA foreign_keys = ON", done); // turn on FK enforcement
},
},
},
testing: {
client: "sqlite3",
connection: { filename: "./data/test.db3" },
useNullAsDefault: true,
migrations: { directory: "./data/migrations" },
seeds: { directory: "./data/seeds" },
},
staging: {
client: "postgresql",
connection: {
database: "my_db",
user: "username",
password: "password",
},
pool: {
min: 2,
max: 10,
},
migrations: {
tableName: "knex_migrations",
},
},
// production: {
// client: "pg",
// connection: {
// host: "ec2-174-129-252-226.compute-1.amazonaws.com",
// database: "da331ci5il1rtb",
// user: "vhurvlbvryxlxf",
// password:
// "4e453cc71be3af80a773d51c77458f6392074623bc80dd5da2bbc044c5ae8a42",
// },
// pool: {
// min: 2,
// max: 10,
// },
// migrations: {
// directory: "./data/migrations",
// tableName: "knex_migrations",
// },
// },
production: {
client: "pg",
connection: process.env.DATABASE_URL,
pool: {
min: 2,
max: 10,
},
migrations: {
directory: "./data/migrations",
},
seeds: {
directory: "./data/seeds",
},
},
};