Skip to main content

Wrapper around psycopg2 to simplify the process of connecting to a PostgreSQL database and executing queries.

Project description

Simple PostgreSQL Interaction in Python

This project contains a Python script (simplepgsql.py) that provides a simple interface for interacting with a PostgreSQL database using psycopg2 library.

Getting Started

Install via PIP

Dependent Libraries

  • Python 3.6+
  • PostgreSQL
  • psycopg2 Python library
  • Pandas

Usage

from simplepgsql Import DBConnect

conn_params = {
        "host": config['DB']['DB_HOST'],
        "database": config['DB']['DB_NAME'],
        "user": config['DB']['DB_USER'].strip(),
        "password": config['DB']['DB_PASSWORD'].strip(),
        "port": config['DB']['DB_PORT'],
    }

_query_params = {
        "schema": "public",
        "table_name": "film_list",
        "columns": ["category", "price"],
        "aggregate": {
            "price": "SUM"
        },
        "conditions": {
            "length": (60, ">")
        },
        "order_by": ("price", "DESC"),
        "group_by": ["category", "price"],
        "limit": 10,
    }
    with DBConnect(conn_params, return_type=pd.DataFrame) as cursor:
        results = cursor.read(**_query_params)
        print(results)

Output

      category sum: price
0          New     109.78
1       Travel     109.78
2       Family      74.85
3        Games     129.74
4  Documentary      69.86
5    Animation      74.85
6       Sports     119.76
7       Comedy      94.81
8       Horror      89.82
9      Foreign      99.80

License

This project is licensed under the GNU GPL v3 License.

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

simplepgsql-0.1.0.tar.gz (31.9 kB view hashes)

Uploaded Source

Built Distribution

simplepgsql-0.1.0-py2.py3-none-any.whl (30.7 kB view hashes)

Uploaded Python 2 Python 3

Supported by

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