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
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
|
/**
* Config source: https://git.io/JesV9
*
* Feel free to let us know via PR, if you find something broken in this config
* file.
*/
import path from 'node:path';
import env from '#start/env';
import { defineConfig } from '@adonisjs/lucid';
const databaseConfig = defineConfig({
/*
|--------------------------------------------------------------------------
| Connection
|--------------------------------------------------------------------------
|
| The primary connection for making database queries across the application
| You can use any key from the `connections` object defined in this same
| file.
|
*/
connection: env.get('DB_CONNECTION', 'sqlite'),
connections: {
/*
|--------------------------------------------------------------------------
| SQLite
|--------------------------------------------------------------------------
|
| Configuration for the SQLite database. Make sure to install the driver
| from npm when using this connection
|
| npm i sqlite3
|
*/
sqlite: {
client: 'sqlite',
connection: {
filename: path.join(
env.get('DATA_DIR', 'data'),
`${env.get('DB_DATABASE', 'ferdium')}.sqlite`,
),
},
pool: {
afterCreate: (conn, cb) => {
conn.run('PRAGMA foreign_keys=true', cb);
},
},
migrations: {
naturalSort: true,
},
useNullAsDefault: true,
healthCheck: false,
},
/*
|--------------------------------------------------------------------------
| MySQL config
|--------------------------------------------------------------------------
|
| Configuration for MySQL database. Make sure to install the driver
| from npm when using this connection
|
| npm i mysql
|
*/
mysql: {
client: 'mysql',
connection: {
host: env.get('DB_HOST', 'localhost'),
port: Number(env.get('DB_PORT')),
user: env.get('DB_USER', 'root'),
password: env.get('DB_PASSWORD', ''),
database: env.get('DB_DATABASE', 'ferdium'),
},
migrations: {
naturalSort: true,
},
healthCheck: false,
},
/*
|--------------------------------------------------------------------------
| PostgreSQL config
|--------------------------------------------------------------------------
|
| Configuration for PostgreSQL database. Make sure to install the driver
| from npm when using this connection
|
| npm i pg
|
*/
pg: {
client: 'pg',
connection: {
host: env.get('DB_HOST', 'localhost'),
port: Number(env.get('DB_PORT')),
user: env.get('DB_USER', 'root'),
password: env.get('DB_PASSWORD', ''),
database: env.get('DB_DATABASE', 'ferdium'),
ssl: env.get('DB_CA_CERT')
? {
rejectUnauthorized: false,
ca: env.get('DB_CA_CERT'),
}
: JSON.parse(env.get('DB_SSL', 'true')),
},
migrations: {
naturalSort: true,
},
healthCheck: false,
},
},
});
export default databaseConfig;
|