CVS commit: pkgsrc/databases/py-tortoise-orm

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

Module Name:    pkgsrc
Committed By:   adam
Date:           Mon Oct 19 12:18:08 UTC 2026

Modified Files:
        pkgsrc/databases/py-tortoise-orm: Makefile distinfo

Log Message:
py-tortoise-orm: updated to 1.1.9

1.1.9

Added

Q.__bool__() so Q objects with no filters/children (including nested empty Q children) are falsy.
PostgreSQL password credential now accepts a sync or async callable, resolved once per new connection, to support short-lived credentials such as AWS RDS/Aurora IAM tokens and Azure Entra ID tokens.

Changed

tortoise.contrib.starlette now only supports Starlette 1.0+ (This does not affect FastAPI users; you can continue using FastAPI with any version of Starlette).

Fixed

Aggregates now apply _filter when the aggregated argument is an F() or a combined expression (e.g. Sum(F("price") * F("qty"), _filter=Q(status="paid"))). Previously the filter was silently dropped 
and every row was aggregated.
Negating an already negated Q now cancels out: ~~Q(...) and .exclude(~Q(...)) used to keep a single NOT, so they returned the rows the caller meant to drop.
PostgreSQL and Oracle RemoveIndex / partial RemoveConstraint now schema-qualify DROP INDEX, so indexes on models with Meta.schema can be dropped when they are not on the connection search_path.
ForeignKeyField/OneToOneField no longer lose a declared source_field when deconstructed. makemigrations wrote the generated <field>_id backing field name as the column name, so a migrated schema 
disagreed with generate_schemas() and neither path reported an error.
QuerySet.distinct().count() no longer counts rows duplicated by a join (e.g. filtering on a m2m relation); it now counts distinct primary keys and matches the number of rows the query returns.
DecimalField no longer strips the scale it just applied: to_python_value() called .normalize() immediately after .quantize(), so a DecimalField(max_digits=12, decimal_places=2) holding 100.00 came 
back as Decimal('1E+2') and rendered as 1E+2 in strings, f-strings and JSON.
BlackSheep: register_tortoise now enables the global connection fallback, so database access works when BlackSheep runs handlers in tasks other than the one that initialized the ORM.
fix(queryset): support DELETE/UPDATE with filters on related fields.
Fix naive DatetimeField timezone drift.
A model with its own Meta now inherits Meta.ordering from its abstract base model when it does not define its own.
The return type hint for IntEnumField/CharEnumField is now tortoise.fields.Field[EnumType] instead of EnumType.
Make EmailValidator allowed_domains actually restrict domains.
AlterModelOptions now clears options that were removed from the model, instead of only merging in the ones that remain; removing a model docstring no longer makes makemigrations regenerate the same 
migration on every run.
Model.update_or_create() now applies the caller's defaults after losing a concurrent insert, re-reading the current row through the existing transactional update path. Creation is attempted at most 
twice, with a final locked read after the last conflict; repeated concurrent deletions that exhaust recovery raise OperationalError rather than retrying indefinitely.
psycopg: the connection pool now validates a connection on checkout, so one silently dropped by the network while idle (a firewall or load balancer closing it, a DB restart, ...) gets transparently 
replaced instead of being handed to the caller and failing with psycopg.OperationalError: the connection is closed. The check is a cheap no-op query on an already-open socket, so the added latency 
per checkout is negligible next to a real query.
Fixed prefetch_related() on m2m fields ignoring select_related(), annotate(), and order_by() applied to the prefetched queryset.
pydantic_model_creator no longer raises TypeError for models with annotations whose origin is not a class, such as Literal[...].
Filtering by a related model instance on a ForeignKeyField/OneToOneField declared with a non-primary-key to_field now uses the to_field value instead of the instance's primary key, so the generated 
query targets the correct column.
Database URLs with an empty host (e.g. postgres:///db?host=/var/run/postgresql&user=u) no longer overwrite host/user/password given in the query string, so unix domain sockets work.


To generate a diff of this commit:
cvs rdiff -u -r1.51 -r1.52 pkgsrc/databases/py-tortoise-orm/Makefile
cvs rdiff -u -r1.40 -r1.41 pkgsrc/databases/py-tortoise-orm/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-tortoise-orm/Makefile
diff -u pkgsrc/databases/py-tortoise-orm/Makefile:1.51 pkgsrc/databases/py-tortoise-orm/Makefile:1.52
--- pkgsrc/databases/py-tortoise-orm/Makefile:1.51      Fri Oct 16 19:43:44 2026
+++ pkgsrc/databases/py-tortoise-orm/Makefile   Mon Oct 19 12:18:08 2026
@@ -1,6 +1,6 @@
-# $NetBSD: Makefile,v 1.51 2026/10/16 19:43:44 adam Exp $
+# $NetBSD: Makefile,v 1.52 2026/10/19 12:18:08 adam Exp $
 
-DISTNAME=      tortoise_orm-1.1.8
+DISTNAME=      tortoise_orm-1.1.9
 PKGNAME=       ${PYPKGPREFIX}-${DISTNAME:S/_/-/}
 CATEGORIES=    databases python
 MASTER_SITES=  ${MASTER_SITE_PYPI:=t/tortoise-orm/}
@@ -10,9 +10,9 @@ HOMEPAGE=     https://github.com/tortoise/to
 COMMENT=       Easy async ORM for Python, built with relations in mind
 LICENSE=       apache-2.0
 
-TOOL_DEPENDS+= ${PYPKGPREFIX}-pdm_backend>0:../../devel/py-pdm_backend
+TOOL_DEPENDS+= ${PYPKGPREFIX}-pdm_backend>=0:../../devel/py-pdm_backend
 DEPENDS+=      ${PYPKGPREFIX}-aiosqlite>=0.16.0:../../databases/py-aiosqlite
-DEPENDS+=      ${PYPKGPREFIX}-anyio>0:../../devel/py-anyio
+DEPENDS+=      ${PYPKGPREFIX}-anyio>=0:../../devel/py-anyio
 DEPENDS+=      ${PYPKGPREFIX}-iso8601>=2.1.0:../../time/py-iso8601
 DEPENDS+=      ${PYPKGPREFIX}-pypika-tortoise>=0.6.5:../../databases/py-pypika-tortoise
 # accel

Index: pkgsrc/databases/py-tortoise-orm/distinfo
diff -u pkgsrc/databases/py-tortoise-orm/distinfo:1.40 pkgsrc/databases/py-tortoise-orm/distinfo:1.41
--- pkgsrc/databases/py-tortoise-orm/distinfo:1.40      Tue Aug 11 05:40:26 2026
+++ pkgsrc/databases/py-tortoise-orm/distinfo   Mon Oct 19 12:18:08 2026
@@ -1,5 +1,5 @@
-$NetBSD: distinfo,v 1.40 2026/08/11 05:40:26 adam Exp $
+$NetBSD: distinfo,v 1.41 2026/10/19 12:18:08 adam Exp $
 
-BLAKE2s (tortoise_orm-1.1.8.tar.gz) = 8119b4c485dc7246efe3cdd5233333fe58a126da7147fce1269d096505eb1d0c
-SHA512 (tortoise_orm-1.1.8.tar.gz) = f8d23ef8c4768286b5800156ea9594a44498ffc67211a7da107a6a4eb4918d604d9217559b85f83aadd954846d0efbeaf243274900f396790409d4d06817ffc0
-Size (tortoise_orm-1.1.8.tar.gz) = 398141 bytes
+BLAKE2s (tortoise_orm-1.1.9.tar.gz) = 3ae33493d24a0a931c449c37141c8a4c5c05165ac0b744e3d73d76c61d9617a3
+SHA512 (tortoise_orm-1.1.9.tar.gz) = 5e2638851cedba12eed9f6c4d8e2ae757ae8475910abfe73a037e069f18c22005359e4e60f413f1a83f7565aa95a94aa39a23f9cdd5cf3399927f8878dea5a64
+Size (tortoise_orm-1.1.9.tar.gz) = 410828 bytes