cheesefactory-database 0.4

Wrappers for PostgreSQL interaction using dataframes or dictionaries.

cheesefactory-database

---

A wrapper for psycopg2.

Main Features

• Built on psycopg2.
• Pandas dataframe support.
• Test table existence.
• Test field existence.

Note: This package is still in beta status. As such, future versions may not be backwards compatible and features may change.

Installation

The source is hosted at https://bitbucket.org/hellsgrannies/cheesefactory-database

pip install pandas

Dependencies

• psycopg2

License

Parameters

class CfPostgres(host: str = 127.0.0.1, port: int = 5432, user: str = None, password: str = None, database: str = None)

Handles the connection to a PostgreSQL database.

• host: PostgreSQL server hostname/IP.
• port: PostgreSQL server port.
• user: Username for authentication.
• password: Password for authentication.
• database: Database for connection

Examples

Connect to the remote SFTP server

from cheesefactory-database.postgresql import CfPostgres

# Establish connection
db = CfPostgres(host='myhostname', user='myusername', password='mypassword', database='mydatabase')

# Execute query
results = db.execute("SELECT first_name, last_name FROM person WHERE last_name = 'Smith'")