ticrobe.pgsql 26.4.1

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.1

Install

pip install ticrobe.pgsql

For local development from this workspace:

pip install -e .

Build and upload to PyPI

Build from inside 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 tX.tPgSql/dist/

Quick start

from ticrobe.pgsql import DatabaseConfig, PostgresDB

config = DatabaseConfig(
    host="localhost",
    port=5432,
    database="mydb",
    schema="public",
    user="postgres",
    password="secret",
)

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

    db.insert("users", {"name": "Asha", "email": "[e-mail]"})
    db.update(
        "users",
        {"name": "Asha R"},
        "email = %s",
        ["[e-mail]"],
    )
    rows = db.fetch_all("SELECT * FROM users ORDER BY id")
    db.delete("users", "email = %s", ["[e-mail]"])

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.