pyqt-mysql-tools 0.1.0

Small helpers for using PyMySQL safely from PyQt applications.

pyqt-mysql-tools

Helpers for building PyQt applications that talk to MySQL through PyMySQL.

Install for PyQt6:

pip install "pyqt-mysql-tools[pyqt6]"

Install for PyQt5:

pip install "pyqt-mysql-tools[pyqt5]"

Use it from Python as pyqt_mysql_tools:

from pyqt_mysql_tools import ConnectionConfig, MySqlClient

config = ConnectionConfig(
    host="localhost",
    user="root",
    password="password",
    database="app_db",
)

client = MySqlClient(config)
rows = client.fetch_all("select id, name from users where active = %s", (True,))

Run a query from a Qt worker:

from pyqt_mysql_tools import ConnectionConfig, QueryWorker

worker = QueryWorker(
    ConnectionConfig.from_env(),
    "select id, name from users limit 10",
)
worker.finished.connect(print)
worker.failed.connect(lambda exc: print(f"Query failed: {exc}"))

Environment variables supported by ConnectionConfig.from_env():

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