class Comment(Model): __talbe__ = 'comments' id = StringField(primary_key=True, default=get_id, updatable=False) blog_id = StringField(updatable=False) user_id = StringField(updatable=False) user_name = StringField() content = TextField() created_at = FloatField(updatable=False, default=time.time)
class Request(Model): __table__ = 'requests' id = StringField(primary_key=True, ddl='int(32)') rid = StringField(updatable=False, ddl='varchar(64)') 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() scan_xss = StringField(ddl='int(4)') scan_sqli = StringField(ddl='int(4)') result_xss = StringField(ddl='varchar(40)') result_sqli = StringField(ddl='varchar(40)') poc_xss = TextField() poc_sqli = TextField() time = StringField(ddl='varchar(255)') update_time = StringField(ddl='varchar(255)')
class Blog(Model): __table__ = 'blogs' id = StringField(primary_key=True, default=get_id, updatable=False) user_id = StringField(updatable=False) user_name = StringField() name = StringField() summary = StringField() 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)') 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 Review(Model): __table__ = 'reviews' id = StringField(primary_key=True, default=next_id, ddl='varchar(50)') movie_id = StringField(updatable=False, ddl='varchar(50)') user_id = StringField(updatable=False, ddl='varchar(50)') user_name = StringField(ddl='varchar(50)') score = IntegerField() content = TextField() created_at = FloatField(default=time.time)
class question(Model): """ """ __table__ = 'question' questionID = IntegerField(primary_key=True, ddl='integer', updatable=False) title = TextField() option = TextField() type = IntegerField(default=0, ddl='integer') createtime = TimeField(updatable=False, default=time.strftime("%Y-%m-%d %H:%M:%S", time.localtime())) altertime = TimeField(updatable=False, default=time.strftime("%Y-%m-%d %H:%M:%S", time.localtime())) score = IntegerField(ddl='integer') right_ans = StringField(ddl='varchar(100)') difficult = IntegerField(ddl='integer') part = IntegerField(ddl='integer')
class Comment(Model): __table__ = 'comments' id = IntegerField(primary_key=True, auto_increment=True) blog_id = StringField(updatable=False, size=50) user_id = StringField(updatable=False, size=50) user_name = StringField(50) user_image = StringField(500) content = TextField() created_at = TimestampField(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)') name = StringField(ddl='varchar(50)') summary = StringField(ddl='varchar(200)') content = TextField() created_at = FloatField(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)