sqlparse

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 statemtents:

>>> 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]
>>> unicode(stmt)  # converting it back to unicode
u'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>)

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

sqlparse-0.1.18.tar.gz (58.6 kB view details)

Uploaded Oct 25, 2015 Source

File details

Details for the file sqlparse-0.1.18.tar.gz.

File metadata

Download URL: sqlparse-0.1.18.tar.gz
Upload date: Oct 25, 2015
Size: 58.6 kB
Tags: Source
Uploaded using Trusted Publishing? No

File hashes

Hashes for sqlparse-0.1.18.tar.gz
Algorithm	Hash digest
SHA256	`39b196c4a06f76d6ac82f029457ca961f662a8bbbb2694eb1dfe4f2b68a2d7cf`
MD5	`777942cb613ebbaedadda81dc7fcdb9b`
BLAKE2b-256	`857d0d217b6132f1dd3fd22d1b1fbc16bb9fd951f5c1a3af814bb8a22edc5da3`