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))