PyMySQLPool

PyMySQLPool copied to clipboard

## What happened ```ping_check``` is not working, no matter I set it to ```int``` or ```bool``` ## Env 1. Ubuntu 20.04 2. Miniconda 23.1.0 3. Base Env: python3.8 ## How...

Greetlist

raise err.ProgrammingError("Cursor closed") pymysql.err.ProgrammingError: Cursor closed Not sure what's wrong with cur as cursor: pool.init() sql = "INSERT INTO users (email, password) VALUES (%s, %s)" cur.execute(sql, (email, password)) pool.release(connection) edit...

mupciamkotki

Please update pypi

2

I found that the latest update https://github.com/prprprus/PyMySQLPool/commit/212110afaaa01f1d0d3faa8fe099ad19f48a8fbe has not been updated to pypi. I believe this update can also solve https://github.com/prprprus/PyMySQLPool/issues/14. If available, please update pypi.

PttCodingMan

i experienced this alot `pymysql.err.OperationalError: (2013, 'Lost connection to MySQL server during query')` and i think this change will fix it. https://github.com/prprprus/PyMySQLPool/blob/212110afaaa01f1d0d3faa8fe099ad19f48a8fbe/pymysqlpool/pool.py#L184 change to ` c.ping(reconnect=True)`

bokunodev

support python with interfaces? [feature request]

1

please, consider to support `with` by implementing `__enter__` and ` __exit__` method. it'll make this lib easier to use.

bokunodev

Thread locking

5

I am experiencing a thread lock and the application won't exit. I am using pyMySQL 0.9.3 and PyMySQLPool 1.0.6. Any suggestions? Thanks

terzano

Ping '__ping_check_timestamp' attributes is turned to '_Pool__ping_check_timestamp'

1

$ python -V Python 3.6.8 ### Debug Log (Pdb) > /usr/local/lib/python3.6/site-packages/pymysqlpool/pool.py(177)__get_safe_conn() -> if not hasattr(c, '__ping_check_timestamp'): (Pdb) old_attributes = set(vars(c).keys()) > /usr/local/lib/python3.6/site-packages/pymysqlpool/pool.py(178)__get_safe_conn() -> c.__ping_check_timestamp = now (Pdb) n > /usr/local/lib/python3.6/site-packages/pymysqlpool/pool.py(179)__get_safe_conn()...

abhishekp-uc

invalid syntax (pool.py, line 81)

1

Hi... Thank you for opening good code. I'm using python 2.7.17. When I try use your package, python shows an error : invalid syntax (pool.py, line 81). Could you fix...

JoonYong-Kim

Bumps [pymysql](https://github.com/PyMySQL/PyMySQL) from 0.9.2 to 1.1.1. Release notes Sourced from pymysql's releases. v1.1.1 [!WARNING] This release fixes a vulnerability (CVE-2024-36039). All users are recommended to update to this version. If...

dependabot[bot]

Just trying out this package and reading through the source code. I made a couple of minor tweaks for your consideration: - The main one, functionally, is not to have...

ch3pjw