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


Release history Release notifications

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 & hash File type Python version Upload date
hey_pgsqlexec-1.0.2.tar.gz (3.9 kB) View hashes Source None

Supported by

Elastic Elastic Search Pingdom Pingdom Monitoring Google Google BigQuery Sentry Sentry Error logging AWS AWS Cloud computing DataDog DataDog Monitoring Fastly Fastly CDN SignalFx SignalFx Supporter DigiCert DigiCert EV certificate StatusPage StatusPage Status page