def htm2po_by_po(pre):
txt = pre.txt.rstrip()
if not txt:
return
zsite = Zsite.mc_get(pre.user_id)
if zsite.cid == CID_SITE:
group_id = zsite.id
else:
group_id = pre.site_id
rp = RssPoId.get(rss_po_id=pre.id)
if rp:
po = Po.mc_get(rp.po_id)
if po:
po.name_ = pre.title
po.save()
else:
po = po_note_new(pre.user_id, pre.title, "", STATE_RM, group_id)
if po and zsite.cid == CID_USER:
po.rid = pre.rss_id
po.save()
if not po:
return
po_id = po.id
if not rp:
rss_po_id_new(zsite, pre.id, po_id)
txt = txt_img_fetch(txt)
po.txt_set(txt)
if group_id:
state = STATE_PO_ZSITE_SHOW_THEN_REVIEW
else:
state = STATE_ACTIVE
po.state = state
po.save()
if po.zsite_id != po.user_id:
zsite_tag_new_by_tag_id(po)
if pre.state == RSS_RT_PO:
po_show_new(po)
mc_flush(po, po.zsite_id)
return po
def po_id_next_by_user(user_id, offset):
from model.po import Po
from model.rss import RssPoId
id = redis.lindex(REDIS_USER_RSS_PO % user_id, offset)
if id:
po = Po.mc_get(id)
if po:
rss_po_id = RssPoId.get(po_id=id)
if rss_po_id:
tag_id_list = rss_po_id.tag_id_list
else:
tag_id_list = ""
tag_id_list = filter(bool, tag_id_list.split(' '))
tag_id_list = list(
zip([
i.name
for i in Zsite.mc_get_list(tag_id_list) if i is not None
], tag_id_list))
po.tag_id_list = tag_id_list
return po
def po_id_next_by_user(user_id, offset):
from model.po import Po
from model.rss import RssPoId
id = redis.lindex(REDIS_USER_RSS_PO%user_id, offset)
if id:
po = Po.mc_get(id)
if po:
rss_po_id = RssPoId.get(po_id=id)
if rss_po_id:
tag_id_list = rss_po_id.tag_id_list
else:
tag_id_list = ""
tag_id_list = filter(bool, tag_id_list.split(' '))
tag_id_list = list(
zip(
[ i.name for i in Zsite.mc_get_list(tag_id_list) if i is not None],
tag_id_list
)
)
po.tag_id_list = tag_id_list
return po
#coding:utf-8
import _env
from model.rss import RssPoId
from model.po import Po
from model.zsite import Zsite
for i in RssPoId.where(rss_po_id=0):
po = Po.get(i.po_id)
if not po:
i.delete()
continue
zsite = Zsite.mc_get(po.user_id)
if not zsite:
i.delete()
continue
print i.id
i.rss_po_id = i.id
i.user_id = po.user_id
i.user_cid = zsite.cid
i.save()
#CREATE TABLE `zpage`.`rss_po_id` (
# `id` int(10) unsigned NOT NULL,
# `po_id` int(10) unsigned NOT NULL,
# `state` int(10) unsigned NOT NULL,
# `tag_id_list` blob NOT NULL,
# `rss_po_id` int(10) unsigned NOT NULL default '0',
# `user_id` int(10) unsigned NOT NULL default '0',
# `admin_id` int(10) unsigned NOT NULL default '0',
#coding:utf-8
import _env
from model.rss import RssPoId
from model.po import Po
from model.zsite import Zsite
for i in RssPoId.where(rss_po_id=0):
po = Po.get(i.po_id)
if not po:
i.delete()
continue
zsite = Zsite.mc_get(po.user_id)
if not zsite:
i.delete()
continue
print i.id
i.rss_po_id = i.id
i.user_id = po.user_id
i.user_cid = zsite.cid
i.save()
#CREATE TABLE `zpage`.`rss_po_id` (
# `id` int(10) unsigned NOT NULL,
# `po_id` int(10) unsigned NOT NULL,
# `state` int(10) unsigned NOT NULL,
# `tag_id_list` blob NOT NULL,
# `rss_po_id` int(10) unsigned NOT NULL default '0',
# `user_id` int(10) unsigned NOT NULL default '0',
# `admin_id` int(10) unsigned NOT NULL default '0',
