summaryrefslogtreecommitdiff
path: root/tests
Commit message (Collapse)AuthorAgeFilesLines
* Remove unnecessary parts in regex for bad escaping.Andi Albrecht2023-04-181-2/+2
| | | | | The regex tried to deal with situations where escaping in the SQL to be parsed was suspicious.
* Fix get_type with comments between WITH keywordShikanime Deva2023-01-041-0/+9
|
* change singleton behaviorSimon Heisterkamp2023-01-022-5/+5
|
* flake8Simon Heisterkamp2023-01-022-5/+15
|
* lexer documentationSimon Heisterkamp2023-01-021-5/+1
|
* test for changing the regexSimon Heisterkamp2023-01-021-3/+31
|
* remove type annotations for python 3.5 compatibilitySimon Heisterkamp2023-01-021-1/+0
|
* test configurable syntaxSimon Heisterkamp2023-01-021-0/+43
|
* configurable syntaxSimon Heisterkamp2023-01-021-1/+2
|
* Revert "add regex pattern to identify IN as a Compasion token"Andi Albrecht2022-12-301-11/+1
| | | | | | | | | | | 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).
* Allow any unicode character as identifier name (fixes #641).Andi Albrecht2022-09-101-0/+1
|
* Add tests for utils.remove_quotes.Andi Albrecht2022-08-241-0/+12
|
* Fixed bad parsing of create table statements that use lower caseSimon Heisterkamp2022-08-241-0/+4
|
* CREATE TABLE tbl AS SELECT should return get_alias() for its columnAki Ariga2022-08-241-0/+5
|
* Make tzcast grouping function less eagerErik Cederstrand2022-08-161-0/+9
|
* DIV is OperatorAki Ariga2022-08-081-0/+6
|
* Optimize regular expression for identifying line breaks in comments.Andi Albrecht2021-09-101-0/+17
|
* Fix parsing of scientific numbers (fixes #399).Andi Albrecht2021-07-141-4/+10
|
* Fix parsing of backticks (fixes #588).Andi Albrecht2020-10-191-0/+7
| | | | | The backticks in this operator regex was introduced in c794c97531c09e66b6a7ffac76626a727ad02f5e. Pretty sure it was by mistake.
* Stabilize formatting of invalid WHERE clauses.Andi Albrecht2020-09-301-0/+6
|
* Improve formatting of type casts in parentheses.Andi Albrecht2020-09-301-0/+6
|
* Fix splitting of statements using CASE ... WHEN (fixes #580).Andi Albrecht2020-09-302-0/+14
|
* Fix splitting when using DECLARE ... HANDLER (fixes #581).Andi Albrecht2020-09-302-0/+16
|
* Don't make parsing of square bracket identifiers too greedy (fixes #583).Andi Albrecht2020-09-301-0/+6
|
* Add postgres WINDOW keywordali-tny2020-09-301-0/+6
| | | | | | | | | | | | | | | 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/+7
|
* Remove changing our stdout encoding.Andi Albrecht2020-09-131-2/+0
|
* Don't flush token streams iff they only contain whitespace tokens (fixes #496).Andi Albrecht2020-09-132-4/+7
|
* add regex pattern to identify IN as a Compasion tokenhurcy2020-09-131-1/+11
|
* Update tests to work with newer pytest version.Andi Albrecht2020-09-131-47/+28
| | | | Also some unification of the tests.
* Remove support for end-of-life PythonsJon Dufresne2020-08-319-65/+43
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 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/+12
|
* [grouping] group_as() no longer groups AS CTELikai Liu2020-02-021-0/+8
| | | | | | | | | | | | | | | | | 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-021-0/+6
|
* Fix testCorey Zumar2020-01-161-14/+14
|
* Like/ilike comparison testCorey Zumar2020-01-161-0/+35
|
* Add symbols back to comparison testCorey Zumar2020-01-162-1/+2
|
* More test casesCorey Zumar2020-01-162-1/+22
|
* Add first test caseCorey Zumar2020-01-161-2/+3
|
* support typed literals (if that's what they're called)Dvořák Václav2019-10-201-0/+28
|
* [fix] Addressing issue #507John Bodley2019-10-091-0/+8
|
* Restrict detection of alias names (fixes #455).Andreas Albrecht2019-10-092-5/+6
| | | | | This change adopts some parts of the pull request #509 by john-bodley. Thanks!
* Revert "Add in slash comment functionality"Toby Mao2019-06-262-21/+0
| | | | This reverts commit 170010e7d709f2145169d23482d006dc56856256.
* Add support for time zone casts (fixes #489).Andi Albrecht2019-05-162-0/+15
|
* Identitfy NULLS FIRST/LAST as keywords (fixes #487).Andi Albrecht2019-05-011-0/+7
|
* Update changelog and authors and add regression test for #485.Andi Albrecht2019-04-171-0/+10
|
* Add regression test for #484.Andi Albrecht2019-03-301-0/+17
|
* Avoid formatting of psql commands (fixes #469).Andi Albrecht2019-03-112-0/+13
|
* [tokenizer] Grouping GROUP/ORDER BYJohn Bodley2019-03-102-1/+13
|
* Add in slash comment functionalityIan Robertson2019-03-102-0/+21
|
View Lorry Controller Status