./databases/py-python-sql, Python library to write SQL queries

[ CVSweb ] [ Homepage ] [ RSS ] [ Required by ] [ Add to tracker ]

Branch: CURRENT, Version: 1.4.3, Package name: py311-python-sql-1.4.3, Maintainer: pkgsrc-users

python-sql is a library to write SQL queries in a pythonic way.


Required to run:
[lang/python310]

Master sites:

Filesize: 32.621 KB

Version history: (Expand)

CVS history: (Expand)


   2024-01-12 19:43:08 by Adam Ciarcinski | Files touched by this commit (3) | Package updated
Log message:
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
   2023-08-28 10:52:41 by Adam Ciarcinski | Files touched by this commit (2) | Package updated
Log message:
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
   2022-11-27 10:26:40 by Adam Ciarcinski | Files touched by this commit (2) | Package updated
Log message:
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
   2022-01-04 21:55:40 by Thomas Klausner | Files touched by this commit (1595) 
Log message:
*: bump PKGREVISION for egg.mk users

They now have a tool dependency on py-setuptools instead of a DEPENDS
   2021-12-05 13:19:02 by Makoto Fujiwara | Files touched by this commit (3) 
Log message:
(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: ----------------------------------------------------------------------
   2021-10-26 12:10:08 by Nia Alarie | Files touched by this commit (417) 
Log message:
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
   2021-10-07 15:35:53 by Nia Alarie | Files touched by this commit (417) 
Log message:
databases: Remove SHA1 distfile hashes
   2020-01-19 00:36:14 by Roland Illig | Files touched by this commit (3046) 
Log message:
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.