class YetwoMovie(db.Model): __tablename__ = 'mv_movie_yetwo' id = db.Column(db.Integer, primary_key=True) title = db.Column(db.String(200)) url = db.Column(db.String(200)) img = db.Column(db.String(200)) category = db.Column(db.String(50))
class Movcat(db.Model): id = db.Column(db.Integer,primary_key=True) ename = db.Column(db.String(45)) name = db.Column(db.String(45)) def __init__(self, ename=None,name=None): self.ename = ename self.name = name def __repr__(self): return '<Category %r>' % self.name + self.ename
class HakuzyMovie(db.Model): __tablename__ = "mv_movie_hakuzy" query_class = HakuzyMovieQuery id = db.Column(db.Integer, primary_key=True) title = db.Column(db.String(200)) url = db.Column(db.String(200)) img = db.Column(db.String(200)) category = db.Column(db.String(50)) contents = db.Column(db.Text) lists = db.Column(db.Text) urltxt = db.Column(db.Text) ck = db.Column(db.Integer) def __init__(self, title, url): self.title = title self.url = url def __repr__(self): return '<Movie %r>' % self.title
class HakuzyMovieCategory(db.Model): __tablename__ = "mv_movie_hakuzycat" #绑定自定义QUERY query_class = HakuzyMovieCategoryQuery id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(45)) def __init__(self, name): self.name = name def __repr__(self): return '<Category %r>' % self.name
class Movdetail(db.Model): id = db.Column(db.Integer,primary_key=True) tp = db.Column(db.Integer) #属于哪个版本 url = db.Column(db.String(255)) mov_id = db.Column(db.Integer,db.ForeignKey('mov.id')) movie = db.relationship('Mov',backref=db.backref('movs',lazy='dynamic'))
class Mov(db.Model): id = db.Column(db.Integer,primary_key=True) title = db.Column(db.String(200)) banben = db.Column(db.String(50)) arts = db.Column(db.String(200)) dc = db.Column(db.String(100)) lang = db.Column(db.String(50)) location = db.Column(db.String(50)) pubdate = db.Column(db.String(50)) status = db.Column(db.String(50)) year = db.Column(db.String(50)) content = db.Column(db.Text) img = db.Column(db.String(200)) fromto = db.Column(db.String(20)) catestr = db.Column(db.String(45)) category_id = db.Column(db.Integer,db.ForeignKey('movcat.id')) category = db.relationship('Movcat',backref=db.backref('movs',lazy='dynamic'))
class YetwoCategory(db.Model): __tablename__ = 'yetwocategory' id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(45))