WIP: refactor: migrate to prisma #22

Open
opened 2026-07-29 11:46:48 +00:00 by robin · 7 comments
Owner

Migrate to prisma from better-sqlite3

Migrate to prisma from better-sqlite3
rudi was assigned by robin 2026-07-29 11:46:48 +00:00
rudi added reference migration-to-prisma 2026-07-30 08:22:59 +00:00
robin changed title from [refactor] migrate to prisma to refactor: migrate to prisma 2026-07-30 08:39:21 +00:00
Owner

Das Grundgerüst ist gemacht, ich kann mit dem ORM (primsa) arbeiten (funktionen aufrufen, usw)
TODO: Umarbeitung von @/lib/db*

Das Grundgerüst ist gemacht, ich kann mit dem ORM (primsa) arbeiten (funktionen aufrufen, usw) TODO: Umarbeitung von @/lib/db*
robin marked the pull request as work in progress 2026-08-04 12:52:18 +00:00
Owner

Function to the Database and the API are done. Now only the Frontend is todo.

Function to the Database and the API are done. Now only the Frontend is todo.
Author
Owner

While workling on the integration to the frontend, I found a few issues on the backend:

  • /app/api/songbooks/route.ts POST: requiers language althought it shouldn't (and the description tells it wouldn't). In general the descriptions are sometimes wrong (e. g. telling the API requires "name" althought it's "title")
  • many (e. g. /lib/db/song.ts): variables are type of 'unknown'.
  • many (e. g. /app/api/songbooks/[songBookId]/songs/[songId]/route.ts): params have a 'any' type.
  • /app/api/songs/route.ts POST: why does the description speak about songbooks althought the API handles songs (hopefully)??

Should I fix them or will you? There might come some more issues in some time.

While workling on the integration to the frontend, I found a few issues on the backend: - [ ] /app/api/songbooks/route.ts POST: requiers language althought it shouldn't (and the description tells it wouldn't). In general the descriptions are sometimes wrong (e. g. telling the API requires "name" althought it's "title") - [ ] many (e. g. /lib/db/song.ts): variables are type of 'unknown'. - [ ] many (e. g. /app/api/songbooks/[songBookId]/songs/[songId]/route.ts): params have a 'any' type. - [ ] /app/api/songs/route.ts POST: why does the description speak about songbooks althought the API handles songs (hopefully)?? Should I fix them or will you? There might come some more issues in some time.
Owner

I forgot to say, that i've done many of Copy and paste, so there could be some issues. The code should work fine, because i usually check the variables in the /lib/-APIs.

You can just ask AI how the Description should be...

I forgot to say, that i've done many of Copy and paste, so there could be some issues. The code should work fine, because i usually check the variables in the /lib/-APIs. You can just ask AI how the Description should be...
Author
Owner

Functions not implemented yet (but needed):

  • remove song from songbook
Functions not implemented yet (but needed): - [x] remove song from songbook
Author
Owner

I forgot to say, that i've done many of Copy and paste, so there could be some issues. The code should work fine, because i usually check the variables in the /lib/-APIs.

You can just ask AI how the Description should be...

I mean for the wiki...

> I forgot to say, that i've done many of Copy and paste, so there could be some issues. The code should work fine, because i usually check the variables in the /lib/-APIs. > > You can just ask AI how the Description should be... > I mean for the wiki...
Owner

What do you mean for the wiki

What do you mean for the wiki
robin added this to the Erste stable-Version milestone 2026-09-28 15:42:25 +00:00
Sign in to join this conversation.
2 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: PsalmTafel/psalmtafel-webservice#22