Python wrapper for libpg_query
Project description
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)
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
pgparse-0.2.0.tar.gz
(1.6 MB
view hashes)