Using MySQL in Flask

Question

Can someone share example codes in Flask on how to access a MySQL DB? There have been documents showing how to connect to sqlite but not on MySQL.

Thank you very much in advance

Answer 1

Firstly you need to install Flask-MySQL package. Using pip for example:

pip install flask-mysql

Next you need to add some configuration and initialize MySQL:

from flask import Flask from flaskext.mysql import MySQL  app = Flask(__name__) mysql = MySQL() app.config['MYSQL_DATABASE_USER'] = 'root' app.config['MYSQL_DATABASE_PASSWORD'] = 'root' app.config['MYSQL_DATABASE_DB'] = 'EmpData' app.config['MYSQL_DATABASE_HOST'] = 'localhost' mysql.init_app(app) 

Now you can get connection and cursor objects and execute raw queries:

conn = mysql.connect() cursor =conn.cursor()  cursor.execute("SELECT * from User") data = cursor.fetchone() 

Answer 2

from flask import Flask from flask_sqlalchemy import SQLAlchemy  app = Flask(__name__) app.config['SQLALCHEMY_DATABASE_URI'] = 'mysql://username:password@server/db' db = SQLAlchemy(app)   class User(db.Model):     id = db.Column(db.Integer, primary_key=True)     username = db.Column(db.String(80), unique=True)     email = db.Column(db.String(120), unique=True)      def __init__(self, username, email):         self.username = username         self.email = email      def __repr__(self):         return '<User %r>' % self.username 

help link