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)