[pkgsrc/trunk]: pkgsrc/databases/py-peewee py-peewee: updated to 3.15.0

[adam <adam%pkgsrc.org@localhost>]

details:   https://anonhg.NetBSD.org/pkgsrc/rev/724cbb8aa091
branches:  trunk
changeset: 380871:724cbb8aa091
user:      adam <adam%pkgsrc.org@localhost>
date:      Fri Jun 17 17:35:22 2022 +0000

description:
py-peewee: updated to 3.15.0

3.15.0

Rollback behavior change in commit ab43376697. Peewee will no longer automatically return the cursor rowcount for certain bulk-inserts. This should only affect users of MySQL and Sqlite who relied on 
a bulk INSERT returning the rowcount (as opposed to the cursor's lastrowid). The rowcount behavior is still available chaining the as_rowcount() method:

# NOTE: this change only affects MySQL or Sqlite.
db = MySQLDatabase(...)

# Previously, bulk inserts of the following forms would return the rowcount.
query = User.insert_many(...)  # Bulk insert.
query = User.insert_from(...)  # Bulk insert (INSERT INTO .. SELECT FROM).

# Previous behavior (peewee 3.12 - 3.14.10):
# rows_inserted = query.execute()

# New behavior:
last_id = query.execute()

# To get the old behavior back:
rows_inserted = query.as_rowcount().execute()
This release contains a fix for a long-standing request to allow data-modifying queries to support CTEs. CTEs are now supported for use with INSERT, DELETE and UPDATE queries.

Additionally, this release adds better support for using the new RETURNING syntax with Sqlite automatically. Specify returing_clause=True when initializing your SqliteDatabase and all bulk inserts 
will automatically specify a RETURNING clause, returning the newly-inserted primary keys. This functionality requires Sqlite 3.35 or newer.

Smaller changes:

Add shortcuts.insert_where() helper for generating conditional INSERT with a bit less boilerplate.
Fix bug in test_utils.count_queres() which could erroneously include pool events such as connect/disconnect, etc.

diffstat:

 databases/py-peewee/Makefile |  5 ++---
 databases/py-peewee/distinfo |  8 ++++----
 2 files changed, 6 insertions(+), 7 deletions(-)

diffs (28 lines):

diff -r 084e1283c6c2 -r 724cbb8aa091 databases/py-peewee/Makefile
--- a/databases/py-peewee/Makefile      Fri Jun 17 17:32:41 2022 +0000
+++ b/databases/py-peewee/Makefile      Fri Jun 17 17:35:22 2022 +0000
@@ -1,8 +1,7 @@
-# $NetBSD: Makefile,v 1.84 2022/04/18 19:10:44 adam Exp $
+# $NetBSD: Makefile,v 1.85 2022/06/17 17:35:22 adam Exp $
 
-DISTNAME=      peewee-3.14.10
+DISTNAME=      peewee-3.15.0
 PKGNAME=       ${PYPKGPREFIX}-${DISTNAME}
-PKGREVISION=   1
 CATEGORIES=    databases python
 MASTER_SITES=  ${MASTER_SITE_PYPI:=p/peewee/}
 
diff -r 084e1283c6c2 -r 724cbb8aa091 databases/py-peewee/distinfo
--- a/databases/py-peewee/distinfo      Fri Jun 17 17:32:41 2022 +0000
+++ b/databases/py-peewee/distinfo      Fri Jun 17 17:35:22 2022 +0000
@@ -1,6 +1,6 @@
-$NetBSD: distinfo,v 1.68 2022/03/07 18:33:15 adam Exp $
+$NetBSD: distinfo,v 1.69 2022/06/17 17:35:22 adam Exp $
 
-BLAKE2s (peewee-3.14.10.tar.gz) = 61fa84eeae5fe9ca4cfab9505c71c1b5e8fda6a9e04e3742d765ada5bf5ac199
-SHA512 (peewee-3.14.10.tar.gz) = 00fe0eb4a34173149150b0f5b3aae707c553b515a005e6e0cf468c28d8071b06a62f419d5744926a9fc96c421ab89f1c87a6e959d0b055eaff4b845e8729f072
-Size (peewee-3.14.10.tar.gz) = 855490 bytes
+BLAKE2s (peewee-3.15.0.tar.gz) = 611b0c13a77aae2bb10769ea6fde393990c03d92c475d4c05cfff12d8057daff
+SHA512 (peewee-3.15.0.tar.gz) = becbead9d0554515599293f74bb7a9378e581d7b62f5b87e88e408ffa709a48f18cd1808703fd482b0c824d42bd93722672f05c2c60c1d38ca7486598380da45
+Size (peewee-3.15.0.tar.gz) = 859070 bytes
 SHA1 (patch-setup.py) = 59788f77a576274de46a2c090a9a0a6ede0e1166