def setXBMCEpisodePlaycount(tvdb_id, seasonid, episodeid, playcount): # httpapi till jsonrpc supports playcount update RawXbmcDb.execute( "UPDATE files" + " SET playcount=%(playcount)s" % {'playcount': xcp(playcount)} + " WHERE idFile IN (" + " SELECT idFile" + " FROM episode" + " INNER JOIN tvshowlinkepisode ON episode.idEpisode = tvshowlinkepisode.idEpisode" + " INNER JOIN tvshow ON tvshowlinkepisode.idShow = tvshow.idShow" + " WHERE tvshow.c12='%(tvdb_id)s'" % {'tvdb_id': xcp(tvdb_id)} + " AND episode.c12='%(seasonid)s'" % {'seasonid': xcp(seasonid)} + " AND episode.c13='%(episodeid)s'" % {'episodeid': xcp(episodeid)} + " )")
def setXBMCEpisodePlaycount(tvdb_id, seasonid, episodeid, playcount): # httpapi till jsonrpc supports playcount update RawXbmcDb.execute( "UPDATE files"+ " SET playcount=%(playcount)s" % {'playcount':xcp(playcount)}+ " WHERE idFile IN ("+ " SELECT idFile"+ " FROM episode"+ " INNER JOIN tvshow ON episode.idShow = tvshow.idShow"+ " WHERE tvshow.c12='%(tvdb_id)s'" % {'tvdb_id':xcp(tvdb_id)}+ " AND episode.c12='%(seasonid)s'" % {'seasonid':xcp(seasonid)}+ " AND episode.c13='%(episodeid)s'" % {'episodeid':xcp(episodeid)}+ " )")
def setXBMCMoviePlaycount(imdb_id, playcount): # httpapi till jsonrpc supports playcount update # c09 => IMDB ID match = RawXbmcDb.query( "SELECT movie.idFile FROM movie"+ " WHERE movie.c09='%(imdb_id)s'" % {'imdb_id':xcp(imdb_id)}) if not match: #add error message here return try: match[0][0] except KeyError: return RawXbmcDb.execute( "UPDATE files"+ " SET playcount=%(playcount)d" % {'playcount':int(playcount)}+ " WHERE idFile=%(idFile)s" % {'idFile':xcp(match[0][0])})
def setXBMCMoviePlaycount(imdb_id, playcount): # httpapi till jsonrpc supports playcount update # c09 => IMDB ID match = RawXbmcDb.query("SELECT movie.idFile FROM movie" + " WHERE movie.c09='%(imdb_id)s'" % {'imdb_id': xcp(imdb_id)}) if not match: #add error message here return try: match[0][0] except KeyError: return RawXbmcDb.execute( "UPDATE files" + " SET playcount=%(playcount)d" % {'playcount': int(playcount)} + " WHERE idFile=%(idFile)s" % {'idFile': xcp(match[0][0])})
def getMovieIdFromXBMC(imdb_id, title): # httpapi till jsonrpc supports searching for a single movie # Get id of movie by movies IMDB Debug("Searching for movie: " + imdb_id + ", " + title) match = RawXbmcDb.query( " SELECT idMovie FROM movie" + " WHERE c09='%(imdb_id)s'" % {'imdb_id': imdb_id} + " UNION" + " SELECT idMovie FROM movie" + " WHERE upper(c00)='%(title)s'" % {'title': xcp(title.upper())} + " LIMIT 1") if not match: Debug("getMovieIdFromXBMC: cannot find movie in database") return -1 return match[0]
def getMovieIdFromXBMC(imdb_id, title): # httpapi till jsonrpc supports searching for a single movie # Get id of movie by movies IMDB Debug("Searching for movie: "+imdb_id+", "+title) match = RawXbmcDb.query( " SELECT idMovie FROM movie"+ " WHERE c09='%(imdb_id)s'" % {'imdb_id':imdb_id}+ " UNION"+ " SELECT idMovie FROM movie"+ " WHERE upper(c00)='%(title)s'" % {'title':xcp(title.upper())}+ " LIMIT 1") if not match: Debug("getMovieIdFromXBMC: cannot find movie in database") return -1 return match[0]
def getShowIdFromXBMC(tvdb_id, title): # httpapi till jsonrpc supports searching for a single show # Get id of show by shows tvdb id Debug("Searching for show: " + str(tvdb_id) + ", " + title) match = RawXbmcDb.query( " SELECT idShow FROM tvshow" + " WHERE c12='%(tvdb_id)s'" % {'tvdb_id': xcp(tvdb_id)} + " UNION" + " SELECT idShow FROM tvshow" + " WHERE upper(c00)='%(title)s'" % {'title': xcp(title.upper())} + " LIMIT 1") if not match: Debug("getShowIdFromXBMC: cannot find movie in database") return -1 return match[0]
def getShowIdFromXBMC(tvdb_id, title): # httpapi till jsonrpc supports searching for a single show # Get id of show by shows tvdb id Debug("Searching for show: "+str(tvdb_id)+", "+title) match = RawXbmcDb.query( " SELECT idShow FROM tvshow"+ " WHERE c12='%(tvdb_id)s'" % {'tvdb_id':xcp(tvdb_id)}+ " UNION"+ " SELECT idShow FROM tvshow"+ " WHERE upper(c00)='%(title)s'" % {'title':xcp(title.upper())}+ " LIMIT 1") if not match: Debug("getShowIdFromXBMC: cannot find movie in database") return -1 return match[0]