def find_missing_books(self): # query for books which have no uploaded file sdb = Factory.connect_sdb() return sdb.select( "ogre_versions", "select sdbkey, filehash, format from ogre_versions where uploaded is null and user = '******'" % self.user.username)
def check_version_exists(self, filehash): sdb = Factory.connect_sdb() rs = sdb.select( "ogre_versions", "select filehash from ogre_versions where filehash = '%s'" % filehash) return (len(rs) > 0)
def find_missing_books(self): # query for books which have no uploaded file sdb = Factory.connect_sdb() return sdb.select("ogre_versions", "select sdbkey, filehash, format from ogre_versions where uploaded is null and user = '******'" % self.user.username)
def check_version_exists(self, filehash): sdb = Factory.connect_sdb() rs = sdb.select("ogre_versions", "select filehash from ogre_versions where filehash = '%s'" % filehash) return (len(rs) > 0)