def getSharedModels(): # 获取所有已经分享的模型 sql = 'select * from upload natural join (select * from file) as a order by date desc;' return db.query(sql)
def getSharedModelsById(id): # 获取某用户分享的所有模型记录 sql = 'select * from file where fid in (select fid from upload where id="' + id + '") order by date desc;' return db.query(sql)
def generatingfid(fid): # 查看生成的随机id是否已经存在 sql = 'select * from file where fid="%s";' % fid return db.query(sql)