Skip to main content

A lazy MySQL client for Python.

Project description

lazy_mysql

A lightweight Python library for simplified MySQL database operations.

Features

  • Unified SQL execution interface
  • Export table structure to Markdown format
  • Query result formatting
  • Simplified insert, update, and select operations
  • Transaction support

Install / upgrade / uninstall

pip install lazy-mysql
pip install --upgrade lazy-mysql
pip uninstall lazy-mysql

Quick Start

from lazy_mysql.executor import SQLExecutor

# Initialize connection
config = {
    'host': 'your_mysql_host',
    'user': 'your_username',
    'password': 'your_password',
    'database': 'your_database'
}

executor = SQLExecutor(config)

# Query example
result = executor.select('your_table', ['column1', 'column2'])
print(result)

# Insert example
executor.insert('your_table', {'column1': 'value1', 'column2': 'value2'}, commit=True)

Requirements

  • mysql-connector-python>=9.4.0
  • pandas>=2.3.1

Note: Compatibility with versions below these requirements has not been verified.

License

This project is licensed under the MIT License.

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

lazy_mysql-0.1.2.tar.gz (10.0 kB view details)

Uploaded Source

Built Distribution

If you're not sure about the file name format, learn more about wheel file names.

lazy_mysql-0.1.2-py3-none-any.whl (13.0 kB view details)

Uploaded Python 3

File details

Details for the file lazy_mysql-0.1.2.tar.gz.

File metadata

  • Download URL: lazy_mysql-0.1.2.tar.gz
  • Upload date:
  • Size: 10.0 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/6.1.0 CPython/3.13.5

File hashes

Hashes for lazy_mysql-0.1.2.tar.gz
Algorithm Hash digest
SHA256 5aa32e727cfa230093351bd45c5807d85d26ac3e1b29fb48809a67da225f69a8
MD5 f5d1ce6959e4d379a73f052db01eec59
BLAKE2b-256 2a64d62d1c4851c088ce9c1e85cb2f1dba4256200c5f2ac6b966b2a370eeb781

See more details on using hashes here.

File details

Details for the file lazy_mysql-0.1.2-py3-none-any.whl.

File metadata

  • Download URL: lazy_mysql-0.1.2-py3-none-any.whl
  • Upload date:
  • Size: 13.0 kB
  • Tags: Python 3
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/6.1.0 CPython/3.13.5

File hashes

Hashes for lazy_mysql-0.1.2-py3-none-any.whl
Algorithm Hash digest
SHA256 41db77fe417db81b35515913d105b649ef56bcbfec245386e9803a1c6eefadf3
MD5 623dd38c81126966cfbcd484fbd6f244
BLAKE2b-256 138d2c8dd385ecbee3cff33380399a9180f7dce51692542ccbae1b02a82de077

See more details on using hashes here.

Supported by

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