在Flask中使用MySQL [英] Using MySQL in Flask
本文介绍了在Flask中使用MySQL的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
非常感谢您提前
解决方案
from flask import Flask
from flask.ext.sqlalchemy import SQLAlchemy
$ b $ 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
$ b def __repr __(self):
return'< User%r>'%self.username
您可以通过googleFlask-Sqlalchemy获取更多信息。
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
解决方案
from flask import Flask
from flask.ext.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
You can google "Flask-Sqlalchemy" for more things.
这篇关于在Flask中使用MySQL的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文