ticrobe.pgsql 26.4.2

tX.tDataStore PostgreSQL helper package for common database operations.

ticrobe.pgsql

Python package for PostgreSQL database operations.

Published package name: ticrobe.pgsql

Version: 26.4.2

Install

pip install ticrobe.pgsql

For local development from this workspace:

pip install -e .

Build and upload to PyPI

Build from inside src/tX.tPgSql:

python -m pip install --upgrade pip build twine
python -m build
python -m twine check dist/*

Upload using a PyPI API token:

python -m twine upload -u __token__ -p pypi-YOUR_API_TOKEN dist/*

Important:

• In twine, the "password" is your PyPI API token
• The username should be exactly __token__
• The package files are generated in src/tX.tPgSql/dist/

Quick start

import asyncio

from ticrobe.pgsql import DatabaseConfig, PostgresDB

async def main() -> None:
    config = DatabaseConfig(
        host="localhost",
        port=5432,
        database="mydb",
        schema="public",
        user="postgres",
        password="secret",
    )

    db = PostgresDB()
    await db.connect(config)
    await db.create_table(
        {
            "table_name": "users",
            "columns": {
            "id": "SERIAL PRIMARY KEY",
            "name": "VARCHAR(100) NOT NULL",
            "email": "VARCHAR(255) UNIQUE NOT NULL",
            "created_at": "TIMESTAMP DEFAULT CURRENT_TIMESTAMP",
        },
        },
    )

    user = await db.insert(
        {
            "name": "Asha",
            "email": "[e-mail]",
        },
        returning=("id", "name", "email"),
    )
    if user is None:
        raise RuntimeError("Insert failed")

    await db.update(
        user["id"],
        {"name": "Asha R"},
        returning=("id", "name", "email"),
    )
    rows = await db.fetch_all("SELECT * FROM users ORDER BY id")
    await db.delete(user["id"])
    await db.disconnect(config)


asyncio.run(main())

You can also load connection settings from PostgreSQL environment variables:

config = DatabaseConfig.from_env()

Supported environment variables include PGHOST, PGPORT, PGDATABASE, PGSCHEMA, PGUSER, PGPASSWORD, and PGCONNECT_TIMEOUT.