CVS commit: pkgsrc/databases/py-pypika

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

Module Name:    pkgsrc
Committed By:   adam
Date:           Sun Feb 15 13:30:33 UTC 2026

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

Log Message:
py-pypika: updated to 0.51.1

0.51.1

typefix: Add explicit type annotations to table attribute for mypy compatibility

0.51.0

typefix: update parameter types in aggregate and function classes to use Term

0.50.0

New Features

JQL (Jira Query Language) support - New JiraQuery class for building Jira queries with isempty() and notempty() methods
QUALIFY clause - Filter rows based on window function results
Bitwise OR support - New bitwiseor() method on fields
ClickHouse DISTINCT ON - distinct_on() method for ClickHouse queries
ClickHouse LIMIT BY - limit_by() and limit_offset_by() methods
ClickHouse FINAL - final() method for FINAL keyword
ClickHouse SAMPLE - sample() method for approximate query processing
Oracle LIMIT/OFFSET - limit() and offset() support using FETCH NEXT/OFFSET ROWS syntax
CREATE/DROP INDEX - Query.create_index() and Query.drop_index() with support for unique, partial, and conditional indices
Pipe operator - QueryBuilder.pipe() method for functional composition
Improved parameterized queries - get_parameters() method to collect parameter values, ListParameter and DictParameter base classes
Auto increment columns - Auto increment support on SqlTypes for CREATE TABLE
datetime.time support - Proper handling of datetime.time values

Bug Fixes

Fixed EmptyCriterion handling in &, |, ^ operations with Criterion
Fixed Field.__init__ to accept string table names
Fixed isin() and notin() to accept frozenset
Fixed MySQL set operations (UNION/INTERSECT/MINUS) to wrap queries in parentheses
Fixed PostgreSQL array syntax for UPDATE statements
Fixed escape quotes in identifiers

Typing & Compatibility

Added py.typed marker for PEP 561 compliance
Fixed typing hint for @builder decorator to preserve callable type
Fixed types for mypy downstream usage, added __all__ exports
Improved typing for builder methods
Added Python 3.13 and 3.14 support
Applied future type style annotations

Documentation

Added comprehensive documentation for all new features to README.rst
Added documentation for: Analytic Queries (NTILE, RANK, FIRST_VALUE, LAST_VALUE, MEDIAN, AVG, STDDEV), Window Frames, ROLLUP, Pseudo Columns, TEMPORARY/UNLOGGED tables
Unified documentation between README.rst and ReadTheDocs (single source of truth)
Fixed PseudoColumn import in docs
Added contributing guidelines
Various typo fixes

Internal

Refactored Interval to inherit from Term
Refactored shared logic for Criterion comparisons
Updated CI to test Python 3.8-3.14 and PyPy 3.9-3.11 on Ubuntu and macOS
Added GitHub Actions release workflow for PyPI publishing
Removed tox dependency, simplified test running
Updated Sphinx and other dev dependencies


To generate a diff of this commit:
cvs rdiff -u -r1.30 -r1.31 pkgsrc/databases/py-pypika/Makefile
cvs rdiff -u -r1.3 -r1.4 pkgsrc/databases/py-pypika/PLIST
cvs rdiff -u -r1.25 -r1.26 pkgsrc/databases/py-pypika/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-pypika/Makefile
diff -u pkgsrc/databases/py-pypika/Makefile:1.30 pkgsrc/databases/py-pypika/Makefile:1.31
--- pkgsrc/databases/py-pypika/Makefile:1.30    Thu Oct  9 10:56:26 2025
+++ pkgsrc/databases/py-pypika/Makefile Sun Feb 15 13:30:33 2026
@@ -1,8 +1,7 @@
-# $NetBSD: Makefile,v 1.30 2025/10/09 10:56:26 wiz Exp $
+# $NetBSD: Makefile,v 1.31 2026/02/15 13:30:33 adam Exp $
 
-DISTNAME=      PyPika-0.48.9
-PKGNAME=       ${PYPKGPREFIX}-${DISTNAME:tl}
-PKGREVISION=   3
+DISTNAME=      pypika-0.51.1
+PKGNAME=       ${PYPKGPREFIX}-${DISTNAME}
 CATEGORIES=    databases python
 MASTER_SITES=  ${MASTER_SITE_PYPI:=P/PyPika/}
 
@@ -15,12 +14,7 @@ TOOL_DEPENDS+=       ${PYPKGPREFIX}-setuptools
 
 CONFLICTS=     py[0-9]*-pypika-tortoise-[0-9]*
 
-# ast.Str, see https://github.com/kayak/pypika/issues/847
-PYTHON_VERSIONS_INCOMPATIBLE+= 314
-
 USE_LANGUAGES= # none
 
-WHEEL_NAME=    ${DISTNAME:tl}
-
 .include "../../lang/python/wheel.mk"
 .include "../../mk/bsd.pkg.mk"

Index: pkgsrc/databases/py-pypika/PLIST
diff -u pkgsrc/databases/py-pypika/PLIST:1.3 pkgsrc/databases/py-pypika/PLIST:1.4
--- pkgsrc/databases/py-pypika/PLIST:1.3        Mon Apr 14 11:31:12 2025
+++ pkgsrc/databases/py-pypika/PLIST    Sun Feb 15 13:30:33 2026
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.3 2025/04/14 11:31:12 adam Exp $
+@comment $NetBSD: PLIST,v 1.4 2026/02/15 13:30:33 adam Exp $
 ${PYSITELIB}/${WHEEL_INFODIR}/METADATA
 ${PYSITELIB}/${WHEEL_INFODIR}/RECORD
 ${PYSITELIB}/${WHEEL_INFODIR}/WHEEL
@@ -43,6 +43,7 @@ ${PYSITELIB}/pypika/functions.pyo
 ${PYSITELIB}/pypika/pseudocolumns.py
 ${PYSITELIB}/pypika/pseudocolumns.pyc
 ${PYSITELIB}/pypika/pseudocolumns.pyo
+${PYSITELIB}/pypika/py.typed
 ${PYSITELIB}/pypika/queries.py
 ${PYSITELIB}/pypika/queries.pyc
 ${PYSITELIB}/pypika/queries.pyo

Index: pkgsrc/databases/py-pypika/distinfo
diff -u pkgsrc/databases/py-pypika/distinfo:1.25 pkgsrc/databases/py-pypika/distinfo:1.26
--- pkgsrc/databases/py-pypika/distinfo:1.25    Mon Apr  4 18:21:25 2022
+++ pkgsrc/databases/py-pypika/distinfo Sun Feb 15 13:30:33 2026
@@ -1,5 +1,5 @@
-$NetBSD: distinfo,v 1.25 2022/04/04 18:21:25 adam Exp $
+$NetBSD: distinfo,v 1.26 2026/02/15 13:30:33 adam Exp $
 
-BLAKE2s (PyPika-0.48.9.tar.gz) = 799996e0f2056e36d663f1d7cc891ee7fab4759db8313ad0bcc4d8a7c4df98a8
-SHA512 (PyPika-0.48.9.tar.gz) = f6b00622a37298e8c9b911ba5c29c354519f1bbe3c9b74ea2b3c0059724189f56a7e8566dc058ccd77de11f834405cd8e46922c3cc997dd445e636ca71fa6481
-Size (PyPika-0.48.9.tar.gz) = 67259 bytes
+BLAKE2s (pypika-0.51.1.tar.gz) = 3816accee1314762950de6db3f794959102344468ecf07128fa721700f189aed
+SHA512 (pypika-0.51.1.tar.gz) = d56ac771b66884ce8fe881bc0d29f18048e3da0af0e882265e022f025adbc7af326d2e0c9c8e867c7d95d0b50cd2f825229cebd8ed8037e6806699cf992631d5
+Size (pypika-0.51.1.tar.gz) = 80919 bytes