sqlalchemy/alembic issues and pull requests

#1607 - Unexpected warning for computed column when migrating with MariaDB

Issue - State: open - Opened by eganma-umich 6 days ago - 5 comments
Labels: autogenerate - detection, mysql

#1606 - migrations during app startup with async engine - context has no attribute 'configure'

Issue - State: closed - Opened by wildenthal 8 days ago - 1 comment
Labels: asyncio

#1606 - migrations during app startup with async engine - context has no attribute 'configure'

Issue - State: closed - Opened by wildenthal 8 days ago - 1 comment
Labels: asyncio

#1604 - Unexpected behavior postgis migration on fastAPI

Issue - State: closed - Opened by Pierre-Alexandre35 9 days ago

#1604 - Unexpected behavior postgis migration on fastAPI

Issue - State: closed - Opened by Pierre-Alexandre35 9 days ago

#1603 - Operator classes in index produces wrong SQL when using column labels

Issue - State: open - Opened by jleguina 11 days ago - 12 comments
Labels: op directives, autogenerate - rendering, use case

#1603 - Operator classes in index produces wrong SQL when using column labels

Issue - State: closed - Opened by jleguina 11 days ago - 12 comments
Labels: op directives, autogenerate - rendering, use case

#1602 - ondelete="CASCADE" is not properly removed on downgrade()

Issue - State: closed - Opened by bechtold 11 days ago - 3 comments
Labels: expected behavior

#1602 - ondelete="CASCADE" is not properly removed on downgrade()

Issue - State: closed - Opened by bechtold 11 days ago - 3 comments
Labels: expected behavior

#1601 - Incorrect constraint_name argument type for op.drop_constraint

Issue - State: closed - Opened by mazen-isstech 12 days ago - 4 comments
Labels: pep 484, expected behavior

#1601 - Incorrect constraint_name argument type for op.drop_constraint

Issue - State: closed - Opened by mazen-isstech 12 days ago - 4 comments
Labels: pep 484, expected behavior

#1600 - CheckConstraint not detected in declarative table column

Issue - State: closed - Opened by chenaccio 12 days ago - 1 comment
Labels: duplicate

#1600 - CheckConstraint not detected in declarative table column

Issue - State: closed - Opened by chenaccio 12 days ago - 1 comment
Labels: duplicate

#1598 - refactor: add revision context to AutogenerateDiffsDetected so that wrappers may make other formatting of the diff

Pull Request - State: closed - Opened by lachaib 18 days ago - 6 comments

#1597 - Unusable display of `alembic_check` output

Issue - State: closed - Opened by lachaib 18 days ago - 6 comments
Labels: command interface, use case

#1590 - Issue with precision on datetime field on MySQL

Issue - State: closed - Opened by mbeijen about 1 month ago - 1 comment
Labels: great mcve

#1589 - Docs: fix layout issue in autogenerate

Pull Request - State: closed - Opened by mbeijen about 1 month ago - 1 comment

#1587 - Initialize revision for tables with foreign keys

Issue - State: closed - Opened by DGDarkKing about 2 months ago

#1585 - variant rendering is missing the "dialect-specific variant first" use case

Issue - State: closed - Opened by zzzeek about 2 months ago - 1 comment
Labels: bug, autogenerate - rendering

#1583 - Unexpected LONGTEXT type

Issue - State: closed - Opened by wu-clan about 2 months ago

#1581 - automatic revison delects same changes when 'include_name' param of context.configure() set.

Issue - State: closed - Opened by gitNetw0rk about 2 months ago

#1577 - fix: Add TextClause to alter_column's server_default fields.

Pull Request - State: open - Opened by DanCardin 2 months ago

#1575 - fixed typo

Pull Request - State: closed - Opened by johnmatthiggins 3 months ago

#1574 - Typo on "Auto Generating Migrations" documentation

Issue - State: closed - Opened by johnmatthiggins 3 months ago - 1 comment
Labels: documentation

#1570 - Clarify what autogenerate compares

Pull Request - State: closed - Opened by peterjc 3 months ago - 6 comments

#1569 - Add missing imports to example

Pull Request - State: closed - Opened by peterjc 3 months ago - 1 comment

#1568 - Avoid D103 linter warnings via script.py.mako

Pull Request - State: closed - Opened by peterjc 3 months ago - 2 comments

#1567 - D103 linter warnings from script.py.mako templates

Issue - State: closed - Opened by peterjc 3 months ago - 5 comments
Labels: migration environment

#1565 - postgresql serial column detection might fail

Issue - State: open - Opened by JabberWocky-22 4 months ago - 3 comments
Labels: bug, postgresql

#1564 - Fix mypy linting issues

Pull Request - State: closed - Opened by maver1ck 4 months ago - 3 comments

#1563 - Add ability to configure alembic_version table in DialectImpl

Pull Request - State: closed - Opened by maver1ck 4 months ago - 20 comments

#1561 - Initial work to support Starrocks DB

Pull Request - State: closed - Opened by maver1ck 4 months ago - 2 comments

#1560 - Make version table customizable by dialects

Issue - State: closed - Opened by maver1ck 4 months ago - 9 comments
Labels: migration environment, use case

#1558 - fix(requirements): add `tzdata` to `tz` extras; fixes #1556

Pull Request - State: closed - Opened by Danipulok 4 months ago - 2 comments

#1556 - A timezone error on `python3.12` and `alembic[tz]`?

Issue - State: closed - Opened by Danipulok 4 months ago - 7 comments
Labels: bug, use case

#1555 - All foreign keys added and removed despite no changes

Issue - State: closed - Opened by OD1995 4 months ago

#1553 - Sqlite drop table operation not rollbacked during a revision up/downgrade

Issue - State: closed - Opened by vtgn 4 months ago - 2 comments

#1552 - Log directory location is insecure

Issue - State: closed - Opened by devinbost 4 months ago - 1 comment

#1551 - The Enum's `name` property is lost within an autogenerated migration

Issue - State: open - Opened by mberdyshev 4 months ago - 7 comments
Labels: bug, autogenerate - rendering, autogenerate for enums, PRs (with tests!) welcome

#1548 - Use logging.WARNING instead of logging.WARN

Pull Request - State: closed - Opened by thirtysixpw 5 months ago - 3 comments

#1547 - fix: Correct the AutogenContext.metadata typing to include Sequence[MetaData].

Pull Request - State: closed - Opened by DanCardin 5 months ago - 2 comments

#1544 - Support for auto-generated SQL migrations in online mode

Issue - State: closed - Opened by basvandriel 5 months ago
Labels: use case

#1541 - Add colon (:) to invalid char for revision name

Pull Request - State: open - Opened by PatilHrushikesh 5 months ago - 7 comments

#1540 - Colon (:) shouldn't be allowed in custom revision id, as it is used as revision range

Issue - State: open - Opened by PatilHrushikesh 5 months ago
Labels: use case

#1539 - Add support for preserving field order?

Issue - State: open - Opened by msaysell 5 months ago - 5 comments
Labels: op directives, mysql, use case

#1539 - Add support for preserving field order?

Issue - State: open - Opened by msaysell 5 months ago - 5 comments
Labels: op directives, mysql, use case

#1538 - Enable Private Vulnerability Reporting

Issue - State: closed - Opened by rokydas-OR 5 months ago

#1537 - Enable Private Vulnerability Reporting

Issue - State: closed - Opened by rokydas-OR 5 months ago - 1 comment

#1536 - Enable Private Vulnerability Reporting

Issue - State: closed - Opened by rokydas-OR 5 months ago - 2 comments

#1535 - Update tutorial.rst for ruff post_write_hooks

Pull Request - State: closed - Opened by gxxeel 5 months ago - 2 comments

#1531 - Unique constraint missing name/duplicated create_unique/drop_constraint

Issue - State: closed - Opened by gaborfekete-greehill 6 months ago

#1530 - create_unique_constraint if not exists

Issue - State: closed - Opened by aakrem 6 months ago - 2 comments
Labels: use case

#1529 - Mention time zone data unavailability on some systems

Pull Request - State: closed - Opened by floxay 6 months ago - 2 comments

#1527 - No time zone data on Windows, error setting `timezone` in `alembic.ini`

Issue - State: closed - Opened by floxay 6 months ago - 1 comment
Labels: cant reproduce

#1526 - Migration autogeneration should respect schemas defined using quoted_name

Issue - State: open - Opened by characat0 6 months ago
Labels: bug, autogenerate - rendering

#1525 - Improve write_pyi usage

Pull Request - State: closed - Opened by agriffin-grow 6 months ago - 2 comments

#1524 - write_pyi.py script using globally installed dependencies

Issue - State: closed - Opened by agriffin-grow 6 months ago - 2 comments
Labels: test suite

#1523 - Wrong generation partial index for Boolean condition

Issue - State: closed - Opened by mmmcorpsvit 6 months ago - 4 comments
Labels: awaiting info

#1521 - Support if_exists and if_not_exists on create/drop table commands

Pull Request - State: closed - Opened by agriffin-grow 6 months ago - 13 comments

#1520 - Support if_exists / if_not_exists on drop_table and create_table operations

Issue - State: closed - Opened by agriffin-grow 6 months ago - 6 comments
Labels: command interface, use case

#1518 - Possible regression since `1.12.0` on `BIGSERIAL` handling

Issue - State: closed - Opened by hugo-ricateau 6 months ago
Labels: requires triage

#1516 - Name error when using a custom type imported from another file.

Issue - State: closed - Opened by 0x1618 7 months ago

#1514 - Coroutine was not awaited error when running command.stamp() in async dialect

Issue - State: closed - Opened by EricScottN 7 months ago - 1 comment
Labels: asyncio, expected behavior

#1511 - Don't do unique=True with index=True PostgreSQL

Issue - State: closed - Opened by Badsnus 7 months ago - 9 comments
Labels: autogenerate - rendering

#1510 - Enhance version_path_separator behaviour by adding a newline option

Pull Request - State: closed - Opened by pristupa 7 months ago - 15 comments

#1509 - Multiline version_locations

Issue - State: closed - Opened by pristupa 7 months ago - 2 comments
Labels: use case, configuration

#1508 - sqlachemy 2.0 nullability not reflecting properly with the alembic.

Issue - State: closed - Opened by sant527 7 months ago - 1 comment
Labels: autogenerate - rendering, cant reproduce

#1507 - Postgres sequences detected with `::regclass` cast

Issue - State: open - Opened by ChrisLovering 7 months ago - 2 comments
Labels: bug, autogenerate - detection, postgresql

#1505 - Alembic migration with postgres multi schema not working

Issue - State: closed - Opened by biyani701 7 months ago

#1504 - Autogeneration causes invalid SQL with some PostGRES serial columns

Issue - State: open - Opened by adamlogan73 7 months ago - 3 comments
Labels: bug, autogenerate - detection, postgresql, regression

#1503 - Using alembic to manage multiple databases and schema_translate_map.

Issue - State: closed - Opened by skip-life1 7 months ago - 1 comment
Labels: duplicate

#1498 - Flask, Alembic, PGSQL: Migration hangs after upgrade to 1.13.2 and works ONCE after downgrade to 1.13.0

Issue - State: closed - Opened by BID-Equity 8 months ago

#1495 - Schema-Level Multi Tenancy for PostgreSQL Databases - Edge Case

Issue - State: closed - Opened by biyani701 8 months ago
Labels: use case

#1493 - Primary + unique constraint on same migration

Issue - State: closed - Opened by Gildraen 8 months ago

#1492 - Autogeneration of index with coalesce function produces invalid SQL

Issue - State: open - Opened by AurelienJoy 8 months ago - 4 comments
Labels: bug, autogenerate - rendering, mysql

#1491 - conditional ddl support; add autogeneration support for `ddf_if()`

Issue - State: open - Opened by chriswhite199 8 months ago - 8 comments
Labels: autogenerate - detection, autogenerate - rendering

#1489 - Alembic Config does work properly with sqlalchemy.URL

Issue - State: closed - Opened by aqeelat 9 months ago

#1487 - Alembic migrations fail when applying on distributed databases

Issue - State: closed - Opened by cfloressuazo 9 months ago - 2 comments
Labels: third party library / application issues

#1486 - Fix postgres detect serial in autogenerate (#1479)

Pull Request - State: closed - Opened by JabberWocky-22 9 months ago - 6 comments

#1482 - command.upgrade(alembic_cfg, "head") never returns and blocks the process indefinitely.

Issue - State: closed - Opened by oefterdal 9 months ago

#1479 - autogenerate failed to detect postgresql serial

Issue - State: closed - Opened by JabberWocky-22 9 months ago - 2 comments
Labels: bug, autogenerate - detection, postgresql, PRs (with tests!) welcome

#1471 - Upgrading to 1.12 changes type of `Mapped[str]` in new migrations

Issue - State: closed - Opened by knkski 10 months ago - 1 comment
Labels: autogenerate - detection, expected behavior

#1468 - Improve server_default / existing_server_default typing

Issue - State: open - Opened by CaselIT 10 months ago - 2 comments
Labels: bug, pep 484