pymysql-based database connection pool
Project description
PyMySQLPool
PyMySQLPool is a pymysql-based database connection pool, simple and lightweight.
Table of content
Features
- Maintain a minimum number of connection pools by default.
- If number of unuse connections less than zero, dynamically add connections to pool until current number of inuse connections equal maximum of pool.
- Release the idle connections in regular until number of unuse connections equal minimum of pool.
Requirements
- Python
- CPython : >= 3.4
- MySQL Server -- one of the following:
- MySQL >= 5.5
- MariaDB >= 5.5
- PyMySQL: >= 0.9.2
Installation
Package is uploaded on PyPI
You can install with pip
$ pip install pymysql-pooling
Example
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
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 auto-commit mode, as following:
pool = Pool(host=HOST, port=PORT, user=USER, password=PASSWORD, db=DB, autocommit=True)
That's all.
Parameters for the pool initial:
host
: Host of MySQL server, default for localhostport
: Port of MySQL server, default for 3306user
: User of MySQL server, default for Nonepassword
: Password of MySQL server, default for Nonedb
: Database of MySQL server, default for Nonecharset
: Charset of MySQL server, default for utf8cursorclass
: Class of MySQL Cursor, default for pymysql.cursors.DictCursorautocommit
: auto commit mode, default for Falsemin_size
: Minimum size of connection pool, default for 1max_size
: Maximum size of connection pool, default for 3timeout
: Watting time in the multi-thread environment, default for 10.0interval
: Statistical cycle time, default for 600.0stati_mun
: Statistical frequency, default for 3multiple
: Regulation standard, default for 4counter
: Counter, default for 0accumulation
: Statiscal result, default for 0
Roadmap
- Connection Pool
- Dynamically Create
- Dynamically Release
- Monitor Web Interface
Resources
License
PyMySQLPool is released under the MIT License. See LICENSE for more information.
Contributing
Thank you for your interest in contribution of PyMySQLPool, your help and contribution is very valuable.
You can submit issue and pull requests, please submit an issue before submitting pull requests.
At last if the project is helpful to you, please click a star, thank you so much.
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
Built Distribution
Hashes for pymysql_pooling-1.0.0-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | afa36a856bfa136aa5776f909b84ae9fc651b8e2f228a1c04e01339b11b914cd |
|
MD5 | 074564875948994336a0c3defccd1834 |
|
BLAKE2b-256 | fa31aef87b5cc804f8339760442bdf773985ee4a8dc7220c536f4e8b6662f608 |