Skip to main content

Simplifies writing MySQL statements in non-ORM environments.

Project description

MySQL-statement-builder (mysqlsb)

...

Installation

pip install mysql-statement-builder

Usage

import mysql.connector
from mysql.connector import pooling
from contextlib import contextmanager

from mysqlsb import MySQLStatementBuilder, FetchType

# Setup a connection pool using the MySQL python connector
connection_pool = mysql.connector.pooling.MySQLConnectionPool(
    user='user',
    password='password',
    host='host',
    database='database',
    port='port',
    autocommit=False,
)


# Setup a method for recieving a connection from the connection pool
@contextmanager
def get_connection() -> pooling.PooledMySQLConnection:
    """
    Returns a MySQL connection that can be used for read/write.
    """
    connection = connection_pool.get_connection()
    try:
        yield connection
    finally:
        connection.close()


# Apply mysql-statement-builder to select data from the database
def get_user_from_database(user_id: int):
    with get_connection() as connection:
        mysql_statement = MySQLStatementBuilder(connection)
        user_data = mysql_statement \
            .select('users', ['id', 'username', 'email']) \
            .where('id = %s', [user_id]) \
            .execute(fetch_type=FetchType.FETCH_ONE, dictionary=True)

        if user_data is None:
            raise UserNotFoundException('User could not be found in database')

        user = User(**user_data)  # Unpack results dictionary into e.g. a Pydantic basemodel class
        return user

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

mysql-statement-builder-0.3.0.tar.gz (7.2 kB view details)

Uploaded Source

Built Distribution

mysql_statement_builder-0.3.0-py3-none-any.whl (9.0 kB view details)

Uploaded Python 3

File details

Details for the file mysql-statement-builder-0.3.0.tar.gz.

File metadata

File hashes

Hashes for mysql-statement-builder-0.3.0.tar.gz
Algorithm Hash digest
SHA256 6a445888167052df24e2c2f5092f088eb3459ea00503086c94745f28765a14e8
MD5 8b8978952659043f3323a77d73370cb3
BLAKE2b-256 83c317ca7cb8cb7844a644452d17a2d0a51abe76752184917e7aec174cd78915

See more details on using hashes here.

Provenance

File details

Details for the file mysql_statement_builder-0.3.0-py3-none-any.whl.

File metadata

File hashes

Hashes for mysql_statement_builder-0.3.0-py3-none-any.whl
Algorithm Hash digest
SHA256 6203f946a47d2b8de9d69d08d1f2381ba428e5e7b748119952928274e7c44126
MD5 8c9bd71ba2a3bd782226cde4c2e7e511
BLAKE2b-256 b3372f8c9fe9d31221cb4def7a0de7d6377045085d257267a8adb0d8e5cc439e

See more details on using hashes here.

Provenance

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page