Python Zsite.raw_sql示例

示例#1

def get_uri():
    from model.zsite_link import ZsiteLink
    from model.zsite import Zsite, ZSITE_STATE_VERIFY
    ids = Zsite.raw_sql('select id from zpage.zsite where cid = %s' , CID_USER).fetchall()
    links = []
    for id in ids:
        r = ZsiteLink.raw_sql('select link from zpage.zsite_link where zsite_id = %s and cid in (0,2)', *id).fetchall()
        for link in r:
            links.append([id[0], link[0]])
    return links

示例#2

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

def get_name():
    names = Zsite.raw_sql('select id,name from zpage.zsite').fetchall()
    for id, name in names:
        if check(name):
            zsite_name_rm(id)