CVS commit: pkgsrc/databases/py-alembic

["Adam Ciarcinski" <adam%netbsd.org@localhost>]

Module Name:    pkgsrc
Committed By:   adam
Date:           Tue Nov 10 13:08:47 UTC 2026

Modified Files:
        pkgsrc/databases/py-alembic: Makefile distinfo

Log Message:
py-alembic: updated to 1.20.1

1.20.1

bug

[bug] [autogenerate]
Fixed issue where a table or column comment set to an empty string would cause autogenerate to detect a comment change on every run. As most backends, including PostgreSQL, MySQL, MariaDB and Oracle, 
don’t store an empty string comment distinctly from no comment, autogenerate now treats an empty string comment the same as None when comparing comments. Additionally, an empty string comment is now 
rendered in op.create_table() and op.add_column() directives, where it was previously omitted. Pull request courtesy vineoy.

[bug] [autogenerate] [postgresql]
Fixed rendering of the PostgreSQL DOMAIN type in autogenerated migration scripts. Previously the type was rendered using repr(), which omitted the check, not_null, default, collation, 
constraint_name, schema and create_type arguments and did not apply a dialect prefix to the underlying data type. The full set of arguments is now rendered and the underlying data type is rendered 
using the standard type-rendering logic. Pull request courtesy Sebastian Cao.

[bug] [autogenerate] [postgresql]
Fixed false-positive “Computed default cannot be modified” warning emitted during autogenerate when comparing PostgreSQL Computed columns whose reflected SQL expression includes type cast specifiers 
such as ::regconfig or ::text, which PostgreSQL adds to the expression as stored. These cast specifiers are now stripped before comparison so that otherwise equivalent expressions no longer trigger 
the warning. Pull request courtesy Sebastian Cao.

[bug] [autogenerate] [postgresql]
Fixed issue where autogenerate would detect an unchanged PostgreSQL expression-based index as modified when the expression included type casts, such as a cast to a type with a length or precision, a 
nested cast, or a cast followed by a DESC modifier.

[bug] [postgresql]
Fixed bug where Operations.alter_column() against a PostgreSQL identity column would render an incomplete, invalid ALTER TABLE ... ALTER COLUMN statement with no clause at all when 
existing_server_default was omitted, even if there were no existing server default. Pull request courtesy Riti Grover.

[bug] [environment]
Fixed issue where a third party plugin published using the alembic.plugins entrypoint, configured to refer to a plugin module as documented at Plugins, would cause import alembic to fail with a 
TypeError, as the loaded module was erroneously iterated rather than being set up directly. An entrypoint that refers to a collection of modules, the form which inadvertently worked previously, 
continues to be accepted but now emits a deprecation warning.

[bug] [autogenerate]
Fixed issue where dialect-specific keyword arguments on a ForeignKeyConstraint, ForeignKey or CheckConstraint, such as postgresql_not_valid, were not rendered for the constraints that are part of an 
autogenerated Operations.create_table() directive, nor for an autogenerated Operations.create_check_constraint() directive. The Operations.create_table() case additionally requires SQLAlchemy 2.0.55 
/ 2.1.5 or greater, which include the fix for SQLAlchemy issue 13677 where these arguments were lost when the Table was copied.

[bug] [autogenerate]
Fixed issue where, when using SQLAlchemy 2.1, the CHECK constraint generated by a type such as Enum or Boolean with create_constraint=True would be rendered by autogenerate as explicit 
sa.CheckConstraint() entries within op.create_table(), in addition to the type itself which already produces that constraint, leading to a duplicate constraint error when the migration is run.

[bug] [operations]
Fixed issue where a CreateTableOp produced from an existing Table using CreateTableOp.from_table() would emit the CHECK constraint generated by a type such as Enum or Boolean with 
create_constraint=True twice in the resulting CREATE TABLE statement when invoked directly.


To generate a diff of this commit:
cvs rdiff -u -r1.53 -r1.54 pkgsrc/databases/py-alembic/Makefile
cvs rdiff -u -r1.41 -r1.42 pkgsrc/databases/py-alembic/distinfo

Please note that diffs are not public domain; they are subject to the
copyright notices on the relevant files.

Modified files:

Index: pkgsrc/databases/py-alembic/Makefile
diff -u pkgsrc/databases/py-alembic/Makefile:1.53 pkgsrc/databases/py-alembic/Makefile:1.54
--- pkgsrc/databases/py-alembic/Makefile:1.53   Fri Oct 16 19:43:43 2026
+++ pkgsrc/databases/py-alembic/Makefile        Tue Nov 10 13:08:47 2026
@@ -1,6 +1,6 @@
-# $NetBSD: Makefile,v 1.53 2026/10/16 19:43:43 adam Exp $
+# $NetBSD: Makefile,v 1.54 2026/11/10 13:08:47 adam Exp $
 
-DISTNAME=      alembic-1.19.2
+DISTNAME=      alembic-1.20.1
 PKGNAME=       ${PYPKGPREFIX}-${DISTNAME}
 CATEGORIES=    databases python
 MASTER_SITES=  ${MASTER_SITE_PYPI:=a/alembic/}
@@ -12,7 +12,7 @@ LICENSE=      mit
 
 TOOL_DEPENDS+= ${PYPKGPREFIX}-setuptools>=78:../../devel/py-setuptools
 DEPENDS+=      ${PYPKGPREFIX}-mako>=0:../../devel/py-mako
-DEPENDS+=      ${PYPKGPREFIX}-sqlalchemy>=1.4.23:../../databases/py-sqlalchemy
+DEPENDS+=      ${PYPKGPREFIX}-sqlalchemy>=2.0:../../databases/py-sqlalchemy
 DEPENDS+=      ${PYPKGPREFIX}-typing-extensions>=4.12:../../devel/py-typing-extensions
 
 USE_LANGUAGES= # none

Index: pkgsrc/databases/py-alembic/distinfo
diff -u pkgsrc/databases/py-alembic/distinfo:1.41 pkgsrc/databases/py-alembic/distinfo:1.42
--- pkgsrc/databases/py-alembic/distinfo:1.41   Tue Sep  8 05:31:06 2026
+++ pkgsrc/databases/py-alembic/distinfo        Tue Nov 10 13:08:47 2026
@@ -1,5 +1,5 @@
-$NetBSD: distinfo,v 1.41 2026/09/08 05:31:06 adam Exp $
+$NetBSD: distinfo,v 1.42 2026/11/10 13:08:47 adam Exp $
 
-BLAKE2s (alembic-1.19.2.tar.gz) = 0a9536b3a643f114f8d3a105d993c231ed2450c619147cdb5c5bdf13f00375bc
-SHA512 (alembic-1.19.2.tar.gz) = c6ae515303f5106bf357c92ff979c9960a682b086c91423d467565613e8011be17db90b13c298f237e37d5a598b32fa9aa0251e5499e4aaf6626b66ea4e41bc8
-Size (alembic-1.19.2.tar.gz) = 2082643 bytes
+BLAKE2s (alembic-1.20.1.tar.gz) = 3b211034300d07813579893eab10ec636955ec369cda9676148578be1832480d
+SHA512 (alembic-1.20.1.tar.gz) = 5adb134698a25ee773e2dbc45fb59d4b81414bb26da903f463afb6dcdf32adf0c0b2ef19a77361ebdedf6946b24d8620f7fd646a1c23f028c13c0af3acb39762
+Size (alembic-1.20.1.tar.gz) = 2103576 bytes