<feed xmlns='http://www.w3.org/2005/Atom'>
<title>delta/python-packages/sqlparse.git/tests/test_grouping.py, branch 0.4.4</title>
<subtitle>github.com: andialbrecht/sqlparse.git
</subtitle>
<link rel='alternate' type='text/html' href='http://trove.baserock.org/cgit/delta/python-packages/sqlparse.git/'/>
<entry>
<title>Revert "add regex pattern to identify IN as a Compasion token"</title>
<updated>2022-12-30T09:57:31+00:00</updated>
<author>
<name>Andi Albrecht</name>
<email>albrecht.andi@gmail.com</email>
</author>
<published>2022-12-30T09:57:31+00:00</published>
<link rel='alternate' type='text/html' href='http://trove.baserock.org/cgit/delta/python-packages/sqlparse.git/commit/?id=e9241945801808d1db7f76bdccbbe9a200042c37'/>
<id>e9241945801808d1db7f76bdccbbe9a200042c37</id>
<content type='text'>
This reverts commit 28c4d4026e1d9389a99d8cd627c96fa360c17fc4.

See #694. The expectation is that IN is primarily recognized as a keyword,
although it acts as a comparison operator. This also matches the definition of
IN in most SQL syntax references where it is listed as a reserved
keyword (PostgreSQL:
https://www.postgresql.org/docs/current/sql-keywords-appendix.html, MySQL:
https://dev.mysql.com/doc/refman/8.0/en/keywords.html, for example).
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
This reverts commit 28c4d4026e1d9389a99d8cd627c96fa360c17fc4.

See #694. The expectation is that IN is primarily recognized as a keyword,
although it acts as a comparison operator. This also matches the definition of
IN in most SQL syntax references where it is listed as a reserved
keyword (PostgreSQL:
https://www.postgresql.org/docs/current/sql-keywords-appendix.html, MySQL:
https://dev.mysql.com/doc/refman/8.0/en/keywords.html, for example).
</pre>
</div>
</content>
</entry>
<entry>
<title>Fixed bad parsing of create table statements that use lower case</title>
<updated>2022-08-24T19:14:38+00:00</updated>
<author>
<name>Simon Heisterkamp</name>
<email>she@delegate.dk</email>
</author>
<published>2021-09-19T09:56:46+00:00</published>
<link rel='alternate' type='text/html' href='http://trove.baserock.org/cgit/delta/python-packages/sqlparse.git/commit/?id=403de6fc648ac4e012b60b49161c3f5f36dc944a'/>
<id>403de6fc648ac4e012b60b49161c3f5f36dc944a</id>
<content type='text'>
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
</pre>
</div>
</content>
</entry>
<entry>
<title>CREATE TABLE tbl AS SELECT should return get_alias() for its column</title>
<updated>2022-08-24T19:08:17+00:00</updated>
<author>
<name>Aki Ariga</name>
<email>chezou+github@gmail.com</email>
</author>
<published>2022-05-03T07:33:01+00:00</published>
<link rel='alternate' type='text/html' href='http://trove.baserock.org/cgit/delta/python-packages/sqlparse.git/commit/?id=7de1999a0af9dbbd09f0afb3a50383ad91c22c4c'/>
<id>7de1999a0af9dbbd09f0afb3a50383ad91c22c4c</id>
<content type='text'>
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
</pre>
</div>
</content>
</entry>
<entry>
<title>Don't flush token streams iff they only contain whitespace tokens (fixes #496).</title>
<updated>2020-09-13T07:25:56+00:00</updated>
<author>
<name>Andi Albrecht</name>
<email>albrecht.andi@gmail.com</email>
</author>
<published>2020-09-13T07:25:56+00:00</published>
<link rel='alternate' type='text/html' href='http://trove.baserock.org/cgit/delta/python-packages/sqlparse.git/commit/?id=27ad2564f30f1021a96addafb7b7eb6a7504c28f'/>
<id>27ad2564f30f1021a96addafb7b7eb6a7504c28f</id>
<content type='text'>
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
</pre>
</div>
</content>
</entry>
<entry>
<title>add regex pattern to identify IN as a Compasion token</title>
<updated>2020-09-13T06:58:20+00:00</updated>
<author>
<name>hurcy</name>
<email>cinyoung.hur@gmail.com</email>
</author>
<published>2020-07-29T05:47:47+00:00</published>
<link rel='alternate' type='text/html' href='http://trove.baserock.org/cgit/delta/python-packages/sqlparse.git/commit/?id=28c4d4026e1d9389a99d8cd627c96fa360c17fc4'/>
<id>28c4d4026e1d9389a99d8cd627c96fa360c17fc4</id>
<content type='text'>
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
</pre>
</div>
</content>
</entry>
<entry>
<title>Remove support for end-of-life Pythons</title>
<updated>2020-09-01T00:27:38+00:00</updated>
<author>
<name>Jon Dufresne</name>
<email>jon.dufresne@gmail.com</email>
</author>
<published>2020-05-24T13:44:09+00:00</published>
<link rel='alternate' type='text/html' href='http://trove.baserock.org/cgit/delta/python-packages/sqlparse.git/commit/?id=3e3892f939031d58d98275ce8a237689225d299a'/>
<id>3e3892f939031d58d98275ce8a237689225d299a</id>
<content type='text'>
Python 2.7 and 3.4 are end-of-life. They are no longer receiving bug
fixes, including for security issues. Python 2.7 went EOL on 2020-01-01
and 3.4 on 2019-03-18. For additional details on support Python
versions, see:

Supported: https://devguide.python.org/#status-of-python-branches
EOL: https://devguide.python.org/devcycle/#end-of-life-branches

Removing support for EOL Pythons will reduce testing and maintenance
resources while allowing the library to move towards modern Python 3.

Using pypinfo, we can show the PyPI download statistics, showing less
than 10% of users are using Python 2.7.

| python_version | percent | download_count |
| -------------- | ------: | -------------: |
| 3.7            |  45.36% |      3,056,010 |
| 3.6            |  26.46% |      1,782,778 |
| 3.8            |  12.22% |        823,213 |
| 2.7            |   9.97% |        671,459 |
| 3.5            |   5.86% |        394,846 |
| 3.4            |   0.10% |          6,700 |
| 3.9            |   0.03% |          2,346 |
| 2.6            |   0.00% |             57 |
| 3.3            |   0.00% |             21 |
| 3.10           |   0.00% |              6 |
| Total          |         |      6,737,436 |

Library users who continue to use Python 2.7 will still be able to
install previous versions of sqlparse.

Compatibility shims have been dropped, simplifying the code.

Using pyupgrade, the codebase has been updated to take advantage of
modern syntax &lt;https://github.com/asottile/pyupgrade&gt;.

The wheel is no longer marked as "universal" as it is now Python 3 only.
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
Python 2.7 and 3.4 are end-of-life. They are no longer receiving bug
fixes, including for security issues. Python 2.7 went EOL on 2020-01-01
and 3.4 on 2019-03-18. For additional details on support Python
versions, see:

Supported: https://devguide.python.org/#status-of-python-branches
EOL: https://devguide.python.org/devcycle/#end-of-life-branches

Removing support for EOL Pythons will reduce testing and maintenance
resources while allowing the library to move towards modern Python 3.

Using pypinfo, we can show the PyPI download statistics, showing less
than 10% of users are using Python 2.7.

| python_version | percent | download_count |
| -------------- | ------: | -------------: |
| 3.7            |  45.36% |      3,056,010 |
| 3.6            |  26.46% |      1,782,778 |
| 3.8            |  12.22% |        823,213 |
| 2.7            |   9.97% |        671,459 |
| 3.5            |   5.86% |        394,846 |
| 3.4            |   0.10% |          6,700 |
| 3.9            |   0.03% |          2,346 |
| 2.6            |   0.00% |             57 |
| 3.3            |   0.00% |             21 |
| 3.10           |   0.00% |              6 |
| Total          |         |      6,737,436 |

Library users who continue to use Python 2.7 will still be able to
install previous versions of sqlparse.

Compatibility shims have been dropped, simplifying the code.

Using pyupgrade, the codebase has been updated to take advantage of
modern syntax &lt;https://github.com/asottile/pyupgrade&gt;.

The wheel is no longer marked as "universal" as it is now Python 3 only.
</pre>
</div>
</content>
</entry>
<entry>
<title>[fix] Adding TypedLiteral to comparison</title>
<updated>2020-03-29T17:08:25+00:00</updated>
<author>
<name>John Bodley</name>
<email>john.bodley@airbnb.com</email>
</author>
<published>2020-03-28T22:25:34+00:00</published>
<link rel='alternate' type='text/html' href='http://trove.baserock.org/cgit/delta/python-packages/sqlparse.git/commit/?id=28a2acdd9b307c95d2111f1f831b1a5afc634691'/>
<id>28a2acdd9b307c95d2111f1f831b1a5afc634691</id>
<content type='text'>
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
</pre>
</div>
</content>
</entry>
<entry>
<title>[grouping] group_as() no longer groups AS CTE</title>
<updated>2020-02-02T20:21:09+00:00</updated>
<author>
<name>Likai Liu</name>
<email>liulk@likai.org</email>
</author>
<published>2020-01-07T23:22:32+00:00</published>
<link rel='alternate' type='text/html' href='http://trove.baserock.org/cgit/delta/python-packages/sqlparse.git/commit/?id=a301b79c042c5c4e8677ad6e44905903ea9375c3'/>
<id>a301b79c042c5c4e8677ad6e44905903ea9375c3</id>
<content type='text'>
This patch changes the grouping of AS so that:

  Foo AS WITH bar AS 1 SELECT 2

with no longer be grouped as:

  [Identifier[Foo, AS, WITH, Identifier[Bar AS 1]], SELECT, 2]

but will be grouped as:

  [Identifier[Foo], AS, WITH, Identifier[Bar AS 1], SELECT, 2]

This fixes the parsing of CREATE TABLE new_table AS WITH ... so the
rest of the tokens after AS are parsed the same as a bare WITH.
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
This patch changes the grouping of AS so that:

  Foo AS WITH bar AS 1 SELECT 2

with no longer be grouped as:

  [Identifier[Foo, AS, WITH, Identifier[Bar AS 1]], SELECT, 2]

but will be grouped as:

  [Identifier[Foo], AS, WITH, Identifier[Bar AS 1], SELECT, 2]

This fixes the parsing of CREATE TABLE new_table AS WITH ... so the
rest of the tokens after AS are parsed the same as a bare WITH.
</pre>
</div>
</content>
</entry>
<entry>
<title>[fix] Fixing typed literal regression</title>
<updated>2020-02-02T20:19:41+00:00</updated>
<author>
<name>John Bodley</name>
<email>john.bodley@airbnb.com</email>
</author>
<published>2020-01-20T21:09:52+00:00</published>
<link rel='alternate' type='text/html' href='http://trove.baserock.org/cgit/delta/python-packages/sqlparse.git/commit/?id=44eacf2e2f4a4255829109a5e67e0c1d2af542da'/>
<id>44eacf2e2f4a4255829109a5e67e0c1d2af542da</id>
<content type='text'>
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
</pre>
</div>
</content>
</entry>
<entry>
<title>Fix test</title>
<updated>2020-01-16T08:19:34+00:00</updated>
<author>
<name>Corey Zumar</name>
<email>corey.zumar@databricks.com</email>
</author>
<published>2020-01-14T19:12:30+00:00</published>
<link rel='alternate' type='text/html' href='http://trove.baserock.org/cgit/delta/python-packages/sqlparse.git/commit/?id=6cab2ea2add40449d3f6cfd46711cb16993f8aec'/>
<id>6cab2ea2add40449d3f6cfd46711cb16993f8aec</id>
<content type='text'>
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
</pre>
</div>
</content>
</entry>
</feed>
