Resolve "Upgrade SQLAlchemy"
Description
Upgrade to SQLAlchemy v2. Includes updates to alembic, psycopg2, and SQLAlchemy-Searchable.
Notes to review (code/docs/QA)
Mypy is allowed to fail in CI, awaiting #2236 (closed) (and possibly #2238 (closed)).
Migrations might be broken, as alembic has been upgraded, and we don't actually test data migrations (only schema migrations). Docs should reflect this by something like this:
Migrating database from pre 1.18.0: If you experience problems with database migrations (using ella-cli database upgrade head
) on v1.18.0 or later, perform the migrations in two steps:
- Run migrations using version v1.17.2
- Run migrations using latest/desired version (v1.18.0 or later)
Related issues
Closes #2235 (closed)
Edited by Øyvind Evju