def po_event_feedback_list(event_id):
ids = rank_po_id_list(event_id, CID_EVENT_FEEDBACK, 'confidence')
li = Po.mc_get_list(ids)
Zsite.mc_bind(li, 'user', 'user_id')
return li
def po_event_feedback_list(event_id):
ids = rank_po_id_list(event_id, CID_EVENT_FEEDBACK, 'confidence')
li = Po.mc_get_list(ids)
Zsite.mc_bind(li, 'user', 'user_id')
return li
def po_user_id_list(question_id):
question = Po.mc_get(question_id)
user_id = question.user_id
po_id_list = rank_po_id_list(question_id, CID_QUESTION, 'confidence')
po_list = Po.mc_get_list(po_id_list)
user_id_list = [i.user_id for i in po_list]
user_id_list.append(user_id)
return set(user_id_list)
def po_user_id_list(question_id):
question = Po.mc_get(question_id)
user_id = question.user_id
po_id_list = rank_po_id_list(question_id, CID_QUESTION, 'confidence')
po_list = Po.mc_get_list(po_id_list)
user_id_list = [i.user_id for i in po_list]
user_id_list.append(user_id)
return set(user_id_list)
def event_joiner_by_owner_id(user_id):
event_id_list = event_id_list_by_zsite_id(user_id, False, None, None)
result = []
if event_id_list:
event_id_list_with_count = []
event_id_count_list = []
for id, count in zip(event_id_list,
event_joiner_new_count.get_list(event_id_list)):
if count:
event_id_list_with_count.append(id)
event_id_count_list.append(count)
for po, count in zip(Po.mc_get_list(event_id_list_with_count),
event_id_count_list):
result.append((po.id, po.name, count))
return result
def event_joiner_by_owner_id(user_id):
event_id_list = event_id_list_by_zsite_id(user_id, False, None, None)
result = []
if event_id_list:
event_id_list_with_count = []
event_id_count_list = []
for id, count in zip(
event_id_list,
event_joiner_new_count.get_list(event_id_list)
):
if count:
event_id_list_with_count.append(id)
event_id_count_list.append(count)
for po, count in zip(
Po.mc_get_list(event_id_list_with_count),
event_id_count_list
):
result.append((po.id, po.name, count))
return result
def po_answer_list(question_id, zsite_id=0, user_id=0):
ids = rank_po_id_list(question_id, CID_QUESTION, 'confidence')
if zsite_id == user_id:
zsite_id = 0
user_ids = filter(bool, (zsite_id, user_id))
if user_ids:
_ids = []
for i in user_ids:
user_answer_id = answer_id_get(i, question_id)
if user_answer_id:
_ids.append(user_answer_id)
if user_answer_id in ids:
ids.remove(user_answer_id)
if _ids:
_ids.extend(ids)
ids = _ids
li = Po.mc_get_list(ids)
Zsite.mc_bind(li, 'user', 'user_id')
return li
def po_answer_list(question_id, zsite_id=0, user_id=0):
ids = rank_po_id_list(question_id, CID_QUESTION, 'confidence')
if zsite_id == user_id:
zsite_id = 0
user_ids = filter(bool, (zsite_id, user_id))
if user_ids:
_ids = []
for i in user_ids:
user_answer_id = answer_id_get(i, question_id)
if user_answer_id:
_ids.append(user_answer_id)
if user_answer_id in ids:
ids.remove(user_answer_id)
if _ids:
_ids.extend(ids)
ids = _ids
li = Po.mc_get_list(ids)
Zsite.mc_bind(li, 'user', 'user_id')
return li
def po_list_by_zsite_id(zsite_id, cid , limit, offset):
return Po.mc_get_list(po_id_list_by_zsite_id(
zsite_id, cid , limit, offset
))
def event_list_join_by_user_id(user_id, limit, offset):
id_list = event_id_list_join_by_user_id(user_id, limit, offset)
return zip(Event.mc_get_list(id_list), Po.mc_get_list(id_list))
def event_end_list_by_city_pid(city_pid, limit, offset):
id_list = event_end_id_list_by_city_pid(city_pid, limit, offset)
return zip(Event.mc_get_list(id_list), Po.mc_get_list(id_list))
def event_list_by_city_pid_cid(city_pid, cid, limit=10, offset=0):
id_list = event_id_list_by_city_pid_cid(city_pid, cid, limit, offset)
return zip(Event.mc_get_list(id_list), Po.mc_get_list(id_list))
if user_id:
return self.user_id == user_id
def mc_flush_reply_id_list(cid, rid):
key = '%s_%s' % (cid, rid)
mc_reply_id_list.delete(key)
mc_reply_id_list_reversed.delete(key)
mc_reply_count.delete(key)
mc_reply_zsite_id_list.delete(key)
if __name__ == '__main__':
r = Reply.raw_sql(
'select *,count(rid) from reply where cid = 62 group by rid order by count(rid) desc limit 50'
).fetchall()
from po import Po
p_l, c_l = [], []
for i in r:
p_l.append(i[1])
c_l.append(i[-1])
p = Po.mc_get_list(p_l)
p = filter(lambda x: x, p)
p = map(lambda x: (x.name, x.txt, 'http:%s' % x.link), p)
res = zip(p, c_l[1:])
for n, ((i, l, j), k) in enumerate(res):
print '#' * 20
print '第%s名：' % (n + 1), i, j, '\n', '回复数:', k,
print l, '\n\n'
pass
def po_review_list_active_by_zsite_id(id):
return Po.mc_get_list(po_review_id_list_active_by_zsite_id(id))
def count_po_list_by_zsite_tag_id_cid(zsite_tag_id, cid, limit=6):
return (
zsite_tag_cid_count(zsite_tag_id, cid),
Po.mc_get_list(po_id_list_by_zsite_tag_id_cid(zsite_tag_id, cid, limit))
)
def can_admin(self, user_id):
if user_id:
return self.user_id == user_id
def mc_flush_reply_id_list(cid, rid):
key = '%s_%s' % (cid, rid)
mc_reply_id_list.delete(key)
mc_reply_id_list_reversed.delete(key)
mc_reply_count.delete(key)
mc_reply_zsite_id_list.delete(key)
if __name__ == '__main__':
r = Reply.raw_sql('select *,count(rid) from reply where cid = 62 group by rid order by count(rid) desc limit 50').fetchall()
from po import Po
p_l,c_l = [],[]
for i in r:
p_l.append(i[1])
c_l.append(i[-1])
p = Po.mc_get_list(p_l)
p = filter(lambda x:x,p)
p = map(lambda x:(x.name,x.txt,'http:%s'%x.link),p)
res = zip(p,c_l[1:])
for n,((i,l,j),k) in enumerate(res):
print '#'*20
print '第%s名：'%(n+1),i,j,'\n','回复数:',k,
print l,'\n\n'
pass
def fav_po_list_by_user_id_cid(user_id, cid, limit, offset=0):
id_list = fav_po_id_list_by_user_id_cid(user_id, cid, limit, offset)
if cid == CID_EVENT:
return zip(Event.mc_get_list(id_list), Po.mc_get_list(id_list))
return Po.mc_get_list(id_list)
def event_list_by_city_pid_cid(city_pid, cid, limit=10, offset=0):
id_list = event_id_list_by_city_pid_cid(city_pid, cid, limit, offset)
return zip(Event.mc_get_list(id_list), Po.mc_get_list(id_list))
def event_list_by_zsite_id(zsite_id, can_admin, limit, offset):
id_list = event_id_list_by_zsite_id(zsite_id, bool(can_admin), limit,
offset)
return zip(Event.mc_get_list(id_list), Po.mc_get_list(id_list))
def event_all_list(limit, offset):
id_list = event_all_id_list(limit, offset)
return zip(Event.mc_get_list(id_list), Po.mc_get_list(id_list))
def po_event_notice_list_by_event_id(event_id):
return Po.mc_get_list(
po_event_notice_id_list_by_event_id(event_id)
)
def po_event_notice_list_by_event_id(event_id):
return Po.mc_get_list(po_event_notice_id_list_by_event_id(event_id))
def po_review_show_list_with_user(id):
review_list = Po.mc_get_list(po_review_show_id_list(id))
po_review_bind(review_list)
return review_list
def product_show_list(limit=None, offset=None):
return Po.mc_get_list(product_show_id_list(limit, offset))
def count_po_list_by_zsite_tag_id_cid(zsite_tag_id, cid, limit=6):
return (zsite_tag_cid_count(zsite_tag_id, cid),
Po.mc_get_list(
po_id_list_by_zsite_tag_id_cid(zsite_tag_id, cid, limit)))
def product_list_by_com_id(com_id):
return Po.mc_get_list(product_id_list_by_com_id(com_id))
def po_review_show_list_with_user(id):
review_list = Po.mc_get_list(po_review_show_id_list(id))
po_review_bind(review_list)
return review_list
def event_end_list_by_city_pid(city_pid, limit, offset):
id_list = event_end_id_list_by_city_pid(city_pid, limit, offset)
return zip(Event.mc_get_list(id_list), Po.mc_get_list(id_list))
def product_list_by_com_id(com_id):
return Po.mc_get_list(product_id_list_by_com_id(com_id))
def product_show_list(limit=None, offset=None):
return Po.mc_get_list(product_show_id_list(limit, offset))
def event_list_join_by_user_id(user_id, limit, offset):
id_list = event_id_list_join_by_user_id(user_id, limit, offset)
return zip(Event.mc_get_list(id_list), Po.mc_get_list(id_list))
def po_show_list(limit, offset):
ids = feed_rt_list(0, limit, offset)
li = Po.mc_get_list(ids)
li = Po.mc_get_list(i.rid for i in li)
Zsite.mc_bind(li, 'user', 'user_id')
return li
def event_all_list(limit, offset):
id_list = event_all_id_list(limit, offset)
return zip(Event.mc_get_list(id_list), Po.mc_get_list(id_list))
def po_review_list_active_by_zsite_id(id):
return Po.mc_get_list(
po_review_id_list_active_by_zsite_id(id)
)
def event_list_by_zsite_id(zsite_id, can_admin, limit, offset):
id_list = event_id_list_by_zsite_id(zsite_id, bool(can_admin), limit, offset)
return zip(Event.mc_get_list(id_list), Po.mc_get_list(id_list))
def po_show_list(limit, offset):
ids = feed_rt_list(0, limit, offset)
li = Po.mc_get_list(ids)
li = Po.mc_get_list(i.rid for i in li)
Zsite.mc_bind(li, 'user', 'user_id')
return li
def po_list_by_zsite_id(zsite_id, cid, limit, offset):
return Po.mc_get_list(po_id_list_by_zsite_id(zsite_id, cid, limit, offset))
