def zsite_fav_get_and_touch(zsite, owner_id):
id, state = zsite_list_id_state(zsite.id, owner_id, zsite.cid)
if id:
ZsiteList.raw_sql('update zsite_list set rank=rank+1 where id=%s', id)
return id
else:
zsite_fav_touch(zsite, owner_id)
def zsite_fav_get_and_touch(zsite, owner_id):
id , state = zsite_list_id_state(zsite.id, owner_id, zsite.cid)
if id:
ZsiteList.raw_sql('update zsite_list set rank=rank+1 where id=%s', id)
return id
else:
zsite_fav_touch(zsite, owner_id)
def zsite_admin_empty(zsite_id):
for i in ZsiteList.where(cid=CID_SITE, zsite_id=zsite_id).where(
'state>%s' % STATE_ACTIVE):
i.state = STATE_ACTIVE
i.save()
mc_zsite_id_list_by_admin_id.delete(admin_id)
mc_admin_id_list_by_zsite_id.delete(zsite_id)
def zsite_fav_rm_all_by_zsite_id(zsite_id):
zsite = Zsite.mc_get(zsite_id)
fav_list = ZsiteList.where(zsite_id=zsite_id)
for fav in fav_list:
zsite_list_rm(
zsite.id,
fav.owner_id,
zsite.cid
)
def zsite_fav_rm_all_by_zsite_id(zsite_id):
zsite = Zsite.mc_get(zsite_id)
fav_list = ZsiteList.where(zsite_id=zsite_id)
for fav in fav_list:
zsite_list_rm(zsite.id, fav.owner_id, zsite.cid)
def zsite_id_list_by_admin_id(id):
return ZsiteList.where(cid=CID_SITE, owner_id=id).where(
'state>=%s' % STATE_ADMIN).order_by('id desc').col_list(col='zsite_id')
#!/usr/bin/env python
# -*- coding: utf-8 -*-
from _db import cursor_by_table, McModel, McCache, McNum, McCacheA
from zsite import Zsite
from model.cid import CID_SITE
from zkit.algorithm.wrandom import sample_or_shuffle
from model.zsite_list import zsite_list_new, STATE_ACTIVE, zsite_list_get, zsite_list_id_get, zsite_list_rm, zsite_list_count_by_zsite_id, zsite_list_id_state, ZsiteList, zsite_id_list_by_zsite_id, mc_zsite_list_id_state, STATE_ACTIVE, STATE_ADMIN, STATE_OWNER
mc_zsite_id_list_by_admin_id = McCacheA('ZsiteIdListBYAdminId.%s')
mc_admin_id_list_by_zsite_id = McCacheA('AdminIdListByZsiteId.%s')
zsite_by_admin_id_count = McNum(
lambda id: ZsiteList.where(cid=CID_SITE, owner_id=id).where(
'state>%s' % STATE_ADMIN).count(), 'ZsiteByAdminIdTotal.%s')
def zsite_admin_new(zsite_id, admin_id, state=STATE_OWNER):
if zsite_id and admin_id:
cid = CID_SITE
zsite = zsite_list_get(zsite_id, admin_id, cid)
if not zsite:
zsite = zsite_list_new(zsite_id, admin_id, cid, 1, state)
else:
zsite.state = state
zsite.save()
mc_flush(zsite_id, admin_id)
def mc_flush(zsite_id, admin_id):
mc_admin_id_list_by_zsite_id.delete(zsite_id)
mc_zsite_id_list_by_admin_id.delete(admin_id)
def zsite_admin_empty(zsite_id):
for i in ZsiteList.where(cid=CID_SITE, zsite_id=zsite_id).where('state>%s'%STATE_ACTIVE):
i.state = STATE_ACTIVE
i.save()
mc_zsite_id_list_by_admin_id.delete(admin_id)
mc_admin_id_list_by_zsite_id.delete(zsite_id)
def zsite_id_list_by_admin_id(id):
return ZsiteList.where(
cid=CID_SITE,
owner_id=id
).where('state>=%s' % STATE_ADMIN).order_by('id desc').col_list(col='zsite_id')
#!/usr/bin/env python
# -*- coding: utf-8 -*-
from _db import cursor_by_table, McModel, McCache, McNum, McCacheA
from zsite import Zsite
from model.cid import CID_SITE
from zkit.algorithm.wrandom import sample_or_shuffle
from model.zsite_list import zsite_list_new, STATE_ACTIVE, zsite_list_get, zsite_list_id_get, zsite_list_rm, zsite_list_count_by_zsite_id , zsite_list_id_state, ZsiteList, zsite_id_list_by_zsite_id, mc_zsite_list_id_state, STATE_ACTIVE, STATE_ADMIN, STATE_OWNER
mc_zsite_id_list_by_admin_id = McCacheA('ZsiteIdListBYAdminId.%s')
mc_admin_id_list_by_zsite_id = McCacheA('AdminIdListByZsiteId.%s')
zsite_by_admin_id_count = McNum(
lambda id:ZsiteList.where(
cid=CID_SITE,
owner_id=id
).where('state>%s' % STATE_ADMIN).count(),
'ZsiteByAdminIdTotal.%s'
)
def zsite_admin_new(zsite_id, admin_id, state=STATE_OWNER):
if zsite_id and admin_id:
cid = CID_SITE
zsite = zsite_list_get(
zsite_id,
admin_id,
cid
)
if not zsite:
zsite = zsite_list_new(
def zsite_id_count_by_member_admin(id):
r = ZsiteList.where(zsite_id=id, cid=CID_ZSITE_TUPLE_LIST_MEMBER).where('state>=%s', STATE_ACTIVE)
return r.count()
