head 1.4; access; symbols pkgsrc-2026Q1:1.4.0.2 pkgsrc-2026Q1-base:1.4 pkgsrc-2025Q4:1.3.0.6 pkgsrc-2025Q4-base:1.3 pkgsrc-2025Q3:1.3.0.4 pkgsrc-2025Q3-base:1.3 pkgsrc-2025Q2:1.3.0.2 pkgsrc-2025Q2-base:1.3 pkgsrc-2025Q1:1.2.0.12 pkgsrc-2025Q1-base:1.2 pkgsrc-2024Q4:1.2.0.10 pkgsrc-2024Q4-base:1.2 pkgsrc-2024Q3:1.2.0.8 pkgsrc-2024Q3-base:1.2 pkgsrc-2024Q2:1.2.0.6 pkgsrc-2024Q2-base:1.2 pkgsrc-2024Q1:1.2.0.4 pkgsrc-2024Q1-base:1.2 pkgsrc-2023Q4:1.2.0.2 pkgsrc-2023Q4-base:1.2 pkgsrc-2023Q3:1.1.0.28 pkgsrc-2023Q3-base:1.1 pkgsrc-2023Q2:1.1.0.26 pkgsrc-2023Q2-base:1.1 pkgsrc-2023Q1:1.1.0.24 pkgsrc-2023Q1-base:1.1 pkgsrc-2022Q4:1.1.0.22 pkgsrc-2022Q4-base:1.1 pkgsrc-2022Q3:1.1.0.20 pkgsrc-2022Q3-base:1.1 pkgsrc-2022Q2:1.1.0.18 pkgsrc-2022Q2-base:1.1 pkgsrc-2022Q1:1.1.0.16 pkgsrc-2022Q1-base:1.1 pkgsrc-2021Q4:1.1.0.14 pkgsrc-2021Q4-base:1.1 pkgsrc-2021Q3:1.1.0.12 pkgsrc-2021Q3-base:1.1 pkgsrc-2021Q2:1.1.0.10 pkgsrc-2021Q2-base:1.1 pkgsrc-2021Q1:1.1.0.8 pkgsrc-2021Q1-base:1.1 pkgsrc-2020Q4:1.1.0.6 pkgsrc-2020Q4-base:1.1 pkgsrc-2020Q3:1.1.0.4 pkgsrc-2020Q3-base:1.1 pkgsrc-2020Q2:1.1.0.2 pkgsrc-2020Q2-base:1.1; locks; strict; comment @# @; 1.4 date 2026.02.15.13.30.33; author adam; state Exp; branches; next 1.3; commitid BKQxboHCozSgztuG; 1.3 date 2025.04.14.11.31.12; author adam; state Exp; branches; next 1.2; commitid iWGafUs4MGRtM0RF; 1.2 date 2023.11.23.08.03.59; author adam; state Exp; branches; next 1.1; commitid nT6yAosphquNXHNE; 1.1 date 2020.05.23.20.00.45; author adam; state Exp; branches; next ; commitid MPjy7A5fsVrt2p9C; desc @@ 1.4 log @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 @ text @@@comment $NetBSD: PLIST,v 1.3 2025/04/14 11:31:12 adam Exp $ ${PYSITELIB}/${WHEEL_INFODIR}/METADATA ${PYSITELIB}/${WHEEL_INFODIR}/RECORD ${PYSITELIB}/${WHEEL_INFODIR}/WHEEL ${PYSITELIB}/${WHEEL_INFODIR}/licenses/LICENSE.txt ${PYSITELIB}/${WHEEL_INFODIR}/top_level.txt ${PYSITELIB}/pypika/__init__.py ${PYSITELIB}/pypika/__init__.pyc ${PYSITELIB}/pypika/__init__.pyo ${PYSITELIB}/pypika/analytics.py ${PYSITELIB}/pypika/analytics.pyc ${PYSITELIB}/pypika/analytics.pyo ${PYSITELIB}/pypika/clickhouse/__init__.py ${PYSITELIB}/pypika/clickhouse/__init__.pyc ${PYSITELIB}/pypika/clickhouse/__init__.pyo ${PYSITELIB}/pypika/clickhouse/array.py ${PYSITELIB}/pypika/clickhouse/array.pyc ${PYSITELIB}/pypika/clickhouse/array.pyo ${PYSITELIB}/pypika/clickhouse/condition.py ${PYSITELIB}/pypika/clickhouse/condition.pyc ${PYSITELIB}/pypika/clickhouse/condition.pyo ${PYSITELIB}/pypika/clickhouse/dates_and_times.py ${PYSITELIB}/pypika/clickhouse/dates_and_times.pyc ${PYSITELIB}/pypika/clickhouse/dates_and_times.pyo ${PYSITELIB}/pypika/clickhouse/nullable_arg.py ${PYSITELIB}/pypika/clickhouse/nullable_arg.pyc ${PYSITELIB}/pypika/clickhouse/nullable_arg.pyo ${PYSITELIB}/pypika/clickhouse/search_string.py ${PYSITELIB}/pypika/clickhouse/search_string.pyc ${PYSITELIB}/pypika/clickhouse/search_string.pyo ${PYSITELIB}/pypika/clickhouse/type_conversion.py ${PYSITELIB}/pypika/clickhouse/type_conversion.pyc ${PYSITELIB}/pypika/clickhouse/type_conversion.pyo ${PYSITELIB}/pypika/dialects.py ${PYSITELIB}/pypika/dialects.pyc ${PYSITELIB}/pypika/dialects.pyo ${PYSITELIB}/pypika/enums.py ${PYSITELIB}/pypika/enums.pyc ${PYSITELIB}/pypika/enums.pyo ${PYSITELIB}/pypika/functions.py ${PYSITELIB}/pypika/functions.pyc ${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 ${PYSITELIB}/pypika/terms.py ${PYSITELIB}/pypika/terms.pyc ${PYSITELIB}/pypika/terms.pyo ${PYSITELIB}/pypika/utils.py ${PYSITELIB}/pypika/utils.pyc ${PYSITELIB}/pypika/utils.pyo @ 1.3 log @Fix PLIST after py-setuptools update; bump depends and revision @ text @d1 1 a1 1 @@comment $NetBSD: PLIST,v 1.2 2023/11/23 08:03:59 adam Exp $ d46 1 @ 1.2 log @py-pypika: add CONFLICTS, switch to wheel.mk, bump revision @ text @d1 1 a1 2 @@comment $NetBSD: PLIST,v 1.1 2020/05/23 20:00:45 adam Exp $ ${PYSITELIB}/${WHEEL_INFODIR}/LICENSE.txt d5 1 @ 1.1 log @py-pypika: added version 0.37.6 PyPika is a Python API for building SQL queries. The motivation behind PyPika is to provide a simple interface for building SQL queries without limiting the flexibility of handwritten SQL. Designed with data analysis in mind, PyPika leverages the builder design pattern to construct queries to avoid messy string formatting and concatenation. It is also easily extended to take full advantage of specific features of SQL database vendors. @ text @d1 6 a6 5 @@comment $NetBSD$ ${PYSITELIB}/${EGG_INFODIR}/PKG-INFO ${PYSITELIB}/${EGG_INFODIR}/SOURCES.txt ${PYSITELIB}/${EGG_INFODIR}/dependency_links.txt ${PYSITELIB}/${EGG_INFODIR}/top_level.txt @