sqlalchemy/alembic issues and pull requests

#1287 - autogenerate migration issues of constraints across schemas

Issue - State: closed - Opened by n00b42 over 1 year 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 over 1 year ago - 6 comments
Labels: autogenerate - detection, postgresql, expected behavior

#1283 - Path is not represented in current version locations

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

#1281 - PostGIS not work with SQLAlchemy==2.0.19

Issue - State: closed - Opened by luolingchun over 1 year 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 over 1 year ago - 1 comment
Labels: expected behavior, configuration

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

Pull Request - State: closed - Opened by lanzz over 1 year ago - 16 comments

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

Issue - State: closed - Opened by lanzz over 1 year 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 over 1 year ago - 11 comments

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

Issue - State: closed - Opened by lanzz over 1 year ago - 9 comments
Labels: autogenerate - rendering, use case

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

Pull Request - State: closed - Opened by kkirsche over 1 year ago - 27 comments

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

Issue - State: closed - Opened by kkirsche over 1 year ago - 3 comments
Labels: bug, command interface, PR welcome

#1271 - Set schema name while first migration

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

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

Issue - State: closed - Opened by wasdee over 1 year ago - 1 comment
Labels: autogenerate - detection

#1267 - Column order in migrations for Int fields

Issue - State: closed - Opened by lasmaty07 over 1 year 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 over 1 year 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 over 1 year ago

#1262 - Fixed CLI output when running post_write hooks

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

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

Issue - State: closed - Opened by duc00 over 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 over 1 year ago - 9 comments

#1258 - Index `postgresql_include` renders the columns incorrectly

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

#1254 - enum already exists

Issue - State: open - Opened by chirayushukla28 over 1 year ago - 24 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 over 1 year ago - 2 comments
Labels: bug, pep 484

#1250 - Skip autogenerate in multiple database

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

#1249 - pg nulls not distinct support #8240

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

#1248 - Enable compareType by default

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

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

Issue - State: closed - Opened by josteinl over 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 almost 2 years 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 almost 2 years 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 almost 2 years 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 almost 2 years 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 almost 2 years ago - 16 comments
Labels: autogenerate - detection, mysql, regression

#1238 - Support sorting and expression index reflection on oracle

Issue - State: open - Opened by CaselIT almost 2 years 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 almost 2 years 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 almost 2 years ago - 2 comments

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

Issue - State: closed - Opened by allmonday almost 2 years ago - 2 comments
Labels: bug, autogenerate - rendering

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

Issue - State: closed - Opened by spladug almost 2 years ago - 3 comments
Labels: bug, command interface

#1233 - set default None for user_module_prefix

Pull Request - State: closed - Opened by allmonday almost 2 years ago - 4 comments

#1232 - Function add_column doesn't work for primary_key

Issue - State: closed - Opened by BoWuGit almost 2 years 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 almost 2 years 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 almost 2 years 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 almost 2 years ago - 3 comments

#1227 - new warning when packaging

Issue - State: closed - Opened by zzzeek almost 2 years ago - 7 comments
Labels: bug, installation

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

Issue - State: closed - Opened by otonnesen almost 2 years ago - 3 comments
Labels: bug, duplicate

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

Issue - State: open - Opened by TheoGoudout almost 2 years 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 almost 2 years 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 almost 2 years ago - 1 comment
Labels: bug, batch migrations

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

Pull Request - State: closed - Opened by jayaddison almost 2 years ago - 12 comments

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

Pull Request - State: closed - Opened by jayaddison almost 2 years ago - 10 comments

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

Pull Request - State: closed - Opened by jayaddison almost 2 years ago - 7 comments

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

Issue - State: closed - Opened by Kalmis almost 2 years ago - 6 comments
Labels: bug, op directives

#1213 - Autogenerate does not support sort options on indexes

Issue - State: closed - Opened by jarviliam almost 2 years ago - 6 comments
Labels: bug, autogenerate - detection, postgresql

#1212 - Autogenerate fails when index with expression is removed

Issue - State: closed - Opened by rafales almost 2 years ago - 7 comments
Labels: bug, autogenerate - detection, autogenerate - rendering, postgresql

#1209 - Fix type annotation for `url`

Pull Request - State: closed - Opened by Viicos almost 2 years 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 almost 2 years 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 almost 2 years ago

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

Issue - State: closed - Opened by AlexanderPodorov almost 2 years 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 almost 2 years 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 almost 2 years 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 almost 2 years ago - 13 comments
Labels: test suite, postgresql

#1196 - cannot import name '_NONE_NAME' from 'sqlalchemy.sql.naming

Issue - State: closed - Opened by shuvamgrad almost 2 years ago - 5 comments
Labels: bug, batch migrations, regression

#1195 - `ValueError: Constraint must have a name` in alembic 1.10.0

Issue - State: open - Opened by harupy almost 2 years ago - 18 comments
Labels: bug, batch migrations, regression, PRs (with tests!) welcome

#1193 - private constructor elements on CreateTableOp make it impossible to copy w/ public API

Issue - State: open - Opened by zzzeek almost 2 years ago
Labels: bug, op directives

#1191 - Pyright warnings in strict mode: type is partially unknown for op.create_index

Issue - State: closed - Opened by AlexanderPodorov almost 2 years ago - 5 comments
Labels: bug, pep 484

#1187 - Some mssql commands are not correctly quoted

Issue - State: closed - Opened by CaselIT almost 2 years ago - 4 comments
Labels: bug, Microsoft SQL Server

#1186 - Update docstring to suggest raw string

Pull Request - State: closed - Opened by howbazaar almost 2 years ago - 5 comments

#1185 - Handle literal_column in ExcludeConstraint differently

Pull Request - State: closed - Opened by jankatins almost 2 years ago - 19 comments

#1184 - literal_column() in ExcludeConstraint are autogenerated as column(), failing in the migration

Issue - State: closed - Opened by jankatins almost 2 years ago - 24 comments
Labels: bug, autogenerate - rendering, postgresql

#1182 - add recursive_version_locations option for searching revision files

Pull Request - State: closed - Opened by ostr00000 about 2 years ago - 8 comments

#1180 - Alembic treats output of custom render_item as compiled sql breaking server_default comparisons for custom funcs

Issue - State: closed - Opened by lukesmurray about 2 years ago - 2 comments
Labels: bug, autogenerate - defaults, autogenerate - detection

#1178 - remove quoting in compare server default

Issue - State: closed - Opened by zzzeek about 2 years ago - 2 comments
Labels: bug, autogenerate - defaults

#1177 - Server_default including quote not detected properly

Issue - State: closed - Opened by GeorgeSchneelochVA about 2 years ago - 9 comments
Labels: bug, autogenerate - defaults, Microsoft SQL Server

#1176 - Merge command passes string "config" instead of object to template

Pull Request - State: closed - Opened by sothatsbrendan about 2 years ago - 7 comments

#1175 - `render_item` param in `context.configure` may return other than boolean

Issue - State: closed - Opened by koki-sato about 2 years ago - 2 comments
Labels: bug, pep 484, PR welcome

#1174 - type error in env.py from documentation

Issue - State: closed - Opened by Dreamsorcerer about 2 years ago - 1 comment
Labels: bug, pep 484

#1173 - Update annotation to allow PathLike

Pull Request - State: closed - Opened by Dreamsorcerer about 2 years ago - 2 comments

#1172 - Include missing part of env.py

Pull Request - State: closed - Opened by Dreamsorcerer about 2 years ago - 11 comments

#1171 - Update example to sqlalchemy 2

Pull Request - State: closed - Opened by Dreamsorcerer about 2 years ago - 1 comment

#1168 - create_index documentation and typing should allow a None name

Issue - State: closed - Opened by simark about 2 years ago - 2 comments
Labels: bug, pep 484, PR welcome

#1167 - Autogenerate loses variants on TypeDecorator column with SQLAlchemy 2.0

Issue - State: closed - Opened by mgorven about 2 years ago - 3 comments
Labels: bug, autogenerate - rendering

#1166 - Autogenerate ignores order of columns in an index

Issue - State: closed - Opened by CaselIT about 2 years ago - 1 comment
Labels: bug, autogenerate - detection

#1165 - autogenerate false positive of sqlite functional indexes

Issue - State: closed - Opened by CaselIT about 2 years ago - 1 comment
Labels: bug, autogenerate - detection, sqlite

#1154 - command.stamp hangs when using with uvcorn

Issue - State: closed - Opened by rajshrestha86 about 2 years ago

#1152 - `compare_server_default` parses `(getdate())` incorrectly

Issue - State: closed - Opened by GeorgeSchneelochVA about 2 years ago - 3 comments
Labels: bug, autogenerate - detection, regression

#1151 - Comparing computed fields throws warn

Issue - State: closed - Opened by hevalhazalkurt about 2 years ago - 4 comments
Labels: bug, autogenerate - defaults, autogenerate - detection, postgresql, cant reproduce

#1148 - add overload stubs for proxied classes

Pull Request - State: closed - Opened by vfazio about 2 years ago - 12 comments

#1147 - Stub generator for proxy classes does not generate overload stubs

Issue - State: closed - Opened by vfazio about 2 years ago - 1 comment
Labels: bug, duplicate, pep 484

#1146 - overload stubs missing for get_x_argument

Issue - State: closed - Opened by vfazio about 2 years ago - 1 comment
Labels: bug, pep 484

#1145 - `compare_server_default` doesn't work with a string column that contains a backslash in its default value

Issue - State: closed - Opened by marcinbarczynski about 2 years ago - 3 comments
Labels: bug, autogenerate - defaults, autogenerate - detection

#1142 - Alembic doesn't recognize JSON

Issue - State: closed - Opened by cheog about 2 years ago - 1 comment

#1141 - Autogenerate error while using FunctionElement with render_item

Issue - State: closed - Opened by NChandan about 2 years ago

#1140 - Bug correction that impeded the "Naming Columns Distinctly from Attribute Names" feature of sqlachemy

Pull Request - State: closed - Opened by ceprio about 2 years ago - 1 comment

#1133 - Alembic Detect Everything

Issue - State: closed - Opened by hamedyosefian about 2 years ago - 1 comment
Labels: duplicate

#1130 - modify ops to have kw only set up (e.g. add the '*')

Issue - State: closed - Opened by zzzeek about 2 years ago - 3 comments
Labels: bug, op directives, py3k

#1128 - Explicit usage of schema in models and foreign keys fails in public schema with postgres

Issue - State: closed - Opened by alexander-jacob about 2 years ago

#1127 - alter_column uses existing_type as new type

Issue - State: closed - Opened by Estartu about 2 years ago - 2 comments
Labels: op directives, expected behavior

#1121 - Consider Removing New Line Characters when Comparing Computed Constructs

Issue - State: open - Opened by james-menzies over 2 years ago - 2 comments
Labels: bug, autogenerate - detection, motivated volunteers requested

#1120 - Augmented (TypeDecorator) JSON type results in data loss during SQLite migration

Issue - State: open - Opened by petergaultney over 2 years ago - 1 comment
Labels: bug, batch migrations, motivated volunteers requested

#1119 - error while comparing json fields in schema against PostgreSQL DB with `compare_server_default=True` option

Issue - State: closed - Opened by casualuser over 2 years ago - 4 comments
Labels: autogenerate - defaults, autogenerate - detection, awaiting info

#1117 - Columns and tables comments with MSSQL

Issue - State: closed - Opened by edulauer over 2 years ago - 1 comment
Labels: use case

#1115 - Fix type annotation in `op.create_table_comment`

Pull Request - State: closed - Opened by colincadams over 2 years ago - 6 comments

GitHub / sqlalchemy/alembic issues and pull requests