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)
