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 /scripts/adonisjs-4-to-5.sh | |
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 'scripts/adonisjs-4-to-5.sh')
-rw-r--r-- | scripts/adonisjs-4-to-5.sh | 50 |
1 files changed, 50 insertions, 0 deletions
diff --git a/scripts/adonisjs-4-to-5.sh b/scripts/adonisjs-4-to-5.sh new file mode 100644 index 0000000..ccb5c9f --- /dev/null +++ b/scripts/adonisjs-4-to-5.sh | |||
@@ -0,0 +1,50 @@ | |||
1 | #!/bin/bash | ||
2 | |||
3 | # THIS SCRIPT IS USED TO MIGRATE FROM ADONISJS V4 TO ADONISJS V5 | ||
4 | # IT SHOULD BE RUN BEFORE RUNNING THE SERVER | ||
5 | |||
6 | # Check if DB_DATABASE is undefined or empty, and set a default value if necessary | ||
7 | if [ -z "$DB_DATABASE" ]; then | ||
8 | DB_DATABASE="ferdium" | ||
9 | fi | ||
10 | |||
11 | # Check if DATA_DIR is undefined or empty, and set a default value if necessary | ||
12 | if [ -z "$DATA_DIR" ]; then | ||
13 | DATA_DIR="/data" | ||
14 | fi | ||
15 | |||
16 | # Define the path to your SQLite database file | ||
17 | db_file="$DATA_DIR/$DB_DATABASE.sqlite" | ||
18 | |||
19 | # Check if the database file exists | ||
20 | if [ ! -f "$db_file" ]; then | ||
21 | echo "Database file '$db_file' not found. An empty database will be created." | ||
22 | exit 0 | ||
23 | fi | ||
24 | |||
25 | # Check if the "adonis_schema_versions" table exists and if the version is less than 2 | ||
26 | version=$(sqlite3 "$db_file" "SELECT version FROM adonis_schema_versions LIMIT 1;" 2>/dev/null) | ||
27 | if [ -z "$version" ] || [ "$version" -lt 2 ]; then | ||
28 | # Table not found or version less than 2, proceed | ||
29 | echo "-- Starting database migration from AdonisJS v4 to v5 --" | ||
30 | |||
31 | # Check if the "adonis_schema" table exists | ||
32 | schema_exists=$(sqlite3 "$db_file" "SELECT name FROM sqlite_master WHERE type='table' AND name='adonis_schema';" 2>/dev/null) | ||
33 | if [ -n "$schema_exists" ]; then | ||
34 | # "adonis_schema" table exists, proceed | ||
35 | |||
36 | # Iterate through rows in the "name" column of "adonis_schema" and append "database/migrations" to each value | ||
37 | sqlite3 -batch "$db_file" "SELECT name FROM adonis_schema;" 2>/dev/null | while read -r old_value; do | ||
38 | new_value="database/migrations/$old_value" | ||
39 | echo "Updating value from '$old_value' to '$new_value'" | ||
40 | |||
41 | # Update the value in the database | ||
42 | sqlite3 "$db_file" "UPDATE adonis_schema SET name='$new_value' WHERE name='$old_value';" 2>/dev/null | ||
43 | done | ||
44 | else | ||
45 | echo "ERROR: Table 'adonis_schema' not found." | ||
46 | exit 1 | ||
47 | fi | ||
48 | # else | ||
49 | # echo "Version is greater than or equal to 2. Exiting script." | ||
50 | fi | ||