class Comment(Model):
__table__ = 'comments'
id = StringField(primary_key=True, default=next_id, ddl='varchar(50)')
blog_id = StringField(updatable=False, ddl='varchar(50)')
user_id = StringField(updatable=False, ddl='varchar(50)')
user_name = StringField(ddl='varchar(50)')
user_image = StringField(ddl='varchar(500)')
content = TextField()
created_at = FloatField(updatable=False, default=time.time)
class Blog(Model):
__table__ = 'blogs'
id = StringField(primary_key=True, default=next_id(), ddl='varchar(50)')
user_id = StringField(updatable=False, ddl='varchar(50)')
user_name = StringField(ddl='varchar(50)')
user_image = StringField(ddl='varchar(50)')
name = StringField(ddl='varchar(50)')
summary = StringField(ddl='varchar(50)')
content = TextField()
created_at = FloatField(updatable=False, default=time.time)
class Blog(Model):
__table__ = 'blogs'
id = IntegerField(primary_key=True, auto_increment=True)
user_id = StringField(updatable=False, size=50)
user_name = StringField(50)
user_image = StringField(500)
name = StringField(50)
summary = StringField(200)
content = TextField()
created_at = TimestampField(updatable=False, default=time.time)
class ExclusionScan(Model):
__table__ = 'exclusions_scan'
id = StringField(primary_key=True, ddl='int(50)')
type = StringField(ddl='int(4)')
ip = StringField(ddl='varchar(40)')
port = StringField(ddl='varchar(40)')
protocol = StringField(ddl='varchar(40)')
host = StringField(ddl='varchar(255)')
method = StringField(ddl='varchar(40)')
user_agent = TextField()
accept = StringField(ddl='varchar(255)')
accept_language = StringField(ddl='varchar(255)')
accept_encoding = StringField(ddl='varchar(255)')
cookie = TextField()
referer = TextField()
content_type = StringField(ddl='varchar(255)')
post_data = TextField()
path = TextField()
update_time = StringField(ddl='varchar(255)')
class log(Model):
""""""
__table__ = 'log'
id = IntegerField(ddl='integer',
primary_key=True,
auto_incre=True,
updatable=False)
time = TimeField(updatable=False,
default=time.strftime("%Y-%m-%d %H:%M:%S",
time.localtime()))
details = TextField()
class Movie(Model):
__table__ = 'movies'
id = StringField(primary_key=True, default=next_id, ddl='varchar(50)')
name = StringField(ddl='varchar(50)')
summary = TextField()
score = FloatField()
num_review = IntegerField()
duration = IntegerField()
style = StringField(ddl='varchar(50)')
date = StringField(ddl='varchar(50)')
director = StringField(ddl='varchar(50)')
writer = StringField(ddl='varchar(50)')
star = StringField(ddl='varchar(200)')
created_at = FloatField(updatable=False, default=time.time)
class Unactiveurl(Model):
__table__='unactiveurl'
id = StringField(updatable=False,primary_key=True, default=next_id, ddl='varchar(50)')
user_id = StringField(updatable=False, ddl='varchar(50)')
url = StringField(ddl='varchar(255)')
frequent = IntegerField(updatable=False, default=30)
top_num = IntegerField(updatable=False, default=1)
send_mail_num = IntegerField(updatable=True, default=0)
total_record_num = IntegerField(updatable=True, default=0)
get_page_num = IntegerField(updatable=True, default=0)
parse_page_num = IntegerField(updatable=True, default=0)
new_record_num = IntegerField(updatable=True, default=0)
record_contents = TextField()
last_send_time = StringField(default =now_datetime)
create_time= StringField(default =now_datetime)
class Url(Model):
__table__='activeurl'
id = StringField(updatable=False,primary_key=True, default=next_id, ddl='varchar(50)')
user_id = StringField(updatable=False, ddl='varchar(50)')
url = StringField(ddl='varchar(255)')
frequent = IntegerField(updatable=False, default=30)
top_num = IntegerField(updatable=False, default=1)
send_mail_num = IntegerField(updatable=True, default=0)
total_record_num = IntegerField(updatable=True, default=0)
get_page_num = IntegerField(updatable=True, default=0)
parse_page_num = IntegerField(updatable=True, default=0)
new_record_num = IntegerField(updatable=True, default=0)
record_contents = TextField()
last_send_time = StringField()
create_time= StringField(default =now_datetime)
status = IntegerField(updatable=True, default=1)
fun_index = IntegerField(updatable=True, default=0)
summary = StringField(ddl='varchar(255)')
reason = StringField(ddl='varchar(1024)',default = r'一切正常')
last_time = IntegerField(updatable=True, default=0)
class ExclusionCookie(Model):
__table__ = 'exclusions_cookie'
id = StringField(primary_key=True, ddl='int(50)')
exclusion = TextField()
update_time = StringField(ddl='varchar(255)')
name = StringField(ddl='varchar(50)')
image = StringField(ddl='varchar(500)')
created_at = FloatField(updatable=False, default=time.time)
class Blog(Model):
__table__ = 'blogs'
id = StringField(primary_key=True, default=next_id, ddl='varchar(50)')
user_id = StringField(updatable=False, ddl='varchar(50)')
user_name = StringField(ddl='varchar(50)')
user_image = StringField(ddl='varchar(500)')
name = StringField(ddl='varchar(50)')
summary = StringField(ddl='varchar(200)')
content = TextField()
created_at = FloatField(updatable=False, default=time.time)
class Comment(Model):
__table__ = 'comments'
id = StringField(primary_key=True, default=next_id, ddl='varchar(50)')
blog_id = StringField(updatable=False, ddl='varchar(50)')
user_id = StringField(updatable=False, ddl='varchar(50)')
user_name = StringField(ddl='varchar(50)')
user_image = StringField(ddl='varchar(500)')
content = TextField()
created_at = FloatField(updatable=False, default=time.time)
