class VideoList(db.Model): # __table__ == 'videolist' id = db.Column(db.INTEGER,primary_key=True) rid = db.Column(db.INTEGER,db.ForeignKey('roominfo_main.room_id')) video_url = db.Column(db.String(128)) poster_url = db.Column(db.String(128)) video_name = db.Column(db.String(64)) def __init__(self,rid,v_url,p_url,v_name): self.rid = rid self.video_url = v_url self.poster_url = p_url self.video_name = v_name
class UserOther(db.Model): __tablename__ = 'user_other_info' id = db.Column(db.INTEGER,primary_key=True) uid = db.Column(db.INTEGER,db.ForeignKey('userinfo_main.user_id')) sex = db.Column(db.Enum('男','女','保密'),nullable=True) phone = db.Column(db.String(11),nullable=True) city = db.Column(db.String(15),nullable=True) ps = db.Column(db.Text,nullable=True) def __init__(self,uid,sex,phone,city,ps): self.uid = uid self.sex = sex self.phone = phone self.city = city self.ps = ps
class RoomComment(db.Model): # __tablename__ == 'room_comment' id = db.Column(db.INTEGER,primary_key=True) rid = db.Column(db.INTEGER,db.ForeignKey('roominfo_main.room_id')) uid = db.Column(db.INTEGER) comment = db.Column(db.Text) uname = db.Column(db.String(30)) def __init__(self,rid,comment,uid,uname): self.rid = rid self.comment = comment self.uid = uid self.uname = uname
class UserMain(UserMixin,db.Model): __tablename__ = 'userinfo_main' user_id = db.Column(db.INTEGER,primary_key=True) user_name = db.Column(db.String(20),nullable=False,unique=True) u_passwd = db.Column(db.String(256),nullable=False) age = db.Column(db.INTEGER,nullable=False) email = db.Column(db.String(50),nullable=False) img = db.Column(db.String(128)) other = db.relationship('UserOther',backref='userinfo_main',lazy='dynamic') fav = db.relationship('UserFav',backref='useinfo_main',lazy='dynamic') gift = db.relationship('UserGift',backref='userinfo_main',lazy='dynamic') score = db.relationship('UserScore',backref='userinfo_main',lazy='dynamic') def __init__(self,uname,pwd,age,email,img='img/user.jpg'): self.user_name = uname self.u_passwd = pwd self.age = age self.email = email self.img = img def __repr__(self): return 'userinfo %s %s'%(self.user_name,self.u_passwd)
class RoomMain(db.Model): __tablename__ = 'roominfo_main' room_id = db.Column(db.INTEGER,primary_key=True) room_name = db.Column(db.String(100)) host_name = db.Column(db.String(50)) img = db.Column(db.String(128)) is_oline = db.Column(db.INTEGER) live_url = db.Column(db.String(128)) host_img = db.Column(db.String(128)) count = db.relationship('RoomCount',backref='roominfo_main',lazy='dynamic') gift = db.relationship('RoomGift',backref='roominfo_main',lazy='dynamic') type = db.relationship('RoomType',backref='roominfo_main',lazy='dynamic') comment = db.relationship('RoomComment',backref='roominfo_main',lazy='dynamic') videolist = db.relationship('VideoList',backref='roominfo_main',lazy='dynamic') def __init__(self,rname,hname,img,ol,url,himg='img/user.jpg'): self.room_name = rname self.host_name = hname self.img = img self.is_oline = ol self.live_url = url self.host_img = himg