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.

PyPI

Project available on PyPI: https://pypi.org/project/lazy-mysql/

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.9.tar.gz (12.5 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.9-py3-none-any.whl (16.1 kB view details)

Uploaded Python 3

File details

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

File metadata

  • Download URL: lazy_mysql-0.1.9.tar.gz
  • Upload date:
  • Size: 12.5 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.9.tar.gz
Algorithm Hash digest
SHA256 7115bcae551b8849035202bad2a86081521239a2281a62ceb17e81fea78bd30d
MD5 3d2262040eec5e6f8ee87640e520fc70
BLAKE2b-256 aebc3c88a7de16dc8b777aa99dbdbc2717a8d5909bee2bf55ce2993519e9f680

See more details on using hashes here.

File details

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

File metadata

  • Download URL: lazy_mysql-0.1.9-py3-none-any.whl
  • Upload date:
  • Size: 16.1 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.9-py3-none-any.whl
Algorithm Hash digest
SHA256 5035296d91219a196d8fdaa7ed14ec9ae8bd70399b5b004f45f6140aca14327e
MD5 2846f5fcd9137f757ec1438fc1a43080
BLAKE2b-256 692221a99b4ec5cd2d979081f1af1a17526079d45fcce8a259e0469a3d89f220

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