Skip to main content

Module for working with PostgreSQL via asyncpg

Project description

https://travis-ci.org/aioworkers/aioworkers-pg.svg?branch=master Python versions https://img.shields.io/pypi/v/aioworkers-pg.svg

Asyncpg plugin for aioworkers.

Usage

Add this to aioworkers config.yaml:

db:
    cls: aioworkers_pg.base.Connector
    dsn: postgresql:///test

You can get access to postgres anywhere via context:

await context.db.execute('CREATE TABLE users(id serial PRIMARY KEY, name text)')
await context.db.execute(users.insert().values(name='Bob'))

Storage

storage:
    cls: aioworkers_pg.storage.RoStorage
    dsn: postgresql:///test
    table: mytable  # optional instead custom sql
    key: id
    get: SELECT * FROM mytable WHERE id = :id  # optional custom sql
    format: dict  # or row

Development

Install dev requirements:

pipenv install --dev --skip-lock

Run tests:

pytest

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Files for aioworkers-pg, version 0.2.0
Filename, size File type Python version Upload date Hashes
Filename, size aioworkers-pg-0.2.0.tar.gz (4.2 kB) File type Source Python version None Upload date Hashes View

Supported by

Pingdom Pingdom Monitoring Google Google Object Storage and Download Analytics Sentry Sentry Error logging AWS AWS Cloud computing DataDog DataDog Monitoring Fastly Fastly CDN DigiCert DigiCert EV certificate StatusPage StatusPage Status page