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
