示例#1
0
 def get_by_wiki(self, citiao):
     tt = CabVoter2Reply.select().where(CabVoter2Reply.title == citiao).count()
     if tt == 0:
         return None
     else:
         self.update_view_count(citiao)
         return CabVoter2Reply.get(CabVoter2Reply.title == citiao)
示例#2
0
 def get_by_wiki(self, citiao):
     tt = CabVoter2Reply.select().where(
         CabVoter2Reply.title == citiao).count()
     if tt == 0:
         return None
     else:
         self.update_view_count(citiao)
         return CabVoter2Reply.get(CabVoter2Reply.title == citiao)
示例#3
0
 def query_cat_random(self, cat_id, num=6):
     if cat_id == '':
         return self.query_random(num)
     if config.dbtype == 1 or config.dbtype == 3:
         return CabVoter2Reply.select().join(CabPost2Catalog).where(CabPost2Catalog.catalog == cat_id).order_by(
             peewee.fn.Random()).limit(num)
     elif config.dbtype == 2:
         return CabVoter2Reply.select().join(CabPost2Catalog).where(CabPost2Catalog.catalog == cat_id).order_by(
             peewee.fn.Rand()).limit(num)
示例#4
0
 def query_cat_random(self, cat_id, num=6):
     if cat_id == '':
         return self.query_random(num)
     if config.dbtype == 1 or config.dbtype == 3:
         return CabVoter2Reply.select().join(CabPost2Catalog).where(
             CabPost2Catalog.catalog == cat_id).order_by(
                 peewee.fn.Random()).limit(num)
     elif config.dbtype == 2:
         return CabVoter2Reply.select().join(CabPost2Catalog).where(
             CabPost2Catalog.catalog == cat_id).order_by(
                 peewee.fn.Rand()).limit(num)
示例#5
0
 def get_previous_record(self, in_uid):
     current_rec = self.get_by_id(in_uid)
     query = CabVoter2Reply.select().where(CabVoter2Reply.time_update > current_rec.time_update).order_by(
         CabVoter2Reply.time_update)
     if query.count() == 0:
         return None
     else:
         return query.get()
示例#6
0
 def get_previous_record(self, in_uid):
     current_rec = self.get_by_id(in_uid)
     query = CabVoter2Reply.select().where(
         CabVoter2Reply.time_update > current_rec.time_update).order_by(
             CabVoter2Reply.time_update)
     if query.count() == 0:
         return None
     else:
         return query.get()
示例#7
0
    def insert_data(self, user_id, reply_id):

        record = CabVoter2Reply.select().where(
            (CabVoter2Reply.reply_id == reply_id) & (CabVoter2Reply.voter_id == user_id))

        if record.count() > 0:
            return (False)

        try:
            CabVoter2Reply.create(
                uid=tools.get_uuid(),
                reply_id=reply_id,
                voter_id=user_id,
                timestamp=time.time(),
            )
            return CabVoter2Reply.select().where(CabVoter2Reply.reply_id == reply_id).count()

        except:
            return False
示例#8
0
    def delete(self, del_id):

        try:
            del_count = CabReply.delete().where(CabReply.uid == del_id)
            del_count.execute()

            del_count2 = CabVoter2Reply.delete().where(CabVoter2Reply.reply_id == del_id)
            del_count2.execute()
            return True
        except:
            return False
示例#9
0
    def insert_data(self, user_id, reply_id):

        record = CabVoter2Reply.select().where(
            (CabVoter2Reply.reply_id == reply_id)
            & (CabVoter2Reply.voter_id == user_id))

        if record.count() > 0:
            return (False)

        try:
            CabVoter2Reply.create(
                uid=tools.get_uuid(),
                reply_id=reply_id,
                voter_id=user_id,
                timestamp=time.time(),
            )
            return CabVoter2Reply.select().where(
                CabVoter2Reply.reply_id == reply_id).count()

        except:
            return False
示例#10
0
    def update(self, uid, post_data, update_time=False):

        if 'id_spec' in post_data:
            id_spec = post_data['id_spec'][0]
        else:
            id_spec = 0

        if 'src_type' in post_data and post_data['src_type'][0] == '1':
            cnt_html = tools.rst2html(post_data['cnt_md'][0])
        else:
            cnt_html = tools.markdown2html(post_data['cnt_md'][0])

        if update_time:
            entry = CabVoter2Reply.update(
                title=post_data['title'][0],
                date=datetime.datetime.now(),
                cnt_html=cnt_html,
                user_name=post_data['user_name'],
                cnt_md=tornado.escape.xhtml_escape(post_data['cnt_md'][0]),
                time_update=time.time(),
                id_spec=id_spec,
                logo=post_data['logo'][0],
                keywords=post_data['keywords'][0],
                src_type=post_data['src_type'][0] if
                ('src_type' in post_data) else 0).where(
                    CabVoter2Reply.uid == uid)
        else:
            entry = CabVoter2Reply.update(
                title=post_data['title'][0],
                cnt_html=cnt_html,
                user_name=post_data['user_name'],
                cnt_md=tornado.escape.xhtml_escape(post_data['cnt_md'][0]),
                id_spec=id_spec,
                logo=post_data['logo'][0],
                keywords=post_data['keywords'][0],
                src_type=post_data['src_type'][0] if
                ('src_type' in post_data) else 0).where(
                    CabVoter2Reply.uid == uid)
        entry.execute()
示例#11
0
    def update(self, uid, post_data, update_time=False):

        if 'id_spec' in post_data:
            id_spec = post_data['id_spec'][0]
        else:
            id_spec = 0

        if 'src_type' in post_data and post_data['src_type'][0] == '1':
            cnt_html = tools.rst2html(post_data['cnt_md'][0])
        else:
            cnt_html = tools.markdown2html(post_data['cnt_md'][0])

        if update_time:
            entry = CabVoter2Reply.update(
                title=post_data['title'][0],
                date=datetime.datetime.now(),
                cnt_html=cnt_html,
                user_name=post_data['user_name'],
                cnt_md=tornado.escape.xhtml_escape(post_data['cnt_md'][0]),
                time_update=time.time(),
                id_spec=id_spec,
                logo=post_data['logo'][0],
                keywords=post_data['keywords'][0],
                src_type=post_data['src_type'][0] if ('src_type' in post_data) else 0
            ).where(CabVoter2Reply.uid == uid)
        else:
            entry = CabVoter2Reply.update(
                title=post_data['title'][0],
                cnt_html=cnt_html,
                user_name=post_data['user_name'],
                cnt_md=tornado.escape.xhtml_escape(post_data['cnt_md'][0]),
                id_spec=id_spec,
                logo=post_data['logo'][0],
                keywords=post_data['keywords'][0],
                src_type=post_data['src_type'][0] if ('src_type' in post_data) else 0
            ).where(CabVoter2Reply.uid == uid)
        entry.execute()
示例#12
0
    def delete(self, del_id):
        try:
            del_count2 = CabVoter2Reply.delete().where(
                CabVoter2Reply.reply_id == del_id)
            del_count2.execute()

            del_count3 = CabPost2Reply.delete().where(
                CabPost2Reply.reply_id == del_id)
            del_count3.execute()

            del_count4 = TabApp2Reply.delete().where(
                TabApp2Reply.reply_id == del_id)
            del_count4.execute()

            del_count = CabReply.delete().where(CabReply.uid == del_id)
            del_count.execute()

            return True
        except:

            return False
示例#13
0
 def update_view_count_by_uid(self, uid):
     entry = CabVoter2Reply.update(view_count=CabVoter2Reply.view_count +
                                   1).where(CabVoter2Reply.uid == uid)
     entry.execute()
示例#14
0
 def update_view_count(self, citiao):
     entry = CabVoter2Reply.update(view_count=CabVoter2Reply.view_count +
                                   1).where(CabVoter2Reply.title == citiao)
     entry.execute()
示例#15
0
 def query_most(self, num=8):
     return CabVoter2Reply.select().order_by(
         CabVoter2Reply.view_count.desc()).limit(num)
示例#16
0
 def update_view_count(self, citiao):
     entry = CabVoter2Reply.update(view_count=CabVoter2Reply.view_count + 1).where(CabVoter2Reply.title == citiao)
     entry.execute()
示例#17
0
文件: mreply.py 项目: Sijiu/TorCMS
 def get_by_zan(self, reply_id):
     return CabVoter2Reply.select().where(CabVoter2Reply.reply_id == reply_id).count()
示例#18
0
 def get_by_zan(self, reply_id):
     return CabVoter2Reply.select().where(
         CabVoter2Reply.reply_id == reply_id).count()
示例#19
0
 def query_dated(self, num=8):
     return CabVoter2Reply.select().order_by(CabVoter2Reply.time_update).limit(num)
示例#20
0
 def __init__(self):
     self.tab = CabVoter2Reply
     try:
         CabVoter2Reply.create_table()
     except:
         pass
示例#21
0
 def query_cat_recent(self, cat_id, num=8):
     return CabVoter2Reply.select().join(CabPost2Catalog).where(CabPost2Catalog.catalog == cat_id).order_by(
         CabVoter2Reply.time_update.desc()).limit(num)
示例#22
0
 def update_keywords(self, uid, inkeywords):
     entry = CabVoter2Reply.update(keywords=inkeywords).where(CabVoter2Reply.uid == uid)
     entry.execute()
示例#23
0
 def update_view_count_by_uid(self, uid):
     entry = CabVoter2Reply.update(view_count=CabVoter2Reply.view_count + 1).where(CabVoter2Reply.uid == uid)
     entry.execute()
示例#24
0
 def update_keywords(self, uid, inkeywords):
     entry = CabVoter2Reply.update(keywords=inkeywords).where(
         CabVoter2Reply.uid == uid)
     entry.execute()
示例#25
0
 def get_num_by_cat(self, cat_str):
     return CabVoter2Reply.select().where(CabVoter2Reply.id_cats.contains(',{0},'.format(cat_str))).count()
示例#26
0
 def query_keywords_empty(self):
     return CabVoter2Reply.select().where(CabVoter2Reply.keywords == '')
示例#27
0
 def __init__(self):
     self.tab = CabVoter2Reply
     try:
         CabVoter2Reply.create_table()
     except:
         pass
示例#28
0
 def query_keywords_empty(self):
     return CabVoter2Reply.select().where(CabVoter2Reply.keywords == '')
示例#29
0
 def query_dated(self, num=8):
     return CabVoter2Reply.select().order_by(
         CabVoter2Reply.time_update).limit(num)
示例#30
0
 def query_cat_recent(self, cat_id, num=8):
     return CabVoter2Reply.select().join(CabPost2Catalog).where(
         CabPost2Catalog.catalog == cat_id).order_by(
             CabVoter2Reply.time_update.desc()).limit(num)
示例#31
0
 def get_num_by_cat(self, cat_str):
     return CabVoter2Reply.select().where(
         CabVoter2Reply.id_cats.contains(',{0},'.format(cat_str))).count()
示例#32
0
 def query_most(self, num=8):
     return CabVoter2Reply.select().order_by(CabVoter2Reply.view_count.desc()).limit(num)