CVS commit: pkgsrc/databases/py-peewee

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

Module Name:    pkgsrc
Committed By:   adam
Date:           Thu Jul 16 11:25:55 UTC 2026

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

Log Message:
py-peewee: updated to 4.2.3

4.2.3

* Fix a compound select (`UNION`/`INTERSECT`/`EXCEPT`) used as a correlated
  subquery emitting a phantom alias for the correlated outer table in every
  branch but the left-most, producing invalid SQL (e.g. `no such column:
  t4.id`). The right-hand branch renders in a fresh alias scope that no longer
  resolved the outer source's existing alias, it now inherits the enclosing
  scope's aliases while still assigning fresh aliases to its own sources.
* Fix full-text search `weights` passed as a `dict` being mis-applied to the
  wrong columns. For FTS3/4 the implicit `docid` primary-key was included when
  building the weight list, shifting every column by one (raising `IndexError`
  with the Python ranking UDF, silently mis-scoring with the Cython one), for
  FTS5, `UNINDEXED` columns were skipped even though `bm25()` weights are
  positional across all columns. The list form of `weights` was unaffected.
* Fix `.cte()` clearing the source query's CTE list in place: converting a query
  that carried a `with_cte(...)` clause into a CTE stripped the clause from that
  query, so reusing it afterward referenced an undeclared CTE. The query is now
  cloned before its CTE list is reset.
* Fix `Table.select()` with no arguments on a `Table` declared without columns
  emitting an empty projection (`SELECT  FROM ...`) instead of `SELECT *`.
* Fix `Table.insert(select_query)` with no `columns` raising `TypeError` instead
  of rendering `INSERT INTO t SELECT ...`.
* Fix the MySQL migrator dropping a foreign key's `ON DELETE`/`ON UPDATE` action
  when `add_not_null()` or `rename_column()` rebuilds the constraint, silently
  downgrading e.g. `CASCADE` to `RESTRICT`. The actions reported by
  `get_foreign_keys()` are now carried through to the rebuilt constraint.
* Fix the legacy `postgres_ext` JSON `contains`/`contained_by`/`concat` raising
  `AttributeError`, and `remove()` silently rewriting the entire column, when
  applied to a `.path()`-chained lookup (e.g. `Model.data['a'].path('b')`). All
  four now resolve the root field and full path via `_resolve_root()`, matching
  the sibling `set`/`replace`/`insert`/`append`/`update` mutators.
* Correct the `postgres_ext.JSONField` docs: the `json`-column field does not
  support the `jsonb`-based mutation/concatenation builders (they raise
  `ProgrammingError`), so the misleading "Postgres casts implicitly" claim was
  removed and new code is steered to the built-in `JSONField`.
* Fix the SQLite migrator treating a bare table-level `UNIQUE (a, b)` constraint
  as a column when rebuilding a table (`add_not_null`, `drop_column`, ...),
  raising `no column named UNIQUE`; `unique` is now recognized as a constraint.
* Fix the SQLite migrator's table rebuild corrupting the `CREATE TABLE` keywords
  for a table whose name is a case-insensitive substring of them (e.g. `ab`,
  `t`, `tab`) -- the table-name substitution is now anchored to the trailing
  name token.


To generate a diff of this commit:
cvs rdiff -u -r1.136 -r1.137 pkgsrc/databases/py-peewee/Makefile
cvs rdiff -u -r1.101 -r1.102 pkgsrc/databases/py-peewee/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-peewee/Makefile
diff -u pkgsrc/databases/py-peewee/Makefile:1.136 pkgsrc/databases/py-peewee/Makefile:1.137
--- pkgsrc/databases/py-peewee/Makefile:1.136   Fri Jul 10 07:44:54 2026
+++ pkgsrc/databases/py-peewee/Makefile Thu Jul 16 11:25:55 2026
@@ -1,6 +1,6 @@
-# $NetBSD: Makefile,v 1.136 2026/07/10 07:44:54 adam Exp $
+# $NetBSD: Makefile,v 1.137 2026/07/16 11:25:55 adam Exp $
 
-DISTNAME=      peewee-4.1.2
+DISTNAME=      peewee-4.2.3
 PKGNAME=       ${PYPKGPREFIX}-${DISTNAME}
 CATEGORIES=    databases python
 MASTER_SITES=  ${MASTER_SITE_PYPI:=p/peewee/}

Index: pkgsrc/databases/py-peewee/distinfo
diff -u pkgsrc/databases/py-peewee/distinfo:1.101 pkgsrc/databases/py-peewee/distinfo:1.102
--- pkgsrc/databases/py-peewee/distinfo:1.101   Fri Jul 10 07:44:54 2026
+++ pkgsrc/databases/py-peewee/distinfo Thu Jul 16 11:25:55 2026
@@ -1,5 +1,5 @@
-$NetBSD: distinfo,v 1.101 2026/07/10 07:44:54 adam Exp $
+$NetBSD: distinfo,v 1.102 2026/07/16 11:25:55 adam Exp $
 
-BLAKE2s (peewee-4.1.2.tar.gz) = e2ea02e904a9ad40929c53d7a32a1f8a86e492eb0879cfd2a4b13fe4b43bd0f6
-SHA512 (peewee-4.1.2.tar.gz) = 5a21c054754e86e94b91962638e5ec5dc883f5fc524450a7a1137509c023366463263be18930cf72bf14d2435f9787b4fc20ebf6697274d52c47afbfe18acacc
-Size (peewee-4.1.2.tar.gz) = 776979 bytes
+BLAKE2s (peewee-4.2.3.tar.gz) = 40b16656a9f536e2ed2f9318c86e1ee37fb2e4ae859165dfef62e885abb68a11
+SHA512 (peewee-4.2.3.tar.gz) = 5a366ec4dbbbc894d8cc6a3754905e2c0641eb79472bdaff273c445b290d72410122c126347141c9bbf08eab4c9b09db02db536ba43ab7a5271397df6aaca4dd
+Size (peewee-4.2.3.tar.gz) = 779440 bytes