our-db 0.1.0

Database connectivity and configuration brick

our-db

Database connectivity, configuration, and migration brick. Part of the ourochronos ecosystem.

Installation

pip install our-db

# With async support
pip install our-db[async]

Usage

from our_db import get_cursor, get_config

# Database access
with get_cursor() as cur:
    cur.execute("SELECT * FROM my_table")
    rows = cur.fetchall()

# Configuration
config = get_config()
print(config.db_host, config.db_port)

Async

from our_db import async_cursor

async with async_cursor() as conn:
    rows = await conn.fetch("SELECT * FROM my_table")

Migrations

from our_db import MigrationRunner

runner = MigrationRunner(migrations_dir="./migrations")
runner.up()        # Apply pending
runner.status()    # Check status

Development

make dev    # Install with dev dependencies
make test   # Run tests
make lint   # Run linters