<feed xmlns='http://www.w3.org/2005/Atom'>
<title>pkgsrc/databases/py-python-sql/distinfo, branch trunk</title>
<subtitle>[no description]</subtitle>
<id>https://git.osdyson.ru/mirror/pkgsrc/atom?h=trunk</id>
<link rel='self' href='https://git.osdyson.ru/mirror/pkgsrc/atom?h=trunk'/>
<link rel='alternate' type='text/html' href='https://git.osdyson.ru/mirror/pkgsrc/'/>
<updated>2022-11-27T09:26:40Z</updated>
<entry>
<title>py-python-sql: updated to 1.4.0</title>
<updated>2022-11-27T09:26:40Z</updated>
<author>
<name>adam</name>
<email>adam@pkgsrc.org</email>
</author>
<published>2022-11-27T09:26:40Z</published>
<link rel='alternate' type='text/html' href='https://git.osdyson.ru/mirror/pkgsrc/commit/?id=09c434f78dab5f302db40f23dbe05d8ff98fd977'/>
<id>urn:sha1:09c434f78dab5f302db40f23dbe05d8ff98fd977</id>
<content type='text'>
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</content>
</entry>
<entry>
<title>(databases/py-python-sql) Updated 0.9 to 1.3.0 (build fix)</title>
<updated>2021-12-05T12:19:02Z</updated>
<author>
<name>mef</name>
<email>mef@pkgsrc.org</email>
</author>
<published>2021-12-05T12:19:02Z</published>
<link rel='alternate' type='text/html' href='https://git.osdyson.ru/mirror/pkgsrc/commit/?id=a48c8c337bc9f7aad2dd7d0425b43d23742ab5b0'/>
<id>urn:sha1:a48c8c337bc9f7aad2dd7d0425b43d23742ab5b0</id>
<content type='text'>
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: ----------------------------------------------------------------------</content>
</entry>
<entry>
<title>databases: Replace RMD160 checksums with BLAKE2s checksums</title>
<updated>2021-10-26T10:09:13Z</updated>
<author>
<name>nia</name>
<email>nia@pkgsrc.org</email>
</author>
<published>2021-10-26T10:09:13Z</published>
<link rel='alternate' type='text/html' href='https://git.osdyson.ru/mirror/pkgsrc/commit/?id=110d5bf2cb42630a7f459b1e8f899f8e59991e1b'/>
<id>urn:sha1:110d5bf2cb42630a7f459b1e8f899f8e59991e1b</id>
<content type='text'>
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</content>
</entry>
<entry>
<title>databases: Remove SHA1 distfile hashes</title>
<updated>2021-10-07T13:35:05Z</updated>
<author>
<name>nia</name>
<email>nia@pkgsrc.org</email>
</author>
<published>2021-10-07T13:35:05Z</published>
<link rel='alternate' type='text/html' href='https://git.osdyson.ru/mirror/pkgsrc/commit/?id=461331b2af81f67812062f24d93a6ed5e8abfee9'/>
<id>urn:sha1:461331b2af81f67812062f24d93a6ed5e8abfee9</id>
<content type='text'>
</content>
</entry>
<entry>
<title>py-python-sql: update to 0.9</title>
<updated>2017-09-18T17:43:55Z</updated>
<author>
<name>adam</name>
<email>adam@pkgsrc.org</email>
</author>
<published>2017-09-18T17:43:55Z</published>
<link rel='alternate' type='text/html' href='https://git.osdyson.ru/mirror/pkgsrc/commit/?id=3409de0a083130b3121591042e1d93ab46ca54b7'/>
<id>urn:sha1:3409de0a083130b3121591042e1d93ab46ca54b7</id>
<content type='text'>
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</content>
</entry>
<entry>
<title>Add SHA512 digests for distfiles for databases category</title>
<updated>2015-11-03T01:56:09Z</updated>
<author>
<name>agc</name>
<email>agc@pkgsrc.org</email>
</author>
<published>2015-11-03T01:56:09Z</published>
<link rel='alternate' type='text/html' href='https://git.osdyson.ru/mirror/pkgsrc/commit/?id=aeaba3aae764a51ecafeaf2f47fc7f21645cee71'/>
<id>urn:sha1:aeaba3aae764a51ecafeaf2f47fc7f21645cee71</id>
<content type='text'>
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.</content>
</entry>
<entry>
<title>Version 0.7 - 2015-05-19</title>
<updated>2015-06-26T16:13:51Z</updated>
<author>
<name>rodent</name>
<email>rodent@pkgsrc.org</email>
</author>
<published>2015-06-26T16:13:51Z</published>
<link rel='alternate' type='text/html' href='https://git.osdyson.ru/mirror/pkgsrc/commit/?id=003320a80fdd837c0c71e530843aad5f2a643d03'/>
<id>urn:sha1:003320a80fdd837c0c71e530843aad5f2a643d03</id>
<content type='text'>
* 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</content>
</entry>
<entry>
<title>Version 0.6 - 2015-02-05</title>
<updated>2015-04-01T02:19:17Z</updated>
<author>
<name>rodent</name>
<email>rodent@pkgsrc.org</email>
</author>
<published>2015-04-01T02:19:17Z</published>
<link rel='alternate' type='text/html' href='https://git.osdyson.ru/mirror/pkgsrc/commit/?id=b31d9272eaf1590b1d2c8999e870db320bc536e1'/>
<id>urn:sha1:b31d9272eaf1590b1d2c8999e870db320bc536e1</id>
<content type='text'>
* 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</content>
</entry>
<entry>
<title>Version 0.4 - 2014-08-03</title>
<updated>2014-08-07T01:15:25Z</updated>
<author>
<name>rodent</name>
<email>rodent@pkgsrc.org</email>
</author>
<published>2014-08-07T01:15:25Z</published>
<link rel='alternate' type='text/html' href='https://git.osdyson.ru/mirror/pkgsrc/commit/?id=ea99d43cc8eb84c7ee62fd49c2bcb8a6cf58c559'/>
<id>urn:sha1:ea99d43cc8eb84c7ee62fd49c2bcb8a6cf58c559</id>
<content type='text'>
* 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</content>
</entry>
<entry>
<title>Updated to latest release, 0.3. Remove setting WRKSRC. Fix HOMEPAGE.</title>
<updated>2014-02-01T14:10:47Z</updated>
<author>
<name>rodent</name>
<email>rodent@pkgsrc.org</email>
</author>
<published>2014-02-01T14:10:47Z</published>
<link rel='alternate' type='text/html' href='https://git.osdyson.ru/mirror/pkgsrc/commit/?id=a310a223642c6974c17b0b157f77c42176cb5b7b'/>
<id>urn:sha1:a310a223642c6974c17b0b157f77c42176cb5b7b</id>
<content type='text'>
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</content>
</entry>
</feed>
