summaryrefslogtreecommitdiff
path: root/sqlparse
Commit message (Collapse)AuthorAgeFilesLines
* Switch back to development mode.Andi Albrecht2020-10-071-1/+1
|
* Bump version to 0.4.0.0.4.0Andi Albrecht2020-10-071-1/+1
|
* Update copyright notice.Andi Albrecht2020-10-0721-21/+21
|
* Stabilize formatting of invalid WHERE clauses.Andi Albrecht2020-09-301-0/+3
|
* Improve formatting of type casts in parentheses.Andi Albrecht2020-09-301-0/+2
|
* Fix an issue with negative indexes causing IndexError in some cases.Andi Albrecht2020-09-301-0/+2
|
* Fix splitting of statements using CASE ... WHEN (fixes #580).Andi Albrecht2020-09-301-1/+1
|
* Fix splitting when using DECLARE ... HANDLER (fixes #581).Andi Albrecht2020-09-301-1/+1
|
* Don't make parsing of square bracket identifiers too greedy (fixes #583).Andi Albrecht2020-09-301-1/+1
|
* Add RLIKE keywordWill Jones2020-09-301-1/+1
|
* Add postgres WINDOW keywordali-tny2020-09-301-0/+1
| | | | | | | | | | | | | | | 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 <Identifier 'x WINDOW'>.
* Preserve line breaks when removing comments (fixes #484).Andi Albrecht2020-09-131-7/+16
|
* Don't flush token streams iff they only contain whitespace tokens (fixes #496).Andi Albrecht2020-09-131-1/+1
|
* add regex pattern to identify IN as a Compasion tokenhurcy2020-09-131-1/+1
|
* Remove support for end-of-life PythonsJon Dufresne2020-08-3122-159/+76
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 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 <https://github.com/asottile/pyupgrade>. The wheel is no longer marked as "universal" as it is now Python 3 only.
* [fix] Adding TypedLiteral to comparisonJohn Bodley2020-03-291-1/+1
|
* Switch back to develoment mode.Andreas Albrecht2020-02-291-1/+1
|
* Update version number for release.0.3.1Andreas Albrecht2020-02-291-1/+1
|
* [grouping] group_as() no longer groups AS CTELikai Liu2020-02-021-1/+1
| | | | | | | | | | | | | | | | | 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.
* [fix] Fixing typed literal regressionJohn Bodley2020-02-022-4/+3
|
* Update sql.pyJohn Bodley2020-01-201-1/+2
|
* Update sql.pyJohn Bodley2020-01-201-1/+1
|
* [sql] Adding TIMESTAMP to typed literalJohn Bodley2020-01-201-1/+1
|
* More test casesCorey Zumar2020-01-161-1/+1
|
* Add first test caseCorey Zumar2020-01-161-1/+1
|
* Map like and ilike clauses to comparisonsCorey Zumar2020-01-161-1/+1
|
* Stabilize grouping engine when parsing invalid SQL statements.Andreas Albrecht2020-01-061-2/+2
| | | | | It's just to make sure, that the comparison returns a valid result when feed with invalid SQL statements.
* Code cleanup.Andreas Albrecht2019-10-205-19/+26
|
* support typed literals (if that's what they're called)Dvořák Václav2019-10-203-6/+43
|
* [sql] Fix TokenList.__init__ when no tokens are providedJohn Bodley2019-10-091-1/+1
|
* [fix] Addressing issue #507John Bodley2019-10-091-3/+3
|
* Restrict detection of alias names (fixes #455).Andreas Albrecht2019-10-091-15/+27
| | | | | This change adopts some parts of the pull request #509 by john-bodley. Thanks!
* Revert "Add in slash comment functionality"Toby Mao2019-06-261-2/+2
| | | | This reverts commit 170010e7d709f2145169d23482d006dc56856256.
* Optimize parsing of literal blocks between dollar signs (fixes #491).Andi Albrecht2019-06-261-1/+1
|
* Add support for time zone casts (fixes #489).Andi Albrecht2019-05-162-1/+15
|
* Identitfy NULLS FIRST/LAST as keywords (fixes #487).Andi Albrecht2019-05-011-0/+1
|
* Fixes #485William Ivanski2019-04-171-1/+1
|
* Fixes #485William Ivanski2019-04-171-1/+0
|
* Fixes #485William Ivanski2019-04-171-6/+9
|
* Added HQL Keywordsmathilde.oustlant2019-03-121-2/+97
|
* Switch back to development.Andi Albrecht2019-03-111-1/+1
|
* Bump version.0.3.0Andi Albrecht2019-03-111-1/+1
|
* Avoid formatting of psql commands (fixes #469).Andi Albrecht2019-03-113-1/+7
|
* Remove unnecessary compat shim for bytesJon Dufresne2019-03-102-4/+2
| | | | | | | | | | Both Python 2.7 and Python 3 have the type bytes. On Python 2.7, it is an alias of str, same as was previously defined in compat.py. Makes the code slightly more compatible with Python 3 style syntax. Observe: $ python2 >>> bytes <type 'str'>
* [tokenizer] Addressing @andialbrecht commentsJohn Bodley2019-03-101-6/+6
|
* [tokenizer] Grouping GROUP/ORDER BYJohn Bodley2019-03-104-8/+17
|
* [keywords] Adding Calcite temporal keywordsJohn Bodley2019-03-101-0/+4
|
* Add in slash comment functionalityIan Robertson2019-03-101-2/+2
|
* [filters] Stripping parenthesis whitespaceJohn Bodley2019-03-101-2/+2
|
* Fix formatting on INSERT (fixes #329)Fredy Wijaya2019-03-103-1/+35
| | | | | | | | | | | | | | | | | | | | This patch fixes the formatting on INSERT by creating a new instance of sql.Values to group all the values. SQL: insert into foo values (1, 'foo'), (2, 'bar'), (3, 'baz') Before: insert into foo values (1, 'foo'), (2, 'bar'), (3, 'baz') After: insert into foo values (1, 'foo'), (2, 'bar'), (3, 'baz')