Parses PostgreSQL/MySQL and translates ADQL to PostgreSQL/MySQL.
Tool for parsing and processing of MySQL/PostgreSQL and translation of ADQL SELECT-like queries
Designed to be used in conjunction with django-daiquri as a query processing backend but it can be easily used as a stand-alone tool or integrated into another project.
The easiest way to install the package is by using the pip tool:
pip install queryparser-python3
Alternatively, you can clone the repository and install it from there. However, this step also requires generating the parser which is a slightly more elaborate process (see below).
Generating the parser from the git repository
To generate the parsers you need
java above version
antlr-4.*-complete.jar has to be installed inside the
After cloning the project run
lib directory will be created. After that, run
python setup.py install
to install the generated parser in your virtual environment.
Parsing MySQL and PostgreSQL
Parsing and processing of MySQL queries can be done by creating an instance
from queryparser.mysql import MySQLQueryProcessor qp = MySQLQueryProcessor()
feeding it a MySQL query
sql = "SELECT a FROM db.tab;" qp.set_query(sql)
and running it with
After the processing is completed, the processor object
qp will include
tables, columns, functions, and keywords used in the query or will raise a
QuerySyntaxError if there are any syntax errors in the query.
Alternatively, passing the query at initialization automatically processes it.
PostgreSQL parsing is very similar to MySQL, except it requires importing
from queryparser.postgresql import PostgreSQLQueryProcessor qp = PostgreSQLQueryProcessor()
The rest of the functionality remains the same.
Translation of ADQL queries is done similarly by first creating an instance of
from queryparser.adql import ADQLQueryTranslator adql = "SELECT TOP 100 POINT('ICRS', ra, de) FROM db.tab;" adt = ADQLQueryTranslator(adql)
which returns a translated string representing a valid MySQL query if
the ADQL query had no errors. The MySQL query can then be parsed with the
MySQLQueryProcessor in the same way as shown above.
pip install pytest
then run the test suite for a version of python you would like to test with
More elaborate testing procedures can be found in the development notes.
Release history Release notifications | RSS feed
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Hashes for queryparser-python3-0.6.1.tar.gz
Hashes for queryparser_python3-0.6.1-py3-none-any.whl