class Moviecol(db.Model): id = db.Column(db.Integer, primary_key=True, autoincrement=True) movie_id = db.Column(db.Integer, db.ForeignKey(Movie.id)) user_id = db.Column(db.Integer, db.ForeignKey(User.id)) addtime = db.Column(db.DateTime, index=True, default=datetime.now) def __repr__(self): return '<Moviecol %r>' % self.id
class OrderItem(db.Model): __tablename__ = "myaxf_orderitem" # 修改表名 id = db.Column(db.Integer, primary_key=True, autoincrement=True) order_id = db.Column(db.Integer, db.ForeignKey("myaxf_order.id")) goods_id = db.Column(db.Integer, db.ForeignKey("axf_goods.id")) num = db.Column(db.Integer) buy_money = db.Column(db.Numeric(precision=10, scale=2))
class Preview(db.Model): id = db.Column(db.Integer, primary_key=True, autoincrement=True) title = db.Column(db.String(255), unique=True) logo = db.Column(db.String(255)) addtime = db.Column(db.DateTime, index=True, default=datetime.now) def __repr__(self): return '<Preview %r>' % self.title
class Auth(db.Model): id = db.Column(db.Integer, primary_key=True, autoincrement=True) # 名称 name = db.Column(db.String(255), unique=True) # 地址 url = db.Column(db.String(255), unique=True) addtime = db.Column(db.DateTime, index=True, default=datetime.now) def __repr__(self): return '<Auth %r>' % self.name
class Collection(db.Model): """收藏模型""" id = db.Column(db.Integer, primary_key=True, autoincrement=True) #设置与用户 一对多的关联关系 u_id = db.Column(db.Integer, db.ForeignKey("user.id")) #设置与博客 一对多的关联关系 b_id = db.Column(db.Integer, db.ForeignKey("blog.id")) __table_args__ = (db.UniqueConstraint("u_id", "b_id", name="u_id_b_id_uin_unique"), )
class Tag(db.Model): id = db.Column(db.Integer, primary_key=True, autoincrement=True) name = db.Column(db.String(255), unique=True) # 添加时间 addtime = db.Column(db.DateTime, index=True, default=datetime.now) movies = db.relationship('Movie', backref='tag', lazy=True) # 定义返回类型 def __repr__(self): return '<Tag %r>' % self.name
class Userlog(db.Model): id = db.Column(db.Integer, primary_key=True, autoincrement=True) # 登录IP ip = db.Column(db.String(255)) # 登录时间 addtime = db.Column(db.DateTime, index=True, default=datetime.now) user_id = db.Column(db.Integer, db.ForeignKey(User.id)) # 定义返回类型 def __repr__(self): return '<Userlog %r>' % self.name
class Order(db.Model): __tablename__ = "myaxf_order" # 修改表名 id = db.Column(db.Integer, primary_key=True, autoincrement=True) user_id = db.Column(db.Integer, # db.ForeignKey("myaxf_myuser.id") ) create_time = db.Column(db.DateTime, default=datetime.datetime.now()) status = db.Column(db.Integer) order_items = db.relationship("OrderItem", backref="order", lazy=True)
class Oplog(db.Model): id = db.Column(db.Integer, primary_key=True, autoincrement=True) # 登录IP ip = db.Column(db.String(255)) # 登录时间 addtime = db.Column(db.DateTime, index=True, default=datetime.now) # # 操作原因 reason = db.Column(db.String(255)) admin_id = db.Column(db.Integer, db.ForeignKey(Admin.id)) def __repr__(self): return '<Oplog %r>' % self.id
class Admin(db.Model): id = db.Column(db.Integer, primary_key=True, autoincrement=True) name = db.Column(db.String(30), unique=True) password = db.Column(db.Integer) # 是否为超级管理员 is_super = db.Column(db.SmallInteger) addtime = db.Column(db.DateTime, index=True, default=datetime.now) adminlogs = db.relationship('Adminlog', backref='admin', lazy=True) oplogs = db.relationship('Oplog', backref='admin', lazy=True) def __repr__(self): return '<Admin %r>' % self.id
class Blog(db.Model): """博客模型""" id = db.Column(db.Integer, primary_key=True, autoincrement=True) b_title = db.Column(db.String(255)) b_content = db.Column(db.String(255)) col = db.relationship("Collection", backref="blog", lazy=True) def to_dict(self): return { "id": self.id, "b_title": self.b_title, "b_content": self.b_content }
class News(db.Model): id = db.Column( db.Integer, primary_key=True, autoincrement=True ) title = db.Column( db.String(30), index=True ) content = db.Column( db.String(251), nullable=True )
class News(db.Model): id = db.Column(db.Integer, primary_key=True, autoincrement=True) title = db.Column(db.String(30), index=True) content = db.Column(db.String(100), nullable=True) type = db.Column(db.String(30), default="军事") def to_dict(self): data = { "id": self.id, "title": self.title, "content": self.content, "type": self.type } return data
class User(db.Model): id = db.Column(db.Integer, primary_key=True, autoincrement=True) name = db.Column(db.String(30), unique=True) password = db.Column(db.Integer) email = db.Column(db.String(100), unique=True) phone = db.Column(db.String(11)) # 个性简介 info = db.Column(db.Text) # 头像 face = db.Column(db.String(255)) addtime = db.Column(db.DateTime, index=True, default=datetime.now) uuid = db.Column(db.String(255), unique=True) isdelete = db.Column(db.Boolean, default=False) userlogs = db.relationship('Userlog', backref='user', lazy=True) comments = db.relationship('Comment', backref='user', lazy=True) moviecols = db.relationship('Moviecol', backref='user', lazy=True) # 定义返回类型 def __repr__(self): return '<User %r>' % self.name
class User(db.Model): """用户模型""" id = db.Column(db.Integer, primary_key=True, autoincrement=True) u_name = db.Column(db.String(255), nullable=True) u_phone = db.Column(db.String(13), nullable=True) u_password = db.Column(db.String(255), nullable=False) u_icon = db.Column(db.String(255), ) is_delete = db.Column(db.Boolean, default=False) cols = db.relationship("Collection", backref="user", lazy=True)
class User(db.Model): id = db.Column(db.Integer, primary_key=True, autoincrement=True) name = db.Column(db.String(30), nullable=True) email = db.Column(db.String(30), unique=True, index=True) pwd = db.Column(db.String(255), nullable=False) is_active = db.Column( db.Boolean, default=False, ) is_delete = db.Column( db.Boolean, default=False, ) #创建用户方法 @classmethod def create_user(cls, email, pwd, name=None): # email 能不能搜到一个用户,检查email users = User.query.filter(User.email == email) if users.count() > 0: return None # 加密pwd user_pwd = enc_pwd(pwd) # 创建用户 name = name if name else email user = cls(name=name, email=email, pwd=user_pwd) db.session.add(user) db.session.commit() return user #重置密码 def set_pwd(self, pwd): if not pwd and len(pwd) == 0: raise Exception("密码不能为空") #对密码加密 self.pwd = enc_pwd(pwd) db.session.add(self) db.session.commit() return True #检测密码 def check_pwd(self, pwd): u_pwd = enc_pwd(pwd) if u_pwd == self.pwd: return True else: return False
class Goods(db.Model): __tablename__ = "axf_goods" #修改表名 id = db.Column(db.Integer, primary_key=True, autoincrement=True) productid = db.Column(db.String(20)) productimg = db.Column(db.String(255)) productname = db.Column(db.String(130), ) productlongname = db.Column(db.String(190)) isxf = db.Column(db.Boolean, default=False) pmdesc = db.Column(db.Integer) specifics = db.Column(db.String(40)) price = db.Column(db.Numeric(precision=10, scale=2) #最大长度10位,小数点两位 ) marketprice = db.Column(db.Numeric(precision=10, scale=2)) categoryid = db.Column(db.Integer) childcid = db.Column(db.Integer) childcidname = db.Column(db.String(30)) dealerid = db.Column(db.String(30)) storenums = db.Column(db.Integer) productnum = db.Column(db.Integer) order_items_goods = db.relationship("OrderItem", backref="goods", lazy=True)
class Movie(db.Model): id = db.Column(db.Integer, primary_key=True, autoincrement=True) title = db.Column(db.String(255), unique=True) url = db.Column(db.String(255), unique=True) info = db.Column(db.Text) # 封面 logo = db.Column(db.String(255)) # 星级,小整形 star = db.Column(db.SmallInteger) # 播放量 playnum = db.Column(db.BigInteger) # 评论量 commentnum = db.Column(db.BigInteger) # 上映时间 release_time = db.Column(db.Date) # 时长 alength = db.Column(db.String(255)) # 上映地区 area = db.Column(db.String(255)) # 添加时间 addtime = db.Column(db.DateTime, index=True, default=datetime.now) # 所属标签 tag_id = db.Column(db.Integer, db.ForeignKey(Tag.id)) comments = db.relationship('Comment', backref='movie', lazy=True) moviecols = db.relationship('Moviecol', backref='movie', lazy=True) def __repr__(self): return '<Movie %r>' % self.title