* Cleanup whitespace in README. * GitHub Actions: Add Py3.10, update Actions, more flake8 tests "3.10" must be quoted in yaml https://dev.to/hugovk/the-python-3-1-problem-85g * Test on Python 3.11 beta 5 * Reduce max line length in flake8 to the default of 79. * Update authors and changelog. * Update actions in codeql workflow. * Fix INDICATOR keyword * docs: Add a PiPY package badge * Acknowledge support for Python 3.10 A subset of andialbrecht#645 Follow on to andialbrecht#661 * DIV is Operator * added some builtin types that can appear in Spark create table statements. * Don't make slice copies in TokenList._token_matching(). Since we are working with indexes anyway, don't bother calling enumerate() with a slice from self.tokens (which requires copying memory). Instead, just generate the indexes using range() and use normal indexing to access the desired tokens. The old behavior resulted in quadratic runtime with respect to the number of tokens, which significantly impacted performance for statements with very large numbers of tokens. With the new behavior, the runtime is now linear with respect to the number of tokens. * Refactor to reduce redundant code. * Add regex pattern to identify REGEXP as a Compasion token * Make tzcast grouping function less eager * Update authors and changelog. * Add DISTINCTROW keyword (fixes andialbrecht#677). * Update Changelog. * CREATE TABLE tbl AS SELECT should return get_alias() for its column * Update Changelog. * Fixed bad parsing of create table statements that use lower case * Update CHANGELOG. yeah... I promise to make fewer commits like that in the future... * add backtick to remove_quotes character list * Update Changelog and authors. * Add tests for utils.remove_quotes. * Add docstring and comments. * Allow any unicode character as identifier name (fixes andialbrecht#641). * Bump version. * Switch back to development mode. * Revert "add regex pattern to identify IN as a Compasion token" This reverts commit 28c4d40. See andialbrecht#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). * Update changelog. * Update workflow runner. * Update tested Python versions in workflow. * Setup a nightly build, even without changes in the module itself. * Fix schedule trigger syntax. * Switch to pyproject.toml (fixes andialbrecht#685). * configurable syntax * test configurable syntax * remove type annotations for python 3.5 compatibility * test for changing the regex * lexer documentation * flake8 * additional documentation * change singleton behavior * Fix get_type with comments between WITH keyword * Cleanup regex for detecting keywords (fixes andialbrecht#709). * CI: Use codecov action. codecov module is deprecated and was removed from PyPI in favor of the github action. * Remove unnecessary parts in regex for bad escaping. The regex tried to deal with situations where escaping in the SQL to be parsed was suspicious. * Testing branch * Removed test file * Bump version. * Update Changelog. * Switch back to development mode. * Update python-app.yml: Try with 3.12-beta1 * Update python-app.yml: Revert to 3.12-dev and add check-latest * Add classifier for Python 3.11 (fixes andialbrecht#726). * Remove outdated and unused editorconfig. * Drop support for Python 3.5. * Get tox running again. We have to pin versions for tox and virtualenv because newer versions don't support Python 3.6 anymore. * Don't pin virtualenv in dev section. The requirements in dev section are more general (and may require newer versions). * Add reminder for github release (fixes andialbrecht#732). * Update issue templates * Update bug_report.md * Add link to discussion when creating issues. * Update config.yml. * Update test action. * Add Code of Conduct. * Add contributing guide. * Create SECURITY.md * Add Pull request template. * Update Python version in test action. * Updated too early... switching back to 3.12.0-beta.4. * CI: Try to fix importlib issue with flake8. See python/importlib_metadata#406 * Bump GitHub Actions * Add support for Python 3.12 * Update changelog and authors. * Ignore attributes starting with dunder in _TokenType (fixes andialbrecht#672). This issue came up, when trying to deepcopy a parsed statement. deepcopy uses getattr(obj, '__deepcopy__', None) to get a method for copying an object. Before this change a new attribute '__deepcopy__' was created as a new instance of _TokenType (a tuple). * Simplify regex. * Code cleanup. --------- Co-authored-by: Andi Albrecht <albrecht.andi@gmail.com> Co-authored-by: Christian Clauss <cclauss@me.com> Co-authored-by: osmnv <80402144+osmnv@users.noreply.github.com> Co-authored-by: Hao Xin <haoxinst@gmail.com> Co-authored-by: Aki Ariga <chezou+github@gmail.com> Co-authored-by: Simon Heisterkamp <she@delegate.dk> Co-authored-by: Daniel Harding <dharding@living180.net> Co-authored-by: JavierPan <PeterSandwich@users.noreply.github.com> Co-authored-by: Erik Cederstrand <erik@adamatics.com> Co-authored-by: Long Le Xich <codenamelxl@users.noreply.github.com> Co-authored-by: Simon Heisterkamp <simon@heisterkamp.dk> Co-authored-by: Shikanime Deva <deva.shikanime@protonmail.com> Co-authored-by: Kevin Stubbings <kwstubbs@github.com> Co-authored-by: Hugo van Kemenade <hugovk@users.noreply.github.com>

Redundant characters in regular expression #709

Description

Metadata

Metadata

Assignees

Labels

Projects

Milestone

Relationships

Development

Issue actions