mysql创建模型_连接mysql数据库，创建用户模型

安装与配置python3.6&＃43;flask&＃43;mysql数据库下载安装MySQL数据库

下载安装MySQL-python 中间件

pip install flask-sqlalchemy (Python的ORM框架SQLAlchemy)

mysql创建数据库

3.数据库配置信息config.py

SQLALCHEMY_DATABASE_URI &＃61; &＃39;mysql&＃43;pymysql://root:&＃64;127.0.0.1:3306/login_db?charset&＃61;utf8&＃39;

SQLALCHEMY_TRACK_MODIFICATIONS &＃61; False

4.建立mysql和app的连接

5.创建用户模型

from flask import Flask

from flask import render_template

from flask_sqlalchemy import SQLAlchemy

import config

app &＃61; Flask(__name__)

app.config.from_object(config)

db &＃61; SQLAlchemy(app)

class User(db.Model):

__tablename__ &＃61; &＃39;User&＃39;

id &＃61; db.Column(db.Integer,primary_key&＃61;True,autoincrement&＃61;True)

Username &＃61; db.Column(db.String(20),nullable&＃61;False)

Password&＃61; db.Column(db.String(20), nullable&＃61;False)

db.create_all()

&＃64;app.route(&＃39;/&＃39;)

def base():

return render_template(&＃39;base.html&＃39;)

&＃64;app.route(&＃39;/login/&＃39;)

def login():

return render_template(&＃39;login.html&＃39;)

&＃64;app.route(&＃39;/register/&＃39;)

def register():

return render_template(&＃39;register.html&＃39;)

&＃64;app.route(&＃39;/question/&＃39;)

def question():

return render_template(&＃39;question.html&＃39;)

if __name__ &＃61;&＃61; &＃39;__main__&＃39;:

app.run(debug&＃61;True)