wrapg 0.1.3

Wrapper around psycopg3 using easy functions to interact with postgres.

wrapg

Wrapper around psycopg 3.x meant to make easy use of postgres within scripts using simple functions.

Project is in infancy, work in progress.

Table of Contents

• Features
• Setup
• Usage
• Todo
• Acknowledgements
• Contact
• License

Features

• Simple functions to run postgres sql via python
• Pass various data structutes into sql functions
  • supports pandas dataframe out of box
• Auto import default postgres connection parameters via .env
  • saves on repeating code to specify connection
  • overide default connection parameters with kwargs in each function
  • see examples for more details (future)
• Upsert, insert_ignore functions included
  • automatically creates index
  • option to upsert/insert_ignore without creating index (future)
• Copy functions to follow postgres COPY protocol (today only csv is avail)

Setup

Dependencies:

• python 3.10+
• psycopg[binary]>=3.0.11
• pandas>=1.4.2

Usage

• TODO: add examples later

Todo

• Add delete_row, delete funtionality
• Handle JSON, ITERATOR?
• Add tests
• Make into package on pypi
• Optimize code after it is all working

Acknowledgements

This project built on great work by psycopg 3 and was inspired by dataset

Contact

Created by jturnercode - hope package is helps.

License

• MIT