A Python Module for the "General SQL Parser" library (sqlparser.com)
This library currently supports: Windows 32bit/64bit and Linux 32bit/64bit. There are currently no binaries for Mac OSX available.
Also, please note that this module does not support Python 3.*
Simply clone or download this git and execute
python setup.py build
python setup.py install
The setup script will automatically download the right library (from sqlparser.com) for you.
Simply import the module with import sqlparser The following example will parse a simple query:
import sqlparser
query = "SELECT a, b FROM table_1 WHERE c > 20"
parser = sqlparser.Parser()
# Check for syntax errors
if parser.check_syntax(query) == 0:
# Get first statement from the query
stmt = parser.get_statement(0)
# Get root node
root = stmt.get_root()
print root.__dict__And print the node information the SELECT node:
{"computeClause": None,
"cteList": None,
"expandOnClause": None,
"fetchFirstClause": None,
"forupdateClause": None,
"fromTableList": <sqlparser.Node object at 0x7ff48c5eed50>,
"groupByClause": None,
"hierarchicalClause": None,
"intoClause": None,
"intoTableClause": None,
"isolationClause": None,
"leftNode": None,
"limitClause": None,
"lockingClause": None,
"node_type": 5,
"optimizeForClause": None,
"orderbyClause": None,
"qualifyClause": None,
"resultColumnList": <sqlparser.Node object at 0x7ff48c5ee618>,
"rightNode": None,
"sampleClause": None,
"selectDistinct": None,
"selectToken": "SELECT",
"setOperator": 0,
"topClause": None,
"valueClause": None,
"whereCondition": <sqlparser.Node object at 0x7ff48c5eea78>,
"windowClause": None,
"withClauses": None}For more examples please check the examples directory.