| Name | sqlparse JSON |
| Version |
0.5.2
JSON |
| download |
| home_page | None |
| Summary | A non-validating SQL parser. |
| upload_time | 2024-11-14 10:06:31 |
| 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/57/61/5bc3aff85dc5bf98291b37cf469dab74b3d0aef2dd88eade9070a200af05/sqlparse-0.5.2.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.2",
"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": "7a135f6654c9d915077fae255686ca6fa42095b62b7337e3e1aa9e82caa6f43a",
"md5": "32e53dad865186b9280cfd05905b0ef2",
"sha256": "e99bc85c78160918c3e1d9230834ab8d80fc06c59d03f8db2618f65f65dda55e"
},
"downloads": -1,
"filename": "sqlparse-0.5.2-py3-none-any.whl",
"has_sig": false,
"md5_digest": "32e53dad865186b9280cfd05905b0ef2",
"packagetype": "bdist_wheel",
"python_version": "py3",
"requires_python": ">=3.8",
"size": 44407,
"upload_time": "2024-11-14T10:06:25",
"upload_time_iso_8601": "2024-11-14T10:06:25.268156Z",
"url": "https://files.pythonhosted.org/packages/7a/13/5f6654c9d915077fae255686ca6fa42095b62b7337e3e1aa9e82caa6f43a/sqlparse-0.5.2-py3-none-any.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": null,
"digests": {
"blake2b_256": "57615bc3aff85dc5bf98291b37cf469dab74b3d0aef2dd88eade9070a200af05",
"md5": "3d009b2cc325b46d4f1e8b00102f1934",
"sha256": "9e37b35e16d1cc652a2545f0997c1deb23ea28fa1f3eefe609eee3063c3b105f"
},
"downloads": -1,
"filename": "sqlparse-0.5.2.tar.gz",
"has_sig": false,
"md5_digest": "3d009b2cc325b46d4f1e8b00102f1934",
"packagetype": "sdist",
"python_version": "source",
"requires_python": ">=3.8",
"size": 84951,
"upload_time": "2024-11-14T10:06:31",
"upload_time_iso_8601": "2024-11-14T10:06:31.941632Z",
"url": "https://files.pythonhosted.org/packages/57/61/5bc3aff85dc5bf98291b37cf469dab74b3d0aef2dd88eade9070a200af05/sqlparse-0.5.2.tar.gz",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2024-11-14 10:06:31",
"github": true,
"gitlab": false,
"bitbucket": false,
"codeberg": false,
"github_user": "andialbrecht",
"github_project": "sqlparse",
"travis_ci": false,
"coveralls": false,
"github_actions": true,
"lcname": "sqlparse"
}
