sqlparse is a non-validating SQL parser module. It provides support for parsing, splitting and formatting SQL statements.
Visit the project page for additional information and documentation.
Example Usage
Splitting SQL statements:
>>> import sqlparse
>>> sqlparse.split('select * from foo; select * from bar;')
[u'select * from foo; ', u'select * from bar;']
Formatting statements:
>>> sql = 'select * from foo where id in (select id from bar);' >>> print(sqlparse.format(sql, reindent=True, keyword_case='upper')) SELECT * FROM foo WHERE id IN (SELECT id FROM bar);
Parsing:
>>> sql = 'select * from someschema.mytable where id = 1' >>> res = sqlparse.parse(sql) >>> res (<Statement 'select...' at 0x9ad08ec>,) >>> stmt = res[0] >>> str(stmt) # converting it back to unicode 'select * from someschema.mytable where id = 1' >>> # This is how the internal representation looks like: >>> stmt.tokens (<DML 'select' at 0x9b63c34>, <Whitespace ' ' at 0x9b63e8c>, <Operator '*' at 0x9b63e64>, <Whitespace ' ' at 0x9b63c5c>, <Keyword 'from' at 0x9b63c84>, <Whitespace ' ' at 0x9b63cd4>, <Identifier 'somes...' at 0x9b5c62c>, <Whitespace ' ' at 0x9b63f04>, <Where 'where ...' at 0x9b5caac>)
1 maintainer
Metadata
1 maintainer
Release files for sqlparse 0.3.1
For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.
Source distribution (sdist)
| File | Size | Uploaded | |
|---|---|---|---|
| sqlparse-0.3.1.tar.gz | 67.6 kB | Details |
Built distribution (wheel)
| File | Interpreter | ABI | Platform | Reset |
|---|---|---|---|---|
| sqlparse-0.3.1-py2.py3-none-any.whl | Python 3, Python 2 | none | any | Details |
Total release size: 108.3 kB
Release files / sqlparse-0.3.1.tar.gz
| Download URL | sqlparse-0.3.1.tar.gz |
|---|---|
| Size | 67.6 kB |
| Tags | Source |
|
SHA-256 checksum How to use checksums |
e162203737712307dfe78860cc56c8da8a852ab2ee33750e33aeadf38d12c548
|
|
BLAKE2b-256 checksum How to use checksums |
674b253b6902c1526885af6d361ca8c6b1400292e649f0e9c95ee0d2e8ec8681
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/3.1.1 pkginfo/1.5.0.1 requests/2.23.0 setuptools/40.6.2 requests-toolbelt/0.9.1 tqdm/4.43.0 CPython/3.6.9
|
Release files / sqlparse-0.3.1-py2.py3-none-any.whl
| Download URL | sqlparse-0.3.1-py2.py3-none-any.whl |
|---|---|
| Size | 40.8 kB |
| Tags | Python 2 Python 3 |
|
SHA-256 checksum How to use checksums |
022fb9c87b524d1f7862b3037e541f68597a730a8843245c349fc93e1643dc4e
|
|
BLAKE2b-256 checksum How to use checksums |
85ee6e821932f413a5c4b76be9c5936e313e4fc626b33f16e027866e1d60f588
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/3.1.1 pkginfo/1.5.0.1 requests/2.23.0 setuptools/40.6.2 requests-toolbelt/0.9.1 tqdm/4.43.0 CPython/3.6.9
|
