def test_delete(self):
self.add_tag()
self.add_2post()
self.add_rela()
aa = MHelper.get_by_uid(TabRel, self.uid)
assert aa.post_f_id == self.post_id
MRelation.delete(self.uid)
aa = MHelper.get_by_uid(TabRel, self.uid)
assert aa == None
self.tearDown()
def test_query_average_rating(self):
self.add_message()
ave1=MRating.query_average_rating(self.post_id)
assert ave1==self.rating
MRating.update(self.post_id, 'fin', 4)
ave=MRating.query_average_rating(self.post_id)
assert ave==3.5
self.tearDown()
aa = MRating.query_by_post(self.post_id)
for i in aa:
if i.user_id == 'fin':
self.uid2 = i.uid
MHelper.delete(TabRating,self.uid2)
def get_by_uid(uid):
'''
Get the wiki object by the UID.
:param uid:
:return:
'''
return MHelper.get_by_uid(TabWiki, uid)
def get_by_uid(uid):
'''
根据ID得到类别实例
'''
if uid:
return MHelper.get_by_uid(TabTag, uid)
return False
def delete(uid):
'''
Delete by uid
:param uid:
:return:
'''
q_u1 = TabPostHist.delete().where(TabPostHist.post_id == uid)
q_u1.execute()
q_u2 = TabRel.delete().where(TabRel.post_f_id == uid
or TabRel.post_t_id == uid)
q_u2.execute()
q_u3 = TabCollect.delete().where(TabCollect.post_id == uid)
q_u3.execute()
q_u4 = TabPost2Tag.delete().where(TabPost2Tag.post_id == uid)
q_u4.execute()
q_u5 = TabUsage.delete().where(TabUsage.post_id == uid)
q_u5.execute()
reply_arr = []
for reply in TabUser2Reply.select().where(
TabUser2Reply.reply_id == uid):
reply_arr.append(reply.reply_id.uid)
q_u6 = TabUser2Reply.delete().where(TabUser2Reply.reply_id == uid)
q_u6.execute()
for replyid in reply_arr:
TabReply.delete().where(TabReply.uid == replyid).execute()
q_u7 = TabEvaluation.delete().where(TabEvaluation.post_id == uid)
q_u7.execute()
q_u8 = TabRating.delete().where(TabRating.post_id == uid)
q_u8.execute()
return MHelper.delete(TabPost, uid)
def delete(uid):
'''
Delete by uid
:param uid:
:return:
'''
return MHelper.delete(TabWikiHist, uid)
def delete(uid):
'''
Delete by uid
:param uid:
:return:
'''
return MHelper.delete(g_Link, uid)
def get_by_uid(uid):
'''
return the record by uid
:param uid:
:return:
'''
return MHelper.get_by_uid(g_PostHist, uid)
def delete(uid):
'''
Delete by uid
:param uid:
:return:
'''
return MHelper.delete(TabTag, uid)
def test_add_relation(self):
self.add_tag()
self.add_2post()
self.add_rela()
aa = MHelper.get_by_uid(TabRel, self.uid)
assert aa.post_f_id == self.post_id
assert aa.post_t_id == self.post_id2
self.tearDown()
def test_update_relation(self):
self.add_tag()
self.add_2post()
self.add_rela()
MRelation.update_relation(self.post_id, self.post_id2, weight=2)
aa = MHelper.get_by_uid(TabRel, self.uid)
assert aa.count >= 2 + 1
self.tearDown()
def delete(uid):
'''
Delete by uid
'''
return MHelper.delete(TabLink, uid)
def get_by_uid(uid):
'''
Get a link by ID.
'''
return MHelper.get_by_uid(TabLink, uid)
def delete(uid):
'''
:param uid:
:return:
'''
return MHelper.delete(MabLayout, uid)
def get_by_uid(uid):
return MHelper.get_by_uid(g_Link, uid)
def get_by_uid(uid):
'''
return the record by uid
'''
return MHelper.get_by_uid(TabReplyid, uid)
def get_by_uid(uid):
return MHelper.get_by_uid(TabWikiHist, uid)
def delete(uid):
return MHelper.delete(TabTag, uid)
def get_by_uid(uid):
return MHelper.get_by_uid(TabEntity, uid)
def get_by_uid(uid):
'''
return the record by uid
'''
return MHelper.get_by_uid(TabLog, uid)
def get_by_uid(uid):
'''
:param uid:
:return:
'''
return MHelper.get_by_uid(MabLayout, uid)
def tearDown(self):
print("function teardown")
MHelper.delete(TabRating,self.uid)
self.uid=''
def get_by_uid(uid):
'''
return the record by uid
'''
return MHelper.get_by_uid(TabReferrer, uid)
def get_by_uid(uid):
'''
return the record by uid
'''
return MHelper.get_by_uid(TabPostHist, uid)
def delete(uid):
return MHelper.delete(g_Tag, uid)
def delete(uid):
return MHelper.delete(TabEntity, uid)
def get_by_uid(uid):
return MHelper.get_by_uid(TabTag, uid)
def tearDown(self):
print("function teardown")
tt = MLog.get_by_uid(self.uid)
if tt:
MHelper.delete(TabLog, self.uid)
def delete(uid):
'''
Delete by uid
'''
return MHelper.delete(TabWiki, uid)
def delete(uid):
'''
Delete by uid
'''
return MHelper.delete(TabReferrer, uid)