pymysql-dist 0.1.0

Unofficial helper utilities for PyMySQL-based applications.

pymysql-dist

pymysql-dist is an unofficial support library for applications that use PyMySQL.

It provides small, readable helpers for connection settings, safe SQL snippets, basic CRUD operations, pagination, row normalization, and SQL script loading. The package is intentionally simple, so it can be used as a reference while building desktop or educational database applications.

This project is not affiliated with the PyMySQL project.

Installation

pip install pymysql-dist

Quick Example

from pymysql_dist import DatabaseConfig, connection, TableGateway

config = DatabaseConfig(
    host="localhost",
    user="root",
    password="",
    database="shop",
)

with connection(config) as conn:
    products = TableGateway(conn, "products")
    rows = products.all(order_by="id")

Environment Configuration

from pymysql_dist import DatabaseConfig

config = DatabaseConfig.from_env()

Default environment variables:

• MYSQL_HOST
• MYSQL_PORT
• MYSQL_USER
• MYSQL_PASSWORD
• MYSQL_DATABASE
• MYSQL_CHARSET

Modules

• pymysql_dist.config - database configuration.
• pymysql_dist.connection - connection helpers.
• pymysql_dist.crud - small table gateway.
• pymysql_dist.sql - SQL builders, filters, and sorting helpers.
• pymysql_dist.schema - SQL file loading and script execution.
• pymysql_dist.rows - row conversion helpers.
• pymysql_dist.pagination - pagination data structures.
• pymysql_dist.qt - lightweight table data adapters.