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
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.1.tar.gz
(9.8 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.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
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
0937788f27659ea88506cc3eaf9750b562e627d6a517a34a9cdb4a8d4a1ee959
|
|
| MD5 |
99c70c7478003c24d135631bc0e3a2f3
|
|
| BLAKE2b-256 |
21d7bb836945ee6aed28593ca5aa3c38e5b18521ec45eddf348394795ae60b92
|
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
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
35d69660c009fa7ed6e557bbee4f48cf258273f05051e70dbde0fe172fe80e55
|
|
| MD5 |
55fce2f7a9ca23581e8d5e0d3530390b
|
|
| BLAKE2b-256 |
53e12b509a7af42089340cc1a614665e18a4d777cfdccd31e6b6c7a0bc8aa374
|