<feed xmlns='http://www.w3.org/2005/Atom'>
<title>delta/python-packages/sqlparse.git/tests/test_tokenize.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>Add postgres WINDOW keyword</title>
<updated>2020-09-30T05:21:06+00:00</updated>
<author>
<name>ali-tny</name>
<email>aliteeney@googlemail.com</email>
</author>
<published>2020-09-26T06:29:40+00:00</published>
<link rel='alternate' type='text/html' href='http://trove.baserock.org/cgit/delta/python-packages/sqlparse.git/commit/?id=4c570778b2e1c06e8bfcb3c48ae5baeff908fcdf'/>
<id>4c570778b2e1c06e8bfcb3c48ae5baeff908fcdf</id>
<content type='text'>
Postgres allows statements of the form:
```sql
SELECT col_1, col_2, SUM(col_3) OVER w
FROM x
WINDOW w AS (PARTITION BY col_1 ORDER BY col_2)
```
where the window is defined once at the end of the query (see
https://www.postgresql.org/docs/9.5/sql-select.html).

This change adds WINDOW as a postgres keyword, preventing queries like
the above being misparsed, with table name and WINDOW being grouped into
an single identifier &lt;Identifier 'x WINDOW'&gt;.
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
Postgres allows statements of the form:
```sql
SELECT col_1, col_2, SUM(col_3) OVER w
FROM x
WINDOW w AS (PARTITION BY col_1 ORDER BY col_2)
```
where the window is defined once at the end of the query (see
https://www.postgresql.org/docs/9.5/sql-select.html).

This change adds WINDOW as a postgres keyword, preventing queries like
the above being misparsed, with table name and WINDOW being grouped into
an single identifier &lt;Identifier 'x WINDOW'&gt;.
</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>Add symbols back to comparison test</title>
<updated>2020-01-16T08:19:34+00:00</updated>
<author>
<name>Corey Zumar</name>
<email>corey.zumar@databricks.com</email>
</author>
<published>2019-12-26T07:52:48+00:00</published>
<link rel='alternate' type='text/html' href='http://trove.baserock.org/cgit/delta/python-packages/sqlparse.git/commit/?id=ea54b8b1a4064b1289273fd8d14d498b5068c82f'/>
<id>ea54b8b1a4064b1289273fd8d14d498b5068c82f</id>
<content type='text'>
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
</pre>
</div>
</content>
</entry>
<entry>
<title>More test cases</title>
<updated>2020-01-16T08:19:34+00:00</updated>
<author>
<name>Corey Zumar</name>
<email>corey.zumar@databricks.com</email>
</author>
<published>2019-12-25T08:22:02+00:00</published>
<link rel='alternate' type='text/html' href='http://trove.baserock.org/cgit/delta/python-packages/sqlparse.git/commit/?id=101084b790496ae916557f6407be18c4e528f776'/>
<id>101084b790496ae916557f6407be18c4e528f776</id>
<content type='text'>
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
</pre>
</div>
</content>
</entry>
<entry>
<title>Add support for time zone casts (fixes #489).</title>
<updated>2019-05-16T05:56:57+00:00</updated>
<author>
<name>Andi Albrecht</name>
<email>albrecht.andi@gmail.com</email>
</author>
<published>2019-05-16T05:56:57+00:00</published>
<link rel='alternate' type='text/html' href='http://trove.baserock.org/cgit/delta/python-packages/sqlparse.git/commit/?id=7168e5ce67119d0c171be7dac36bd7d21f762589'/>
<id>7168e5ce67119d0c171be7dac36bd7d21f762589</id>
<content type='text'>
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
</pre>
</div>
</content>
</entry>
<entry>
<title>Identitfy NULLS FIRST/LAST as keywords (fixes #487).</title>
<updated>2019-05-01T09:55:31+00:00</updated>
<author>
<name>Andi Albrecht</name>
<email>albrecht.andi@gmail.com</email>
</author>
<published>2019-05-01T09:55:31+00:00</published>
<link rel='alternate' type='text/html' href='http://trove.baserock.org/cgit/delta/python-packages/sqlparse.git/commit/?id=93262c895b955ff50a1bc13536de3024d3eede50'/>
<id>93262c895b955ff50a1bc13536de3024d3eede50</id>
<content type='text'>
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
</pre>
</div>
</content>
</entry>
<entry>
<title>Avoid formatting of psql commands (fixes #469).</title>
<updated>2019-03-11T11:45:11+00:00</updated>
<author>
<name>Andi Albrecht</name>
<email>albrecht.andi@gmail.com</email>
</author>
<published>2019-03-11T11:45:11+00:00</published>
<link rel='alternate' type='text/html' href='http://trove.baserock.org/cgit/delta/python-packages/sqlparse.git/commit/?id=cff61bb93a080c1becbf2c6cd33911bc206cf587'/>
<id>cff61bb93a080c1becbf2c6cd33911bc206cf587</id>
<content type='text'>
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
</pre>
</div>
</content>
</entry>
<entry>
<title>[tokenizer] Grouping GROUP/ORDER BY</title>
<updated>2019-03-10T07:59:16+00:00</updated>
<author>
<name>John Bodley</name>
<email>john.bodley@airbnb.com</email>
</author>
<published>2019-01-15T06:38:55+00:00</published>
<link rel='alternate' type='text/html' href='http://trove.baserock.org/cgit/delta/python-packages/sqlparse.git/commit/?id=c4e9dae235abca0b4ae7099f9f9000c075b3a8e5'/>
<id>c4e9dae235abca0b4ae7099f9f9000c075b3a8e5</id>
<content type='text'>
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
</pre>
</div>
</content>
</entry>
<entry>
<title>Fix parsing of UNION ALL (fixes #294).</title>
<updated>2016-09-26T11:03:42+00:00</updated>
<author>
<name>Andi Albrecht</name>
<email>albrecht.andi@gmail.com</email>
</author>
<published>2016-09-26T11:03:42+00:00</published>
<link rel='alternate' type='text/html' href='http://trove.baserock.org/cgit/delta/python-packages/sqlparse.git/commit/?id=ee2cbfea194fac4f2bbfe526fe2c3bdb856aed0b'/>
<id>ee2cbfea194fac4f2bbfe526fe2c3bdb856aed0b</id>
<content type='text'>
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
</pre>
</div>
</content>
</entry>
<entry>
<title>Fix parsing of names containing special chars (fixes 291).</title>
<updated>2016-09-14T12:45:44+00:00</updated>
<author>
<name>Andi Albrecht</name>
<email>albrecht.andi@gmail.com</email>
</author>
<published>2016-09-14T12:45:44+00:00</published>
<link rel='alternate' type='text/html' href='http://trove.baserock.org/cgit/delta/python-packages/sqlparse.git/commit/?id=358ad4b9754721f69c6b40333653bd84edb8634f'/>
<id>358ad4b9754721f69c6b40333653bd84edb8634f</id>
<content type='text'>
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
</pre>
</div>
</content>
</entry>
</feed>
