![[BACK]](/icons/back.gif){kind=icon}
Up to [cvs.NetBSD.org] / pkgsrc / databases / py-python-sql
Request diff between arbitrary revisions
Default branch: MAIN
Revision 1.12 / (download) - annotate - [select for diffs], Mon Aug 28 08:52:41 2023 UTC (3 months ago) by adam
Branch: MAIN
CVS Tags: pkgsrc-2023Q3-base,
pkgsrc-2023Q3,
HEAD
Changes since 1.11: +4 -4
lines
Diff to previous 1.11 (colored)
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) - annotate - [select for diffs], Sun Nov 27 09:26:40 2022 UTC (12 months ago) by adam
Branch: MAIN
CVS Tags: pkgsrc-2023Q2-base,
pkgsrc-2023Q2,
pkgsrc-2023Q1-base,
pkgsrc-2023Q1,
pkgsrc-2022Q4-base,
pkgsrc-2022Q4
Changes since 1.10: +4 -4
lines
Diff to previous 1.10 (colored)
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) - annotate - [select for diffs], Sun Dec 5 12:19:02 2021 UTC (23 months, 3 weeks ago) by mef
Branch: MAIN
CVS Tags: pkgsrc-2022Q3-base,
pkgsrc-2022Q3,
pkgsrc-2022Q2-base,
pkgsrc-2022Q2,
pkgsrc-2022Q1-base,
pkgsrc-2022Q1,
pkgsrc-2021Q4-base,
pkgsrc-2021Q4
Changes since 1.9: +4 -4
lines
Diff to previous 1.9 (colored)
(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) - annotate - [select for diffs], Tue Oct 26 10:09:52 2021 UTC (2 years, 1 month ago) by nia
Branch: MAIN
Changes since 1.8: +2 -2
lines
Diff to previous 1.8 (colored)
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) - annotate - [select for diffs], Thu Oct 7 13:35:39 2021 UTC (2 years, 1 month ago) by nia
Branch: MAIN
Changes since 1.7: +1 -2
lines
Diff to previous 1.7 (colored)
databases: Remove SHA1 distfile hashes
Revision 1.7 / (download) - annotate - [select for diffs], Mon Sep 18 17:43:55 2017 UTC (6 years, 2 months ago) by adam
Branch: 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
Changes since 1.6: +5 -5
lines
Diff to previous 1.6 (colored)
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) - annotate - [select for diffs], Tue Nov 3 01:56:28 2015 UTC (8 years, 1 month ago) by agc
Branch: 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
Changes since 1.5: +2 -1
lines
Diff to previous 1.5 (colored)
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) - annotate - [select for diffs], Fri Jun 26 16:13:51 2015 UTC (8 years, 5 months ago) by rodent
Branch: MAIN
CVS Tags: pkgsrc-2015Q3-base,
pkgsrc-2015Q3,
pkgsrc-2015Q2-base,
pkgsrc-2015Q2
Changes since 1.4: +4 -4
lines
Diff to previous 1.4 (colored)
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) - annotate - [select for diffs], Wed Apr 1 02:19:17 2015 UTC (8 years, 8 months ago) by rodent
Branch: MAIN
CVS Tags: pkgsrc-2015Q1-base,
pkgsrc-2015Q1
Changes since 1.3: +4 -4
lines
Diff to previous 1.3 (colored)
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) - annotate - [select for diffs], Thu Aug 7 01:15:25 2014 UTC (9 years, 3 months ago) by rodent
Branch: MAIN
CVS Tags: pkgsrc-2014Q4-base,
pkgsrc-2014Q4,
pkgsrc-2014Q3-base,
pkgsrc-2014Q3
Changes since 1.2: +4 -4
lines
Diff to previous 1.2 (colored)
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) - annotate - [select for diffs], Sat Feb 1 14:10:47 2014 UTC (9 years, 10 months ago) by rodent
Branch: MAIN
CVS Tags: pkgsrc-2014Q2-base,
pkgsrc-2014Q2,
pkgsrc-2014Q1-base,
pkgsrc-2014Q1
Changes since 1.1: +4 -4
lines
Diff to previous 1.1 (colored)
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) - annotate - [select for diffs], Thu Jan 30 04:54:57 2014 UTC (9 years, 10 months ago) by rodent
Branch: MAIN
Import py27-python-sql-0.2 as databases/py-python-sql. python-sql is a library to write SQL queries in a pythonic way.