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