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
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)