diff options
author | Ricardo <ricardo@cino.io> | 2023-10-13 14:12:03 +0200 |
---|---|---|
committer | GitHub <noreply@github.com> | 2023-10-13 13:12:03 +0100 |
commit | e503468660a13760010a94ecda5f0625c6f47f87 (patch) | |
tree | fa532f54fc5f091de08d55405ec6339bd2440a02 /config/database.ts | |
parent | 1.3.16 [skip ci] (diff) | |
download | ferdium-server-e503468660a13760010a94ecda5f0625c6f47f87.tar.gz ferdium-server-e503468660a13760010a94ecda5f0625c6f47f87.tar.zst ferdium-server-e503468660a13760010a94ecda5f0625c6f47f87.zip |
Server re-build with latest AdonisJS framework & Typescript (#47)
* chore: setup first basis structure
* chore: ensure styling is loaded correctly
* chore: comply to new routing syntax by replace . with / in routes/resource locations
* chore: add login controller
* chore: correctly use views with slash instead of dot
* chore: working login + tests
* chore: clean up tests
* chore: add password-forgot endpoint and matching test
* chore: add delete page test
* chore: add logout test
* chore: add reset-password route and tests
* chore: remove obsolete comment
* chore: add account-page and tests
* chore: add data page & first step of the test
* chore: add transfer/import data feature and tests
* chore: add export and basic test
* chore: add all static api routes with tests
* Regenerate 'pnpm-lock.json' and fix bad merge conflict
WIP:
- Tests have been commented out since they dont work
- Server doesn't start
* easier dev and test runs
* - remove --require-pragma from reformat-files so formatting works properly
- run pnpm reformat-files over codebase
- remove .json files from .eslintignore
- add invalid.json file to .eslintignore
- configure prettier properly in eslint config
- add type jsdoc to prettier config
- run adonis generate:manifest command to regenerate ace-manifest.json
- specify volta in package.json
- introduce typecheck npm script
- remove unused .mjs extension from npm scripts
- install missing type definition dependencies
- add pnpm.allowedDeprecatedVersions to package.json
- fix invalid extends in tsconfig.json causing TS issues throughout codebase
- remove @ts-ignore throughout codebase which is not relevant anymore
- enable some of the tsconfig options
- remove outdated eslint-disable from codebase
- change deprecated faker.company.companyName() to faker.company.name()
- fix TS issues inside transfer.spec.ts
* - update to latest node and pnpm versions
- upgrade all non-major dependencies to latest
- install missing @types/luxon dependency
- add cuid to pnpm.allowedDeprecatedVersions
- add esModuleInterop config option to tsconfig
- migrate more deprecated faker methods to new ones
- add more temporary ts-ignore to code
* - update eslint config
- remove trailingComma: all since default in prettier v3
- add typecheck command to prepare-code npm script
- upgrade various dependencies to latest major version
- update tsconfig to include only useful config options
- disable some lint issues and fix others
* - add test command to prepare-code
- disable strictPropertyInitialization flag in tsconfig which creates issues with adonis models
- update precommit hook to excute pnpm prepare-code
- remove ts-ignore statements from all models
* fix node and pnpm dependency update
* add cross env (so that we can develop on windows)
* add signup endpoint (TODO: JWT auth)
* Add login endpoint
* Add me and updateMe endpoints
* Add service endpoint
* refactor: change endpoints to use jwt
* add recipes endpoint
* add workspaces endpoint
* fix web controllors for login and post import
* Update node deps
* Change auth middleware (for web) and exempt api from CSRF
* Add import endpoint (franz import)
* Fix export/import logic
* Fix service and workspace data in user/data
* Fix partial lint
* chore: workaround lint issues
* fix: migration naming had two .
* Sync back node with recipes repo
* Temporarily ignore typescript
* Fix adonisrc to handle public folder static assets
* Fix issue with production database
* add Legacy Password Provider
* Fix lint errors
* Fix issue on login errors frontend
* add Legacy Password Provider
* Fix issue with customIcons
* Fix issue with auth tokens
* Update 'node' to '18.18.0'
* make docker work
* improve docker entrypoint (test api performance)
* Add migration database script
* NODE_ENV on recipes
* prefer @ts-expect-error over @ts-ignore
* small fixes
* Update 'pnpm' to '8.7.6'
* fix error catch
* Automatically generate JWT Public and Private keys
* Use custom Adonis5-jwt
* Update code to use secret (old way, no breaking changes)
* Normalize appKey
* Trick to make JWT tokens on client work with new version
* Fix error with new JWT logic
* Change migration and how we store JWT
* Fix 500 response code (needs to be 401)
* Improve logic and fix bugs
* Fix build and entrypoint logic
* Catch error if appKey changes
* Add newToken logic
* Fix lint (ignore any errors)
* Add build for PRs
* pnpm reformat-files result
* Fix some tests
* Fix reset password not working (test failing)
* Restore csrfTokens (disabled by accident)
* Fix pnpm start command with .env
* Disable failing tests on the transfer endpoint (TODO)
* Add tests to PR build
* Fix build
* Remove unnecessary assertStatus
* Add typecheck
* hash password on UserFactory (fix build)
* Add JWT_USE_PEM true by default (increase security)
* fix name of github action
---------
Co-authored-by: Vijay A <vraravam@users.noreply.github.com>
Co-authored-by: Balaji Vijayakumar <kuttibalaji.v6@gmail.com>
Co-authored-by: MCMXC <16797721+mcmxcdev@users.noreply.github.com>
Co-authored-by: André Oliveira <oliveira.andrerodrigues95@gmail.com>
Diffstat (limited to 'config/database.ts')
-rw-r--r-- | config/database.ts | 121 |
1 files changed, 121 insertions, 0 deletions
diff --git a/config/database.ts b/config/database.ts new file mode 100644 index 0000000..65a9455 --- /dev/null +++ b/config/database.ts | |||
@@ -0,0 +1,121 @@ | |||
1 | /* eslint-disable @typescript-eslint/indent */ | ||
2 | /** | ||
3 | * Config source: https://git.io/JesV9 | ||
4 | * | ||
5 | * Feel free to let us know via PR, if you find something broken in this config | ||
6 | * file. | ||
7 | */ | ||
8 | |||
9 | import path from 'node:path'; | ||
10 | import Env from '@ioc:Adonis/Core/Env'; | ||
11 | import { DatabaseConfig } from '@ioc:Adonis/Lucid/Database'; | ||
12 | |||
13 | const databaseConfig: DatabaseConfig = { | ||
14 | /* | ||
15 | |-------------------------------------------------------------------------- | ||
16 | | Connection | ||
17 | |-------------------------------------------------------------------------- | ||
18 | | | ||
19 | | The primary connection for making database queries across the application | ||
20 | | You can use any key from the `connections` object defined in this same | ||
21 | | file. | ||
22 | | | ||
23 | */ | ||
24 | connection: Env.get('DB_CONNECTION', 'sqlite'), | ||
25 | |||
26 | connections: { | ||
27 | /* | ||
28 | |-------------------------------------------------------------------------- | ||
29 | | SQLite | ||
30 | |-------------------------------------------------------------------------- | ||
31 | | | ||
32 | | Configuration for the SQLite database. Make sure to install the driver | ||
33 | | from npm when using this connection | ||
34 | | | ||
35 | | npm i sqlite3 | ||
36 | | | ||
37 | */ | ||
38 | sqlite: { | ||
39 | client: 'sqlite', | ||
40 | connection: { | ||
41 | filename: path.join( | ||
42 | Env.get('DATA_DIR', 'data'), | ||
43 | `${Env.get('DB_DATABASE', 'ferdium')}.sqlite`, | ||
44 | ), | ||
45 | }, | ||
46 | pool: { | ||
47 | afterCreate: (conn, cb) => { | ||
48 | conn.run('PRAGMA foreign_keys=true', cb); | ||
49 | }, | ||
50 | }, | ||
51 | migrations: { | ||
52 | naturalSort: true, | ||
53 | }, | ||
54 | useNullAsDefault: true, | ||
55 | healthCheck: false, | ||
56 | debug: Env.get('DB_DEBUG', false), | ||
57 | }, | ||
58 | |||
59 | /* | ||
60 | |-------------------------------------------------------------------------- | ||
61 | | MySQL config | ||
62 | |-------------------------------------------------------------------------- | ||
63 | | | ||
64 | | Configuration for MySQL database. Make sure to install the driver | ||
65 | | from npm when using this connection | ||
66 | | | ||
67 | | npm i mysql | ||
68 | | | ||
69 | */ | ||
70 | mysql: { | ||
71 | client: 'mysql', | ||
72 | connection: { | ||
73 | host: Env.get('DB_HOST', 'localhost'), | ||
74 | port: Env.get('DB_PORT', ''), | ||
75 | user: Env.get('DB_USER', 'root'), | ||
76 | password: Env.get('DB_PASSWORD', ''), | ||
77 | database: Env.get('DB_DATABASE', 'ferdium'), | ||
78 | }, | ||
79 | migrations: { | ||
80 | naturalSort: true, | ||
81 | }, | ||
82 | healthCheck: false, | ||
83 | debug: Env.get('DB_DEBUG', false), | ||
84 | }, | ||
85 | |||
86 | /* | ||
87 | |-------------------------------------------------------------------------- | ||
88 | | PostgreSQL config | ||
89 | |-------------------------------------------------------------------------- | ||
90 | | | ||
91 | | Configuration for PostgreSQL database. Make sure to install the driver | ||
92 | | from npm when using this connection | ||
93 | | | ||
94 | | npm i pg | ||
95 | | | ||
96 | */ | ||
97 | pg: { | ||
98 | client: 'pg', | ||
99 | connection: { | ||
100 | host: Env.get('DB_HOST', 'localhost'), | ||
101 | port: Env.get('DB_PORT', ''), | ||
102 | user: Env.get('DB_USER', 'root'), | ||
103 | password: Env.get('DB_PASSWORD', ''), | ||
104 | database: Env.get('DB_DATABASE', 'ferdium'), | ||
105 | ssl: Env.get('DB_CA_CERT') | ||
106 | ? { | ||
107 | rejectUnauthorized: false, | ||
108 | ca: Env.get('DB_CA_CERT'), | ||
109 | } | ||
110 | : JSON.parse(Env.get('DB_SSL', 'true')), | ||
111 | }, | ||
112 | migrations: { | ||
113 | naturalSort: true, | ||
114 | }, | ||
115 | healthCheck: false, | ||
116 | debug: Env.get('DB_DEBUG', false), | ||
117 | }, | ||
118 | }, | ||
119 | }; | ||
120 | |||
121 | export default databaseConfig; | ||