%global _empty_manifest_terminate_build 0 Name: python-pymysql-pooling Version: 1.0.6 Release: 1 Summary: pymysql-based database connection pool License: MIT License URL: https://github.com/prprprus/PyMySQLPool Source0: https://mirrors.aliyun.com/pypi/web/packages/17/bd/b1ac40913ce80995aaf50b481b35ac769cf25191c89485f67c52efdfc8df/pymysql-pooling-1.0.6.tar.gz BuildArch: noarch Requires: python3-PyMySQL %description # PyMySQLPool [![build status](https://travis-ci.org/prprprus/PyMySQLPool.svg?branch=master)](https://travis-ci.org/zongzhenh/PyMySQLPool.svg?branch=master) [![codecov](https://codecov.io/gh/zongzhenh/PyMySQLPool/branch/master/graph/badge.svg)](https://codecov.io/gh/zongzhenh/PyMySQLPool) [![pip version](https://img.shields.io/badge/pip-v18.1-blue.svg)](https://img.shields.io/badge/pip-v18.1-blue.svg) [![license](https://img.shields.io/dub/l/vibe-d.svg)](./LICENSE) PyMySQLPool is a pymysql-based database connection pool, simple and lightweight. Table of content - [Features](https://github.com/zongzhenh/PyMySQLPool#features) - [Requirements](https://github.com/zongzhenh/PyMySQLPool/blob/master/README.md#requirements) - [Installation](https://github.com/zongzhenh/PyMySQLPool/blob/master/README.md#installation) - [Example](https://github.com/zongzhenh/PyMySQLPool/blob/master/README.md#example) - [Roadmap](https://github.com/zongzhenh/PyMySQLPool/blob/master/README.md#roadmap) - [Resources](https://github.com/zongzhenh/PyMySQLPool/blob/master/README.md#resources) - [License](https://github.com/zongzhenh/PyMySQLPool/blob/master/README.md#license) - [Contributing](https://github.com/zongzhenh/PyMySQLPool/blob/master/README.md#contributing) ## Features - Maintain a minimum number of connection pools by default. - If a number of unuse connections less than zero, dynamically add connections to pool until the current number of inuse connections equal maximum of the pool. - Release the idle connections in regular until a number of unuse connections equal minimum of the pool. - Support auto-commit mode. - Support for ping check to get healthy connections. ## 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](https://pypi.org/project/pymysql-pooling/) You can install with pip ``` $ pip install pymysql-pooling ``` ## Example Make use of a simple table (Example in [MySQL doc](https://dev.mysql.com/doc/refman/8.0/en/creating-tables.html)) ```mysql 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); ``` ```python 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 autocommit mode, as following: ```python pool = Pool(host=HOST, port=PORT, user=USER, password=PASSWORD, db=DB, autocommit=True) ``` That's all. ## Roadmap - [x] Connection Pool - [x] Dynamically Create - [x] Dynamically Release - [ ] Monitor Web Interface ## Resources - [PyMySQL Documenation](https://pymysql.readthedocs.io/en/latest/index.html) - [MySQL Reference Manuals](https://dev.mysql.com/doc/refman/8.0/en/) ## License PyMySQLPool is released under the MIT License. See LICENSE for more information. ## Contributing 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. %package -n python3-pymysql-pooling Summary: pymysql-based database connection pool Provides: python-pymysql-pooling BuildRequires: python3-devel BuildRequires: python3-setuptools BuildRequires: python3-pip %description -n python3-pymysql-pooling # PyMySQLPool [![build status](https://travis-ci.org/prprprus/PyMySQLPool.svg?branch=master)](https://travis-ci.org/zongzhenh/PyMySQLPool.svg?branch=master) [![codecov](https://codecov.io/gh/zongzhenh/PyMySQLPool/branch/master/graph/badge.svg)](https://codecov.io/gh/zongzhenh/PyMySQLPool) [![pip version](https://img.shields.io/badge/pip-v18.1-blue.svg)](https://img.shields.io/badge/pip-v18.1-blue.svg) [![license](https://img.shields.io/dub/l/vibe-d.svg)](./LICENSE) PyMySQLPool is a pymysql-based database connection pool, simple and lightweight. Table of content - [Features](https://github.com/zongzhenh/PyMySQLPool#features) - [Requirements](https://github.com/zongzhenh/PyMySQLPool/blob/master/README.md#requirements) - [Installation](https://github.com/zongzhenh/PyMySQLPool/blob/master/README.md#installation) - [Example](https://github.com/zongzhenh/PyMySQLPool/blob/master/README.md#example) - [Roadmap](https://github.com/zongzhenh/PyMySQLPool/blob/master/README.md#roadmap) - [Resources](https://github.com/zongzhenh/PyMySQLPool/blob/master/README.md#resources) - [License](https://github.com/zongzhenh/PyMySQLPool/blob/master/README.md#license) - [Contributing](https://github.com/zongzhenh/PyMySQLPool/blob/master/README.md#contributing) ## Features - Maintain a minimum number of connection pools by default. - If a number of unuse connections less than zero, dynamically add connections to pool until the current number of inuse connections equal maximum of the pool. - Release the idle connections in regular until a number of unuse connections equal minimum of the pool. - Support auto-commit mode. - Support for ping check to get healthy connections. ## 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](https://pypi.org/project/pymysql-pooling/) You can install with pip ``` $ pip install pymysql-pooling ``` ## Example Make use of a simple table (Example in [MySQL doc](https://dev.mysql.com/doc/refman/8.0/en/creating-tables.html)) ```mysql 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); ``` ```python 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 autocommit mode, as following: ```python pool = Pool(host=HOST, port=PORT, user=USER, password=PASSWORD, db=DB, autocommit=True) ``` That's all. ## Roadmap - [x] Connection Pool - [x] Dynamically Create - [x] Dynamically Release - [ ] Monitor Web Interface ## Resources - [PyMySQL Documenation](https://pymysql.readthedocs.io/en/latest/index.html) - [MySQL Reference Manuals](https://dev.mysql.com/doc/refman/8.0/en/) ## License PyMySQLPool is released under the MIT License. See LICENSE for more information. ## Contributing 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. %package help Summary: Development documents and examples for pymysql-pooling Provides: python3-pymysql-pooling-doc %description help # PyMySQLPool [![build status](https://travis-ci.org/prprprus/PyMySQLPool.svg?branch=master)](https://travis-ci.org/zongzhenh/PyMySQLPool.svg?branch=master) [![codecov](https://codecov.io/gh/zongzhenh/PyMySQLPool/branch/master/graph/badge.svg)](https://codecov.io/gh/zongzhenh/PyMySQLPool) [![pip version](https://img.shields.io/badge/pip-v18.1-blue.svg)](https://img.shields.io/badge/pip-v18.1-blue.svg) [![license](https://img.shields.io/dub/l/vibe-d.svg)](./LICENSE) PyMySQLPool is a pymysql-based database connection pool, simple and lightweight. Table of content - [Features](https://github.com/zongzhenh/PyMySQLPool#features) - [Requirements](https://github.com/zongzhenh/PyMySQLPool/blob/master/README.md#requirements) - [Installation](https://github.com/zongzhenh/PyMySQLPool/blob/master/README.md#installation) - [Example](https://github.com/zongzhenh/PyMySQLPool/blob/master/README.md#example) - [Roadmap](https://github.com/zongzhenh/PyMySQLPool/blob/master/README.md#roadmap) - [Resources](https://github.com/zongzhenh/PyMySQLPool/blob/master/README.md#resources) - [License](https://github.com/zongzhenh/PyMySQLPool/blob/master/README.md#license) - [Contributing](https://github.com/zongzhenh/PyMySQLPool/blob/master/README.md#contributing) ## Features - Maintain a minimum number of connection pools by default. - If a number of unuse connections less than zero, dynamically add connections to pool until the current number of inuse connections equal maximum of the pool. - Release the idle connections in regular until a number of unuse connections equal minimum of the pool. - Support auto-commit mode. - Support for ping check to get healthy connections. ## 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](https://pypi.org/project/pymysql-pooling/) You can install with pip ``` $ pip install pymysql-pooling ``` ## Example Make use of a simple table (Example in [MySQL doc](https://dev.mysql.com/doc/refman/8.0/en/creating-tables.html)) ```mysql 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); ``` ```python 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 autocommit mode, as following: ```python pool = Pool(host=HOST, port=PORT, user=USER, password=PASSWORD, db=DB, autocommit=True) ``` That's all. ## Roadmap - [x] Connection Pool - [x] Dynamically Create - [x] Dynamically Release - [ ] Monitor Web Interface ## Resources - [PyMySQL Documenation](https://pymysql.readthedocs.io/en/latest/index.html) - [MySQL Reference Manuals](https://dev.mysql.com/doc/refman/8.0/en/) ## License PyMySQLPool is released under the MIT License. See LICENSE for more information. ## Contributing 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. %prep %autosetup -n pymysql-pooling-1.0.6 %build %py3_build %install %py3_install install -d -m755 %{buildroot}/%{_pkgdocdir} if [ -d doc ]; then cp -arf doc %{buildroot}/%{_pkgdocdir}; fi if [ -d docs ]; then cp -arf docs %{buildroot}/%{_pkgdocdir}; fi if [ -d example ]; then cp -arf example %{buildroot}/%{_pkgdocdir}; fi if [ -d examples ]; then cp -arf examples %{buildroot}/%{_pkgdocdir}; fi pushd %{buildroot} if [ -d usr/lib ]; then find usr/lib -type f -printf "\"/%h/%f\"\n" >> filelist.lst fi if [ -d usr/lib64 ]; then find usr/lib64 -type f -printf "\"/%h/%f\"\n" >> filelist.lst fi if [ -d usr/bin ]; then find usr/bin -type f -printf "\"/%h/%f\"\n" >> filelist.lst fi if [ -d usr/sbin ]; then find usr/sbin -type f -printf "\"/%h/%f\"\n" >> filelist.lst fi touch doclist.lst if [ -d usr/share/man ]; then find usr/share/man -type f -printf "\"/%h/%f.gz\"\n" >> doclist.lst fi popd mv %{buildroot}/filelist.lst . mv %{buildroot}/doclist.lst . %files -n python3-pymysql-pooling -f filelist.lst %dir %{python3_sitelib}/* %files help -f doclist.lst %{_docdir}/* %changelog * Thu Jun 08 2023 Python_Bot - 1.0.6-1 - Package Spec generated