db.create_all()使用错误,无法在MySQL中创建对应的table
在连接mysql时,使用“mysql+pymysql://user:password@端口/数据库名”
代码块
代码块语法遵循标准markdown代码,例如:
from flask_sqlalchemy import SQLAlchemy
from flask import Flask
import pymysql
app=Flask(__name__)
app.config['SQLALCHEMY_DATABASE_URI']="mysql+pymysql://root:123456@localhost:3306/test"
app.config['SQLALCHEMY_COMMIT_ON_TEARDOWN'] = True
app.config['SQLALCHEMY_TRACK_MODIFICATIONS']=False
db=SQLAlchemy(app)
class Role(db.Model):
__tablename__='name'
id =db.Column(db.Integer,primary_key=True)
username=db.Column(db.String(32),unique=True)
password=db.Column(db.String(32))
def add(ob):
db.session.add(ob)
db.session.commit()
if __name__=="__main__":
db.create_all()