| Name | sqlparse JSON |
| Version |
0.5.0
JSON |
| download |
| home_page | None |
| Summary | A non-validating SQL parser. |
| upload_time | 2024-04-13 12:37:09 |
| 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/50/26/5da251cd090ccd580f5cfaa7d36cdd8b2471e49fffce60ed520afc27f4bc/sqlparse-0.5.0.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.0",
"project_urls": {
"Documentation": "https://sqlparse.readthedocs.io/",
"Home": "https://github.com/andialbrecht/sqlparse",
"Release Notes": "https://sqlparse.readthedocs.io/en/latest/changes/",
"Source": "https://github.com/andialbrecht/sqlparse",
"Tracker": "https://github.com/andialbrecht/sqlparse/issues"
},
"split_keywords": [],
"urls": [
{
"comment_text": null,
"digests": {
"blake2b_256": "435da0fdd88fd486b39ae1fd1a75ff75b4e29a0df96c0304d462fd407b82efe0",
"md5": "f22879a0ed4eb42d721e3c2c57c6a29c",
"sha256": "c204494cd97479d0e39f28c93d46c0b2d5959c7b9ab904762ea6c7af211c8663"
},
"downloads": -1,
"filename": "sqlparse-0.5.0-py3-none-any.whl",
"has_sig": false,
"md5_digest": "f22879a0ed4eb42d721e3c2c57c6a29c",
"packagetype": "bdist_wheel",
"python_version": "py3",
"requires_python": ">=3.8",
"size": 43971,
"upload_time": "2024-04-13T12:37:11",
"upload_time_iso_8601": "2024-04-13T12:37:11.177304Z",
"url": "https://files.pythonhosted.org/packages/43/5d/a0fdd88fd486b39ae1fd1a75ff75b4e29a0df96c0304d462fd407b82efe0/sqlparse-0.5.0-py3-none-any.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": null,
"digests": {
"blake2b_256": "50265da251cd090ccd580f5cfaa7d36cdd8b2471e49fffce60ed520afc27f4bc",
"md5": "cc677bad6c6724a8b0b4aa178cbdacb7",
"sha256": "714d0a4932c059d16189f58ef5411ec2287a4360f17cdd0edd2d09d4c5087c93"
},
"downloads": -1,
"filename": "sqlparse-0.5.0.tar.gz",
"has_sig": false,
"md5_digest": "cc677bad6c6724a8b0b4aa178cbdacb7",
"packagetype": "sdist",
"python_version": "source",
"requires_python": ">=3.8",
"size": 83475,
"upload_time": "2024-04-13T12:37:09",
"upload_time_iso_8601": "2024-04-13T12:37:09.316071Z",
"url": "https://files.pythonhosted.org/packages/50/26/5da251cd090ccd580f5cfaa7d36cdd8b2471e49fffce60ed520afc27f4bc/sqlparse-0.5.0.tar.gz",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2024-04-13 12:37:09",
"github": true,
"gitlab": false,
"bitbucket": false,
"codeberg": false,
"github_user": "andialbrecht",
"github_project": "sqlparse",
"travis_ci": false,
"coveralls": false,
"github_actions": true,
"lcname": "sqlparse"
}
