Skip to content

Resolve "Upgrade SQLAlchemy"

Øyvind Evju requested to merge 2235-upgrade-sqlalchemy into dev

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:

  1. Run migrations using version v1.17.2
  2. Run migrations using latest/desired version (v1.18.0 or later)

Related issues

Closes #2235 (closed)

Edited by Øyvind Evju

Merge request reports