summaryrefslogtreecommitdiff
path: root/databases/py-python-sql
AgeCommit message (Collapse)AuthorFilesLines
2022-11-27py-python-sql: updated to 1.4.0adam2-7/+6
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*: bump PKGREVISION for egg.mk userswiz1-1/+2
They now have a tool dependency on py-setuptools instead of a DEPENDS
2021-12-05(databases/py-python-sql) Updated 0.9 to 1.3.0 (build fix)mef3-7/+10
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-26databases: Replace RMD160 checksums with BLAKE2s checksumsnia1-2/+2
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-07databases: Remove SHA1 distfile hashesnia1-2/+1
2020-01-18all: migrate several HOMEPAGEs to httpsrillig1-2/+2
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.
2017-09-18py-python-sql: update to 0.9adam2-7/+7
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
2017-09-16Reset maintainerwiz1-2/+2
2017-09-04Update some URLs.wiz1-2/+2
2016-06-08Switch to MASTER_SITES_PYPI.wiz1-2/+2
2015-11-03Add SHA512 digests for distfiles for databases categoryagc1-1/+2
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.
2015-06-26Version 0.7 - 2015-05-19rodent3-7/+13
* 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
2015-04-01Version 0.6 - 2015-02-05rodent3-7/+19
* 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
2014-12-31Improve EGG_NAME default to work for packages with '-' in their name.wiz1-2/+1
Remove now unnecessary overrides in various packages.
2014-08-07Version 0.4 - 2014-08-03rodent2-6/+6
* 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
2014-02-01Remove FETCH_USING, because that's handled with magick now.rodent1-2/+1
2014-02-01Updated to latest release, 0.3. Remove setting WRKSRC. Fix HOMEPAGE.rodent2-12/+11
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
2014-01-30Import py27-python-sql-0.2 as databases/py-python-sql.rodent4-0/+99
python-sql is a library to write SQL queries in a pythonic way.
generated by cgit v1.2.3 (git 2.39.1) at 2025-07-25 16:51:44 +0000