wrapper for PostgreSQL queries with transaction and connection pooling support
Project description
elephant_parsel
wrapper for PostgreSQL queries with transaction and connection pooling support
This project is about making psycopg2 easier to use.
supported versions
Debian >=10, psycopg2 >=2.7, python >=3.7
installation
install using pipenv:
pipenv install elephant_parsel
basic usage
from elephant_parsel.postgres_db import PostgresDB, PostgresDBException
import logging
db = PostgresDB(connection_config=dict(
host='db.example.com',
port=5432,
dbname='the_database_name',
user='the_username',
password='****',
minconn=1,
maxconn=4
), logger=logging.getLogger(), connect=True, register_hstore=False)
server_version_string = db.query_one('select version()', None, column='version')
The connection_config
is used as kwargs for the psycopg2.ThreadedConnectionPool
, so it should support all libpq connection variables: https://www.postgresql.org/docs/current/libpq-connect.html#LIBPQ-PARAMKEYWORDS
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
elephant_parsel-1.1.2.tar.gz
(8.0 kB
view hashes)
Built Distribution
Close
Hashes for elephant_parsel-1.1.2-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 70f548f8a8555d7acfb298cdf82f82a8f20221e21938a1964f353408d5fa33da |
|
MD5 | 18d3ff357f21262ca764ee95a31e464b |
|
BLAKE2b-256 | 6eb19adafc2a404140711b7f0304c58de1d7757e23a082ef3b67032f7ea28543 |