Skip to main content

Wrappers for PostgreSQL interaction using dataframes or dictionaries.

Project description

cheesefactory-database


A wrapper for psycopg2.

PyPI Latest Release PyPI status PyPI download month PyPI download week PyPI download day

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

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'")

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

cheesefactory-database-0.2.tar.gz (6.8 kB view details)

Uploaded Source

File details

Details for the file cheesefactory-database-0.2.tar.gz.

File metadata

  • Download URL: cheesefactory-database-0.2.tar.gz
  • Upload date:
  • Size: 6.8 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/2.0.0 pkginfo/1.5.0.1 requests/2.23.0 setuptools/46.0.0.post20200309 requests-toolbelt/0.9.1 tqdm/4.43.0 CPython/3.8.1

File hashes

Hashes for cheesefactory-database-0.2.tar.gz
Algorithm Hash digest
SHA256 1272cab9a04feba32c534b8fbc4fec28e15ed00329b26a08a4e1e85e050bbaae
MD5 17295c55b1462719231a320b7c46e328
BLAKE2b-256 a7596a0de13d9fdc23ac9c1ff7e4f4fd9e53401ea65eeb7ead7c14b9f43ee1bf

See more details on using hashes here.

Supported by

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