automatic import of python-pymysql-pooling

3 files changed, 399 insertions, 0 deletions

diff --git a/.gitignore b/.gitignore
index e69de29..be474da 100644
--- a/.gitignore
+++ b/.gitignore
@@ -0,0 +1 @@
+/pymysql-pooling-1.0.6.tar.gz
diff --git a/python-pymysql-pooling.spec b/python-pymysql-pooling.spec
new file mode 100644
index 0000000..55f4dd6
--- /dev/null
+++ b/python-pymysql-pooling.spec
@@ -0,0 +1,397 @@
+%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.nju.edu.cn/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
+* Wed May 17 2023 Python_Bot <Python_Bot@openeuler.org> - 1.0.6-1
+- Package Spec generated
diff --git a/sources b/sources
new file mode 100644
index 0000000..f96bc9e
--- /dev/null
+++ b/sources
@@ -0,0 +1 @@
+5a8decbcdd13c7eee5ff53780db81349  pymysql-pooling-1.0.6.tar.gz