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

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

Branch: CURRENT, Version: 1.5.2, Package name: py312-python-sql-1.5.2, Maintainer: pkgsrc-users

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


Required to run:
[lang/python310]

Master sites:

Filesize: 38.253 KB

Version history: (Expand)

CVS history: (Expand)


   2024-11-11 08:29:31 by Thomas Klausner | Files touched by this commit (862) 
Log message:
py-*: remove unused tool dependency

py-setuptools includes the py-wheel functionality nowadays
   2024-10-03 10:40:16 by Adam Ciarcinski | Files touched by this commit (3) | Package updated
Log message:
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
   2024-05-29 13:39:37 by Adam Ciarcinski | Files touched by this commit (2) | Package updated
Log message:
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
   2024-05-15 10:08:35 by Adam Ciarcinski | Files touched by this commit (3) | Package updated
Log message:
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
   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