def list(self, cur_p=''): ''' List the replies. ''' if cur_p == '': current_page_number = 1 else: current_page_number = int(cur_p) current_page_number = 1 if current_page_number < 1 else current_page_number pager_num = int(MReply.total_number() / CMS_CFG['list_num']) kwd = { 'pager': '', 'current_page': current_page_number, 'title': '单页列表', 'num_of_reply': MReply.total_number() } self.render( 'admin/reply_ajax/reply_list.html', kwd=kwd, view_all=MReply.query_all(), infos=MReply.query_pager(current_page_num=current_page_number), userinfo=self.userinfo)
def setup(self): print('setup 方法执行于本类中每条用例之前') self.post = MPost() self.user = MUser() self.reply = MReply() self.post_title = 'ccc' self.username = '******' self.uid = tools.get_uu4d()
def test_create_reply(self): post_data = { 'post_id': '11111', 'user_name': 'giser', 'user_id': 'ddadsaweadqw', 'cnt_reply': 'gisersdasdasdasdzxcsdwdqgiser', } MReply.create_reply(post_data) assert True
def setup(self): print('setup 方法执行于本类中每条用例之前') self.user = MUser() self.reply = MReply() self.r2u = MReply2User() self.username = '******' self.password = '******' self.user_uid = '12345' self.reply_uid = '65412'
def test_update_vote(self): self.add_message() MReply.update_vote(self.reply_uid, 8) aa = MReply.query_all() tf = False for i in aa: if i.uid == self.reply_uid: tf = True assert i.vote==8 self.tearDown() assert tf
def test_delete_by_uid(self): self.add_message() aa = MReply.query_all() tf = False for i in aa: if i.uid == self.reply_uid: tf = True assert tf MReply.delete_by_uid(self.reply_uid) aa = MReply.get_by_uid(self.reply_uid) assert aa == None self.tearDown()
def setup(self): print('setup 方法执行于本类中每条用例之前') self.post = MPost() self.user = MUser() self.reply = MReply() self.r2u = MReply2User() self.post_title = 'fwwgccc' self.username = '******' self.user_uid = '' self.reply_uid = '' self.post_uid = '998h' self.password = '******'
def test_get_by_uid(self): self.add_message() aa=MReply.get_by_uid(self.reply_uid) assert aa.uid==self.reply_uid assert aa.post_id==self.post_id assert aa.user_name==self.username self.tearDown()
class ReplyHandler(BaseHandler): def initialize(self): self.init() self.mreply = MReply() self.mreply2user = MReply2User() self.mpost2reply = MPost2Reply() def get(self, url_str=''): url_arr = self.parse_url(url_str) if url_arr[0] == 'get': self.get_by_id(url_arr[1]) def get_by_id(self, reply_id): reply = self.mreply.get_reply_by_uid(reply_id) self.render( 'doc/reply/show_reply.html', cnt=reply.cnt_html, username=reply.user_name, date=reply.date, vote=reply.vote, uid=reply.uid, userinfo=self.userinfo, unescape=tornado.escape.xhtml_unescape, )
def render(self, *args, **kwargs): uid = args[0] userinfo = args[1] return self.render_string('modules/widget/reply_panel.html', uid=uid, replys=MReply.query_by_post(uid), userinfo=userinfo, linkify=tornado.escape.linkify)
def zan(self, id_reply): ''' 先在外部表中更新,然后更新内部表字段的值。 有冗余,但是查看的时候避免了联合查询 ''' logger.info('zan: {0}'.format(id_reply)) MReply2User.create_reply(self.userinfo.uid, id_reply) cur_count = MReply2User.get_voter_count(id_reply) if cur_count: MReply.update_vote(id_reply, cur_count) output = {'text_zan': cur_count} else: output = {'text_zan': 0} logger.info('zan dic: {0}'.format(cur_count)) return json.dump(output, self)
def list(self): ''' List the replies. ''' kwd = {'pager': '', 'title': '单页列表'} self.render('admin/reply_ajax/reply_list.html', kwd=kwd, view_all=MReply.query_all(), userinfo=self.userinfo)
def test_modify_by_uid(self): self.add_message() aa=MReply.get_by_uid(self.reply_uid) assert aa.uid==self.reply_uid assert aa.post_id==self.post_id assert aa.user_name==self.username post_reply = { 'category': '1234', 'user_name': 'pink', 'user_id': '8900', 'cnt_reply': 'hahah' } MReply.modify_by_uid(self.reply_uid,post_reply) aa = MReply.get_by_uid(self.reply_uid) assert aa.user_name =='pink' assert aa.category == '1234' assert aa.user_id == '8900' self.tearDown()
def test_query_all(self): self.add_message() aa=MReply.query_all() tf = False for i in aa: if i.uid == self.reply_uid: tf = True self.tearDown() assert tf
def test_create_reply(self): self.add_message() aa=MReply.query_by_post(self.post_id) tf=False for i in aa: if i.uid==self.reply_uid: tf=True self.tearDown() assert tf
def delete_com(self, del_id): ''' Delete the reply id ''' if MReply.delete_by_uid(del_id): output = {'del_reply': 1} else: output = {'del_reply': 0} return json.dump(output, self)
def list(self): kwd = { 'pager': '', 'unescape': tornado.escape.xhtml_unescape, 'title': '单页列表' } self.render('admin/reply_ajax/reply_list.html', kwd=kwd, view_all=MReply.query_all(), userinfo=self.userinfo)
def add(self, post_id): post_data = self.get_post_data() post_data['user_name'] = self.userinfo.user_name post_data['user_id'] = self.userinfo.uid post_data['post_id'] = post_id replyid = MReply.create_reply(post_data) if replyid: out_dic = {'pinglun': post_data['cnt_reply'], 'uid': replyid} logger.info('add reply result dic: {0}'.format(out_dic)) return json.dump(out_dic, self)
def initialize(self, hinfo=''): self.init() self.mevaluation = MEvaluation() self.mpost2label = MInfor2Label() self.mpost2catalog = MInfor2Catalog() self.mpost = MInfor() self.musage = MUsage() self.mcat = MCategory() self.mrel = MInforRel() self.mreply = MReply() self.mpost_hist = MInfoHist()
def get_by_id(self, reply_id): reply = MReply.get_by_uid(reply_id) logger.info('get_reply: {0}'.format(reply_id)) self.render('misc/reply/show_reply.html', reply=reply, username=reply.user_name, date=reply.date, vote=reply.vote, uid=reply.uid, userinfo=self.userinfo, unescape=tornado.escape.xhtml_unescape)
def modify(self, pid, cat): ''' Adding comment to a post. ''' post_data = self.get_post_data() post_data['user_name'] = self.userinfo.user_name post_data['user_id'] = self.userinfo.uid post_data['category'] = cat reply = MReply.modify_by_uid(pid, post_data) if reply: out_dic = {'pinglun': post_data['cnt_reply'], 'uid': reply} logger.info('Modify reply result dic: {0}'.format(out_dic)) return json.dump(out_dic, self)
def render(self, *args, **kwargs): replyid = kwargs.get('replyid', '') userinfo = kwargs.get('userinfo', '') res = MReplyid.get_by_rid(replyid) datas = [] for x in res: rec = MReply.get_by_uid(x.reply1) if rec in datas: pass else: datas.append(rec) return self.render_string('modules/widget/comment_list.html', userinfo=userinfo, recs=datas)
def get_by_id(self, reply_id): ''' Get the reply by id. ''' reply = MReply.get_by_uid(reply_id) logger.info('get_reply: {0}'.format(reply_id)) self.render('misc/reply/show_reply.html', reply=reply, username=reply.user_name, date=reply.date, vote=reply.vote, uid=reply.uid, userinfo=self.userinfo)
def add_reply(self, post_id, reply_id): ''' Adding reply ''' post_data = self.get_post_data() post_data['user_name'] = self.userinfo.user_name post_data['user_id'] = self.userinfo.uid post_data['post_id'] = post_id post_data['category'] = '1' # 表里添加回复内容返回存储id replyid = MReply.create_reply(post_data) # 在关联表里存储评论id与回复id MReplyid.create_replyid(reply_id, replyid) if replyid: out_dic = {'pinglun': post_data['cnt_reply'], 'uid': replyid} logger.info('add reply result dic: {0}'.format(out_dic)) return json.dump(out_dic, self)
def add_message(self, **kwargs): post_data = { 'user_name': self.username, 'user_pass': kwargs.get('user_pass', 'g131322'), 'user_email': kwargs.get('user_email', '*****@*****.**'), } MUser.create_user(post_data) aa = MUser.get_by_name(self.username) self.user_id = aa.uid p_d = { 'title': kwargs.get('title', 'iiiii'), 'cnt_md': kwargs.get('cnt_md', 'grgr'), 'time_create': kwargs.get('time_create', '1992'), 'time_update': kwargs.get('time_update', '1996070600'), 'user_name': kwargs.get('user_name', 'ngng'), 'view_count': kwargs.get('view_count', 1), 'logo': kwargs.get('logo', 'prprprprpr'), 'memo': kwargs.get('memo', ''), 'order': kwargs.get('order', '1'), 'keywords': kwargs.get('keywords', ''), 'extinfo': kwargs.get('extinfo', {}), 'kind': kwargs.get('kind2', '1'), 'valid': kwargs.get('valid', 1), } MPost.create_post(self.post_id, p_d) post_reply={ 'post_id':self.post_id, 'user_name':self.username, 'user_id':self.user_id, 'cnt_reply':'daswrevwefgfgff' } self.reply_uid=MReply.create_reply(post_reply) MReplyid.create_replyid(self.post_id,self.reply_uid) aa=MReplyid.get_by_rid(self.post_id) for i in aa: if i.reply1==self.reply_uid: self.reply_id_uid=i.reply0 MReply2User.create_reply(self.user_id,self.reply_uid)
def render(self, *args, **kwargs): current = int(args[0]) # kind # current 当前页面 num_of_cat = MReply.count_of_certain() tmp_page_num = int(num_of_cat / config.CMS_CFG['list_num']) page_num = (tmp_page_num if abs(tmp_page_num - num_of_cat / config.CMS_CFG['list_num']) < 0.1 else tmp_page_num + 1) kwd = { 'page_home': False if current <= 1 else True, 'page_end': False if current >= page_num else True, 'page_pre': False if current <= 1 else True, 'page_next': False if current >= page_num else True, } return self.render_string('modules/admin/reply_pager.html', kwd=kwd, pager_num=page_num, page_current=current)
class TestMReply(): def setup(self): print('setup 方法执行于本类中每条用例之前') self.post = MPost() self.user = MUser() self.reply = MReply() self.post_title = 'ccc' self.username = '******' self.uid = tools.get_uu4d() # def test_insert_post(self): # # raw_count = self.post.get_counts() # # post_data = { # 'title': self.post_title, # 'cnt_md': '## adslkfjasdf\n lasdfkjsadf', # 'user_name': 'Tome', # 'view_count': 1, # 'logo': '/static/', # 'keywords': 'sdf', # # } # self.post.insert_data(self.uid, post_data) # # # tt = self.post.get_by_uid(self.uid) def test_insert_user(self): post_data = { 'user_name': self.username, 'user_pass': '******', 'user_email': '*****@*****.**', } tt = self.user.create_user(post_data) print('=' * 20) print(tt) assert tt['success'] == True self.tearDown() def test_insert_reply(self): post_data = { 'user_name': self.username, 'user_pass': '******', 'user_email': '*****@*****.**', } # tt=self.user.create_user(post_data) # u_id = self.user.get_by_name(self.username) # # # self.userid = u_id.uid # # print("*" * 50) # print(self.userid) # print("*" * 50) # post_data = { # 'user_name':[self.username], # 'create_user_id':[self.userid], # 'timestamp':['2'], # 'date':['1'], # 'cnt_md':['###adfafasf/sdf'], # 'cnt_html':['###adfafasf/sdf'], # 'vote':0, # } self.tearDown() # # def test_update_vote(self): # self.reply.update_vote() # assert True # # # def test_delete_by_uid(self): # self.reply.delete_by_uid() # assert True # # # def test_modify_by_uid(self): # self.reply.modify_by_uid() # assert True # def test_query_pager(self): self.reply.query_pager() assert True def test_total_number(self): self.reply.total_number() assert True def test_count_of_certain(self): self.reply.count_of_certain() assert True # # def test_delete(self): # self.reply.delete() # assert True # # def test_query_all(self): # self.reply.query_all() # assert True # # def test_get_by_zan(self): # self.reply.get_by_zan() # assert True # # def test_query_by_post(self): # self.reply.query_by_post() # assert True # # def test_create_reply(self): # self.reply.create_reply() # assert True # # def test_get_by_uid(self): # self.reply.get_by_uid() # assert True def tearDown(self): print("function teardown") tt = self.post.get_by_uid(self.uid) if tt: self.post.delete(tt.uid) self.user.delete_by_user_name(self.username)
def test_get_by_zan(self): a=MReply.get_by_zan(self.reply_uid) self.add_message() b=MReply.get_by_zan(self.reply_uid) assert a+1==b self.tearDown()
def tearDown(self): print("function teardown") MUser.delete_by_user_name(self.username) MPost.delete(self.post_id) MReply2User.delete(self.reply_uid) MReply.delete_by_uid(self.reply_uid)
def Test(): assert MReply()