def del_attac_aid(id): #这里也是要删关联 myvars = dict(att_id=id) db.delete(util.tab('attac_rel'), where="att_id=$att_id", vars=myvars) myvars = dict(id=id) #还要删文件 attac = get_attac_id(id) if attac is not None: util.del_attac_qiniu(attac.title) db.delete(util.tab('attac'), where="id=$id", vars=myvars)
def add_attacs(post_id, attacs): attacs = attacs.split("|") if attacs is not None and len(attacs) > 0: for attac in attacs: if attac is not None: attac = attac.strip() try: attac = int(attac) db.insert(util.tab('attac_rel'), att_id=attac, rel_id=post_id) except: continue; #删除一下没有post关联的附件 #这里还要删文件啊 s_sql = "select * from `%s` where id not in(select att_id from `%s`)" %(util.tab('attac'), util.tab('attac_rel')) result = db.query(s_sql) if result is not None and len(result) > 0: for res in result: util.del_attac_qiniu(res.title) d_sql = "delete from `%s` where id not in(select att_id from `%s`)" %(util.tab('attac'), util.tab('attac_rel')) db.query(d_sql)