sqlalchemy/alembic issues and pull requests

#1435 - test suite breaks in pytest 8.1

Issue - State: closed - Opened by zzzeek 12 months ago - 3 comments

#1434 - Generate the table DDLs with `if not exists` or `if exists`

Issue - State: closed - Opened by CaselIT 12 months ago - 3 comments
Labels: duplicate, feature, op directives, PRs (with tests!) welcome

#1434 - Generate the table DDLs with `if not exists` or `if exists`

Issue - State: closed - Opened by CaselIT 12 months ago - 3 comments
Labels: duplicate, feature, op directives, PRs (with tests!) welcome

#1431 - script_location PATH config is not OS agnostic

Issue - State: closed - Opened by developer992 12 months ago - 7 comments
Labels: documentation, configuration

#1430 - Fix type annotations in create_foreign_key

Pull Request - State: closed - Opened by kasium 12 months ago - 1 comment

#1429 - create_foreign_key has wrong type annotations

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

#1428 - Change the default `include_schemas` to be `"from_metadata"`

Issue - State: open - Opened by CaselIT about 1 year ago

#1424 - refactor: make drop_constraint() constraint_name Optional

Pull Request - State: closed - Opened by JudeDavis1 about 1 year ago - 6 comments

#1421 - running migrations on clickhouse

Issue - State: closed - Opened by kar-pev about 1 year ago - 1 comment

#1420 - stamp command type annotation prohibits use of `None` revision

Issue - State: closed - Opened by ctheune about 1 year ago - 6 comments
Labels: documentation, use case

#1419 - python dataclasses seems to look in sys.modules[module], so all dynamic loading patterns would need to add there too (which...how do you clean up ...shrugs)

Issue - State: closed - Opened by kasium about 1 year ago - 11 comments
Labels: bug, wontfix, execution model

#1415 - Alembic Autogenerate Creates New Table Scripts Instead of Adding Column to Existing Table

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

#1413 - Sql Server default constraints have generated names

Issue - State: closed - Opened by marshall62 about 1 year ago - 1 comment
Labels: question, op directives, Microsoft SQL Server

#1411 - change rev_id to datetime string.

Pull Request - State: closed - Opened by bqfan about 1 year ago

#1409 - Alembic doesn't work properly with postgres schemas

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

#1405 - Migrations File don't auto import sqlalchemy_utils

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

#1400 - Update license year to 2024

Pull Request - State: closed - Opened by evilaliv3 about 1 year ago - 6 comments

#1397 - Fix `alembic.ini` templates to match `configparser` file format.

Pull Request - State: closed - Opened by bhushan-mohanraj about 1 year ago - 6 comments

#1396 - Naming conventions in metadata sequences are ignored

Issue - State: open - Opened by iurisilvio about 1 year ago - 4 comments
Labels: bug, op directives, autogenerate - rendering

#1395 - Remove support for sqlalchemy 1.3

Issue - State: closed - Opened by CaselIT about 1 year ago - 1 comment

#1394 - alembic is passing an empty tuple to conn.execute() which is nonsensical

Issue - State: closed - Opened by zzzeek about 1 year ago - 3 comments
Labels: bug, execution model

#1393 - Ignore newlines in expressions for Computed

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

#1392 - Ignore newlines in expressions for Computed

Pull Request - State: closed - Opened by GeorchW about 1 year ago

#1391 - Computed statements containing newlines cause warnings on autogenerate

Issue - State: closed - Opened by GeorchW about 1 year ago - 2 comments
Labels: autogenerate - detection, use case

#1390 - Alembic always detects changes on indexes that use to_tsvector()

Issue - State: open - Opened by caumons about 1 year ago - 6 comments
Labels: bug, autogenerate - detection, postgresql, index expressions

#1388 - update column constraint when adding enum item

Issue - State: closed - Opened by bbbart about 1 year ago - 2 comments
Labels: bug, duplicate, autogenerate for enums

#1387 - render type.impl when type is a TypeDecorator instance

Pull Request - State: closed - Opened by saifelse about 1 year ago - 1 comment

#1386 - Autogenerate renders TypeDecorator instance instead of underlying impl type

Issue - State: open - Opened by saifelse about 1 year ago - 7 comments
Labels: autogenerate - rendering, use case, cookbook requested

#1385 - fix alembic.util.messaging.msg to properly wrap at terminal width

Pull Request - State: closed - Opened by saifelse about 1 year ago - 6 comments

#1384 - alembic.util.messaging.msg does not properly wrap at terminal width

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

#1381 - autogenerate: alembic keeps creating tables that return False on `include_name`

Issue - State: closed - Opened by puilp0502 about 1 year ago - 1 comment
Labels: expected behavior

#1378 - Missing type stubs

Issue - State: closed - Opened by stinovlas about 1 year ago - 5 comments
Labels: expected behavior

#1377 - mypy suite is not run with strict mode and many typing errors still remain

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

#1376 - Fix downgrade when normalized down revisions have overlap via depends_on

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

#1375 - fixed typo

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

#1374 - Fixed typo in latest release (1.13.0)

Pull Request - State: closed - Opened by Zbysekz about 1 year ago - 1 comment

#1373 - Downgrading to depends_on migration causes "Requested revision ... overlaps with other requested revisions ..." issue

Issue - State: closed - Opened by saifelse about 1 year ago - 3 comments
Labels: versioning model, use case, PRs (with tests!) welcome

#1372 - Keep the unique flag in `DropIndexOp`

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

#1371 - Changing a unique index generate a non-unique downgrade

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

#1370 - Fix `get_x_arguments(as_dictionary=True)` for args without `=`

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

#1369 - `get_x_argument(as_dictionary=True)` fails if x values doesn't have `=`

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

#1368 - Improve `Rewriter` implementation

Pull Request - State: closed - Opened by zrotceh about 1 year ago - 6 comments

#1366 - Path is not represented in current version locations

Issue - State: open - Opened by CaselIT about 1 year ago
Labels: bug, windows, PRs (with tests!) welcome

#1365 - Fix 'alembic check' with multidb env

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

#1364 - Fix typo in alembic.ini templates

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

#1363 - AttributeError: 'ConfigParser' object has no attribute '_proxies'

Issue - State: closed - Opened by MosTafa2K about 1 year ago - 2 comments
Labels: third party library / application issues

#1362 - Programmatically call revision with autogenerate True does not set context.cmd_options.autogenerate to True

Issue - State: closed - Opened by ruben-janssens over 1 year ago - 1 comment
Labels: wontfix

#1361 - TypeError when running database upgrade with generated migration from updated table comment

Issue - State: closed - Opened by FranzForstmayr over 1 year ago - 6 comments
Labels: bug, autogenerate - rendering, batch migrations

#1360 - Rendering postgresql dialect DOMAIN field

Issue - State: open - Opened by ovangle over 1 year ago - 1 comment
Labels: bug, autogenerate - rendering, postgresql, PRs (with tests!) welcome

#1359 - Remove support for python 3.7

Issue - State: closed - Opened by CaselIT over 1 year ago - 1 comment
Labels: installation

#1358 - Open up `if_(not_)?exists` to SQLAlchemy 1.4+

Pull Request - State: closed - Opened by zrotceh over 1 year ago - 9 comments

#1357 - autogenerate postgresql DOMAIN type column

Issue - State: open - Opened by ovangle over 1 year ago - 2 comments
Labels: bug, autogenerate - detection, postgresql, PRs (with tests!) welcome

#1356 - Wrong index detection on cockroachdb

Issue - State: closed - Opened by OndrejIT over 1 year ago - 4 comments
Labels: external driver issues, index expressions

#1353 - Alembic can't run migrations in async mode if loop already exists.

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

#1352 - Alembic drop and create foreignkey on every migrate without any changes

Issue - State: closed - Opened by Ezak91 over 1 year ago - 1 comment

#1349 - Fixes: #1348 Typings for target_metadata sequence of metadatas

Pull Request - State: closed - Opened by iurisilvio over 1 year ago - 5 comments

#1348 - target_metadata typing don't support metadata sequences

Issue - State: closed - Opened by iurisilvio over 1 year ago - 1 comment
Labels: bug, pep 484

#1347 - `create_type=false` still creating enum and consequently failing on duplicate

Issue - State: closed - Opened by Faolain over 1 year ago - 9 comments
Labels: expected behavior

#1345 - FAILED: Could not determine revision id from filename env.py when the migrations directory is different from alembic

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

#1343 - Is there a existing way to log each operation when running upgrade?

Issue - State: closed - Opened by notatallshaw-gts over 1 year ago
Labels: use case

#1342 - `compare_type` does not detect length/param changes (when they get removed)

Issue - State: closed - Opened by rafales over 1 year ago - 1 comment
Labels: expected behavior

#1341 - Autogenerate migration still has minor typing issues with mypy

Issue - State: open - Opened by kshpytsya over 1 year ago - 1 comment
Labels: bug, pep 484, PRs (with tests!) welcome

#1340 - Fix typing of `revision` argument in "Don't Generate Empty Migrations with Autogenerate" recipe

Pull Request - State: closed - Opened by jwodder over 1 year ago - 3 comments

#1339 - Replace dateutil with zoneinfo buildin module

Issue - State: closed - Opened by CaselIT over 1 year ago - 1 comment
Labels: use case

#1338 - Update of the no-empty-migrations snippet to work with alembic check

Pull Request - State: closed - Opened by BayerSe over 1 year ago - 4 comments

#1337 - Improve re-writer implementation, fixing chain and adding support to callables

Issue - State: closed - Opened by CaselIT over 1 year ago - 1 comment
Labels: autogenerate - rendering

#1336 - Implement ExecuteSQLOp.to_diff_tuple, fixes #1335

Pull Request - State: closed - Opened by BayerSe over 1 year ago - 6 comments

#1335 - check does not work with ExecuteSQLOp present

Issue - State: closed - Opened by CaselIT over 1 year ago - 2 comments
Labels: bug, PRs (with tests!) welcome

#1333 - Support of source object(.so) files in alembic versions.

Issue - State: closed - Opened by adityaSiso over 1 year ago - 5 comments
Labels: wontfix, use case

#1331 - Improve handling of prepend_sys_path, fixes #1330

Pull Request - State: open - Opened by mwerezak over 1 year ago - 8 comments

#1330 - prepend_sys_path does not work with absolute paths on windows

Issue - State: open - Opened by mwerezak over 1 year ago - 7 comments
Labels: bug, configuration, PRs (with tests!) welcome

#1329 - render table .info in create table, also fix typing for rewriter

Issue - State: closed - Opened by zzzeek over 1 year ago - 1 comment
Labels: bug, autogenerate - rendering

#1327 - Autogenerate does not support Operator classes for postgres

Issue - State: closed - Opened by tl24 over 1 year ago - 6 comments
Labels: bug, postgresql, index expressions

#1326 - Using `alembic downgrade`, it's impossible to cancel the initial revision

Issue - State: closed - Opened by vporton over 1 year ago - 4 comments
Labels: documentation, expected behavior, PRs (with tests!) welcome

#1325 - `process_revision_directives` documentation disagrees with type annotation

Issue - State: closed - Opened by jwodder over 1 year 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 over 1 year 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 over 1 year ago - 5 comments
Labels: autogenerate - rendering, postgresql

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

Issue - State: closed - Opened by vasa-chi over 1 year 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 over 1 year 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 over 1 year ago - 2 comments
Labels: expected behavior

#1317 - Downgrade results in TypeError

Issue - State: closed - Opened by vikramsg over 1 year ago - 1 comment
Labels: expected behavior

#1315 - Alembic doesn't detect adding unique constraints

Issue - State: closed - Opened by matthiasburger over 1 year ago - 1 comment
Labels: Microsoft SQL Server

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

Pull Request - State: closed - Opened by ProgramRipper over 1 year ago - 1 comment

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

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

#1310 - Spelling fixes

Pull Request - State: closed - Opened by jsoref over 1 year ago

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

Pull Request - State: closed - Opened by vlcinsky over 1 year 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 over 1 year ago

#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 over 1 year ago - 6 comments
Labels: bug, autogenerate - detection, postgresql, awaiting info

GitHub / sqlalchemy/alembic issues and pull requests