def get_path_list(self): # Create empty list res = [] # Create query query = 'SELECT idPath, strPath \ FROM path \ WHERE strContent = "movies"' # Create a cursor c = self.db.create_cursor() # Launch query c.execute(query) # Build result for idp, strp in c: res.append(metaStr(strp, idp)) # Close cursor c.close() # Return result return res
def get_movie_list(self, id_path): # Create empty list res = [] # Create query query = "SELECT f.idFile, m.c00 \ FROM movie m, files f \ WHERE m.idFile = f.idFile AND f.idPath = ?" if self.options["watched"]: query += " AND f.playcount > 0 " query += "ORDER BY m.c00" # Create values value = (id_path,) # Create a cursor c = self.db.create_cursor() # Launch query c.execute(query, value) # Build result for idf, mov in c: res.append(metaStr(mov, idf)) # Close cursor c.close() # Return result return res
def get_episode_list( self, show ): # Create empty list res = [] # Create query query = "SELECT e.c12, e.c13, e.c00, e.idFile \ FROM tvshowlinkepisode tsle, episode e, files f \ WHERE tsle.idEpisode = e.idEpisode AND e.idFile = f.idFile \ AND tsle.idShow = ?" if self.options["watched"]: query += " AND f.playcount > 0 " # Create values value = show.meta, # Create a cursor c = self.db.create_cursor() # Launch query c.execute( query, value ) # Build result for s, e, name, eid in c: res.append( metaStr( "%02dx%02d - %s" % ( int(s), int(e), name ), eid ) ) # Close cursor c.close() # Return result return sorted( res )
def get_tvshow_list( self, path ): # Create empty list res = [] # Create query query = "SELECT ts.idShow, ts.c00 \ FROM tvshowlinkpath tslp, tvshow ts \ WHERE tslp.idShow = ts.idShow AND idPath IN \ ( SELECT idPath \ FROM path \ WHERE strPath LIKE ? ) \ ORDER BY ts.c00" # Create values value = path+"%", # Create a cursor c = self.db.create_cursor() # Launch query c.execute( query, value ) # Build result for ids, tvs in c: res.append( metaStr( tvs, ids ) ) # Close cursor c.close() # Return result return res