代码如下:
# coding:utf8
from flask import Flask
from flask_sqlalchemy import SQLAlchemy
from datetime import datetime
import pymysql
app = Flask(__name__)
app.config["SQLALCHEMY_DATABASE_URI"] = "mysql+pymysql://root:root@127.0.0.1:3306/flaskbooklibrary"
app.config["SQLALCHEMY_TRACK_MODIFICATIONS"] = True
db = SQLAlchemy(app)
# 管理员
class Admin(db.Model):
__tablename__ = "admin"
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)) # 手机号码
# 用户
class User(db.Model):
__tablename__ = "user"
id = db.Column(db.Integer, primary_key=True) # 编号
name = db.Column(db.String(100)) # 用户名称
sex = db.Column(db.String(100)) # 性别
photo=db.Column(db.String(300))#头像
phone=db.Column(db.String(20))#手机号码
identify=db.Column(db.String(20), unique=True)#身份证号
pwd=db.Column(db.String(50))#密码
addtime = db.Column(db.DateTime, index=True, default=datetime.now) # 登录时间
# 标签
class SysFunction(db.Model):
__tablename__ = "sysfunction"
funid = db.Column(db.Integer, primary_key=True) #主键
funName = db.Column(db.String(300), unique=True) # 功能名称
funUrl =db.Column(db.String(300), unique=True)#路径
funpid =db.Column(db.Integer)#父ID
funstate =db.Column(db.Integer)#状态
class BookType(db.Model):
__tablename__ = "booktype"
tid = db.Column(db.Integer, primary_key=True) # 编号
name= db.Column(db.String(255), unique=True)
# 书籍
class Book(db.Model):
__tablename__ = "book"
bid = db.Column(db.Integer, primary_key=True) # 编号
bookName = db.Column(db.String(255)) # s书名
bookNum=db.Column(db.String(255)) #图书编号
author=db.Column(db.String(255))#作者
num=db.Column(db.Integer)#数量
press=db.Column(db.String(255))#出版社
bookType = db.relationship("BookType", backref='book') #
class History(db.Model):
__tablename__ = "history"
id=db.Column(db.Integer, primary_key=True) # 编号
user = db.relationship("User", backref='history')#用户
book=db.relationship("Book", backref='history')#图书
beginTime=db.Column(db.DateTime, index=True, default=datetime.now) # 添加时间
endTime=db.Column(db.DateTime, index=True)#截至日期
status=db.Column(db.String(255))#借书状态
num=db.Column(db.Integer)#借书数量
class Comment(db.Model):
__tablename__ = "comment"
id = db.Column(db.Integer, primary_key=True)
user = db.relationship("User", backref='comment') # 用户
book = db.relationship("Book", backref='comment') # 图书
content=db.Column(db.String(255))#评论内容
commentDate=db.Column(db.DateTime, index=True, default=datetime.now) # 添加时间
# if __name__ == "__main__":
db.create_all() # 根据以上数据模型,逆向生成数据库表