CVS commit: pkgsrc/databases/py-alembic

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

Module Name:    pkgsrc
Committed By:   adam
Date:           Tue Sep  8 05:31:06 UTC 2026

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

Log Message:
py-alembic: updated to 1.19.2

1.19.2

changed

[changed] [autogenerate]
The autogenerate plugin for CHECK constraint detection by name, added in 1.19.0. for 508, is no longer enabled by default. It has been renamed from alembic.autogenerate.checkconstraint_byname to 
alembic.ext.checkconstraint_byname and no longer matches on the "alembic.autogenerate.*" wildcard, which remains the default plugin specification. The previous name will still function as well if 
placed in the plugins list explicitly, both to enable the plugin and within a "~" exclusion, so that an env.py written against 1.19.0 or 1.19.1 requires no change.

The plugin is now recommended only for schemas that ensure the naming of all constraints using a client side naming convention, otherwise there’s a persistent risk of false positives. See Detecting 
CHECK Constraints for background on things to be aware of when using this plugin.

As part of this change “type bound” CHECK constraints, which include constraints generated for the Boolean and Enum datatypes when the create_constraint parameter is set to True, are no longer 
ignored in the metadata side, so that normal name-based matching can occur for these constraints.

usecase

[usecase] [autogenerate] [batch]
The target of a ForeignKey is now located using the ForeignKey.target_tokens and ForeignKey.target_table_key accessors added in SQLAlchemy 2.1, rather than by splitting the dotted string form of that 
target on ".". As a dot inside a schema, table or column name cannot be told apart from the separator between those names, a foreign key whose target name contained a dot was previously mis-parsed by 
autogenerate rendering as well as by batch migrations. The dotted string continues to be split when running against SQLAlchemy 2.0, where these accessors are not present. Thanks to Gyanu Mayank for 
the initial pull request.


To generate a diff of this commit:
cvs rdiff -u -r1.51 -r1.52 pkgsrc/databases/py-alembic/Makefile
cvs rdiff -u -r1.12 -r1.13 pkgsrc/databases/py-alembic/PLIST
cvs rdiff -u -r1.40 -r1.41 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.51 pkgsrc/databases/py-alembic/Makefile:1.52
--- pkgsrc/databases/py-alembic/Makefile:1.51   Mon Jun 29 05:27:02 2026
+++ pkgsrc/databases/py-alembic/Makefile        Tue Sep  8 05:31:06 2026
@@ -1,6 +1,6 @@
-# $NetBSD: Makefile,v 1.51 2026/06/29 05:27:02 adam Exp $
+# $NetBSD: Makefile,v 1.52 2026/09/08 05:31:06 adam Exp $
 
-DISTNAME=      alembic-1.18.5
+DISTNAME=      alembic-1.19.2
 PKGNAME=       ${PYPKGPREFIX}-${DISTNAME}
 CATEGORIES=    databases python
 MASTER_SITES=  ${MASTER_SITE_PYPI:=a/alembic/}
@@ -11,7 +11,7 @@ COMMENT=      Database migration tool for SQL
 LICENSE=       mit
 
 TOOL_DEPENDS+= ${PYPKGPREFIX}-setuptools>=78:../../devel/py-setuptools
-DEPENDS+=      ${PYPKGPREFIX}-mako-[0-9]*:../../devel/py-mako
+DEPENDS+=      ${PYPKGPREFIX}-mako>=0:../../devel/py-mako
 DEPENDS+=      ${PYPKGPREFIX}-sqlalchemy>=1.4.23:../../databases/py-sqlalchemy
 DEPENDS+=      ${PYPKGPREFIX}-typing-extensions>=4.12:../../devel/py-typing-extensions
 

Index: pkgsrc/databases/py-alembic/PLIST
diff -u pkgsrc/databases/py-alembic/PLIST:1.12 pkgsrc/databases/py-alembic/PLIST:1.13
--- pkgsrc/databases/py-alembic/PLIST:1.12      Sun Jan 11 10:47:15 2026
+++ pkgsrc/databases/py-alembic/PLIST   Tue Sep  8 05:31:06 2026
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.12 2026/01/11 10:47:15 adam Exp $
+@comment $NetBSD: PLIST,v 1.13 2026/09/08 05:31:06 adam Exp $
 bin/alembic-${PYVERSSUFFIX}
 ${PYSITELIB}/${WHEEL_INFODIR}/METADATA
 ${PYSITELIB}/${WHEEL_INFODIR}/RECORD
@@ -88,6 +88,12 @@ ${PYSITELIB}/alembic/ddl/sqlite.pyo
 ${PYSITELIB}/alembic/environment.py
 ${PYSITELIB}/alembic/environment.pyc
 ${PYSITELIB}/alembic/environment.pyo
+${PYSITELIB}/alembic/ext/__init__.py
+${PYSITELIB}/alembic/ext/__init__.pyc
+${PYSITELIB}/alembic/ext/__init__.pyo
+${PYSITELIB}/alembic/ext/checkconstraint_byname.py
+${PYSITELIB}/alembic/ext/checkconstraint_byname.pyc
+${PYSITELIB}/alembic/ext/checkconstraint_byname.pyo
 ${PYSITELIB}/alembic/migration.py
 ${PYSITELIB}/alembic/migration.pyc
 ${PYSITELIB}/alembic/migration.pyo

Index: pkgsrc/databases/py-alembic/distinfo
diff -u pkgsrc/databases/py-alembic/distinfo:1.40 pkgsrc/databases/py-alembic/distinfo:1.41
--- pkgsrc/databases/py-alembic/distinfo:1.40   Mon Jun 29 05:27:02 2026
+++ pkgsrc/databases/py-alembic/distinfo        Tue Sep  8 05:31:06 2026
@@ -1,5 +1,5 @@
-$NetBSD: distinfo,v 1.40 2026/06/29 05:27:02 adam Exp $
+$NetBSD: distinfo,v 1.41 2026/09/08 05:31:06 adam Exp $
 
-BLAKE2s (alembic-1.18.5.tar.gz) = cf20e615a8808040a450ed0628f54c64872072106b387d3c427b1aab6ba278e1
-SHA512 (alembic-1.18.5.tar.gz) = 41d9675e2c99d339e2aa92e670acc0d562ab6a23d2006f2180478fa912ede643be959ca89713678adffe37deb20118a0d67ea7c023b2dea15d3acb5be18721fc
-Size (alembic-1.18.5.tar.gz) = 2060480 bytes
+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