The NetBSD Project

CVS log for pkgsrc/databases/py-python-sql/Makefile

[BACK] Up to [cvs.NetBSD.org] / pkgsrc / databases / py-python-sql

Request diff between arbitrary revisions


Keyword substitution: kv
Default branch: MAIN


Revision 1.20: download - view: text, markup, annotated - select for diffs
Thu Oct 3 08:40:16 2024 UTC (4 weeks, 3 days ago) by adam
Branches: MAIN
CVS tags: HEAD
Diff to: previous 1.19: preferred, colored
Changes since revision 1.19: +2 -4 lines
py-python-sql: updated to 1.5.2

Version 1.5.2 - 2024-09-30
* Use parameter for unary operator
* Support default values when inserting not matched merge
* Replace assert by ValueError

Revision 1.19: download - view: text, markup, annotated - select for diffs
Wed May 29 11:39:37 2024 UTC (5 months ago) by adam
Branches: MAIN
CVS tags: pkgsrc-2024Q3-base, pkgsrc-2024Q3, pkgsrc-2024Q2-base, pkgsrc-2024Q2
Diff to: previous 1.18: preferred, colored
Changes since revision 1.18: +2 -2 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.18: download - view: text, markup, annotated - select for diffs
Wed May 15 08:08:35 2024 UTC (5 months, 2 weeks ago) by adam
Branches: MAIN
Diff to: previous 1.17: preferred, colored
Changes since revision 1.17: +3 -3 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.17: download - view: text, markup, annotated - select for diffs
Fri Jan 12 18:43:08 2024 UTC (9 months, 3 weeks ago) by adam
Branches: MAIN
CVS tags: pkgsrc-2024Q1-base, pkgsrc-2024Q1
Diff to: previous 1.16: preferred, colored
Changes since revision 1.16: +8 -3 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.16: download - view: text, markup, annotated - select for diffs
Mon Aug 28 08:52:41 2023 UTC (14 months, 1 week ago) by adam
Branches: MAIN
CVS tags: pkgsrc-2023Q4-base, pkgsrc-2023Q4, pkgsrc-2023Q3-base, pkgsrc-2023Q3
Diff to: previous 1.15: preferred, colored
Changes since revision 1.15: +2 -2 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.15: download - view: text, markup, annotated - select for diffs
Sun Nov 27 09:26:40 2022 UTC (23 months, 1 week 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.14: preferred, colored
Changes since revision 1.14: +2 -3 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.14: download - view: text, markup, annotated - select for diffs
Tue Jan 4 20:52:44 2022 UTC (2 years, 9 months ago) by wiz
Branches: MAIN
CVS tags: pkgsrc-2022Q3-base, pkgsrc-2022Q3, pkgsrc-2022Q2-base, pkgsrc-2022Q2, pkgsrc-2022Q1-base, pkgsrc-2022Q1
Diff to: previous 1.13: preferred, colored
Changes since revision 1.13: +2 -1 lines
*: bump PKGREVISION for egg.mk users

They now have a tool dependency on py-setuptools instead of a DEPENDS

Revision 1.13: download - view: text, markup, annotated - select for diffs
Sun Dec 5 12:19:02 2021 UTC (2 years, 10 months ago) by mef
Branches: MAIN
CVS tags: pkgsrc-2021Q4-base, pkgsrc-2021Q4
Diff to: previous 1.12: preferred, colored
Changes since revision 1.12: +2 -2 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.12: download - view: text, markup, annotated - select for diffs
Sat Jan 18 23:30:19 2020 UTC (4 years, 9 months ago) by rillig
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
Diff to: previous 1.11: preferred, colored
Changes since revision 1.11: +2 -2 lines
all: migrate several HOMEPAGEs to https

pkglint --only "https instead of http" -r -F

With manual adjustments afterwards since pkglint 19.4.4 fixed a few
indentations in unrelated lines.

This mainly affects projects hosted at SourceForce, as well as
freedesktop.org, CTAN and GNU.

Revision 1.11: download - view: text, markup, annotated - select for diffs
Mon Sep 18 17:43:55 2017 UTC (7 years, 1 month ago) by adam
Branches: MAIN
CVS tags: 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.10: preferred, colored
Changes since revision 1.10: +2 -2 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.10: download - view: text, markup, annotated - select for diffs
Sat Sep 16 19:26:44 2017 UTC (7 years, 1 month ago) by wiz
Branches: MAIN
Diff to: previous 1.9: preferred, colored
Changes since revision 1.9: +2 -2 lines
Reset maintainer

Revision 1.9: download - view: text, markup, annotated - select for diffs
Mon Sep 4 18:55:07 2017 UTC (7 years, 2 months ago) by wiz
Branches: MAIN
Diff to: previous 1.8: preferred, colored
Changes since revision 1.8: +2 -2 lines
Update some URLs.

Revision 1.8: download - view: text, markup, annotated - select for diffs
Wed Jun 8 17:43:22 2016 UTC (8 years, 4 months ago) by wiz
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
Diff to: previous 1.7: preferred, colored
Changes since revision 1.7: +2 -2 lines
Switch to MASTER_SITES_PYPI.

Revision 1.7: download - view: text, markup, annotated - select for diffs
Fri Jun 26 16:13:51 2015 UTC (9 years, 4 months ago) by rodent
Branches: MAIN
CVS tags: pkgsrc-2016Q1-base, pkgsrc-2016Q1, pkgsrc-2015Q4-base, pkgsrc-2015Q4, pkgsrc-2015Q3-base, pkgsrc-2015Q3, pkgsrc-2015Q2-base, pkgsrc-2015Q2
Diff to: previous 1.6: preferred, colored
Changes since revision 1.6: +2 -2 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.6: download - view: text, markup, annotated - select for diffs
Wed Apr 1 02:19:17 2015 UTC (9 years, 7 months ago) by rodent
Branches: MAIN
CVS tags: pkgsrc-2015Q1-base, pkgsrc-2015Q1
Diff to: previous 1.5: preferred, colored
Changes since revision 1.5: +2 -2 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.5: download - view: text, markup, annotated - select for diffs
Wed Dec 31 13:57:26 2014 UTC (9 years, 10 months ago) by wiz
Branches: MAIN
Diff to: previous 1.4: preferred, colored
Changes since revision 1.4: +1 -2 lines
Improve EGG_NAME default to work for packages with '-' in their name.
Remove now unnecessary overrides in various packages.

Revision 1.4: download - view: text, markup, annotated - select for diffs
Thu Aug 7 01:15:25 2014 UTC (10 years, 3 months ago) by rodent
Branches: MAIN
CVS tags: pkgsrc-2014Q4-base, pkgsrc-2014Q4, pkgsrc-2014Q3-base, pkgsrc-2014Q3
Diff to: previous 1.3: preferred, colored
Changes since revision 1.3: +2 -2 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.3: download - view: text, markup, annotated - select for diffs
Sat Feb 1 17:19:07 2014 UTC (10 years, 9 months ago) by rodent
Branches: MAIN
CVS tags: pkgsrc-2014Q2-base, pkgsrc-2014Q2, pkgsrc-2014Q1-base, pkgsrc-2014Q1
Diff to: previous 1.2: preferred, colored
Changes since revision 1.2: +1 -2 lines
Remove FETCH_USING, because that's handled with magick now.

Revision 1.2: download - view: text, markup, annotated - select for diffs
Sat Feb 1 14:10:47 2014 UTC (10 years, 9 months ago) by rodent
Branches: MAIN
Diff to: previous 1.1: preferred, colored
Changes since revision 1.1: +7 -8 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 (10 years, 9 months ago) by rodent
Branches: 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.

Diff request

This form allows you to request diffs between any two revisions of a file. You may select a symbolic revision name using the selection box or you may type in a numeric name using the type-in text box.

Log view options

CVSweb <webmaster@jp.NetBSD.org>