Upgrade to sqlalchemy2

Open alastair opened this issue 1 month ago • 1 comments

Automatic upgrade with codex, I tested the webapp and it loads and runs, but didn't check for correctness and didn't check the import scripts

Oct 30 '25 12:10 alastair

Verified the database changes with jamendo-api and id3 tags, and running the app, seems ok with minor hiccup on API (I think jamendo started returning strings instead of ints). Decided to update the schema for streaming_id so it is a bit less headache and having all ids as ints. Contributes to potential necessity of rebuilding the db, although I suspect migrating to v2 would necessitate it anyway. As mentioned in #8 all data would need to be rebuilt anyway.

Nov 02 '25 22:11 philtgun