πŸ’­ `ValueError: Constraint must have a name` in alembic 1.10.0 Β· ... ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ !https://github.com/sqlalchemy/alembic/issues/1195 Date: August 5, 2023 Image: `ValueError: Constraint must have a name` in alembic 1.10.0 Β· Issue #1195 Β· sqlalchemy/alembic β€” Describe the bug ValueError: Constraint must have a name in alembic 1.10.0. Expected behavior Migration succeeds. To Reproduce Please try to provide a Minimal, Complete, and Verifiable example, wit... `ValueError: Constraint must have a name` in alembic 1.10.0 Β· Issue #1195 Β· sqlalchemy/alembic Describe the bug ValueError: Constraint must have a name in alembic 1.10.0. Expected behavior Migration succeeds. To Reproduce Please try to provide a Minimal, Complete, and Verifiable example, wit... GitHub Β· github.com After a nasty time with alembic upgrades, thoughts is about to get a new users table. This may have came from incorrectly setting up alembic for sqlite from the start, but I was able to fix the issue with this GitHub issue. ``` alembic sqlite ValueError: Constraint must have a name ``` The change I needed to make to get my migration to run. ``` + batch_op.create_foreign_key('fk_post_author_id_user', 'user', ['author_id'], ['id']) ``` NOTE β”‚ This post is a thought . It’s a short note that I make about someone else’s content online #thoughts