运行环境
click==6.7
Flask==0.12.2
Flask-MySQLdb==0.2.0
Flask-SQLAlchemy==2.3.2
itsdangerous==0.24
Jinja2==2.10
MarkupSafe==1.0
mysqlclient==1.3.12
PyMySQL==0.8.0
SQLAlchemy==1.2.4
Werkzeug==0.14.1
from flask import Flask
from flask_sqlalchemy import SQLAlchemy
import pymysql
from datetime import datetime
# http://www.pythondoc.com/flask-sqlalchemy/config.html
app = Flask(__name__)
app.config["SQLALCHEMY_DATABASE_URI"] = "mysql://root:root@localhost:3306/movies?charset=utf8"
app.config["SQLALCHEMY_TRACK_MODIFICATIONS"] = True
app.config["SQLALCHEMY_NATIVE_UNICODE"] = True
db = SQLAlchemy(app)
# 用户
class User(db.Model):
__tablename__ = "user"
# id
id = db.Column(db.Integer, primary_key=True)
# 姓名
name = db.Column(db.String(100), unique=True)
# 密码
pwd = db.Column(db.String(100))
# 邮箱
email = db.Column(db.String(100), unique=True)
# 电话
phone = db.Column(db.String(11), unique=True)
# 简介
info = db.Column(db.Text)
# 头像
face = db.Column(db.String(255), unique=True)
# 注册时间
addtime = db.Column(db.DateTime, index=True, default=datetime.utcnow)
# 唯一标识符
uuid = db.Column(db.String(255), unique=True)
# 关联 外键 第一个是类名
userlogs = db.relationship("Userlog", backref='user') # 日志关联
comments = db.relationship("Comment", ba