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)
