Connect to MySQL database and create user model

Database configuration Information config.py

Sqlalchemy_database_uri = ' Mysql+pymysql://root:@127.0.0.1:3306/jellyfish_db?charset=utf8 ' SQLALCHEMY_TRACK_ Modifications = False

Build MySQL and App connections

Create a user model

From flask import flaskfrom flask_sqlalchemy import sqlalchemyimport Configapp = Flask (__name__) App.config.from_object ( Config) db=sqlalchemy (app) class User (db). Model):    __tablename__= ' user '    id=db. Column (db. integer,primary_key=taberror,autoincrement=true)    username=db. Column (db. String (a), nullable=false)    password=db. Column (db. String (a), nullable=false)    phone=db. Column (db. String (a), nullable=false)    email=db. Column (db. String (a), Nullable=false) Db=create_all () @app. Route ('/') def hello_world ():    return ' Hello world! ' if __name__ = = ' __main__ ':    app.run ()

Connect to MySQL database and create user model