PyMySQLPool is a pymysql-based database connection pool, simple and lightweight.
Table of content
Package is uploaded on PyPI
You can install with pip
$ pip install pymysql-pooling
Make use of a simple table (Example in MySQL doc)
mysql> CREATE TABLE pet (name VARCHAR(20), owner VARCHAR(20),
-> species VARCHAR(20), sex CHAR(1), birth DATE, death DATE);
mysql> INSERT INTO pet
-> VALUES ("Puffball", "Diane", "hamster", "f", "1999-03-30", NULL);
from pymysqlpool.pool import Pool
# Note: you can also add any parameters relates to `pymysql.connections.Connection` object
pool = Pool(host=HOST, port=PORT, user=USER, password=PASSWORD, db=DB)
pool.init()
connection = pool.get_conn()
cur = connection.cursor()
cur.execute('SELECT * FROM `pet` WHERE `name`=%s', args=("Puffball", ))
print(cur.fetchone())
pool.release(connection)
This example will print:
('Puffball', 'Diane', 'hamster', 'f', datetime.date(1999, 3, 30), None)
Support autocommit mode, as following:
pool = Pool(host=HOST, port=PORT, user=USER, password=PASSWORD, db=DB, autocommit=True)
That's all.
PyMySQLPool is released under the MIT License. See LICENSE for more information.
Thank you for your interest in the contribution of PyMySQLPool, your help and contribution is very valuable.
You can submit an issue and pull requests, please submit an issue before submitting pull requests.