Python Zsite.where示例

示例#1

    def get(self, n=1):
        total = Zsite.where().count()
        page, limit, offset = page_limit_offset(href='/user_list-%s',
                                                total=total,
                                                n=n,
                                                limit=PAGE_LIMIT)
        user_list = Zsite.where(
            cid=CID_USER).order_by('id desc')[offset:offset + limit]

        self.render(
            user_list=user_list,
            page=page,
        )

示例#2

文件： user_list.py 项目： immissile/42qu_github_mirror

    def get(self, n=1):
        total = Zsite.where().count()
        page, limit, offset = page_limit_offset(
            href='/user_list-%s',
            total=total,
            n=n,
            limit=PAGE_LIMIT
        )
        user_list = Zsite.where(cid=CID_USER).order_by('id desc')[offset:offset+limit]

        self.render(
            user_list=user_list,
            page=page,
        )

示例#3

def site_count_by_state(state):
    qs = Zsite.where(cid=CID_SITE)

    if state:
        qs = qs.where(state=state)

    return qs.count()

示例#4

def site_id_list_by_state(state, limit=None, offset=None):
    qs = Zsite.where(cid=CID_SITE)

    if state:
        qs = qs.where(state=state)

    return qs.order_by('id desc').col_list(limit, offset, 'id')

示例#5

def main():
    id2alias = {}
    for zhihu_topic in ZHIHU_TOPIC:
        id = zhihu_topic[0]
        alias_list = zhihu_topic[5]
        id2alias[int(id)] = alias_list


    name2id = {}

    for i in Zsite.where(cid=CID_TAG):
        tag_list = map(str.strip, i.name.split("/"))
        zhihu_id = MY2ID[i.id]
        alias_list = id2alias.get(zhihu_id,())

        tag_list.extend(alias_list)
       
        for name in tag_list:
            name2id[name.lower()] = i.id

    print """
#coding:utf-8

NAME2ID = """,
    pprint(name2id)

示例#6

 def get(self, n=1):
     n = int(n)
     count = zsite_user_verify_count()
     page, limit, offset = page_limit_offset('/user_show_id_list-%s', count,
                                             n, 64)
     zsite_list = Zsite.where(cid=CID_USER).where(
         'state>=%s' %
         ZSITE_STATE_VERIFY).order_by('id desc')[offset:offset + limit]
     self.render(zsite_list=zsite_list, page=page)

示例#7

文件： user_mail_change_state.py 项目： immissile/42qu_github_mirror

def check():
    for z in Zsite.where():
        um = UserMail.get(user_id=z.id)
        print z.id
        if um:
            if z.state <= ZSITE_STATE_APPLY:
                um.state = MAIL_UNVERIFY
                um.save()
            else:
                um.state = MAIL_LOGIN
                um.save()

示例#8

def check():
    for z in Zsite.where():
        um = UserMail.get(user_id=z.id)
        print z.id
        if um:
            if z.state <= ZSITE_STATE_APPLY:
                um.state = MAIL_UNVERIFY
                um.save()
            else:
                um.state = MAIL_LOGIN
                um.save()

示例#9

文件： com.py 项目： xqk/42qu_github_mirror

 def get(self, n=1):
     qs = Zsite.where(cid=CID_COM)
     total = qs.count()
     page, limit, offset = page_limit_offset(
         '/com-%s',
         total,
         n,
         PAGE_LIMIT,
     )
     li = qs.order_by('id desc')[offset:offset + limit]
     self.render(li=li, page=page)

示例#10

文件： add_sites.py 项目： immissile/42qu_github_mirror

def rm_same():
    sites = []
    result = {}
    for site in Zsite.where(cid=3, state=40):
        if site.name in result:
            sites.append([site.id, site.name])
        else:
            result[site.name] = site.id
    print len(sites)

    for i, j in sites:
        zsite_site_rm(i)

示例#11

文件： add_sites.py 项目： xqk/42qu_github_mirror

def rm_same():
    sites = []
    result = {}
    for site in Zsite.where(cid=3, state=40):
        if site.name in result:
            sites.append([site.id, site.name])
        else:
            result[site.name] = site.id
    print len(sites)

    for i, j in sites:
        zsite_site_rm(i)

示例#12

文件： com.py 项目： xqk/42qu_github_mirror

 def get(self, state, n=1):
     state = int(state)
     qs = Zsite.where(cid=CID_COM)
     total = qs.count()
     page, limit, offset = page_limit_offset(
         '/com/%s-%%s' % state,
         total,
         n,
         PAGE_LIMIT,
     )
     li = qs.order_by('id desc')[offset:offset + limit]
     self.render(state=state, li=li, page=page)

示例#13

文件： com.py 项目： immissile/42qu_github_mirror

 def get(self, n=1):
     qs = Zsite.where(cid=CID_COM)
     total = qs.count()
     page, limit, offset = page_limit_offset(
             '/com-%s',
             total,
             n,
             PAGE_LIMIT,
             )
     li = qs.order_by('id desc')[offset: offset+limit]
     self.render(
             li=li,
             page=page
             )

示例#14

文件： add_sites.py 项目： xqk/42qu_github_mirror

def recover():
    rec = []
    for z in Zsite.where(cid=3, state=0):
        if Rss.get(user_id=z.id):
            rec.append(z)

    #  print rec
    rec_name = [i.name for i in rec]
    # print rec_name

    rm = []
    for z in Zsite.where(cid=3, state=40):
        if z.name in rec_name:
            rm.append(z)

    for z in rec:
        z.state = 40
        zsite_admin_new(z.id, 10017321)
        z.save()
        zsite_show_new(z.id, 3)

    for z in rm:
        zsite_site_rm(z.id)

示例#15

文件： add_sites.py 项目： immissile/42qu_github_mirror

def recover():
    rec = []
    for z in Zsite.where(cid=3, state=0):
        if Rss.get(user_id=z.id):
            rec.append(z)

    #  print rec
    rec_name = [i.name for i in rec]
    # print rec_name

    rm = []
    for z in Zsite.where(cid=3, state=40):
        if z.name in rec_name:
            rm.append(z)

    for z in rec:
        z.state = 40
        zsite_admin_new(z.id, 10017321)
        z.save()
        zsite_show_new(z.id, 3)

    for z in rm:
        zsite_site_rm(z.id)

示例#16

文件： com.py 项目： immissile/42qu_github_mirror

 def get(self, state, n=1):
     state = int(state)
     qs = Zsite.where(cid=CID_COM)
     total = qs.count()
     page, limit, offset = page_limit_offset(
         '/com/%s-%%s'%state,
         total,
         n,
         PAGE_LIMIT,
     )
     li = qs.order_by('id desc')[offset:offset+limit]
     self.render(
         state=state,
         li=li,
         page=page
     )

示例#17

文件： user_list.py 项目： immissile/42qu_github_mirror

 def get(self, n=1):
     n = int(n)
     count = zsite_user_verify_count()
     page, limit, offset = page_limit_offset('/user_show_id_list-%s', count, n, 64)
     zsite_list = Zsite.where(cid=CID_USER).where('state>=%s'%ZSITE_STATE_VERIFY).order_by('id desc')[offset:offset+limit]
     self.render(zsite_list=zsite_list, page=page)

示例#18

            NAME_ID[i] = id

#    NAME_KEYWORD[name] = []
#    for i in name_list:
#        i = i.replace("·"," ")
#        i = i.split()
#        NAME_KEYWORD[name].extend(i)

#    NAME_RANK[name] = rank
#    if _name != name:
#        NAME_RANK[_name] = name

count = 0

MY2Z = {}
for i in Zsite.where(cid=CID_TAG):
    i.name = i.name.strip()
    i.save()
    if i.name not in NAME_ID:
        for j in map(str.strip,i.name.split("/")):
            if j in NAME_ID:
                MY2Z[i.id] = NAME_ID[j] 
                break
    else:
        MY2Z[i.id] = NAME_ID[i.name]
    if i.id not in MY2Z:
        count += 1
        #print count, '%s|'%i.name

import _env
from zkit.pprint import pprint

示例#19

def main():
    for i in Zsite.where().col_list():
        rank = zsite_rank_by_zsite_id(i)
        zsite_rank_update_by_zsite_id(i, rank)

示例#20

def main():
    for i in Zsite.where().col_list():
        man = Man.get(i)

示例#21

#    url2id = {}
#    for i in ZHIHU_TOPIC:
#        url = i[2] or i[1]
#        id = i[0]
#        rank = i[-1]
#
#        if id in ID2MY:
#            url2id[ID2MY[id] ] = rank
#
#
#    from zkit.pprint import pprint
#
#    pprint(url2id)
#"""
RESULT = {}
for tag in Zsite.where(cid=CID_TAG):
    name_list = map(str.strip, tag.name.split('/'))
    for name in name_list:
        RESULT[name.replace('·', '.').lower()] = tag.id

for i in ZHIHU_TOPIC:
    id = i[0]
    if id not in ID2MY:
        continue
    rename = i[-1]
    for name in rename:
        name = name.lower()
        if name in RESULT and RESULT[name] != ID2MY[id]:
            zsite = Zsite.mc_get(ID2MY[id])
            print zsite.id, zsite.name
            zsite = Zsite.mc_get(RESULT[name])

示例#22

文件： zsite_com.py 项目： xqk/42qu_github_mirror

def zsite_com_id_list(cid, limit, offset):
    return Zsite.where(cid=cid).col_list(limit, offset, 'id')


def zsite_com_list(cid, limit, offset):
    return Zsite.mc_get_list(zsite_com_id_list(cid, limit, offset))


def zsite_com_place_new(zsite_id, pid, address):
    zsite_com = ZsiteComPlace.get_or_create(com_id=zsite_id, pid=pid)
    zsite_com.address = address
    zsite_com.save()
    return zsite_com


zsite_com_count = McNum(lambda cid: Zsite.where(cid=cid).count(),
                        'ZsiteComCount.%s')


def com_new(name, admin_id, state=ZSITE_STATE_VERIFY):
    name = name.replace('科技有限公司', '')
    com = zsite_new(name, CID_COM, state)
    com_id = com.id
    zsite_com_count.delete(CID_COM)
    mc_zsite_com_id_list.delete(CID_COM)
    return com


def com_can_admin(zsite_id, user_id):
    if zsite_user_state(zsite_id, user_id) >= STATE_ADMIN:
        return True

示例#23

文件： zsite_com.py 项目： xqk/42qu_github_mirror

def zsite_com_id_list(cid, limit, offset):
    return Zsite.where(cid=cid).col_list(limit, offset, 'id')

示例#24

@mc_zsite_com_id_list('{cid}')
def zsite_com_id_list(cid, limit, offset):
    return Zsite.where(cid=cid).col_list(limit, offset, 'id')

def zsite_com_list(cid, limit, offset):
    return Zsite.mc_get_list(zsite_com_id_list(cid, limit, offset))

def zsite_com_place_new(zsite_id, pid, address):
    zsite_com = ZsiteComPlace.get_or_create(com_id=zsite_id, pid=pid)
    zsite_com.address = address
    zsite_com.save()
    return zsite_com


zsite_com_count = McNum(lambda cid: Zsite.where(cid=cid).count(), 'ZsiteComCount.%s')


def com_new(name, admin_id, state=ZSITE_STATE_VERIFY):
    name = name.replace('科技有限公司', '')
    com = zsite_new(name, CID_COM, state)
    com_id = com.id
    zsite_com_count.delete(CID_COM)
    mc_zsite_com_id_list.delete(CID_COM)
    return com

def com_can_admin(zsite_id, user_id):
    if zsite_user_state(zsite_id, user_id) >= STATE_ADMIN:
        return True

#def zsite_com_count(cid):

示例#25

文件： zsite_txt.py 项目： immissile/42qu_github_mirror

def main():
    for i in Zsite.where().col_list():
        man = Man.get(i)

示例#26

文件： name2id.py 项目： immissile/42qu_github_mirror

#    url2id = {}
#    for i in ZHIHU_TOPIC:
#        url = i[2] or i[1]
#        id = i[0]
#        rank = i[-1]
#
#        if id in ID2MY:
#            url2id[ID2MY[id] ] = rank 
#
#
#    from zkit.pprint import pprint
#
#    pprint(url2id)
#"""
RESULT = {}
for tag in Zsite.where(cid=CID_TAG):
    name_list = map(str.strip, tag.name.split('/'))
    for name in name_list:
        RESULT[name.replace('·', '.').lower()] = tag.id

for i in ZHIHU_TOPIC:
    id = i[0]
    if id not in ID2MY:
        continue
    rename = i[-1]
    for name in rename:
        name = name.lower()
        if name in RESULT and RESULT[name] != ID2MY[id]:
            zsite = Zsite.mc_get(ID2MY[id])
            print zsite.id, zsite.name
            zsite = Zsite.mc_get(RESULT[name])

示例#27

def zsite_com_id_list(cid, limit, offset):
    return Zsite.where(cid=cid).col_list(limit, offset, 'id')