sqlalchemy/alembic issues and pull requests

#1325 - `process_revision_directives` documentation disagrees with type annotation

Issue - State: closed - Opened by jwodder 9 months ago - 5 comments
Labels: bug, documentation, pep 484

#1323 - Index creation with `if_not_exists` not supported for SQLAlchemy 1.4.49

Issue - State: closed - Opened by inikolaev 9 months ago - 4 comments
Labels: op directives, use case, PRs (with tests!) welcome

#1322 - pg dialect when rendering index expressions needs to apply self_group() the same way core DDL compiler does

Issue - State: closed - Opened by MIrinkov 9 months ago - 5 comments
Labels: autogenerate - rendering, postgresql

#1321 - Alembic generates unneeded migrations for expression-based indexes

Issue - State: closed - Opened by vasa-chi 9 months ago - 11 comments
Labels: bug, autogenerate - detection, postgresql, index expressions

#1320 - git does not commit "versions" by default, so we should possibly ensure some file is present there

Issue - State: open - Opened by sjsadowski 9 months ago - 6 comments
Labels: migration environment, use case

#1318 - alembic --auogenerate should put columns from base class before columns from derived class

Issue - State: closed - Opened by BlackZork 9 months ago - 2 comments
Labels: expected behavior

#1317 - Downgrade results in TypeError

Issue - State: closed - Opened by vikramsg 9 months ago - 1 comment
Labels: expected behavior

#1315 - Alembic doesn't detect adding unique constraints

Issue - State: closed - Opened by matthiasburger 9 months ago - 1 comment
Labels: Microsoft SQL Server

#1312 - fix(command): `init --package` path display

Pull Request - State: closed - Opened by ProgramRipper 10 months ago - 1 comment

#1311 - `alembic init --package` doesn't show adding `init.py` path correctly

Issue - State: closed - Opened by ProgramRipper 10 months ago - 1 comment
Labels: bug, command interface

#1310 - Spelling fixes

Pull Request - State: closed - Opened by jsoref 10 months ago

#1309 - setup.cfg Project Links: added Changelog + reorder

Pull Request - State: closed - Opened by vlcinsky 10 months ago - 2 comments

#1307 - Deadlock while updating a column, updated the env.py file to replicate same set of migrations on different schemas

Issue - State: closed - Opened by jay-patel-simformsolutions 10 months ago

#1305 - Facing an issue with alter enum column

Issue - State: closed - Opened by idomic 10 months ago - 6 comments
Labels: expected behavior

#1304 - Support future sqlalchemy change regarding sequence and identity

Issue - State: closed - Opened by CaselIT 10 months ago - 1 comment
Labels: use case

#1303 - Add `match` keyword argument to rendering of foreign key constraints

Pull Request - State: closed - Opened by asibkamalsada 10 months ago - 6 comments

#1302 - ForeignKeyConstraint argument `match` is not rendered in autogeneration

Issue - State: closed - Opened by asibkamalsada 10 months ago - 3 comments
Labels: bug, autogenerate - rendering, PRs (with tests!) welcome

#1301 - Fixes #1300: Inability to pass an ExcludeConstraint object to DropConstraint.from_constraint

Pull Request - State: closed - Opened by DJHills 10 months ago - 16 comments

#1300 - Unable to pass ExcludeConstraint to DropConstraintOp.from_constraint

Issue - State: closed - Opened by DJHills 10 months ago - 5 comments
Labels: bug, op directives, postgresql

#1299 - `alembic merge` ignores `revision_environment` and cannot find the hooks defined in `env.py`

Issue - State: closed - Opened by FeeeeK 10 months ago - 2 comments
Labels: bug, command interface

#1298 - Feature: deployment rollback - saving the previously migration hash on DB for downgrade

Issue - State: closed - Opened by staticdev 10 months ago - 18 comments
Labels: duplicate, use case

#1297 - Alembic generate drop_constraint and drop_index on upgrade?

Issue - State: closed - Opened by cnicodeme 11 months ago - 2 comments
Labels: duplicate, mysql

#1295 - Weirdness for pytest

Issue - State: closed - Opened by Lewiscowles1986 11 months ago - 1 comment

#1293 - PR #619 completely removed support for `compare_against_backend`, but it's still documented

Issue - State: closed - Opened by CaselIT 11 months ago - 2 comments
Labels: bug, data types

#1291 - Alembic 1.10.4 incorrectly reflects nulls not distinct

Issue - State: closed - Opened by CaselIT 11 months ago - 4 comments
Labels: bug, autogenerate - detection, postgresql

#1288 - Migrations generation worked in 1.10.3. Now, in 1.10.4, it creates migrations that seem overly complex and migrating them fails

Issue - State: closed - Opened by blockjon-dd 11 months ago - 6 comments
Labels: bug, autogenerate - detection, postgresql, awaiting info

#1287 - autogenerate migration issues of constraints across schemas

Issue - State: closed - Opened by n00b42 11 months ago - 4 comments
Labels: autogenerate - detection, postgresql, awaiting info

#1285 - Alembic 10.1.4+ re-creates index with DESC defined via `postgresql_ops` without changes

Issue - State: closed - Opened by mtvx 11 months ago - 6 comments
Labels: autogenerate - detection, postgresql, expected behavior

#1283 - Path is not represented in current version locations

Issue - State: closed - Opened by harpener 11 months ago - 1 comment

#1281 - PostGIS not work with SQLAlchemy==2.0.19

Issue - State: closed - Opened by luolingchun 12 months ago - 1 comment

#1279 - Error When there is an @ symbol in the password. error: invalid interpolation syntax in %r at

Issue - State: closed - Opened by greper 12 months ago - 1 comment
Labels: expected behavior, configuration

#1278 - Accept insert and delete expressions in `op.execute`

Pull Request - State: closed - Opened by lanzz 12 months ago - 16 comments

#1277 - Wrong type for `sqltext` argument of `op.execute`

Issue - State: closed - Opened by lanzz 12 months ago - 4 comments
Labels: bug, pep 484

#1276 - Implement new `exec` write-hook runner that will execute arbitrary binaries

Pull Request - State: closed - Opened by lanzz 12 months ago - 11 comments

#1275 - Support for non-Python post-write hooks

Issue - State: closed - Opened by lanzz 12 months ago - 9 comments
Labels: autogenerate - rendering, use case

#1274 - Specify `"locale"` encoding when reading configuration file

Pull Request - State: closed - Opened by kkirsche 12 months ago - 27 comments

#1273 - Use an explicit encoding when reading the configuration file

Issue - State: closed - Opened by kkirsche 12 months ago - 3 comments
Labels: bug, command interface, PR welcome

#1271 - Set schema name while first migration

Issue - State: closed - Opened by annndruha 12 months ago
Labels: use case

#1268 - custom `include_name()` affect reflection, making it always include all tables all time

Issue - State: closed - Opened by wasdee 12 months ago - 1 comment
Labels: autogenerate - detection

#1267 - Column order in migrations for Int fields

Issue - State: closed - Opened by lasmaty07 12 months ago - 1 comment
Labels: third party library / application issues

#1266 - create_check_constraint condition argument type doesn't allow boolean expression

Issue - State: closed - Opened by ods 12 months ago - 2 comments
Labels: bug, pep 484, PRs (with tests!) welcome

#1264 - Automatic migrations wants to drop and recreate Foreign Keys created with create_foreign_key

Issue - State: closed - Opened by asyte about 1 year ago

#1262 - Fixed CLI output when running post_write hooks

Pull Request - State: closed - Opened by duc00 about 1 year ago - 8 comments

#1261 - Badly formatted output when running post-write hooks

Issue - State: closed - Opened by duc00 about 1 year ago - 3 comments
Labels: bug, good first issue

#1260 - Added parameters if_exists and if_not_exists for index operations.

Pull Request - State: closed - Opened by ionsome about 1 year ago - 9 comments

#1258 - Index `postgresql_include` renders the columns incorrectly

Issue - State: open - Opened by CaselIT about 1 year ago
Labels: bug, autogenerate - rendering, postgresql

#1254 - enum already exists

Issue - State: open - Opened by chirayushukla28 about 1 year ago - 19 comments
Labels: postgresql, awaiting info, autogenerate for enums, expected behavior

#1253 - Autogenerate migration has minor typing issues with mypy

Issue - State: closed - Opened by igorbga about 1 year ago - 2 comments
Labels: bug, pep 484

#1250 - Skip autogenerate in multiple database

Issue - State: closed - Opened by 9bany about 1 year ago - 1 comment
Labels: use case

#1249 - pg nulls not distinct support #8240

Pull Request - State: closed - Opened by Bulbashful about 1 year ago - 8 comments

#1248 - Enable compareType by default

Issue - State: closed - Opened by CaselIT about 1 year ago - 5 comments
Labels: autogenerate - detection

#1247 - Attribute type change in Mapped[] not detected

Issue - State: closed - Opened by josteinl about 1 year ago - 9 comments
Labels: question, autogenerate - detection, awaiting info, cant reproduce

#1246 - Minor typing issue for alembic.context.configure in 1.11.0

Issue - State: closed - Opened by AlexanderPodorov about 1 year ago - 2 comments
Labels: bug, pep 484

#1245 - Minor 1.11.0 break 1.10.4 on `drop_constraint() takes 2 positional arguments but 3 were given`

Issue - State: closed - Opened by YonatanKiron about 1 year ago - 3 comments
Labels: op directives

#1244 - v1.10.4 -> v1.11.0: pyright: "setitem" method not defined on type "Mapping[str, str]"

Issue - State: closed - Opened by gitpushdashf about 1 year ago - 4 comments
Labels: bug, pep 484

#1243 - TypeError: drop_index() takes 2 positional arguments but 3 were given

Issue - State: closed - Opened by bobbypriambodo about 1 year ago - 6 comments
Labels: op directives

#1240 - change to no longer sort index cols for index sig produces false positives on mysql

Issue - State: closed - Opened by provinzio about 1 year ago - 16 comments
Labels: autogenerate - detection, mysql, regression

#1238 - Support sorting and expression index reflection on oracle

Issue - State: open - Opened by CaselIT about 1 year ago
Labels: autogenerate - detection, use case, oracle, index expressions

#1237 - Don't use `type(None)` as fallback for Computed or Identity

Issue - State: closed - Opened by CaselIT about 1 year ago - 3 comments
Labels: bug

#1236 - alembic/ddl/sqlite.py: enhance the judgment condition to fix the problem of AttributeError: 'NoneType' object has no attribute 'persisted' in the requires_recreate_in_batch function.

Pull Request - State: closed - Opened by hustliyilin about 1 year ago - 2 comments

#1235 - prefix = autogen_context.opts["user_module_prefix"] raise KeyError

Issue - State: closed - Opened by allmonday about 1 year ago - 2 comments
Labels: bug, autogenerate - rendering

#1234 - Error using `alembic check` with multidb script

Issue - State: closed - Opened by spladug about 1 year ago - 3 comments
Labels: bug, command interface

#1233 - set default None for user_module_prefix

Pull Request - State: closed - Opened by allmonday about 1 year ago - 4 comments

#1232 - Function add_column doesn't work for primary_key

Issue - State: closed - Opened by BoWuGit about 1 year ago - 2 comments
Labels: documentation, expected behavior

#1231 - Add op.run_async to allow running async function from upgrade/downgrade when using an async engine

Issue - State: closed - Opened by CaselIT about 1 year ago - 1 comment
Labels: use case, asyncio

#1230 - postgresql ExcludeConstraint behave differently with --autogenerate compare to sqlalchemy Base.metadata.create_all

Issue - State: closed - Opened by tc-yu about 1 year ago - 2 comments
Labels: bug, autogenerate - rendering, postgresql

#1228 - Followup / fixup: apply 'black' code formatting to a couple of missed docstrings

Pull Request - State: closed - Opened by jayaddison about 1 year ago - 3 comments

#1227 - new warning when packaging

Issue - State: closed - Opened by zzzeek about 1 year ago - 7 comments
Labels: bug, installation

#1226 - Self-referential composite foreign key results in crash

Issue - State: closed - Opened by otonnesen about 1 year ago - 3 comments
Labels: bug, duplicate

#1224 - Handle AUTOINCREMENT modification detection in revision auto-generation

Issue - State: open - Opened by TheoGoudout about 1 year ago - 1 comment
Labels: autogenerate - detection, autogenerate - rendering, mysql, use case

#1222 - better way to look at the more recent revision from `alembic history` output

Issue - State: open - Opened by ChannyClaus about 1 year ago - 1 comment
Labels: command interface, use case

#1221 - insert_before and insert_after are ignored in batch_alter_column

Issue - State: closed - Opened by CaselIT about 1 year ago - 1 comment
Labels: bug, batch migrations

#1220 - Consistency: apply codestyle formatting to docstring code snippets

Pull Request - State: closed - Opened by jayaddison about 1 year ago - 12 comments

#1219 - ops.py: cleanup / consistency: remove redundant docstring newline markers

Pull Request - State: closed - Opened by jayaddison about 1 year ago - 10 comments

#1218 - tooling: write_pyi.py: filter usage of raw-strings (rstrings)

Pull Request - State: closed - Opened by jayaddison about 1 year ago - 7 comments

#1215 - Creating a self-referential foreign key with composite primary key throws a SA DuplicateColumnError

Issue - State: closed - Opened by Kalmis about 1 year ago - 6 comments
Labels: bug, op directives

#1213 - Autogenerate does not support sort options on indexes

Issue - State: closed - Opened by jarviliam about 1 year ago - 6 comments
Labels: bug, autogenerate - detection, postgresql

#1212 - Autogenerate fails when index with expression is removed

Issue - State: closed - Opened by rafales about 1 year ago - 7 comments
Labels: bug, autogenerate - detection, autogenerate - rendering, postgresql

#1209 - Fix type annotation for `url`

Pull Request - State: closed - Opened by Viicos over 1 year ago - 7 comments

#1207 - Running `alter table` revisions w/batch operations on SQLite raises an error if table referenced in a view

Issue - State: open - Opened by jdavcs over 1 year ago - 7 comments
Labels: documentation, batch migrations, sqlite, PR welcome

#1203 - Autogenerated migration misses changes to server_default and onupdate

Issue - State: closed - Opened by jankatins over 1 year ago

#1201 - Pyright in "strict" mode complains about "begin_transaction"

Issue - State: closed - Opened by AlexanderPodorov over 1 year ago - 6 comments
Labels: bug, pep 484, PR welcome

#1200 - Alembic installs SQLAlchemy version 2.0.5.post1 - which breaks the Sentry initialization

Issue - State: closed - Opened by ShahriyarR over 1 year ago - 1 comment
Labels: cant reproduce, third party library / application issues

#1198 - Alembic init doesn't work with SQLalchemy 2

Issue - State: closed - Opened by evilhamsterman over 1 year ago - 3 comments
Labels: installation, cant reproduce

#1197 - 1.10.1: pytest is failing in `tests/test_postgresql.py::PostgresqlAutogenRenderTest::test_inline_exclude_constraint_text` unit

Issue - State: closed - Opened by kloczek over 1 year ago - 13 comments
Labels: test suite, postgresql

GitHub / sqlalchemy/alembic issues and pull requests