python烟花代码1

from datetime import datetime from werkzeug.security import generate_password_hash, check_password_hash from info import db class User(db.Model): """用户""" __tablename__ = "user" id = db.Column(db.Integer, primary_key=True) # 用户编号 nick_name = db.Column(db.String(32), unique=True, nullable=False) # 用户昵称 password_hash = db.Column(db.String(128), nullable=False) # 加密的密码 account = db.Column(db.String(11), unique=True, nullable=False) # 账号 avatar_url = db.Column(db.String(256)) # 用户头像路径 user_level = db.Column(db.Integer, db.ForeignKey("user_class.id")) # 用户级别 gender = db.Column(db.Enum("MAN", "WOMAN"), default="MAN") # 用户性别 @property def password (self): raise AttributeError("当前属性不可读") @password.setter def password (self, value): self.password_hash = generate_password_hash(value) def check_passowrd (self, password): return check_password_hash(self.password_hash, password) def to_dict (self): resp_dict = { "id": self.id, "nick_name": self.nick_name, "avatar_url":self.avatar_url if self.avatar_url else "", "account": self.account, "user_level":self.user_class.to_dict() if self.user_class else None, "gender":self.gender if self.gender else "MAN", } return resp_dict class User_class(db.Model): """用户分类(游客，普通用户，工作人员)""" __tablename__ = "user_class" id = db.Column(db.Integer, primary_key=True) # 分类编号 user_class= db.Column(db.String(64), nullable=False) # 分类名 user_list = db.relationship('User', backref='user_class', lazy='dynamic') def to_dict (self): resp_dict = { "id": self.id, "class_name": self.user_class } return resp_dict class News(db.Model): """新闻""" __tablename__ = "news" id = db.Column(db.Integer, primary_key=True) # 新闻编号 title = db.Column(db.String(256), nullable=False) # 新闻标题 content = db.Column(db.Text, nullable=False) # 新闻内容 index_image_url = db.Column(db.String(256)) # 新闻列表图片路径 user_id = db.Column(db.Integer, db.ForeignKey("user.id")) # 当前新闻的作者id create_time = db.Column(db.DateTime, default=datetime.now) # 发布时间 def to_dict (self): resp_dict = { "id": self.id, "title": self.title, "create_time": self.create_time.strftime("%Y-%m-%d %H:%M:%S"), "content": self.content, "index_image_url": self.index_image_url, "author": self.user.to_dict() if self.user else None } return resp_dict class Fireworks(db.Model): """烟花""" __tablename__ = "fireworks" id = db.Column(db.Integer, primary_key=True) # 烟花编号 name = db.Column(db.String(256), nullable=False) # 烟花名字 price = db.Column(db.Integer, nullable=True) # 烟花价格 category = db.Column(db.Integer, db.ForeignKey("fireworks_class.id")) # 烟花分类id fireworks_image_url = db.Column(db.String(256)) # 烟花图片展示路径 video_url = db.Column(db.String(256)) # 烟花视频播放路径 details= db.Column(db.Text, nullable=False) # 烟花介绍 create_time = db.Column(db.DateTime, default=datetime.now) # 发布时间 def to_dict(self): resp_dict = { "id":self.id, "name":self.name, "price":self.price, "category":self.fireworks_class.to_dict(), "fireworks_image_url":self.fireworks_image_url, "video_url":self.video_url, "create_time": self.create_time.strftime("%Y-%m-%d %H:%M:%S"), } return resp_dict class Fireworks_class(db.Model): """烟花分类""" __tablename__ = "fireworks_class" id = db.Column(db.Integer, primary_key=True) # 分类编号 class_name = db.Column(db.String(64), nullable=False) # 分类名 fireworks_list = db.relationship('Fireworks', backref='fireworks_class', lazy='dynamic') def to_dict (self): resp_dict = { "id": self.id, "class_name": self.class_name } return resp_dict