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.

Files for hey_pgsqlexec, version 1.0.2
Filename, size File type Python version Upload date Hashes
Filename, size hey_pgsqlexec-1.0.2.tar.gz (3.9 kB) File type Source Python version None Upload date Hashes View

Supported by

AWS AWS Cloud computing Datadog Datadog Monitoring DigiCert DigiCert EV certificate Facebook / Instagram Facebook / Instagram PSF Sponsor Fastly Fastly CDN Google Google Object Storage and Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Salesforce Salesforce PSF Sponsor Sentry Sentry Error logging StatusPage StatusPage Status page