#!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 ")
Python 操作Flask Mysql 方法
最新推荐文章于 2024-08-26 18:01:57 发布