Python 操作Flask Mysql 方法

#!C:/Python27
#coding=utf-8


"""
安装 pip install flask-sqlalchemy

"""
from flask import Flask
from  flask_sqlalchemy import  SQLAlchemy

app = Flask(__name__)

app.config['SQLALCHEMY_DATABASE_URI'] ='mysql://root:test@localhost/test?charset=utf8'
# 该配置为True,则每次请求结束都会自动commit数据库的变动
app.config['SQLALCHEMY_COMMIT_ON_TEARDOWN'] = True
app.config['SQLALCHEMY_TRACK_MODIFICATIONS'] = True

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(320), unique=True)
    phone = db.Column(db.String(32), nullable=False)
    address = db.Column(db.String(32), nullable=False)

    def __init__(self, username, email, phone, address):
        self.username = username
        self.email = email
        self.phone = phone
        self.address = address
    print  "执行成功"


if __name__ == '__main__':
    app.debug = True
    db.create_all()
    db.select("select * from USER ")