| Name | sqlparse JSON |
| Version |
0.5.3
JSON |
| download |
| home_page | None |
| Summary | A non-validating SQL parser. |
| upload_time | 2024-12-10 12:05:30 |
| maintainer | None |
| docs_url | None |
| author | None |
| requires_python | >=3.8 |
| license | None |
| keywords |
|
| VCS |
 |
| bugtrack_url |
|
| requirements |
No requirements were recorded.
|
| Travis-CI |
No Travis.
|
| coveralls test coverage |
No coveralls.
|
python-sqlparse - Parse SQL statements
======================================
|buildstatus|_
|coverage|_
|docs|_
|packageversion|_
.. docincludebegin
sqlparse is a non-validating SQL parser for Python.
It provides support for parsing, splitting and formatting SQL statements.
The module is compatible with Python 3.8+ and released under the terms of the
`New BSD license <https://opensource.org/licenses/BSD-3-Clause>`_.
Visit the project page at https://github.com/andialbrecht/sqlparse for
further information about this project.
Quick Start
-----------
.. code-block:: sh
$ pip install sqlparse
.. code-block:: python
>>> import sqlparse
>>> # Split a string containing two SQL statements:
>>> raw = 'select * from foo; select * from bar;'
>>> statements = sqlparse.split(raw)
>>> statements
['select * from foo;', 'select * from bar;']
>>> # Format the first statement and print it out:
>>> first = statements[0]
>>> print(sqlparse.format(first, reindent=True, keyword_case='upper'))
SELECT *
FROM foo;
>>> # Parsing a SQL statement:
>>> parsed = sqlparse.parse('select * from foo')[0]
>>> parsed.tokens
[<DML 'select' at 0x7f22c5e15368>, <Whitespace ' ' at 0x7f22c5e153b0>, <Wildcard '*' … ]
>>>
Links
-----
Project page
https://github.com/andialbrecht/sqlparse
Bug tracker
https://github.com/andialbrecht/sqlparse/issues
Documentation
https://sqlparse.readthedocs.io/
Online Demo
https://sqlformat.org/
sqlparse is licensed under the BSD license.
Parts of the code are based on pygments written by Georg Brandl and others.
pygments-Homepage: http://pygments.org/
.. |buildstatus| image:: https://github.com/andialbrecht/sqlparse/actions/workflows/python-app.yml/badge.svg
.. _buildstatus: https://github.com/andialbrecht/sqlparse/actions/workflows/python-app.yml
.. |coverage| image:: https://codecov.io/gh/andialbrecht/sqlparse/branch/master/graph/badge.svg
.. _coverage: https://codecov.io/gh/andialbrecht/sqlparse
.. |docs| image:: https://readthedocs.org/projects/sqlparse/badge/?version=latest
.. _docs: https://sqlparse.readthedocs.io/en/latest/?badge=latest
.. |packageversion| image:: https://img.shields.io/pypi/v/sqlparse?color=%2334D058&label=pypi%20package
.. _packageversion: https://pypi.org/project/sqlparse
Raw data
{
"_id": null,
"home_page": null,
"name": "sqlparse",
"maintainer": null,
"docs_url": null,
"requires_python": ">=3.8",
"maintainer_email": null,
"keywords": null,
"author": null,
"author_email": "Andi Albrecht <albrecht.andi@gmail.com>",
"download_url": "https://files.pythonhosted.org/packages/e5/40/edede8dd6977b0d3da179a342c198ed100dd2aba4be081861ee5911e4da4/sqlparse-0.5.3.tar.gz",
"platform": null,
"description": "python-sqlparse - Parse SQL statements\n======================================\n\n|buildstatus|_\n|coverage|_\n|docs|_\n|packageversion|_\n\n.. docincludebegin\n\nsqlparse is a non-validating SQL parser for Python.\nIt provides support for parsing, splitting and formatting SQL statements.\n\nThe module is compatible with Python 3.8+ and released under the terms of the\n`New BSD license <https://opensource.org/licenses/BSD-3-Clause>`_.\n\nVisit the project page at https://github.com/andialbrecht/sqlparse for\nfurther information about this project.\n\n\nQuick Start\n-----------\n\n.. code-block:: sh\n\n $ pip install sqlparse\n\n.. code-block:: python\n\n >>> import sqlparse\n\n >>> # Split a string containing two SQL statements:\n >>> raw = 'select * from foo; select * from bar;'\n >>> statements = sqlparse.split(raw)\n >>> statements\n ['select * from foo;', 'select * from bar;']\n\n >>> # Format the first statement and print it out:\n >>> first = statements[0]\n >>> print(sqlparse.format(first, reindent=True, keyword_case='upper'))\n SELECT *\n FROM foo;\n\n >>> # Parsing a SQL statement:\n >>> parsed = sqlparse.parse('select * from foo')[0]\n >>> parsed.tokens\n [<DML 'select' at 0x7f22c5e15368>, <Whitespace ' ' at 0x7f22c5e153b0>, <Wildcard '*' \u2026 ]\n >>>\n\nLinks\n-----\n\nProject page\n https://github.com/andialbrecht/sqlparse\n\nBug tracker\n https://github.com/andialbrecht/sqlparse/issues\n\nDocumentation\n https://sqlparse.readthedocs.io/\n\nOnline Demo\n https://sqlformat.org/\n\n\nsqlparse is licensed under the BSD license.\n\nParts of the code are based on pygments written by Georg Brandl and others.\npygments-Homepage: http://pygments.org/\n\n.. |buildstatus| image:: https://github.com/andialbrecht/sqlparse/actions/workflows/python-app.yml/badge.svg\n.. _buildstatus: https://github.com/andialbrecht/sqlparse/actions/workflows/python-app.yml\n.. |coverage| image:: https://codecov.io/gh/andialbrecht/sqlparse/branch/master/graph/badge.svg\n.. _coverage: https://codecov.io/gh/andialbrecht/sqlparse\n.. |docs| image:: https://readthedocs.org/projects/sqlparse/badge/?version=latest\n.. _docs: https://sqlparse.readthedocs.io/en/latest/?badge=latest\n.. |packageversion| image:: https://img.shields.io/pypi/v/sqlparse?color=%2334D058&label=pypi%20package\n.. _packageversion: https://pypi.org/project/sqlparse\n",
"bugtrack_url": null,
"license": null,
"summary": "A non-validating SQL parser.",
"version": "0.5.3",
"project_urls": {
"Documentation": "https://sqlparse.readthedocs.io/",
"Home": "https://github.com/andialbrecht/sqlparse",
"Release Notes": "https://sqlparse.readthedocs.io/en/latest/changes.html",
"Source": "https://github.com/andialbrecht/sqlparse",
"Tracker": "https://github.com/andialbrecht/sqlparse/issues"
},
"split_keywords": [],
"urls": [
{
"comment_text": null,
"digests": {
"blake2b_256": "a95cbfd6bd0bf979426d405cc6e71eceb8701b148b16c21d2dc3c261efc61c7b",
"md5": "28a0ac4500fe5b9b0d7c7e593b21e6df",
"sha256": "cf2196ed3418f3ba5de6af7e82c694a9fbdbfecccdfc72e281548517081f16ca"
},
"downloads": -1,
"filename": "sqlparse-0.5.3-py3-none-any.whl",
"has_sig": false,
"md5_digest": "28a0ac4500fe5b9b0d7c7e593b21e6df",
"packagetype": "bdist_wheel",
"python_version": "py3",
"requires_python": ">=3.8",
"size": 44415,
"upload_time": "2024-12-10T12:05:27",
"upload_time_iso_8601": "2024-12-10T12:05:27.824643Z",
"url": "https://files.pythonhosted.org/packages/a9/5c/bfd6bd0bf979426d405cc6e71eceb8701b148b16c21d2dc3c261efc61c7b/sqlparse-0.5.3-py3-none-any.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": null,
"digests": {
"blake2b_256": "e540edede8dd6977b0d3da179a342c198ed100dd2aba4be081861ee5911e4da4",
"md5": "9764a42264c9a3102526c87260e73d11",
"sha256": "09f67787f56a0b16ecdbde1bfc7f5d9c3371ca683cfeaa8e6ff60b4807ec9272"
},
"downloads": -1,
"filename": "sqlparse-0.5.3.tar.gz",
"has_sig": false,
"md5_digest": "9764a42264c9a3102526c87260e73d11",
"packagetype": "sdist",
"python_version": "source",
"requires_python": ">=3.8",
"size": 84999,
"upload_time": "2024-12-10T12:05:30",
"upload_time_iso_8601": "2024-12-10T12:05:30.728955Z",
"url": "https://files.pythonhosted.org/packages/e5/40/edede8dd6977b0d3da179a342c198ed100dd2aba4be081861ee5911e4da4/sqlparse-0.5.3.tar.gz",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2024-12-10 12:05:30",
"github": true,
"gitlab": false,
"bitbucket": false,
"codeberg": false,
"github_user": "andialbrecht",
"github_project": "sqlparse",
"travis_ci": false,
"coveralls": false,
"github_actions": true,
"lcname": "sqlparse"
}
