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.6.tar.gz (11.2 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.6-py3-none-any.whl (14.2 kB view details)

Uploaded Python 3

File details

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

File metadata

  • Download URL: lazy_mysql-0.1.6.tar.gz
  • Upload date:
  • Size: 11.2 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.6.tar.gz
Algorithm Hash digest
SHA256 57ddba4251ef6e01f096663cc8339aad1fa804e27033c7c24458e5e664e2054a
MD5 8a62148561c82113c7a103cf2f4fb8d2
BLAKE2b-256 2f56e86df9fcc94f0b025b17b1b472c19927bcaff7e76b75c1c049b9e0bca431

See more details on using hashes here.

File details

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

File metadata

  • Download URL: lazy_mysql-0.1.6-py3-none-any.whl
  • Upload date:
  • Size: 14.2 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.6-py3-none-any.whl
Algorithm Hash digest
SHA256 754a43d570fad5920d7b99b67a858331a8f4962b7dfe366dde38195516b6aa4a
MD5 12e880027d80bfb715728b2b8b99a0cb
BLAKE2b-256 4aca6b5e997bf418fe959e1fc235b04fa73b80b329fdbef7fdb138b241b6656d

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