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
Release history Release notifications | RSS feed
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)
Built Distribution
Filter files by name, interpreter, ABI, and platform.
If you're not sure about the file name format, learn more about wheel file names.
Copy a direct link to the current filters
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
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
5aa32e727cfa230093351bd45c5807d85d26ac3e1b29fb48809a67da225f69a8
|
|
| MD5 |
f5d1ce6959e4d379a73f052db01eec59
|
|
| BLAKE2b-256 |
2a64d62d1c4851c088ce9c1e85cb2f1dba4256200c5f2ac6b966b2a370eeb781
|
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
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
41db77fe417db81b35515913d105b649ef56bcbfec245386e9803a1c6eefadf3
|
|
| MD5 |
623dd38c81126966cfbcd484fbd6f244
|
|
| BLAKE2b-256 |
138d2c8dd385ecbee3cff33380399a9180f7dce51692542ccbae1b02a82de077
|