Skip to content

feat: add postgres support + migrations (#628) #1287

feat: add postgres support + migrations (#628)

feat: add postgres support + migrations (#628) #1287

Triggered via push December 16, 2024 13:02
Status Success
Total duration 23m 56s
Artifacts

ci.yml

on: push
Build & Publish Docker Images
23m 36s
Build & Publish Docker Images
Lint & Test Build
0s
Lint & Test Build
Send Discord Notification
3s
Send Discord Notification
Fit to window
Zoom out
Zoom in

Annotations

1 warning
Send Discord Notification
embed field value must be shorter than 1024, got 2950 [`44a9221`](https://github.com/Fallenbagel/jellyseerr/commit/44a9221a9dca501fa57c0bcbd743aed9889059ff) feat: add postgres support + migrations (#628) * chore(release): 1.4.0 * chore(release): 1.4.1 * chore(release): 1.5.0 * chore(release): 1.6.0 * chore(release): 1.7.0 * feat: support for postgresql * test(pgsql): disable root certificate verification * test(ci): temporarily change CI for local repo * fix: don't use SQLite idiom when using PgSQL * feat(db): add flag to toggle TLS for Postgres * feat(postgres and migrations): added migrations for postgres & imporved ssl for postgres config #186 * fix: restored workflow actions * fix: access order * fix: added pushover sound migration tto initial migration * fix: added option to log queries * fix: issue with session migration * chore: relocate pushover sound migration * feat: added logging option to other datasources * chore: small tweaks for the datasource. Added docs for db setup * chore: cleanup logs * fix: added default dates to postgres migration * fix: removed psql specific relation checks * chore: added some debug sanity checks * chore: added some more debug sanity checks * chore: added some more additional debug sanity checks * chore: added some more+ additional debug sanity checks * chore: mild log cleanup * chore: more log cleanup * chore: finish log cleanup * fix: added not null to migration so typeorm doesn't delete ids * chore: cleanup extra psql code * fix: remove eager load * docs: added documentation for migration to postgres * docs: added database option to bug template * feat: created docker-compose postgres file * fix: updated ts schema to align with change to migration * fix: switch timestamp to include timezone * fix: fixed indentation in psql docker-compose * fix: changed version to 0.1.0 to remove ui notification * style: fixed prettier in docker-compose.pastgres.yaml * chore: restored CHANGELOG.md * chore: revverted ts commit * fix: update pnpm lock with pg package * chore(pnpm-lock.yaml): updated pnpm-lock * docs: update docs to add psql set up info * refactor: clean up code from cr comments * feat: migrate blacklist * fix: fix issue with cypress tests * docs: update psql docs * fix: fix psql issue in user page; fix tiny psql error when selecting by empty list * fix: incorrect current date function * fix: null contraint with mediaAddedAt; fix psql col type * refactor: removed unnecessary import * feat: add postgres migration for streaming region --------- Co-authored-by: Fallenbagel <[email protected]> Co-authored-by: semantic-release-bot <[email protected]> Co-authored-by: zackhow <[email protected]> Co-authored-by: Ryan Algar <[email protected]> Co-authored-by: Ryan Algar <[email protected]>