pgparse 0.2.0
Python wrapper for libpg_query
Installation
pip install pgparse
Example Usage
The following example shows how to create a dump and then read it in, and
iterate through the data of one of the tables.
import pprint
import pgparse
sql = "SELECT * FROM pg_catalog.pg_class WHERE relname = 'foo'"
print('Fingerprint: {}'.format(pgparse.fingerprint(sql)))
print('Normalized: {!r}'.format(pgparse.normalize(sql)))
parsed = pgparse.parse(sql)
pprint.pprint(parsed)
func = """\
CREATE FUNCTION sales_tax(subtotal real) RETURNS real AS $$
BEGIN
RETURN subtotal * 0.06;
END;
$$ LANGUAGE plpgsql;
"""
parsed = pgparse.parse_pgsql(func)
pprint.pprint(parsed)
For personal and professional use. You cannot resell or redistribute these repositories in their original state.
There are no reviews.