Flask-pymysql provides MySQL connection for Flask.
First, install Flask-pymysql:
$ pip install flask-mysqldb
Flask-pymysql depends, and will install for you, recent versions of Flask (0.10.1 or later) and mysqlclient. Flask-pymysql is compatible with and tested on Python 2.7, 3.4, 3.5 and 3.6.
Next, add a MySQL instance to your code:
from flask import Flask
from flask_mysqldb import MySQL
app = Flask(__name__)
app.config['MYSQL_USER'] = 'user'
app.config['MYSQL_PASSWORD'] = 'password'
app.config['MYSQL_DB'] = 'database'
app.config['MYSQL_CURSORCLASS'] = 'DictCursor'
mysql = MySQL(app)
@app.route('/')
def users():
cur = mysql.connection.cursor()
cur.execute('''SELECT user, host FROM mysql.user''')
rv = cur.fetchall()
return str(rv)
if __name__ == '__main__':
app.run(debug=True)Other configuration directives can be found here.
Why would you want to use this extension versus just using pymysql by itself? The only reason is that the extension was made using Flask's best pratices in relation to resources that need caching on the app context. What that means is that the extension will manage creating and teardown the connection to MySQL for you while with if you were just using pymysql you would have to do it yourself.