Skip to main content

Hey! PostgreSQL SQL Executable Object

Project description

A simple executable object for dumping SQL from files into a PostgreSQL database through psycopg2.

__doc__

PGSQLExec is a simple interface for dumping SQL into a PostgreSQL database, often from a file, and maybe getting some results out.

The usage is usually something like:

(hey_pgsqlexec.PGSQLExec(self.conn)
 .append_file('txt/check_append.sql', localizer=self._dl)
 .execute()
 .get_rows()[0][0])

Essentially, PGSQLExec is a minimal, chaining wrapper around the psycopg2 Connection and Cursor classes to make the common case of working with pre-written, static SQL files easier.

Project details


Download files

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

Source Distribution

hey_pgsqlexec-1.0.2.tar.gz (3.9 kB view hashes)

Uploaded Source

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page