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_kill_extra(from_id, event_id, po_id):
from notice import notice_event_kill_one, notice_event_kill_mail
event_po = Po.mc_get(event_id)
title = event_po.name
event = Event.mc_get(event_id)
link = event.link
po = Po.mc_get(event_id)
txt = po.name
notice_link = po.link
for i in EventJoiner.where(event_id=event_id).where('state>=%s', EVENT_JOIN_STATE_NEW):
event_joiner_no(i)
user_id = i.user_id
notice_event_kill_one(from_id, user_id, po_id)
notice_event_kill_mail(user_id, title, link, txt, notice_link)
def event_kill_extra(from_id, event_id, po_id):
from notice import notice_event_kill_one, notice_event_kill_mail
event_po = Po.mc_get(event_id)
title = event_po.name
event = Event.mc_get(event_id)
link = event.link
po = Po.mc_get(event_id)
txt = po.name
notice_link = po.link
for i in EventJoiner.where(event_id=event_id).where(
'state>=%s', EVENT_JOIN_STATE_NEW):
event_joiner_no(i)
user_id = i.user_id
notice_event_kill_one(from_id, user_id, po_id)
notice_event_kill_mail(user_id, title, link, txt, notice_link)
def render_feed_by_zsite_id(zsite_id, limit=MAXINT, begin_id=MAXINT):
zsite_id_list = zsite_id_list_by_follow(zsite_id)
rt_dict = defaultdict(list)
id_list = []
id = 0
for i in feed_merge_iter(zsite_id_list, limit, begin_id):
id = i.id
po = Po.mc_get(id)
if po is None:
continue
if po.cid == CID_REC:
id = po.rid
od = rt_dict[id]
user_id = po.user_id
data = (po.id, po.txt,po.user_id)
od.append(data)
else:
id = po.id
if id not in id_list:
id_list.append(id)
return render_feed_list(id_list, zsite_id, rt_dict), id
def event_end_mail(event):
event_id = event.id
owner_id = event.zsite_id
owner = event.zsite
po = Po.mc_get(event_id)
rendermail(
'/mail/event/event_end_owner.txt',
mail_by_user_id(owner_id),
owner.name,
title=po.name,
link=po.link,
user_link=owner.link,
price=event.price,
feedback_link='/event/feedback/%s' % event_id
)
sleep(0.1)
for user_id in event_joiner_user_id_list(event_id):
if user_id != owner_id:
user = Zsite.mc_get(user_id)
rendermail(
'/mail/event/event_end_joiner.txt',
mail_by_user_id(user_id),
user.name,
title=po.name,
link=po.link,
user_link=user.link,
feedback_link='/event/feedback/%s' % event_id
)
sleep(0.1)
def product_rm(com_id, user_id, id):
po = Po.mc_get(id)
if po and po.zsite_id == com_id and po.cid == CID_PRODUCT:
_po_rm(user_id, po)
mc_product_id_list_by_com_id.delete(com_id)
from model.po_product_show import product_show_rm
product_show_rm(po)
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_new(user_id, name, txt, good, event_id, event_user_id):
if not name and not txt:
return
id = event_feedback_id_get(user_id, event_id)
if id:
m = Po.mc_get(id)
else:
m = po_new(CID_EVENT_FEEDBACK, user_id, name, STATE_ACTIVE, event_id)
if m:
id = m.id
mc_event_feedback_id_get.set('%s_%s' % (user_id, event_id), id)
m.feed_new()
from buzz import buzz_event_feedback_new , mq_buzz_event_feedback_owner_new
if user_id != event_user_id:
rank_new(m, event_id, CID_EVENT_FEEDBACK)
buzz_event_feedback_new(user_id, id, event_user_id)
else:
mq_buzz_event_feedback_owner_new(user_id, id)
event_joiner_state_set_by_good(user_id, event_id, good)
return m
def po_recommend_new(rid, user_id, name, reply_id=None):
'''新建推荐'''
#判定?
rec_po = Po.mc_get(rid)
if not rec_po:
return
from po_pos import po_pos_state_buzz
po_pos_state_buzz(user_id, rec_po)
recommend = po_new(
CID_REC,
user_id,
name,
state=STATE_ACTIVE,
rid=rid
)
if recommend:
recommend.feed_new()
mc_po_recommend_id_by_rid_user_id.set(
'%s_%s'%(rid, user_id),
recommend.id
)
if reply_id:
rr = RecRep(
id=recommend.id,
reply_id=reply_id
)
rr.save()
return recommend
def _po_cid_count_by_zsite_id(zsite_id, cid):
qs = Po.where(
zsite_id=zsite_id
).where('state>=%s'%STATE_PO_ZSITE_SHOW_THEN_REVIEW)
if cid:
qs = qs.where(cid=cid)
return qs.count()
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 event_review_yes(id):
event = Event.mc_get(id)
#print event,id, event.state
if event and event.state <= EVENT_STATE_TO_REVIEW:
event.state = EVENT_STATE_BEGIN
event.save()
mc_flush_by_city_pid_cid(event.city_pid, event.cid)
zsite_id = event.zsite_id
event_joiner_new(id, zsite_id, EVENT_JOIN_STATE_YES)
po = Po.mc_get(id)
if po.zsite_id:
state = STATE_PO_ZSITE_SHOW_THEN_REVIEW
else:
state = STATE_ACTIVE
po_state_set(po, state)
notice_event_yes(event.zsite_id, id)
mc_event_id_list_by_zsite_id.delete('%s_%s'%(zsite_id, False))
mq_rendermail(
'/mail/event/event_review_yes.txt',
mail_by_user_id(event.zsite_id),
event.zsite.name,
link=po.link,
title=po.name,
price=event.price
)
def product_rm(com_id , user_id, id):
po = Po.mc_get(id)
if po and po.zsite_id == com_id and po.cid == CID_PRODUCT:
_po_rm(user_id, po)
mc_product_id_list_by_com_id.delete(com_id)
from model.po_product_show import product_show_rm
product_show_rm(po)
def po_event_feedback_new(user_id, name, txt, good, event_id, event_user_id):
if not name and not txt:
return
id = event_feedback_id_get(user_id, event_id)
if id:
m = Po.mc_get(id)
else:
m = po_new(CID_EVENT_FEEDBACK, user_id, name, STATE_ACTIVE, event_id)
if m:
id = m.id
mc_event_feedback_id_get.set('%s_%s' % (user_id, event_id), id)
m.feed_new()
from buzz import buzz_event_feedback_new, mq_buzz_event_feedback_owner_new
if user_id != event_user_id:
rank_new(m, event_id, CID_EVENT_FEEDBACK)
buzz_event_feedback_new(user_id, id, event_user_id)
else:
mq_buzz_event_feedback_owner_new(user_id, id)
event_joiner_state_set_by_good(user_id, event_id, good)
return m
def event_end_mail(event):
event_id = event.id
owner_id = event.zsite_id
owner = event.zsite
po = Po.mc_get(event_id)
rendermail('/mail/event/event_end_owner.txt',
mail_by_user_id(owner_id),
owner.name,
title=po.name,
link=po.link,
user_link=owner.link,
price=event.price,
feedback_link='/event/feedback/%s' % event_id)
sleep(0.1)
for user_id in event_joiner_user_id_list(event_id):
if user_id != owner_id:
user = Zsite.mc_get(user_id)
rendermail('/mail/event/event_end_joiner.txt',
mail_by_user_id(user_id),
user.name,
title=po.name,
link=po.link,
user_link=user.link,
feedback_link='/event/feedback/%s' % event_id)
sleep(0.1)
def event_review_yes(id):
event = Event.mc_get(id)
#print event,id, event.state
if event and event.state <= EVENT_STATE_TO_REVIEW:
event.state = EVENT_STATE_BEGIN
event.save()
mc_flush_by_city_pid_cid(event.city_pid, event.cid)
zsite_id = event.zsite_id
event_joiner_new(id, zsite_id, EVENT_JOIN_STATE_YES)
po = Po.mc_get(id)
if po.zsite_id:
state = STATE_PO_ZSITE_SHOW_THEN_REVIEW
else:
state = STATE_ACTIVE
po_state_set(po, state)
notice_event_yes(event.zsite_id, id)
mc_event_id_list_by_zsite_id.delete('%s_%s' % (zsite_id, False))
mq_rendermail('/mail/event/event_review_yes.txt',
mail_by_user_id(event.zsite_id),
event.zsite.name,
link=po.link,
title=po.name,
price=event.price)
def po_review_id_get(zsite_id, user_id):
c = Po.raw_sql(
'select id from po where zsite_id=%s and user_id=%s and cid=%s',
zsite_id, user_id, CID_REVIEW)
r = c.fetchone()
if r:
return r[0]
return 0
def event_feedback_id_get(user_id, event_id):
c = Po.raw_sql(
'select id from po where rid=%s and cid=%s and user_id=%s and state>%s', event_id, CID_EVENT_FEEDBACK, user_id, STATE_RM
)
r = c.fetchone()
if r:
return r[0]
return 0
def po_id_list_by_zsite_id(zsite_id, cid, limit, offset):
qs = Po.where(zsite_id=zsite_id).where('state>=%s' %
STATE_PO_ZSITE_SHOW_THEN_REVIEW)
if cid:
qs = qs.where(cid=cid)
return qs.order_by('id desc').col_list(limit, offset)
def event_feedback_id_get(user_id, event_id):
c = Po.raw_sql(
'select id from po where rid=%s and cid=%s and user_id=%s and state>%s',
event_id, CID_EVENT_FEEDBACK, user_id, STATE_RM)
r = c.fetchone()
if r:
return r[0]
return 0
def po_id_list_by_zsite_id(zsite_id, cid, limit, offset):
qs = Po.where(
zsite_id=zsite_id
).where('state>=%s'%STATE_PO_ZSITE_SHOW_THEN_REVIEW)
if cid:
qs = qs.where(cid=cid)
return qs.order_by('id desc').col_list(limit, offset)
def po_recommend_id_by_rid_user_id(rid, user_id):
c = Po.raw_sql(
'select id from po where rid=%s and user_id=%s and cid=%s and state = %s',
rid, user_id, CID_REC, STATE_ACTIVE
)
r = c.fetchone()
if r:
return r[0]
return 0
def po_review_id_get(zsite_id, user_id):
c = Po.raw_sql(
'select id from po where zsite_id=%s and user_id=%s and cid=%s',
zsite_id, user_id, CID_REVIEW
)
r = c.fetchone()
if r:
return r[0]
return 0
def notice_event_notice(from_id, event_id, po_id):
from event import event_joiner_user_id_list
po = Po.mc_get(event_id)
title = po.name
link = po.link
notice_po = Po.mc_get(po_id)
txt = notice_po.name
notice_link = notice_po.link
for user_id in event_joiner_user_id_list(event_id):
notice_new(from_id, user_id, CID_NOTICE_EVENT_NOTICE, po_id)
name = Zsite.mc_get(user_id).name
mail = mail_by_user_id(user_id)
rendermail('/mail/event/event_notice.txt',
mail, name,
title=title,
link=link,
txt=txt,
notice_link=notice_link,
)
def fav_rm(user_id, po_id):
cid = fav_cid(user_id, po_id)
if cid:
Fav.where(user_id=user_id, po_id=po_id).delete()
mc_fav_cid.set('%s_%s' % (user_id, po_id), 0)
mc_flush_by_user_id(user_id, cid)
mc_flush_by_po_id(po_id)
po = Po.mc_get(po_id)
from po_tag import po_score_incr
po_score_incr(po, user_id, -7)
def notice_question_mail(notice):
from_id = notice.from_id
to_id = notice.to_id
rid = notice.rid
mail = mail_by_user_id(to_id)
name = Zsite.mc_get(to_id).name
from_name = Zsite.mc_get(from_id).name
question = Po.mc_get(rid)
rendermail('/mail/notice/notice_question.txt', mail, name,
entry=question,
from_name=from_name,
notice=notice,
)
def notice_event_join_yes(from_id, to_id, event_id):
n = notice_new(from_id, to_id, CID_NOTICE_EVENT_JOIN_YES, event_id)
mail = mail_by_user_id(to_id)
zsite = Zsite.mc_get(to_id)
po = Po.mc_get(event_id)
title = po.name
link = po.link
mq_rendermail('/mail/event/event_join_yes.txt',
mail, zsite.name,
link=link,
title=title
)
return n
def feed_po_dict_by_db(id):
o = Po.mc_get(id)
cid = o.cid
rid = o.rid
d = dict(id=id, cid=cid)
if cid == CID_WORD and rid or cid == CID_ANSWER:
d.update(question_dict(rid))
else:
d['name'] = o.name
return d
def feed_po_dict_by_db(id):
o = Po.mc_get(id)
cid = o.cid
rid = o.rid
d = dict(id=id, cid=cid)
if cid == CID_WORD and rid or cid == CID_ANSWER:
d.update(question_dict(rid))
else:
d['name'] = o.name
return d
def fav_new(user_id, po_id):
po = Po.mc_get(po_id)
if po and po.cid in PO_SHARE_FAV_CID and po.state >= STATE_ACTIVE and not fav_cid(user_id, po_id):
cid = po.cid
Fav(user_id=user_id, po_id=po_id, cid=cid).save()
mc_fav_cid.set('%s_%s' % (user_id, po_id), cid)
mc_flush_by_user_id(user_id, cid)
mc_flush_by_po_id(po_id)
po_pos_set(user_id, po)
from po_tag import po_score_incr
po_score_incr(po, user_id, 7)
mq_buzz_po_fav_new(user_id, po_id)
def notice_event_join_no(from_id, to_id, event_id, txt):
cid = CID_NOTICE_EVENT_JOIN_NO
n = notice_new(from_id, to_id, cid, event_id, txt=txt)
mc_notice_last_id_by_zsite_id_cid.set('%s_%s' % (from_id, cid), n.id)
mail = mail_by_user_id(to_id)
zsite = Zsite.mc_get(to_id)
po = Po.mc_get(event_id)
title = po.name
link = po.link
mq_rendermail('/mail/event/event_join_no.txt',
mail, zsite.name,
link=link,
title=title,
reason=txt
)
return n
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_new(user_id, question_id, name, txt, state):
# from buzz import buzz_answer_new
id = answer_id_get(user_id, question_id)
if id:
return Po.mc_get(id)
else:
if txt:
m = _po_answer_new(user_id, name, txt, state, question_id)
else:
m = po_word_new(user_id, name, state, question_id)
if m:
id = m.id
#buzz_answer_new(user_id, question_id)
rank_new(m, question_id, CID_QUESTION)
mq_notice_question(user_id, id)
mc_answer_id_get.set('%s_%s' % (user_id, question_id), id)
answer_count.delete(question_id)
return m
def po_answer_new(user_id, question_id, name, txt, state):
# from buzz import buzz_answer_new
id = answer_id_get(user_id, question_id)
if id:
return Po.mc_get(id)
else:
if txt:
m = _po_answer_new(user_id, name, txt, state, question_id)
else:
m = po_word_new(user_id, name, state, question_id)
if m:
id = m.id
#buzz_answer_new(user_id, question_id)
rank_new(m, question_id, CID_QUESTION)
mq_notice_question(user_id, id)
mc_answer_id_get.set('%s_%s' % (user_id, question_id), id)
answer_count.delete(question_id)
return m
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 render_feed_by_zsite_id(zsite_id, limit=MAXINT, begin_id=MAXINT):
zsite_id_list = zsite_id_list_by_follow(zsite_id)
rt_dict = defaultdict(list)
id_list = []
id = 0
for i in feed_merge_iter(zsite_id_list, limit, begin_id):
id = i.id
po = Po.mc_get(id)
if po is None:
continue
if po.cid == CID_REC:
id = po.rid
od = rt_dict[id]
user_id = po.user_id
data = (po.id, po.txt, po.user_id)
od.append(data)
else:
id = po.id
if id not in id_list:
id_list.append(id)
return render_feed_list(id_list, zsite_id, rt_dict), id
def question_dict(question_id):
o = Po.mc_get(question_id)
return dict(question_id=question_id, question_name=o.name, question_user=user_dict(o.user_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 po_review_get(zsite_id, user_id):
id = po_review_id_get(zsite_id, user_id)
return id and Po.mc_get(id)
def question_dict(question_id):
o = Po.mc_get(question_id)
return dict(question_id=question_id,
question_name=o.name,
question_user=user_dict(o.user_id))
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_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 po_review_list_active_by_zsite_id(id):
return Po.mc_get_list(
po_review_id_list_active_by_zsite_id(id)
)
if __name__ == '__main__':
#po_review_show_id_list_new(1, 2)
#print po_review_show_id_list(1)
#name = "gw"
#po_review_new(zsite_id, user_id, name)
#print po_review_id_get(895, 893)
# user_id =893
# zsite_id = 895
# for i in po_review_list_active_by_zsite_id(zsite_id):
# print i.name
zsite_id = 895
# print po_review_count(zsite_id)
# print po_review_list_by_zsite_id(zsite_id, 0, 1111)
zsite_id = 10163143
user_id = 10002411
po_review_get(zsite_id, user_id)
for i in Po.where(
zsite_id=zsite_id
).where('state=%s'%STATE_ACTIVE).order_by('id desc'):
print i.user_id, i.state
def po_recommend_by_rid_user_id(rid, user_id):
id = po_recommend_id_by_rid_user_id(rid, user_id)
return id and Po.mc_get(id)
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 rm_rec_po_by_po_id(user_id,id):
''' DANGEROUS USE WITH CAUTION '''
for po in Po.where('cid = %s and rid=%s',CID_REC,id):
po_rm(po.user_id,po.id)
return
ProductShow.where(id=id).delete()
mc_flush(id)
def mc_flush(id):
mc_product_show_get.delete(id)
mc_product_show_id_list.delete('')
_product_show_count.delete('')
@mc_product_show_get('{id}')
def product_show_get(id):
i = ProductShow.get(id)
if i:
return i.rank
return 0
if __name__ == '__main__':
#print product_show_rm(12)
#print product_show_list()
#print product_show_id_list()
#product_show_new(13)
#print product_show_count()
#print product_show_id_list()
from po_product import Po
product = Po.mc_get(10170515)
product_show_new(product)
print product
feed_rt(0, po.id)
def po_show_rm(po_id):
feed_rt_rm(0, po_id)
Po.where(user_id=0, rid=po_id, cid=CID_REC, state=STATE_ACTIVE).delete()
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_show_count():
return feed_rt_count(0)
def po_is_show(po):
r = Po.get(user_id=0, rid=po.id, cid=CID_REC, state=STATE_ACTIVE)
if r:
return r.id
if __name__ == '__main__':
po = Po.mc_get(10218451)
# po_show_rm(po.id)
# print po_is_show(po)
def po_review_id_list_active_by_zsite_id(id):
qs = Po.where(
zsite_id=id,
cid=CID_REVIEW
).where('state=%s'%STATE_ACTIVE).order_by('id desc')
return qs.col_list()
def po_show_rm(po_id):
feed_rt_rm(0, po_id)
Po.where(user_id=0, rid=po_id, cid=CID_REC, state=STATE_ACTIVE).delete()
def po_review_list_active_by_zsite_id(id):
return Po.mc_get_list(
po_review_id_list_active_by_zsite_id(id)
)
def po_is_show(po):
r = Po.get(user_id=0, rid=po.id, cid=CID_REC, state=STATE_ACTIVE)
if r:
return r.id
def product_show_list(limit=None, offset=None):
return Po.mc_get_list(product_show_id_list(limit, offset))
