def shareFile(fid, fname, description, preview, date, id):
# 分享模型
sql = '''
insert into file (fid,fname,description,preview,date)
values ('%s','%s','%s','%s','%s');
insert into upload (id,fid) values ('%s','%s');
''' % (fid, fname, description, preview, date, id, fid)
db.execute(sql)
def removeSharedRecord(fid):
# 删除分享
sql = '''
delete upload,file from upload,file
where file.fid=upload.fid and upload.fid='%s';''' % fid
return db.execute(sql)
