CVS commit: pkgsrc/databases/py-alembic

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

Module Name:    pkgsrc
Committed By:   adam
Date:           Sun Jan 11 10:47:15 UTC 2026

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

Log Message:
py-alembic: updated to 1.18.0

1.18.0

feature

[feature] [operations]
When alembic is run in “verbose” mode, alembic now logs a message to indicate from which file is used to load the configuration.

[feature] [autogenerate]
Autogenerate reflection sweeps now use the “bulk” inspector methods introduced in SQLAlchemy 2.0, which for selected dialects including PostgreSQL and Oracle use batched queries to reflect whole 
collections of tables using O(1) queries rather than O(N).

[feature] [autogenerate]
Release 1.18.0 introduces a plugin system that allows for automatic loading of third-party extensions as well as configurable autogenerate compare functionality on a per-environment basis.
The Plugin class provides a common interface for extensions that register handlers among Alembic’s existing extension points such as Operations.register_operation() and 
Operations.implementation_for(). A new interface for registering autogenerate comparison handlers, Plugin.add_autogenerate_comparator(), provides for autogenerate compare functionality that may be 
custom-configured on a per-environment basis using the new EnvironmentContext.configure.autogenerate_plugins parameter.
The change does not impact well known Alembic add-ons such as alembic-utils, which continue to work as before; however, such add-ons have the option to provide plugin entrypoints going forward.
As part of this change, Alembic’s autogenerate compare functionality is reorganized into a series of internal plugins under the alembic.autogenerate namespace, which may be individually or 
collectively identified for inclusion and/or exclusion within the EnvironmentContext.configure() call using a new parameter EnvironmentContext.configure.autogenerate_plugins. This parameter is also 
where third party comparison plugins may also be indicated.
See Plugins for complete documentation on the new Plugin class as well as autogenerate-specific usage instructions.
usecase

[usecase] [environment]
The file_template configuration option now supports directory paths, allowing migration files to be organized into subdirectories. When using directory separators in file_template (e.g., 
%(year)d/%(month).2d/%(day).2d_%(rev)s_%(slug)s), Alembic will automatically create the necessary directory structure. The recursive_version_locations setting must be set to true when using this 
feature in order for the revision files to be located for subsequent commands.

[usecase]
Avoid deprecation warning in add/drop constraint added in SQLAlchemy 2.1. Ensure that alembic is compatible with the changes added in sqlalchemy/sqlalchemy-13006 by explicitly setting 
isolate_from_table=True when running with SQLAlchemy 2.1 or greater.
bug

[bug] [postgresql]
Fixed issue where PostgreSQL sequence defaults on non-primary key columns were incorrectly detected as changed on every autogenerate run. Server default comparison logic is adjusted to filter out the 
::regclass expression added by the server which interferes with the comparison.

[bug] [mssql]
Implemented DDL for column comment add/update/delete when using the Operations.alter_column.comment parameter with Operations.alter_column() on Microsoft SQL Server. Previously, these functions were 
not implemented for SQL Server and would raise UnsupportedCompilationError.


To generate a diff of this commit:
cvs rdiff -u -r1.45 -r1.46 pkgsrc/databases/py-alembic/Makefile
cvs rdiff -u -r1.11 -r1.12 pkgsrc/databases/py-alembic/PLIST
cvs rdiff -u -r1.35 -r1.36 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.45 pkgsrc/databases/py-alembic/Makefile:1.46
--- pkgsrc/databases/py-alembic/Makefile:1.45   Tue Dec 30 12:57:02 2025
+++ pkgsrc/databases/py-alembic/Makefile        Sun Jan 11 10:47:15 2026
@@ -1,6 +1,6 @@
-# $NetBSD: Makefile,v 1.45 2025/12/30 12:57:02 adam Exp $
+# $NetBSD: Makefile,v 1.46 2026/01/11 10:47:15 adam Exp $
 
-DISTNAME=      alembic-1.17.2
+DISTNAME=      alembic-1.18.0
 PKGNAME=       ${PYPKGPREFIX}-${DISTNAME}
 CATEGORIES=    databases python
 MASTER_SITES=  ${MASTER_SITE_PYPI:=a/alembic/}

Index: pkgsrc/databases/py-alembic/PLIST
diff -u pkgsrc/databases/py-alembic/PLIST:1.11 pkgsrc/databases/py-alembic/PLIST:1.12
--- pkgsrc/databases/py-alembic/PLIST:1.11      Wed Aug 20 07:20:35 2025
+++ pkgsrc/databases/py-alembic/PLIST   Sun Jan 11 10:47:15 2026
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.11 2025/08/20 07:20:35 adam Exp $
+@comment $NetBSD: PLIST,v 1.12 2026/01/11 10:47:15 adam Exp $
 bin/alembic-${PYVERSSUFFIX}
 ${PYSITELIB}/${WHEEL_INFODIR}/METADATA
 ${PYSITELIB}/${WHEEL_INFODIR}/RECORD
@@ -18,9 +18,30 @@ ${PYSITELIB}/alembic/autogenerate/__init
 ${PYSITELIB}/alembic/autogenerate/api.py
 ${PYSITELIB}/alembic/autogenerate/api.pyc
 ${PYSITELIB}/alembic/autogenerate/api.pyo
-${PYSITELIB}/alembic/autogenerate/compare.py
-${PYSITELIB}/alembic/autogenerate/compare.pyc
-${PYSITELIB}/alembic/autogenerate/compare.pyo
+${PYSITELIB}/alembic/autogenerate/compare/__init__.py
+${PYSITELIB}/alembic/autogenerate/compare/__init__.pyc
+${PYSITELIB}/alembic/autogenerate/compare/__init__.pyo
+${PYSITELIB}/alembic/autogenerate/compare/comments.py
+${PYSITELIB}/alembic/autogenerate/compare/comments.pyc
+${PYSITELIB}/alembic/autogenerate/compare/comments.pyo
+${PYSITELIB}/alembic/autogenerate/compare/constraints.py
+${PYSITELIB}/alembic/autogenerate/compare/constraints.pyc
+${PYSITELIB}/alembic/autogenerate/compare/constraints.pyo
+${PYSITELIB}/alembic/autogenerate/compare/schema.py
+${PYSITELIB}/alembic/autogenerate/compare/schema.pyc
+${PYSITELIB}/alembic/autogenerate/compare/schema.pyo
+${PYSITELIB}/alembic/autogenerate/compare/server_defaults.py
+${PYSITELIB}/alembic/autogenerate/compare/server_defaults.pyc
+${PYSITELIB}/alembic/autogenerate/compare/server_defaults.pyo
+${PYSITELIB}/alembic/autogenerate/compare/tables.py
+${PYSITELIB}/alembic/autogenerate/compare/tables.pyc
+${PYSITELIB}/alembic/autogenerate/compare/tables.pyo
+${PYSITELIB}/alembic/autogenerate/compare/types.py
+${PYSITELIB}/alembic/autogenerate/compare/types.pyc
+${PYSITELIB}/alembic/autogenerate/compare/types.pyo
+${PYSITELIB}/alembic/autogenerate/compare/util.py
+${PYSITELIB}/alembic/autogenerate/compare/util.pyc
+${PYSITELIB}/alembic/autogenerate/compare/util.pyo
 ${PYSITELIB}/alembic/autogenerate/render.py
 ${PYSITELIB}/alembic/autogenerate/render.pyc
 ${PYSITELIB}/alembic/autogenerate/render.pyo
@@ -102,6 +123,9 @@ ${PYSITELIB}/alembic/runtime/environment
 ${PYSITELIB}/alembic/runtime/migration.py
 ${PYSITELIB}/alembic/runtime/migration.pyc
 ${PYSITELIB}/alembic/runtime/migration.pyo
+${PYSITELIB}/alembic/runtime/plugins.py
+${PYSITELIB}/alembic/runtime/plugins.pyc
+${PYSITELIB}/alembic/runtime/plugins.pyo
 ${PYSITELIB}/alembic/script/__init__.py
 ${PYSITELIB}/alembic/script/__init__.pyc
 ${PYSITELIB}/alembic/script/__init__.pyo

Index: pkgsrc/databases/py-alembic/distinfo
diff -u pkgsrc/databases/py-alembic/distinfo:1.35 pkgsrc/databases/py-alembic/distinfo:1.36
--- pkgsrc/databases/py-alembic/distinfo:1.35   Tue Dec 30 12:57:02 2025
+++ pkgsrc/databases/py-alembic/distinfo        Sun Jan 11 10:47:15 2026
@@ -1,5 +1,5 @@
-$NetBSD: distinfo,v 1.35 2025/12/30 12:57:02 adam Exp $
+$NetBSD: distinfo,v 1.36 2026/01/11 10:47:15 adam Exp $
 
-BLAKE2s (alembic-1.17.2.tar.gz) = 6f9a3360a30cc7d3db7254a1fab0586879addd4a6e8799d3c978dececb8a4496
-SHA512 (alembic-1.17.2.tar.gz) = 39ac83508b505fb81c26afdbe28edc3b9aeffd536d63f0ba8e8015fde4a815b899d269417a18aa4325a08a97cb74b6c52057960ecec6839fe3dc070a6752b9c5
-Size (alembic-1.17.2.tar.gz) = 1988064 bytes
+BLAKE2s (alembic-1.18.0.tar.gz) = fb04f6cfb8145510f5a9db5b2d9a91a9ba0aa50de2b234396d0b69b5c7b0cd10
+SHA512 (alembic-1.18.0.tar.gz) = 77f9d9e3a1c7179e655176ffb630e8f6c90fc646e6d74172f52e41858ba7ca150eb088e54a57fbe08bcec9109ed61e3bfe10b017ecc42cde9a9adbd82c273d45
+Size (alembic-1.18.0.tar.gz) = 2043788 bytes