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 / uninstall

pip install 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.1.tar.gz (9.8 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.1-py3-none-any.whl (12.9 kB view details)

Uploaded Python 3

File details

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

File metadata

  • Download URL: lazy_mysql-0.1.1.tar.gz
  • Upload date:
  • Size: 9.8 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.1.tar.gz
Algorithm Hash digest
SHA256 0937788f27659ea88506cc3eaf9750b562e627d6a517a34a9cdb4a8d4a1ee959
MD5 99c70c7478003c24d135631bc0e3a2f3
BLAKE2b-256 21d7bb836945ee6aed28593ca5aa3c38e5b18521ec45eddf348394795ae60b92

See more details on using hashes here.

File details

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

File metadata

  • Download URL: lazy_mysql-0.1.1-py3-none-any.whl
  • Upload date:
  • Size: 12.9 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.1-py3-none-any.whl
Algorithm Hash digest
SHA256 35d69660c009fa7ed6e557bbee4f48cf258273f05051e70dbde0fe172fe80e55
MD5 55fce2f7a9ca23581e8d5e0d3530390b
BLAKE2b-256 53e12b509a7af42089340cc1a614665e18a4d777cfdccd31e6b6c7a0bc8aa374

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