{ "info": { "author": "Daniel Thorell", "author_email": "dthorell@outlook.com", "bugtrack_url": null, "classifiers": [ "License :: OSI Approved :: MIT License", "Operating System :: OS Independent", "Programming Language :: Python", "Programming Language :: Python :: 3", "Programming Language :: Python :: 3.6", "Programming Language :: Python :: 3.7", "Programming Language :: Python :: Implementation :: CPython" ], "description": "# flask_mysqlpool\n\nThis package allows you to use mysql-connector-pythons pooling feature from flask\n\n# Usage\n\n import mysql.connector\n from flask import Flask, abort, jsonify\n from flask_mysqlpool import MySQLPool\n\n app = Flask(__name__)\n app.config['MYSQL_HOST'] = 'localhost'\n app.config['MYSQL_PORT'] = 3306\n app.config['MYSQL_USER'] = 'test'\n app.config['MYSQL_PASS'] = 'test'\n app.config['MYSQL_DB'] = 'world_x'\n app.config['MYSQL_POOL_NAME'] = 'mysql_pool'\n app.config['MYSQL_POOL_SIZE'] = 5\n app.config['MYSQL_AUTOCOMMIT'] = True\n\n db = MySQLPool(app)\n\n @app.route('/')\n def index():\n try:\n conn = db.connection.get_connection() # get connection from pool\n cursor = conn.cursor(dictionary=True)\n cursor.execute(\"select * from world_x.city limit 10\", )\n result = cursor.fetchall()\n conn.close() # return connection to pool\n except mysql.connector.ProgrammingError as err:\n print(err)\n abort(500)\n to_json = [dict(row) for row in result]\n return jsonify(to_json)\n\n\n", "description_content_type": "text/markdown", "docs_url": null, "download_url": "", "downloads": { "last_day": -1, "last_month": -1, "last_week": -1 }, "home_page": "https://github.com/dthorell/mysqlpool", "keywords": "", "license": "MIT", "maintainer": "", "maintainer_email": "", "name": "flask-mysqlpool", "package_url": "https://pypi.org/project/flask-mysqlpool/", "platform": "", "project_url": "https://pypi.org/project/flask-mysqlpool/", "project_urls": { "Homepage": "https://github.com/dthorell/mysqlpool" }, "release_url": "https://pypi.org/project/flask-mysqlpool/1.0.4/", "requires_dist": [ "flask (>=1.0.0)", "mysql-connector-python (>=8.0.0)" ], "requires_python": "", "summary": "Wrapper for mysql.connector.python to get a pool of mysql connections", "version": "1.0.4" }, "last_serial": 5127707, "releases": { "1.0.2": [ { "comment_text": "", "digests": { "md5": "2ccc3af6123dd10e5c6b06d811d29c1a", "sha256": "cfc1da8c76d4c373aa44bb79c6b50f8415a02fb2f14ab701a6446ed025196e12" }, "downloads": -1, "filename": "flask_mysqlpool-1.0.2-py3-none-any.whl", "has_sig": false, "md5_digest": "2ccc3af6123dd10e5c6b06d811d29c1a", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 3369, "upload_time": "2019-04-05T15:36:33", "url": "https://files.pythonhosted.org/packages/1a/e3/87aafa17c10799e26e4d5b8885fbd3201c22953478cf5b3bb9218e06ccb3/flask_mysqlpool-1.0.2-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "683572a9c1e194ac9d0b326084ba4dfd", "sha256": "40c87a4e5fd7eb6f4199483e1d747ca02b8b4b260977f283c769c3ffcb6a65b9" }, "downloads": -1, "filename": "flask_mysqlpool-1.0.2.tar.gz", "has_sig": false, "md5_digest": "683572a9c1e194ac9d0b326084ba4dfd", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 2165, "upload_time": "2019-04-05T15:36:34", "url": "https://files.pythonhosted.org/packages/b2/7f/370e0901931c792d743b4aacb46c2b6eb49646203d91a44749161740e288/flask_mysqlpool-1.0.2.tar.gz" } ], "1.0.3": [ { "comment_text": "", "digests": { "md5": "2edbd5b5ebf2a9dc1942c071bfd8c2a0", "sha256": "2a349a7913da35aa64291480d8ed435d449b2a3e095798e7efeab587dcd98e6e" }, "downloads": -1, "filename": "flask_mysqlpool-1.0.3-py3-none-any.whl", "has_sig": false, "md5_digest": "2edbd5b5ebf2a9dc1942c071bfd8c2a0", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 3368, "upload_time": "2019-04-06T10:07:14", "url": "https://files.pythonhosted.org/packages/32/c4/a8f1196e15e4d3c897a773e34d053f9ee83baef1c74e574049fba8a322b3/flask_mysqlpool-1.0.3-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "64ab1636bf62f645250a6c3642dfe8ad", "sha256": "8041697dd418fbaab9f68bdafcab33a5897efa8d9c449fdea27461cf943afa3f" }, "downloads": -1, "filename": "flask_mysqlpool-1.0.3.tar.gz", "has_sig": false, "md5_digest": "64ab1636bf62f645250a6c3642dfe8ad", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 2357, "upload_time": "2019-04-06T10:07:15", "url": "https://files.pythonhosted.org/packages/3c/5c/89fc99a140e1ac76601dcad9f44a3f37e4627504773933285a48cd1624b1/flask_mysqlpool-1.0.3.tar.gz" } ], "1.0.4": [ { "comment_text": "", "digests": { "md5": "4492e6fbebb6ecaa54d48fd1e29a7f12", "sha256": "0c8574e94ef43be196e2c55402e18dfd983681a03ec485f12b26e5558d7a26f3" }, "downloads": -1, "filename": "flask_mysqlpool-1.0.4-py3-none-any.whl", "has_sig": false, "md5_digest": "4492e6fbebb6ecaa54d48fd1e29a7f12", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 3457, "upload_time": "2019-04-11T08:25:15", "url": "https://files.pythonhosted.org/packages/3d/09/025eb500843873970f17ecdc6b4fd76b4f08863f2295c9b21adb656c4b0e/flask_mysqlpool-1.0.4-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "413063cb24b5e252a45b7023d9ee90c8", "sha256": "936655078f821a7cec5bb90f0c98107e39d0e211229d372a78f6a2c428f48fad" }, "downloads": -1, "filename": "flask_mysqlpool-1.0.4.tar.gz", "has_sig": false, "md5_digest": "413063cb24b5e252a45b7023d9ee90c8", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 2417, "upload_time": "2019-04-11T08:25:16", "url": "https://files.pythonhosted.org/packages/da/6b/3b94aff41fef8254d1808c95daa5409c9155fa558ac15947a522bc7c1d07/flask_mysqlpool-1.0.4.tar.gz" } ] }, "urls": [ { "comment_text": "", "digests": { "md5": "4492e6fbebb6ecaa54d48fd1e29a7f12", "sha256": "0c8574e94ef43be196e2c55402e18dfd983681a03ec485f12b26e5558d7a26f3" }, "downloads": -1, "filename": "flask_mysqlpool-1.0.4-py3-none-any.whl", "has_sig": false, "md5_digest": "4492e6fbebb6ecaa54d48fd1e29a7f12", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 3457, "upload_time": "2019-04-11T08:25:15", "url": "https://files.pythonhosted.org/packages/3d/09/025eb500843873970f17ecdc6b4fd76b4f08863f2295c9b21adb656c4b0e/flask_mysqlpool-1.0.4-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "413063cb24b5e252a45b7023d9ee90c8", "sha256": "936655078f821a7cec5bb90f0c98107e39d0e211229d372a78f6a2c428f48fad" }, "downloads": -1, "filename": "flask_mysqlpool-1.0.4.tar.gz", "has_sig": false, "md5_digest": "413063cb24b5e252a45b7023d9ee90c8", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 2417, "upload_time": "2019-04-11T08:25:16", "url": "https://files.pythonhosted.org/packages/da/6b/3b94aff41fef8254d1808c95daa5409c9155fa558ac15947a522bc7c1d07/flask_mysqlpool-1.0.4.tar.gz" } ] }