CVS log for pkgsrc/databases/py-python-sql/distinfo
Up to [cvs.NetBSD.org] / pkgsrc / databases / py-python-sql
Request diff between arbitrary revisions
Keyword substitution: kv
Default branch: MAIN
Revision 1.18: download - view: text, markup, annotated - select for diffs
Fri Nov 28 11:46:13 2025 UTC (11 months, 2 weeks ago) by adam
Branches: MAIN
CVS tags: pkgsrc-2026Q3-base,
pkgsrc-2026Q3,
pkgsrc-2026Q2-base,
pkgsrc-2026Q2,
pkgsrc-2026Q1-base,
pkgsrc-2026Q1,
pkgsrc-2025Q4-base,
pkgsrc-2025Q4,
HEAD
Diff to: previous 1.17: preferred, colored; selected 1.16: preferred, colored
Changes since revision 1.17: +4 -4
lines
py-python-sql: updated to 1.7.0
Version 1.7.0 - 2025-11-24
* Add support for Python 3.14
* Do not use parameters for COUNT(*)
Revision 1.17: download - view: text, markup, annotated - select for diffs
Fri Jul 25 11:09:49 2025 UTC (15 months, 3 weeks ago) by adam
Branches: MAIN
CVS tags: pkgsrc-2025Q3-base,
pkgsrc-2025Q3
Diff to: previous 1.16: preferred, colored
Changes since revision 1.16: +4 -4
lines
py-python-sql: updated to 1.6.0
Version 1.6.0 - 2025-05-02
* Fix position of order_by parameters in Select query
* Add support for weak reference on SQL objects
* Add support for Python 3.13
Revision 1.15: download - view: text, markup, annotated - select for diffs
Wed May 29 11:39:37 2024 UTC (2 years, 5 months ago) by adam
Branches: MAIN
CVS tags: pkgsrc-2024Q3-base,
pkgsrc-2024Q3,
pkgsrc-2024Q2-base,
pkgsrc-2024Q2
Diff to: previous 1.14: preferred, colored; selected 1.16: preferred, colored
Changes since revision 1.14: +4 -4
lines
py-python-sql: updated to 1.5.1
Version 1.5.1 - 2024-05-28
* Use parameter for start and end of WINDOW FRAME
* Use parameter for limit and offset
Revision 1.14: download - view: text, markup, annotated - select for diffs
Wed May 15 08:08:35 2024 UTC (2 years, 6 months ago) by adam
Branches: MAIN
Diff to: previous 1.13: preferred, colored; selected 1.16: preferred, colored
Changes since revision 1.13: +4 -4
lines
py-python-sql: updated to 1.5.0
Version 1.5.0 - 2024-05-13
* Skip alias on INSERT without ON CONFLICT or RETURNING
* Add MERGE
* Support UPSERT
* Remove default escape char on LIKE and ILIKE
* Add GROUPING SETS, CUBE, and ROLLUP
Revision 1.13: download - view: text, markup, annotated - select for diffs
Fri Jan 12 18:43:08 2024 UTC (2 years, 10 months ago) by adam
Branches: MAIN
CVS tags: pkgsrc-2024Q1-base,
pkgsrc-2024Q1
Diff to: previous 1.12: preferred, colored; selected 1.16: preferred, colored
Changes since revision 1.12: +4 -4
lines
py-python-sql: updated to 1.4.3
Version 1.4.3 - 2023-12-30
* Render common table expression in combining query
* Add support for Python 3.12
Revision 1.12: download - view: text, markup, annotated - select for diffs
Mon Aug 28 08:52:41 2023 UTC (3 years, 2 months ago) by adam
Branches: MAIN
CVS tags: pkgsrc-2023Q4-base,
pkgsrc-2023Q4,
pkgsrc-2023Q3-base,
pkgsrc-2023Q3
Diff to: previous 1.11: preferred, colored; selected 1.16: preferred, colored
Changes since revision 1.11: +4 -4
lines
py-python-sql: updated to 1.4.2
Version 1.4.2 - 2023-06-25
* Restore usage of alias in returning expression
Version 1.4.1 - 2023-06-16
* Do not use alias in returning expression
Revision 1.11: download - view: text, markup, annotated - select for diffs
Sun Nov 27 09:26:40 2022 UTC (3 years, 11 months ago) by adam
Branches: MAIN
CVS tags: pkgsrc-2023Q2-base,
pkgsrc-2023Q2,
pkgsrc-2023Q1-base,
pkgsrc-2023Q1,
pkgsrc-2022Q4-base,
pkgsrc-2022Q4
Diff to: previous 1.10: preferred, colored; selected 1.16: preferred, colored
Changes since revision 1.10: +4 -4
lines
py-python-sql: updated to 1.4.0
Version 1.4.0 - 2022-05-02
* Use unittest discover
* Use only column name for INSERT and UPDATE
* Add escape to Like operators
* Add default literal '*' expression to Count
* Add support for Python 3.10
Revision 1.10: download - view: text, markup, annotated - select for diffs
Sun Dec 5 12:19:02 2021 UTC (4 years, 11 months ago) by mef
Branches: MAIN
CVS tags: pkgsrc-2022Q3-base,
pkgsrc-2022Q3,
pkgsrc-2022Q2-base,
pkgsrc-2022Q2,
pkgsrc-2022Q1-base,
pkgsrc-2022Q1,
pkgsrc-2021Q4-base,
pkgsrc-2021Q4
Diff to: previous 1.9: preferred, colored; selected 1.16: preferred, colored
Changes since revision 1.9: +4 -4
lines
(databases/py-python-sql) Updated 0.9 to 1.3.0 (build fix)
Version 1.3.0 - 2021-09-14
* Add GROUPS frame to Window
* Add exclude to Window
* Add method for each type of join
* Remove support for Python older than 3.5
* Support Select queries in conditionals and functions
Version 1.2.2 - 2021-05-16
* Escape table and column names containing double quote
* Use alias on the main table used in UPDATE and INSERT
* Add support for Python 3.9
Version 1.2.1 - 2020-10-08
* Fix AttributeError in Select.params with windows
Version 1.2.0 - 2020-10-05
* Add explicit Windows to Select
* Fix missing Windows definitions in nested expressions
Version 1.1.0 - 2020-01-25
* Add ORDER BY clause to aggregate functions
* Add support for Python 3.8
* Add distinct on Select
Version 1.0.0 - 2018-09-30
* Add Flavor filter_ to fallback to case expression
* Allow to use expression in AtTimeZone
* Fix Select query in returning
* Add comparison predicates
* Add COLLATE
kVS: ----------------------------------------------------------------------
Revision 1.9: download - view: text, markup, annotated - select for diffs
Tue Oct 26 10:09:52 2021 UTC (5 years ago) by nia
Branches: MAIN
Diff to: previous 1.8: preferred, colored; selected 1.16: preferred, colored
Changes since revision 1.8: +2 -2
lines
databases: Replace RMD160 checksums with BLAKE2s checksums
All checksums have been double-checked against existing RMD160 and
SHA512 hashes
The following distfiles could not be fetched (some may be only fetched
conditionally):
./databases/cstore/distinfo D6.data.ros.gz
./databases/cstore/distinfo cstore0.2.tar.gz
./databases/cstore/distinfo data4.tar.gz
Revision 1.8: download - view: text, markup, annotated - select for diffs
Thu Oct 7 13:35:39 2021 UTC (5 years, 1 month ago) by nia
Branches: MAIN
Diff to: previous 1.7: preferred, colored; selected 1.16: preferred, colored
Changes since revision 1.7: +1 -2
lines
databases: Remove SHA1 distfile hashes
Revision 1.7: download - view: text, markup, annotated - select for diffs
Mon Sep 18 17:43:55 2017 UTC (9 years, 1 month ago) by adam
Branches: MAIN
CVS tags: pkgsrc-2021Q3-base,
pkgsrc-2021Q3,
pkgsrc-2021Q2-base,
pkgsrc-2021Q2,
pkgsrc-2021Q1-base,
pkgsrc-2021Q1,
pkgsrc-2020Q4-base,
pkgsrc-2020Q4,
pkgsrc-2020Q3-base,
pkgsrc-2020Q3,
pkgsrc-2020Q2-base,
pkgsrc-2020Q2,
pkgsrc-2020Q1-base,
pkgsrc-2020Q1,
pkgsrc-2019Q4-base,
pkgsrc-2019Q4,
pkgsrc-2019Q3-base,
pkgsrc-2019Q3,
pkgsrc-2019Q2-base,
pkgsrc-2019Q2,
pkgsrc-2019Q1-base,
pkgsrc-2019Q1,
pkgsrc-2018Q4-base,
pkgsrc-2018Q4,
pkgsrc-2018Q3-base,
pkgsrc-2018Q3,
pkgsrc-2018Q2-base,
pkgsrc-2018Q2,
pkgsrc-2018Q1-base,
pkgsrc-2018Q1,
pkgsrc-2017Q4-base,
pkgsrc-2017Q4,
pkgsrc-2017Q3-base,
pkgsrc-2017Q3
Diff to: previous 1.6: preferred, colored; selected 1.16: preferred, colored
Changes since revision 1.6: +5 -5
lines
py-python-sql: update to 0.9
Version 0.9:
* Add distinct_on on Select
* Allow to use Select as Column of Select query
* Support Select without from clause
Version 0.8:
* Add DISTINCT qualifier to aggregate expressions
* Allow to order on select queries
* Add NULL ordering
* Use UPPER to simulate missing ILIKE
* Add CURRENT_DATE function
* Fix DateTrunc function name
* Add no_boolean Flavor
* Add converter format2numeric
* Add rownum limit style
* Add no_as Flavor
Revision 1.6: download - view: text, markup, annotated - select for diffs
Tue Nov 3 01:56:28 2015 UTC (11 years ago) by agc
Branches: MAIN
CVS tags: pkgsrc-2017Q2-base,
pkgsrc-2017Q2,
pkgsrc-2017Q1-base,
pkgsrc-2017Q1,
pkgsrc-2016Q4-base,
pkgsrc-2016Q4,
pkgsrc-2016Q3-base,
pkgsrc-2016Q3,
pkgsrc-2016Q2-base,
pkgsrc-2016Q2,
pkgsrc-2016Q1-base,
pkgsrc-2016Q1,
pkgsrc-2015Q4-base,
pkgsrc-2015Q4
Diff to: previous 1.5: preferred, colored; selected 1.16: preferred, colored
Changes since revision 1.5: +2 -1
lines
Add SHA512 digests for distfiles for databases category
Problems found with existing distfiles:
distfiles/D6.data.ros.gz
distfiles/cstore0.2.tar.gz
distfiles/data4.tar.gz
distfiles/sphinx-2.2.7-release.tar.gz
No changes made to the cstore or mariadb55-client distinfo files.
Otherwise, existing SHA1 digests verified and found to be the same on
the machine holding the existing distfiles (morden). All existing
SHA1 digests retained for now as an audit trail.
Revision 1.5: download - view: text, markup, annotated - select for diffs
Fri Jun 26 16:13:51 2015 UTC (11 years, 4 months ago) by rodent
Branches: MAIN
CVS tags: pkgsrc-2015Q3-base,
pkgsrc-2015Q3,
pkgsrc-2015Q2-base,
pkgsrc-2015Q2
Diff to: previous 1.4: preferred, colored; selected 1.16: preferred, colored
Changes since revision 1.4: +4 -4
lines
Version 0.7 - 2015-05-19
* Fix WINDOW and HAVING params order in Select
* Add window functions
* Add filter and within group to aggregate
* Add limitstyle with 'offset' and 'limit'
* Add Lateral
Revision 1.4: download - view: text, markup, annotated - select for diffs
Wed Apr 1 02:19:17 2015 UTC (11 years, 7 months ago) by rodent
Branches: MAIN
CVS tags: pkgsrc-2015Q1-base,
pkgsrc-2015Q1
Diff to: previous 1.3: preferred, colored; selected 1.16: preferred, colored
Changes since revision 1.3: +4 -4
lines
Version 0.6 - 2015-02-05
* Fix Delete query under multithread
* Add missing quote for with query name
Version 0.5 - 2015-01-29
* Add schema
* Add Common Table Expression
* Escape Mod operator '%' with format paramstyle
* Deprecate Interesect in favor of Intersect
* Add Values
Revision 1.3: download - view: text, markup, annotated - select for diffs
Thu Aug 7 01:15:25 2014 UTC (12 years, 3 months ago) by rodent
Branches: MAIN
CVS tags: pkgsrc-2014Q4-base,
pkgsrc-2014Q4,
pkgsrc-2014Q3-base,
pkgsrc-2014Q3
Diff to: previous 1.2: preferred, colored; selected 1.16: preferred, colored
Changes since revision 1.2: +4 -4
lines
Version 0.4 - 2014-08-03
* Fix Mapping in Trim function
* Add __truediv__ alias of __div__ for Python3
* Fix For tables setter when tables is not a list
* Allow to add Table to existing From list
* Fix Select with for_ clause
* Add Null alias for None
* Add missing format of operand in Unary operator
Revision 1.2: download - view: text, markup, annotated - select for diffs
Sat Feb 1 14:10:47 2014 UTC (12 years, 9 months ago) by rodent
Branches: MAIN
CVS tags: pkgsrc-2014Q2-base,
pkgsrc-2014Q2,
pkgsrc-2014Q1-base,
pkgsrc-2014Q1
Diff to: previous 1.1: preferred, colored; selected 1.16: preferred, colored
Changes since revision 1.1: +4 -4
lines
Updated to latest release, 0.3. Remove setting WRKSRC. Fix HOMEPAGE.
Use pypi for MASTER_SITES. From CHANGELOG:
Version 0.3 - 2014-01-31
* Add returning to Update
* Add missing params for returning
* Add columns definitions to Function
* Fix AtTimeZone mapping
Revision 1.1: download - view: text, markup, annotated - select for diffs
Thu Jan 30 04:54:57 2014 UTC (12 years, 9 months ago) by rodent
Branches: MAIN
Diff to: selected 1.16: preferred, colored
Import py27-python-sql-0.2 as databases/py-python-sql.
python-sql is a library to write SQL queries in a pythonic way.
CVSweb <webmaster@jp.NetBSD.org>