Wrapper for mysql.connector.python to get a pool of mysql connections
Project description
flask_mysqlpool
This package allows you to use mysql-connector-pythons pooling feature from flask
Usage
import mysql.connector
from flask import Flask, abort, jsonify
from flask_mysqlpool import MySQLPool
app = Flask(__name__)
app.config['MYSQL_HOST'] = 'localhost'
app.config['MYSQL_PORT'] = 3306
app.config['MYSQL_USER'] = 'test'
app.config['MYSQL_PASS'] = 'test'
app.config['MYSQL_DB'] = 'world_x'
app.config['MYSQL_POOL_NAME'] = 'mysql_pool'
app.config['MYSQL_POOL_SIZE'] = 5
app.config['MYSQL_AUTOCOMMIT'] = True
db = MySQLPool(app)
@app.route('/')
def index():
try:
conn = db.connection.get_connection() # get connection from pool
cursor = conn.cursor(dictionary=True)
cursor.execute("select * from world_x.city limit 10", )
result = cursor.fetchall()
conn.close() # return connection to pool
return jsonify(result)
except mysql.connector.ProgrammingError as err:
print(err)
abort(500)
Project details
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
flask_mysqlpool-1.0.5.tar.gz
(3.3 kB
view hashes)
Built Distribution
Close
Hashes for flask_mysqlpool-1.0.5-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 92dd9cc01c5dde6c46edcb5fa2b1086cc3de91ff008e77728ce1ec9d8102825f |
|
MD5 | 37d78ecb4a4de445d1cdb7e54af91244 |
|
BLAKE2b-256 | ee5f9d53030261f842a11b631d26cc673344d1d254cd4092660e3630504fde25 |