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
