# Fast MySQL driver build in Cython (Sync and Async).
Created to be used in a project, this package is published to github for ease of management and installation across different modules.
## Installation
Install from `PyPi`
```bash
pip install sqlcycli
```
Install from `github`
```bash
pip install git+https://github.com/AresJef/SQLCyCli.git
```
For Linux systems, if you encounter the following error when installing the SQLCyCli dependency [mysqlclient](https://github.com/PyMySQL/mysqlclient):
```
Exception: Can not find valid pkg-config name.
Specify MYSQLCLIENT_CFLAGS and MYSQLCLIENT_LDFLAGS env vars manually
```
Try the following to fix dependency issue (source: [Stack Overflow](https://stackoverflow.com/questions/76585758/mysqlclient-cannot-install-via-pip-cannot-find-pkg-config-name-in-ubuntu)):
```bash
sudo apt-get install pkg-config python3-dev default-libmysqlclient-dev build-essential
```
## Requirements
- Python 3.10 or higher.
- MySQL 5.5 or higher.
## Features
- Written in [Cython](https://cython.org/) for optimal performance (especially for SELECT/INSERT query).
- All classes and methods are well documented and type annotated.
- Supports both `Sync` and `Async` connection to the server.
- API Compatiable with [PyMySQL](https://github.com/PyMySQL/PyMySQL) and [aiomysql](https://github.com/aio-libs/aiomysql).
- Support conversion (escape) for most of the native python types, and objects from libaray [numpy](https://github.com/numpy/numpy) and [pandas](https://github.com/pandas-dev/pandas). Does `NOT` support custom conversion (escape).
## Benchmark
The following result comes from [benchmark](./src/benchmark.py):
- Device: MacbookPro M1Pro(2E8P) 32GB
- Python: 3.12.4
- MySQL: 8.3.0
- mysqlclient: 2.2.4
- PyMySQL: 1.1.1
- aiomysql: 0.2.0
- asyncmy: 0.2.9
```
# Unit: second | Lower is better
name type rows insert-per-row insert-bulk select-per-row select-all
mysqlclient sync 50000 1.729575 0.435661 1.719481 0.117943
SQLCyCli sync 50000 2.165910 0.275736 2.215093 0.056679
PyMySQL sync 50000 2.553401 0.404618 4.212548 0.325706
SQLCyCli async 50000 3.347850 0.282364 4.153874 0.135656
aiomysql async 50000 3.478428 0.394711 5.101733 0.321200
asyncmy async 50000 3.665675 0.397671 5.483239 0.313418
```
```
# Unit: second | Lower is better
name type rows update-per-row update-all delete-per-row delete-all
mysqlclient sync 50000 1.735787 0.345561 1.531275 0.105109
SQLCyCli sync 50000 2.241458 0.343359 2.078324 0.104441
PyMySQL sync 50000 2.516349 0.344614 2.264735 0.104326
SQLCyCli async 50000 3.465996 0.343864 3.269337 0.103967
aiomysql async 50000 3.534125 0.344573 3.345815 0.104281
asyncmy async 50000 3.695764 0.352104 3.460674 0.104523
```
## Usage
### Use `connect()` to create a connection (`Sync` or `Async`) with the server.
```python
import asyncio
import sqlcycli
HOST = "localhost"
PORT = 3306
USER = "root"
PSWD = "password"
# Connection (Sync & Async)
async def test_connection() -> None:
# Sync Connection - - - - - - - - - - - - - - - - - -
with sqlcycli.connect(HOST, PORT, USER, PSWD) as conn:
with conn.cursor() as cur:
cur.execute("SELECT 1")
assert cur.fetchone() == (1,)
# Connection closed
assert conn.closed()
# Async Connection - - - - - - - - - - - - - - - - -
async with sqlcycli.connect(HOST, PORT, USER, PSWD) as conn:
async with conn.cursor() as cur:
await cur.execute("SELECT 1")
assert await cur.fetchone() == (1,)
# Connection closed
assert conn.closed()
if __name__ == "__main__":
asyncio.run(test_connection())
```
### Use `create_pool()` to create a Pool for managing and maintaining connections (`Sync` or `Async`) with the server.
```python
import asyncio
import sqlcycli
HOST = "localhost"
PORT = 3306
USER = "root"
PSWD = "password"
# Pool (Context: Connected)
async def test_pool_context_connected() -> None:
async with sqlcycli.create_pool(HOST, PORT, USER, PSWD, min_size=1) as pool:
# Pool is connected: 1 free connection (min_size=1)
assert not pool.closed() and pool.free == 1
# Sync Connection - - - - - - - - - - - - - - - - - -
with pool.acquire() as conn:
with conn.cursor() as cur:
cur.execute("SELECT 1")
assert cur.fetchone() == (1,)
# Async Connection - - - - - - - - - - - - - - - - -
async with pool.acquire() as conn:
async with conn.cursor() as cur:
await cur.execute("SELECT 1")
assert await cur.fetchone() == (1,)
# Pool closed
assert pool.closed() and pool.total == 0
# Pool (Context: Disconnected)
async def test_pool_context_disconnected() -> None:
with sqlcycli.create_pool(HOST, PORT, USER, PSWD, min_size=1) as pool:
# Pool is not connected: 0 free connection (min_size=1)
assert pool.closed() and pool.free == 0
# Sync Connection - - - - - - - - - - - - - - - - - -
with pool.acquire() as conn:
with conn.cursor() as cur:
cur.execute("SELECT 1")
assert cur.fetchone() == (1,)
# Async Connection - - - - - - - - - - - - - - - - -
async with pool.acquire() as conn:
async with conn.cursor() as cur:
await cur.execute("SELECT 1")
assert await cur.fetchone() == (1,)
# 1 free async connection
assert pool.free == 1
# Pool closed
assert pool.closed() and pool.total == 0
if __name__ == "__main__":
asyncio.run(test_pool_context_connected())
asyncio.run(test_pool_context_disconnected())
```
### Use the `Pool` class to create a Pool instance. `Must close manually`.
```python
import asyncio
import sqlcycli
HOST = "localhost"
PORT = 3306
USER = "root"
PSWD = "password"
# Pool (Instance: Connected)
async def test_pool_instance_connected() -> None:
pool = await sqlcycli.create_pool(HOST, PORT, USER, PSWD, min_size=1)
# Pool is connected: 1 free connection (min_size=1)
assert not pool.closed() and pool.free == 1
# Sync Connection - - - - - - - - - - - - - - - - - -
with pool.acquire() as conn:
with conn.cursor() as cur:
cur.execute("SELECT 1")
assert cur.fetchone() == (1,)
# Async Connection - - - - - - - - - - - - - - - - -
async with pool.acquire() as conn:
async with conn.cursor() as cur:
await cur.execute("SELECT 1")
assert await cur.fetchone() == (1,)
# Close pool manually
await pool.close()
assert pool.closed() and pool.total == 0
# Pool (Instance: Disconnected)
async def test_pool_instance_disconnected() -> None:
pool = sqlcycli.Pool(HOST, PORT, USER, PSWD, min_size=1)
# Pool is not connected: 0 free connection (min_size=1)
assert pool.closed() and pool.free == 0
# Sync Connection - - - - - - - - - - - - - - - - - -
with pool.acquire() as conn:
with conn.cursor() as cur:
cur.execute("SELECT 1")
assert cur.fetchone() == (1,)
# Async Connection - - - - - - - - - - - - - - - - -
async with pool.acquire() as conn:
async with conn.cursor() as cur:
await cur.execute("SELECT 1")
assert await cur.fetchone() == (1,)
# 1 free async connection
assert pool.free == 1
# Close pool manually
await pool.close()
assert pool.closed() and pool.total == 0
if __name__ == "__main__":
asyncio.run(test_pool_instance_connected())
asyncio.run(test_pool_instance_disconnected())
```
### Use the `sqlfunc` module to escape values for MySQL functions.
```python
import asyncio
import datetime
import sqlcycli
from sqlcycli import sqlfunc
HOST = "localhost"
PORT = 3306
USER = "root"
PSWD = "Password_123456"
# SQLFunction
def test_sqlfunction() -> None:
with sqlcycli.connect(HOST, PORT, USER, PSWD) as conn:
with conn.cursor() as cur:
cur.execute("SELECT %s", sqlfunc.TO_DAYS(datetime.date(2007, 10, 7)))
# SQLFunction 'TO_DAYS()' escaped as: TO_DAYS('2007-10-07')
assert cur.executed_sql == "SELECT TO_DAYS('2007-10-07')"
assert cur.fetchone() == (733321,)
# Connection closed
assert conn.closed()
if __name__ == "__main__":
test_sqlfunction()
```
## Acknowledgements
SQLCyCli is build on top of the following open-source repositories:
- [aiomysql](https://github.com/aio-libs/aiomysql)
- [PyMySQL](https://github.com/PyMySQL/PyMySQL)
SQLCyCli is based on the following open-source repositories:
- [numpy](https://github.com/numpy/numpy)
- [orjson](https://github.com/ijl/orjson)
- [pandas](https://github.com/pandas-dev/pandas)
- [mysqlclient](https://github.com/PyMySQL/mysqlclient)
Raw data
{
"_id": null,
"home_page": "https://github.com/AresJef/SQLCyCli",
"name": "sqlcycli",
"maintainer": null,
"docs_url": null,
"requires_python": ">=3.10",
"maintainer_email": null,
"keywords": "mysql, mariadb, pymysql, aiomysql, cython, asyncio",
"author": "Jiefu Chen",
"author_email": "keppa1991@163.com",
"download_url": "https://files.pythonhosted.org/packages/63/7a/ddcab32b1752ff875514acabdfece0696ad06fe7e21def48ef3d748a364d/sqlcycli-1.3.4.tar.gz",
"platform": null,
"description": "# Fast MySQL driver build in Cython (Sync and Async).\n\nCreated to be used in a project, this package is published to github for ease of management and installation across different modules.\n\n## Installation\n\nInstall from `PyPi`\n\n```bash\npip install sqlcycli\n```\n\nInstall from `github`\n\n```bash\npip install git+https://github.com/AresJef/SQLCyCli.git\n```\n\nFor Linux systems, if you encounter the following error when installing the SQLCyCli dependency [mysqlclient](https://github.com/PyMySQL/mysqlclient):\n\n```\nException: Can not find valid pkg-config name.\nSpecify MYSQLCLIENT_CFLAGS and MYSQLCLIENT_LDFLAGS env vars manually\n```\n\nTry the following to fix dependency issue (source: [Stack Overflow](https://stackoverflow.com/questions/76585758/mysqlclient-cannot-install-via-pip-cannot-find-pkg-config-name-in-ubuntu)):\n\n```bash\nsudo apt-get install pkg-config python3-dev default-libmysqlclient-dev build-essential\n```\n\n## Requirements\n\n- Python 3.10 or higher.\n- MySQL 5.5 or higher.\n\n## Features\n\n- Written in [Cython](https://cython.org/) for optimal performance (especially for SELECT/INSERT query).\n- All classes and methods are well documented and type annotated.\n- Supports both `Sync` and `Async` connection to the server.\n- API Compatiable with [PyMySQL](https://github.com/PyMySQL/PyMySQL) and [aiomysql](https://github.com/aio-libs/aiomysql).\n- Support conversion (escape) for most of the native python types, and objects from libaray [numpy](https://github.com/numpy/numpy) and [pandas](https://github.com/pandas-dev/pandas). Does `NOT` support custom conversion (escape).\n\n## Benchmark\n\nThe following result comes from [benchmark](./src/benchmark.py):\n\n- Device: MacbookPro M1Pro(2E8P) 32GB\n- Python: 3.12.4\n- MySQL: 8.3.0\n- mysqlclient: 2.2.4\n- PyMySQL: 1.1.1\n- aiomysql: 0.2.0\n- asyncmy: 0.2.9\n\n```\n# Unit: second | Lower is better\nname type rows insert-per-row insert-bulk select-per-row select-all\nmysqlclient sync 50000 1.729575 0.435661 1.719481 0.117943\nSQLCyCli sync 50000 2.165910 0.275736 2.215093 0.056679\nPyMySQL sync 50000 2.553401 0.404618 4.212548 0.325706\nSQLCyCli async 50000 3.347850 0.282364 4.153874 0.135656\naiomysql async 50000 3.478428 0.394711 5.101733 0.321200\nasyncmy async 50000 3.665675 0.397671 5.483239 0.313418\n```\n\n```\n# Unit: second | Lower is better\nname type rows update-per-row update-all delete-per-row delete-all\nmysqlclient sync 50000 1.735787 0.345561 1.531275 0.105109\nSQLCyCli sync 50000 2.241458 0.343359 2.078324 0.104441\nPyMySQL sync 50000 2.516349 0.344614 2.264735 0.104326\nSQLCyCli async 50000 3.465996 0.343864 3.269337 0.103967\naiomysql async 50000 3.534125 0.344573 3.345815 0.104281\nasyncmy async 50000 3.695764 0.352104 3.460674 0.104523\n```\n\n## Usage\n\n### Use `connect()` to create a connection (`Sync` or `Async`) with the server.\n\n```python\nimport asyncio\nimport sqlcycli\n\nHOST = \"localhost\"\nPORT = 3306\nUSER = \"root\"\nPSWD = \"password\"\n\n# Connection (Sync & Async)\nasync def test_connection() -> None:\n # Sync Connection - - - - - - - - - - - - - - - - - -\n with sqlcycli.connect(HOST, PORT, USER, PSWD) as conn:\n with conn.cursor() as cur:\n cur.execute(\"SELECT 1\")\n assert cur.fetchone() == (1,)\n\n # Connection closed\n assert conn.closed()\n\n # Async Connection - - - - - - - - - - - - - - - - -\n async with sqlcycli.connect(HOST, PORT, USER, PSWD) as conn:\n async with conn.cursor() as cur:\n await cur.execute(\"SELECT 1\")\n assert await cur.fetchone() == (1,)\n\n # Connection closed\n assert conn.closed()\n\nif __name__ == \"__main__\":\n asyncio.run(test_connection())\n```\n\n### Use `create_pool()` to create a Pool for managing and maintaining connections (`Sync` or `Async`) with the server.\n\n```python\nimport asyncio\nimport sqlcycli\n\nHOST = \"localhost\"\nPORT = 3306\nUSER = \"root\"\nPSWD = \"password\"\n\n# Pool (Context: Connected)\nasync def test_pool_context_connected() -> None:\n async with sqlcycli.create_pool(HOST, PORT, USER, PSWD, min_size=1) as pool:\n # Pool is connected: 1 free connection (min_size=1)\n assert not pool.closed() and pool.free == 1\n\n # Sync Connection - - - - - - - - - - - - - - - - - -\n with pool.acquire() as conn:\n with conn.cursor() as cur:\n cur.execute(\"SELECT 1\")\n assert cur.fetchone() == (1,)\n\n # Async Connection - - - - - - - - - - - - - - - - -\n async with pool.acquire() as conn:\n async with conn.cursor() as cur:\n await cur.execute(\"SELECT 1\")\n assert await cur.fetchone() == (1,)\n\n # Pool closed\n assert pool.closed() and pool.total == 0\n\n# Pool (Context: Disconnected)\nasync def test_pool_context_disconnected() -> None:\n with sqlcycli.create_pool(HOST, PORT, USER, PSWD, min_size=1) as pool:\n # Pool is not connected: 0 free connection (min_size=1)\n assert pool.closed() and pool.free == 0\n\n # Sync Connection - - - - - - - - - - - - - - - - - -\n with pool.acquire() as conn:\n with conn.cursor() as cur:\n cur.execute(\"SELECT 1\")\n assert cur.fetchone() == (1,)\n\n # Async Connection - - - - - - - - - - - - - - - - -\n async with pool.acquire() as conn:\n async with conn.cursor() as cur:\n await cur.execute(\"SELECT 1\")\n assert await cur.fetchone() == (1,)\n # 1 free async connection\n assert pool.free == 1\n\n # Pool closed\n assert pool.closed() and pool.total == 0\n\nif __name__ == \"__main__\":\n asyncio.run(test_pool_context_connected())\n asyncio.run(test_pool_context_disconnected())\n```\n\n### Use the `Pool` class to create a Pool instance. `Must close manually`.\n\n```python\nimport asyncio\nimport sqlcycli\n\nHOST = \"localhost\"\nPORT = 3306\nUSER = \"root\"\nPSWD = \"password\"\n\n# Pool (Instance: Connected)\nasync def test_pool_instance_connected() -> None:\n pool = await sqlcycli.create_pool(HOST, PORT, USER, PSWD, min_size=1)\n # Pool is connected: 1 free connection (min_size=1)\n assert not pool.closed() and pool.free == 1\n\n # Sync Connection - - - - - - - - - - - - - - - - - -\n with pool.acquire() as conn:\n with conn.cursor() as cur:\n cur.execute(\"SELECT 1\")\n assert cur.fetchone() == (1,)\n\n # Async Connection - - - - - - - - - - - - - - - - -\n async with pool.acquire() as conn:\n async with conn.cursor() as cur:\n await cur.execute(\"SELECT 1\")\n assert await cur.fetchone() == (1,)\n\n # Close pool manually\n await pool.close()\n assert pool.closed() and pool.total == 0\n\n\n# Pool (Instance: Disconnected)\nasync def test_pool_instance_disconnected() -> None:\n pool = sqlcycli.Pool(HOST, PORT, USER, PSWD, min_size=1)\n # Pool is not connected: 0 free connection (min_size=1)\n assert pool.closed() and pool.free == 0\n\n # Sync Connection - - - - - - - - - - - - - - - - - -\n with pool.acquire() as conn:\n with conn.cursor() as cur:\n cur.execute(\"SELECT 1\")\n assert cur.fetchone() == (1,)\n\n # Async Connection - - - - - - - - - - - - - - - - -\n async with pool.acquire() as conn:\n async with conn.cursor() as cur:\n await cur.execute(\"SELECT 1\")\n assert await cur.fetchone() == (1,)\n # 1 free async connection\n assert pool.free == 1\n\n # Close pool manually\n await pool.close()\n assert pool.closed() and pool.total == 0\n\nif __name__ == \"__main__\":\n asyncio.run(test_pool_instance_connected())\n asyncio.run(test_pool_instance_disconnected())\n```\n\n### Use the `sqlfunc` module to escape values for MySQL functions.\n\n```python\nimport asyncio\nimport datetime\nimport sqlcycli\nfrom sqlcycli import sqlfunc\n\nHOST = \"localhost\"\nPORT = 3306\nUSER = \"root\"\nPSWD = \"Password_123456\"\n\n# SQLFunction\ndef test_sqlfunction() -> None:\n with sqlcycli.connect(HOST, PORT, USER, PSWD) as conn:\n with conn.cursor() as cur:\n cur.execute(\"SELECT %s\", sqlfunc.TO_DAYS(datetime.date(2007, 10, 7)))\n # SQLFunction 'TO_DAYS()' escaped as: TO_DAYS('2007-10-07')\n assert cur.executed_sql == \"SELECT TO_DAYS('2007-10-07')\"\n assert cur.fetchone() == (733321,)\n\n # Connection closed\n assert conn.closed()\n\nif __name__ == \"__main__\":\n test_sqlfunction()\n```\n\n## Acknowledgements\n\nSQLCyCli is build on top of the following open-source repositories:\n\n- [aiomysql](https://github.com/aio-libs/aiomysql)\n- [PyMySQL](https://github.com/PyMySQL/PyMySQL)\n\nSQLCyCli is based on the following open-source repositories:\n\n- [numpy](https://github.com/numpy/numpy)\n- [orjson](https://github.com/ijl/orjson)\n- [pandas](https://github.com/pandas-dev/pandas)\n- [mysqlclient](https://github.com/PyMySQL/mysqlclient)\n",
"bugtrack_url": null,
"license": "MIT license",
"summary": "Fast MySQL driver build in Cython (Sync and Async).",
"version": "1.3.4",
"project_urls": {
"Homepage": "https://github.com/AresJef/SQLCyCli"
},
"split_keywords": [
"mysql",
" mariadb",
" pymysql",
" aiomysql",
" cython",
" asyncio"
],
"urls": [
{
"comment_text": null,
"digests": {
"blake2b_256": "78dc95454c7f6b984d1cfca8fed1971cd82c9c7bb7f1886ec4a940d728f411f7",
"md5": "64c90ccafe63bcdfc28989d175e4f330",
"sha256": "f5b6863c58a007236ce86af86118a1a797c1f788b21ac1849b6b3892042b0597"
},
"downloads": -1,
"filename": "sqlcycli-1.3.4-cp310-cp310-macosx_10_9_universal2.whl",
"has_sig": false,
"md5_digest": "64c90ccafe63bcdfc28989d175e4f330",
"packagetype": "bdist_wheel",
"python_version": "cp310",
"requires_python": ">=3.10",
"size": 8524192,
"upload_time": "2025-02-13T10:37:43",
"upload_time_iso_8601": "2025-02-13T10:37:43.183337Z",
"url": "https://files.pythonhosted.org/packages/78/dc/95454c7f6b984d1cfca8fed1971cd82c9c7bb7f1886ec4a940d728f411f7/sqlcycli-1.3.4-cp310-cp310-macosx_10_9_universal2.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": null,
"digests": {
"blake2b_256": "259464d12bcbe738321e739cdceaffde71775579d2a8d563194faefdf9673ed0",
"md5": "bb68e4782aaf6cad32d9e23622610440",
"sha256": "61927e678a469d3ac5010d4c4e7ca131cb5ae0215d43dc227aac44fecfa353f1"
},
"downloads": -1,
"filename": "sqlcycli-1.3.4-cp310-cp310-macosx_10_9_x86_64.whl",
"has_sig": false,
"md5_digest": "bb68e4782aaf6cad32d9e23622610440",
"packagetype": "bdist_wheel",
"python_version": "cp310",
"requires_python": ">=3.10",
"size": 6272263,
"upload_time": "2025-02-13T10:37:46",
"upload_time_iso_8601": "2025-02-13T10:37:46.224873Z",
"url": "https://files.pythonhosted.org/packages/25/94/64d12bcbe738321e739cdceaffde71775579d2a8d563194faefdf9673ed0/sqlcycli-1.3.4-cp310-cp310-macosx_10_9_x86_64.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": null,
"digests": {
"blake2b_256": "70dafc86f0955cf5afa1a26c698647386f765d48b65fa4edd7be91ce2100f321",
"md5": "e1ec570365d61dd32c3593d705b023d7",
"sha256": "8deeb59e692b15b94b5016a3e81214bd74860f63456d26d34ae870986ba97655"
},
"downloads": -1,
"filename": "sqlcycli-1.3.4-cp310-cp310-macosx_11_0_arm64.whl",
"has_sig": false,
"md5_digest": "e1ec570365d61dd32c3593d705b023d7",
"packagetype": "bdist_wheel",
"python_version": "cp310",
"requires_python": ">=3.10",
"size": 5935432,
"upload_time": "2025-02-13T10:37:48",
"upload_time_iso_8601": "2025-02-13T10:37:48.274486Z",
"url": "https://files.pythonhosted.org/packages/70/da/fc86f0955cf5afa1a26c698647386f765d48b65fa4edd7be91ce2100f321/sqlcycli-1.3.4-cp310-cp310-macosx_11_0_arm64.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": null,
"digests": {
"blake2b_256": "72d756e9903cf4908aa303a6fcf300e68df868062df20245f7527c06940d14c4",
"md5": "bf117b0bf58fca7b4bab355d6b9a9dd7",
"sha256": "8fe82fa0910cac9c623e0338dbb75a0497bf7194f3f264b97c96cb2c5d1993c6"
},
"downloads": -1,
"filename": "sqlcycli-1.3.4-cp310-cp310-manylinux_2_17_x86_64.manylinux2014_x86_64.whl",
"has_sig": false,
"md5_digest": "bf117b0bf58fca7b4bab355d6b9a9dd7",
"packagetype": "bdist_wheel",
"python_version": "cp310",
"requires_python": ">=3.10",
"size": 20389758,
"upload_time": "2025-02-13T10:37:51",
"upload_time_iso_8601": "2025-02-13T10:37:51.104027Z",
"url": "https://files.pythonhosted.org/packages/72/d7/56e9903cf4908aa303a6fcf300e68df868062df20245f7527c06940d14c4/sqlcycli-1.3.4-cp310-cp310-manylinux_2_17_x86_64.manylinux2014_x86_64.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": null,
"digests": {
"blake2b_256": "03910b44dbebfdc60406fe451098fcecf39b80be424df343b5c03806c8f71a9e",
"md5": "595116ed80037c6189a09225e679f7ea",
"sha256": "62c03fdcd3f0d7b75fdceb4d0f135f5d0405c24dc06de66807fce88858c8ae92"
},
"downloads": -1,
"filename": "sqlcycli-1.3.4-cp310-cp310-musllinux_1_2_x86_64.whl",
"has_sig": false,
"md5_digest": "595116ed80037c6189a09225e679f7ea",
"packagetype": "bdist_wheel",
"python_version": "cp310",
"requires_python": ">=3.10",
"size": 18081120,
"upload_time": "2025-02-13T10:37:56",
"upload_time_iso_8601": "2025-02-13T10:37:56.427701Z",
"url": "https://files.pythonhosted.org/packages/03/91/0b44dbebfdc60406fe451098fcecf39b80be424df343b5c03806c8f71a9e/sqlcycli-1.3.4-cp310-cp310-musllinux_1_2_x86_64.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": null,
"digests": {
"blake2b_256": "cd083f4a7a081db8eff5197bef780c9832cb322f0c618b3a37e85fadc48b4ccc",
"md5": "6563e2eba0fabf9c7e69419a4a7c746a",
"sha256": "8481e4550da214e3dadbdcf4cfe7f68e57970d9e24e6bf9c5397ed75fa39b0b6"
},
"downloads": -1,
"filename": "sqlcycli-1.3.4-cp310-cp310-win_amd64.whl",
"has_sig": false,
"md5_digest": "6563e2eba0fabf9c7e69419a4a7c746a",
"packagetype": "bdist_wheel",
"python_version": "cp310",
"requires_python": ">=3.10",
"size": 5964731,
"upload_time": "2025-02-13T10:38:00",
"upload_time_iso_8601": "2025-02-13T10:38:00.377429Z",
"url": "https://files.pythonhosted.org/packages/cd/08/3f4a7a081db8eff5197bef780c9832cb322f0c618b3a37e85fadc48b4ccc/sqlcycli-1.3.4-cp310-cp310-win_amd64.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": null,
"digests": {
"blake2b_256": "58128fe028900181c64cab75c78d5bffa007631179d4da49f1dc6cf8fa552e95",
"md5": "50c886e2184424efa1af1f3e701b533e",
"sha256": "6005bb7364db5cd47aec368fa3bf48df08052e5911ada2ea7de406def9673870"
},
"downloads": -1,
"filename": "sqlcycli-1.3.4-cp311-cp311-macosx_10_9_universal2.whl",
"has_sig": false,
"md5_digest": "50c886e2184424efa1af1f3e701b533e",
"packagetype": "bdist_wheel",
"python_version": "cp311",
"requires_python": ">=3.10",
"size": 8574505,
"upload_time": "2025-02-13T10:38:02",
"upload_time_iso_8601": "2025-02-13T10:38:02.986711Z",
"url": "https://files.pythonhosted.org/packages/58/12/8fe028900181c64cab75c78d5bffa007631179d4da49f1dc6cf8fa552e95/sqlcycli-1.3.4-cp311-cp311-macosx_10_9_universal2.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": null,
"digests": {
"blake2b_256": "95d3d6945cfd454f536f9da7474cd3ad4f268f363c0d7c9a0704ccf9faf9de67",
"md5": "d08dd6828175900b3fada94eadaaf010",
"sha256": "332faf5d723a45262d3b07a5587eae639ecc7f0bc07e31dee1808336d3466e06"
},
"downloads": -1,
"filename": "sqlcycli-1.3.4-cp311-cp311-macosx_10_9_x86_64.whl",
"has_sig": false,
"md5_digest": "d08dd6828175900b3fada94eadaaf010",
"packagetype": "bdist_wheel",
"python_version": "cp311",
"requires_python": ">=3.10",
"size": 6306557,
"upload_time": "2025-02-13T10:38:05",
"upload_time_iso_8601": "2025-02-13T10:38:05.350881Z",
"url": "https://files.pythonhosted.org/packages/95/d3/d6945cfd454f536f9da7474cd3ad4f268f363c0d7c9a0704ccf9faf9de67/sqlcycli-1.3.4-cp311-cp311-macosx_10_9_x86_64.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": null,
"digests": {
"blake2b_256": "47e096f58b9eecd2592380a58395b4c1fafac2d6d59fef7996b86139d39ecbc3",
"md5": "2fd106b714692a758d8a144249b7cab1",
"sha256": "9ed599b341bfa0309668a3d6e473013a6ecb8a7a6022a78582d5bd7a872f7bca"
},
"downloads": -1,
"filename": "sqlcycli-1.3.4-cp311-cp311-macosx_11_0_arm64.whl",
"has_sig": false,
"md5_digest": "2fd106b714692a758d8a144249b7cab1",
"packagetype": "bdist_wheel",
"python_version": "cp311",
"requires_python": ">=3.10",
"size": 5951397,
"upload_time": "2025-02-13T10:38:07",
"upload_time_iso_8601": "2025-02-13T10:38:07.245064Z",
"url": "https://files.pythonhosted.org/packages/47/e0/96f58b9eecd2592380a58395b4c1fafac2d6d59fef7996b86139d39ecbc3/sqlcycli-1.3.4-cp311-cp311-macosx_11_0_arm64.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": null,
"digests": {
"blake2b_256": "7ca60e23fb16bef1b442561f1828622c9ae71c2cec81caf14c5f514ebffbf43a",
"md5": "9acccc84f22dd691c0ca15e364099d3c",
"sha256": "51def1849ace707cbc7c93e5b5dca02cd4a60be1510dcb8d1d2be3635fabc67d"
},
"downloads": -1,
"filename": "sqlcycli-1.3.4-cp311-cp311-manylinux_2_17_x86_64.manylinux2014_x86_64.whl",
"has_sig": false,
"md5_digest": "9acccc84f22dd691c0ca15e364099d3c",
"packagetype": "bdist_wheel",
"python_version": "cp311",
"requires_python": ">=3.10",
"size": 22475248,
"upload_time": "2025-02-13T10:38:10",
"upload_time_iso_8601": "2025-02-13T10:38:10.564171Z",
"url": "https://files.pythonhosted.org/packages/7c/a6/0e23fb16bef1b442561f1828622c9ae71c2cec81caf14c5f514ebffbf43a/sqlcycli-1.3.4-cp311-cp311-manylinux_2_17_x86_64.manylinux2014_x86_64.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": null,
"digests": {
"blake2b_256": "2e33f0393e221a58f7801043c45828fbd6a0b2216ee49b28dfc8925ed40e70c1",
"md5": "300076d06cab909bba243035c6077f6d",
"sha256": "13aa292df4713b30fe527a62d8387bae49822f396f8e59e9b2cdd55f7e7223db"
},
"downloads": -1,
"filename": "sqlcycli-1.3.4-cp311-cp311-musllinux_1_2_x86_64.whl",
"has_sig": false,
"md5_digest": "300076d06cab909bba243035c6077f6d",
"packagetype": "bdist_wheel",
"python_version": "cp311",
"requires_python": ">=3.10",
"size": 19997600,
"upload_time": "2025-02-13T10:38:15",
"upload_time_iso_8601": "2025-02-13T10:38:15.062724Z",
"url": "https://files.pythonhosted.org/packages/2e/33/f0393e221a58f7801043c45828fbd6a0b2216ee49b28dfc8925ed40e70c1/sqlcycli-1.3.4-cp311-cp311-musllinux_1_2_x86_64.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": null,
"digests": {
"blake2b_256": "75ea6012957118ef5f5573b741785d795632778cebdbdc508b77a45df6a1f86f",
"md5": "e6eb0876a0a499d987f6547e2c7cdb72",
"sha256": "4446bd13c21cc1ced38b08aaad8e8413fefda5a40e51a1b9d6ea9959750467d8"
},
"downloads": -1,
"filename": "sqlcycli-1.3.4-cp311-cp311-win_amd64.whl",
"has_sig": false,
"md5_digest": "e6eb0876a0a499d987f6547e2c7cdb72",
"packagetype": "bdist_wheel",
"python_version": "cp311",
"requires_python": ">=3.10",
"size": 5972084,
"upload_time": "2025-02-13T10:38:18",
"upload_time_iso_8601": "2025-02-13T10:38:18.277825Z",
"url": "https://files.pythonhosted.org/packages/75/ea/6012957118ef5f5573b741785d795632778cebdbdc508b77a45df6a1f86f/sqlcycli-1.3.4-cp311-cp311-win_amd64.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": null,
"digests": {
"blake2b_256": "92681275eb3bb00e097589947a89129d6c4d6541f5a88611dc4d5f018aad3936",
"md5": "5549fc8426eee2667d633b504dd63b44",
"sha256": "453e4b5f468893fedff8e6a1200a1e71f45957aff4b9591f3c819590c7e509c0"
},
"downloads": -1,
"filename": "sqlcycli-1.3.4-cp312-cp312-macosx_10_9_universal2.whl",
"has_sig": false,
"md5_digest": "5549fc8426eee2667d633b504dd63b44",
"packagetype": "bdist_wheel",
"python_version": "cp312",
"requires_python": ">=3.10",
"size": 8569434,
"upload_time": "2025-02-13T10:38:21",
"upload_time_iso_8601": "2025-02-13T10:38:21.061100Z",
"url": "https://files.pythonhosted.org/packages/92/68/1275eb3bb00e097589947a89129d6c4d6541f5a88611dc4d5f018aad3936/sqlcycli-1.3.4-cp312-cp312-macosx_10_9_universal2.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": null,
"digests": {
"blake2b_256": "7527ce41868b670fddffed09acfef50b265bfcb6d47c65d4a707bd6a2c6963e7",
"md5": "a6435a841e025858ee80e3ffa5c6a570",
"sha256": "bb3829b9ccfe0b0bc1f31c6cb6745ead2a41c131ab7ed37680425e4404bcbcab"
},
"downloads": -1,
"filename": "sqlcycli-1.3.4-cp312-cp312-macosx_10_9_x86_64.whl",
"has_sig": false,
"md5_digest": "a6435a841e025858ee80e3ffa5c6a570",
"packagetype": "bdist_wheel",
"python_version": "cp312",
"requires_python": ">=3.10",
"size": 6266923,
"upload_time": "2025-02-13T10:38:23",
"upload_time_iso_8601": "2025-02-13T10:38:23.380747Z",
"url": "https://files.pythonhosted.org/packages/75/27/ce41868b670fddffed09acfef50b265bfcb6d47c65d4a707bd6a2c6963e7/sqlcycli-1.3.4-cp312-cp312-macosx_10_9_x86_64.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": null,
"digests": {
"blake2b_256": "5d1b4ec51d1ac07af26d22800b9c05c84e8656d88e15165a1a213443f9fdf19f",
"md5": "40deff74ab37d3c69b0fba00fa0c1333",
"sha256": "1e284c5e2f4a7618897992e0fd3000fc0cf8618419bb614883b5738f67d4e0fa"
},
"downloads": -1,
"filename": "sqlcycli-1.3.4-cp312-cp312-macosx_11_0_arm64.whl",
"has_sig": false,
"md5_digest": "40deff74ab37d3c69b0fba00fa0c1333",
"packagetype": "bdist_wheel",
"python_version": "cp312",
"requires_python": ">=3.10",
"size": 5986399,
"upload_time": "2025-02-13T10:38:26",
"upload_time_iso_8601": "2025-02-13T10:38:26.587287Z",
"url": "https://files.pythonhosted.org/packages/5d/1b/4ec51d1ac07af26d22800b9c05c84e8656d88e15165a1a213443f9fdf19f/sqlcycli-1.3.4-cp312-cp312-macosx_11_0_arm64.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": null,
"digests": {
"blake2b_256": "3c639e28441f61890cbb85bd288ab5470dd580f6815380e84faa3e9c08ec7c3c",
"md5": "26cff5075ef414e50fe1b13360b65241",
"sha256": "313f1c06e4c9114aded5fb7ecd8e99b93b4529b01b2000aa05b7a91dfc956265"
},
"downloads": -1,
"filename": "sqlcycli-1.3.4-cp312-cp312-manylinux_2_17_x86_64.manylinux2014_x86_64.whl",
"has_sig": false,
"md5_digest": "26cff5075ef414e50fe1b13360b65241",
"packagetype": "bdist_wheel",
"python_version": "cp312",
"requires_python": ">=3.10",
"size": 22237545,
"upload_time": "2025-02-13T10:38:30",
"upload_time_iso_8601": "2025-02-13T10:38:30.771362Z",
"url": "https://files.pythonhosted.org/packages/3c/63/9e28441f61890cbb85bd288ab5470dd580f6815380e84faa3e9c08ec7c3c/sqlcycli-1.3.4-cp312-cp312-manylinux_2_17_x86_64.manylinux2014_x86_64.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": null,
"digests": {
"blake2b_256": "708854258e910e14423c712cc757bd7d3cadae3bf63dc39fffd05706b2c8a7f1",
"md5": "96828a014064e40a5baaf5d22268058e",
"sha256": "01bc5966fc24e3f8e9e98567281f27fc8d09aba1951babc9137c478c929d97c2"
},
"downloads": -1,
"filename": "sqlcycli-1.3.4-cp312-cp312-musllinux_1_2_x86_64.whl",
"has_sig": false,
"md5_digest": "96828a014064e40a5baaf5d22268058e",
"packagetype": "bdist_wheel",
"python_version": "cp312",
"requires_python": ">=3.10",
"size": 20059465,
"upload_time": "2025-02-13T10:38:34",
"upload_time_iso_8601": "2025-02-13T10:38:34.783625Z",
"url": "https://files.pythonhosted.org/packages/70/88/54258e910e14423c712cc757bd7d3cadae3bf63dc39fffd05706b2c8a7f1/sqlcycli-1.3.4-cp312-cp312-musllinux_1_2_x86_64.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": null,
"digests": {
"blake2b_256": "d5c502c26e63f73738cdf08f11c2952bf47db4601a4821a70af1cc8c22585ded",
"md5": "39724bb6e6b89fe66ee6fb51ea4326e4",
"sha256": "c9bcdf96c3a85b08dae5a11d7e6401d0aa336fca52a8dca89ffe4ff9a9c5cc3b"
},
"downloads": -1,
"filename": "sqlcycli-1.3.4-cp312-cp312-win_amd64.whl",
"has_sig": false,
"md5_digest": "39724bb6e6b89fe66ee6fb51ea4326e4",
"packagetype": "bdist_wheel",
"python_version": "cp312",
"requires_python": ">=3.10",
"size": 5921770,
"upload_time": "2025-02-13T10:38:37",
"upload_time_iso_8601": "2025-02-13T10:38:37.619068Z",
"url": "https://files.pythonhosted.org/packages/d5/c5/02c26e63f73738cdf08f11c2952bf47db4601a4821a70af1cc8c22585ded/sqlcycli-1.3.4-cp312-cp312-win_amd64.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": null,
"digests": {
"blake2b_256": "388b12883a386cb0616fc5196ff7cba7c7be7f02fc8e2642d8e1abf956288ffb",
"md5": "4d311189d9611c069d0dee21d863355b",
"sha256": "6cbd47c875358d8a889594a2afd9d4700d0bec4bd18defc59d948c88d2541931"
},
"downloads": -1,
"filename": "sqlcycli-1.3.4-cp313-cp313-macosx_10_13_universal2.whl",
"has_sig": false,
"md5_digest": "4d311189d9611c069d0dee21d863355b",
"packagetype": "bdist_wheel",
"python_version": "cp313",
"requires_python": ">=3.10",
"size": 8479131,
"upload_time": "2025-02-13T10:38:40",
"upload_time_iso_8601": "2025-02-13T10:38:40.186490Z",
"url": "https://files.pythonhosted.org/packages/38/8b/12883a386cb0616fc5196ff7cba7c7be7f02fc8e2642d8e1abf956288ffb/sqlcycli-1.3.4-cp313-cp313-macosx_10_13_universal2.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": null,
"digests": {
"blake2b_256": "0ebc748b13c1e0d98a2c0d51dc391c78ff6d29d35af10e83c5f8c626b26d39eb",
"md5": "350397939a57a144c1069c3bc7652ebd",
"sha256": "1717d72053c7ec0820b009a62964369a77bc190bd4cb2697d1c4275316b08acc"
},
"downloads": -1,
"filename": "sqlcycli-1.3.4-cp313-cp313-macosx_10_13_x86_64.whl",
"has_sig": false,
"md5_digest": "350397939a57a144c1069c3bc7652ebd",
"packagetype": "bdist_wheel",
"python_version": "cp313",
"requires_python": ">=3.10",
"size": 6225215,
"upload_time": "2025-02-13T10:38:42",
"upload_time_iso_8601": "2025-02-13T10:38:42.877858Z",
"url": "https://files.pythonhosted.org/packages/0e/bc/748b13c1e0d98a2c0d51dc391c78ff6d29d35af10e83c5f8c626b26d39eb/sqlcycli-1.3.4-cp313-cp313-macosx_10_13_x86_64.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": null,
"digests": {
"blake2b_256": "aba4628ff9500cd642fd58f8215028dcc9e428b568c97b3cb929295fd5c5366c",
"md5": "626831fffc074edaeba63d776a8d08c3",
"sha256": "ae41492eada11e941f3cbc3c608c4cf6f526f711e5dd071aa2bf9be57aaf42c2"
},
"downloads": -1,
"filename": "sqlcycli-1.3.4-cp313-cp313-macosx_11_0_arm64.whl",
"has_sig": false,
"md5_digest": "626831fffc074edaeba63d776a8d08c3",
"packagetype": "bdist_wheel",
"python_version": "cp313",
"requires_python": ">=3.10",
"size": 5937367,
"upload_time": "2025-02-13T10:38:44",
"upload_time_iso_8601": "2025-02-13T10:38:44.874875Z",
"url": "https://files.pythonhosted.org/packages/ab/a4/628ff9500cd642fd58f8215028dcc9e428b568c97b3cb929295fd5c5366c/sqlcycli-1.3.4-cp313-cp313-macosx_11_0_arm64.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": null,
"digests": {
"blake2b_256": "f8e326510b8e4815fddb3cc1d0886aa5ace7db64b1354f277331a04b3c3e4ee4",
"md5": "f6e683a3040b5e15d39c21b358d978ed",
"sha256": "053774e80a4ec552bb7e73321ac33c2df479fd6cae34ac99c9a1be8057ae61b4"
},
"downloads": -1,
"filename": "sqlcycli-1.3.4-cp313-cp313-manylinux_2_17_x86_64.manylinux2014_x86_64.whl",
"has_sig": false,
"md5_digest": "f6e683a3040b5e15d39c21b358d978ed",
"packagetype": "bdist_wheel",
"python_version": "cp313",
"requires_python": ">=3.10",
"size": 22200933,
"upload_time": "2025-02-13T10:38:48",
"upload_time_iso_8601": "2025-02-13T10:38:48.289542Z",
"url": "https://files.pythonhosted.org/packages/f8/e3/26510b8e4815fddb3cc1d0886aa5ace7db64b1354f277331a04b3c3e4ee4/sqlcycli-1.3.4-cp313-cp313-manylinux_2_17_x86_64.manylinux2014_x86_64.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": null,
"digests": {
"blake2b_256": "98e5e403d20f430d705f5f41c193b5cdbaf68a1df9cb4b9b70e82f535de5d212",
"md5": "ea933c268c8211e2f520927f55de100d",
"sha256": "fd0efca61536c2d794ab484e91302277cb81038b98fcae2c55bb08dc7ab86081"
},
"downloads": -1,
"filename": "sqlcycli-1.3.4-cp313-cp313-musllinux_1_2_x86_64.whl",
"has_sig": false,
"md5_digest": "ea933c268c8211e2f520927f55de100d",
"packagetype": "bdist_wheel",
"python_version": "cp313",
"requires_python": ">=3.10",
"size": 20045798,
"upload_time": "2025-02-13T10:38:52",
"upload_time_iso_8601": "2025-02-13T10:38:52.794499Z",
"url": "https://files.pythonhosted.org/packages/98/e5/e403d20f430d705f5f41c193b5cdbaf68a1df9cb4b9b70e82f535de5d212/sqlcycli-1.3.4-cp313-cp313-musllinux_1_2_x86_64.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": null,
"digests": {
"blake2b_256": "804190429c630cd251d161b1e0ff97002f5a273fb0b0d7f7286509526c040e04",
"md5": "a28031c8a4d30e6594d25afcd7e667cc",
"sha256": "7a4a42b89cb32bfe2a58a381832154f36d268ee5ce752a8e53e901bea97a88a3"
},
"downloads": -1,
"filename": "sqlcycli-1.3.4-cp313-cp313-win_amd64.whl",
"has_sig": false,
"md5_digest": "a28031c8a4d30e6594d25afcd7e667cc",
"packagetype": "bdist_wheel",
"python_version": "cp313",
"requires_python": ">=3.10",
"size": 5911048,
"upload_time": "2025-02-13T10:38:55",
"upload_time_iso_8601": "2025-02-13T10:38:55.796237Z",
"url": "https://files.pythonhosted.org/packages/80/41/90429c630cd251d161b1e0ff97002f5a273fb0b0d7f7286509526c040e04/sqlcycli-1.3.4-cp313-cp313-win_amd64.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": null,
"digests": {
"blake2b_256": "637addcab32b1752ff875514acabdfece0696ad06fe7e21def48ef3d748a364d",
"md5": "8c7b100a70e8017fa2d14da045c62227",
"sha256": "63d548a12d54d9bea1e8c2cb365e25edc4fe5c3ee6cc95b8d0f38c9ab293518d"
},
"downloads": -1,
"filename": "sqlcycli-1.3.4.tar.gz",
"has_sig": false,
"md5_digest": "8c7b100a70e8017fa2d14da045c62227",
"packagetype": "sdist",
"python_version": "source",
"requires_python": ">=3.10",
"size": 3528456,
"upload_time": "2025-02-13T10:38:57",
"upload_time_iso_8601": "2025-02-13T10:38:57.636631Z",
"url": "https://files.pythonhosted.org/packages/63/7a/ddcab32b1752ff875514acabdfece0696ad06fe7e21def48ef3d748a364d/sqlcycli-1.3.4.tar.gz",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2025-02-13 10:38:57",
"github": true,
"gitlab": false,
"bitbucket": false,
"codeberg": false,
"github_user": "AresJef",
"github_project": "SQLCyCli",
"travis_ci": false,
"coveralls": false,
"github_actions": true,
"requirements": [
{
"name": "numpy",
"specs": [
[
">=",
"1.25.2"
]
]
},
{
"name": "orjson",
"specs": [
[
">=",
"3.10.2"
]
]
},
{
"name": "pandas",
"specs": [
[
">=",
"2.1.0"
]
]
},
{
"name": "mysqlclient",
"specs": [
[
">=",
"2.2.0"
]
]
},
{
"name": "typing-extensions",
"specs": [
[
">=",
"4.9.0"
]
]
}
],
"lcname": "sqlcycli"
}
JSON
