class TVShows(Items):
def __init__(self, kodicursor, sources_cursor):
self.kodicursor = kodicursor
self.kodi_db = _kodi_tvshows.KodiTVShows(self.kodicursor)
self.sources_cursor = sources_cursor
self.source_db = Customdb_Functions(self.sources_cursor)
self.kodi_version = 17
def _get_func(self, item_type, action):
if item_type == "Series":
actions = {
'added': self.add_shows,
'update': self.add_update,
'userdata': self.updateUserdata,
'remove': self.remove
}
elif item_type == "Season":
actions = {
'added': self.add_seasons,
'update': self.add_updateSeason,
'remove': self.remove
}
elif item_type == "Episode":
actions = {
'added': self.add_episodes,
'update': self.add_updateEpisode,
'userdata': self.updateUserdata,
'remove': self.remove
}
else:
log.info("Unsupported item_type: %s", item_type)
actions = {}
return actions.get(action)
def compare_all(self):
# Pull the list of movies and boxsets in Kodi
pdialog = self.pdialog
views = self.source_db.getView_byType('tvshows')
views += self.source_db.getView_byType('mixed')
log.info("Media folders: %s", views)
# Pull the list of tvshows and episodes in Kodi
try:
all_koditvshows = dict(self.source_db.get_checksum('Series'))
except ValueError:
all_koditvshows = {}
log.info("all_koditvshows = %s", all_koditvshows)
try:
all_kodiepisodes = dict(self.source_db.get_checksum('Episode'))
except ValueError:
all_kodiepisodes = {}
all_embytvshowsIds = set()
all_embyepisodesIds = set()
updatelist = []
# TODO: Review once series pooling is explicitely returned in api
for view in views:
# Get items per view
viewId = view['id']
viewName = view['name']
if pdialog:
pdialog.update(heading=lang(29999),
message="%s %s..." % (lang(33029), viewName))
all_embytvshows = self.emby.getShows(viewId,
basic=True,
dialog=pdialog)
for embytvshow in all_embytvshows['Items']:
if self.should_stop():
return False
API = api.API(embytvshow)
itemid = embytvshow['Id']
all_embytvshowsIds.add(itemid)
if all_koditvshows.get(itemid) != API.get_checksum():
# Only update if movie is not in Kodi or checksum is different
updatelist.append(itemid)
log.info("TVShows to update for %s: %s", viewName, updatelist)
embytvshows = self.emby.getFullItems(updatelist)
self.total = len(updatelist)
del updatelist[:]
if pdialog:
pdialog.update(heading="Processing %s / %s items" %
(viewName, self.total))
self.count = 0
for embytvshow in embytvshows:
# Process individual show
if self.should_stop():
return False
itemid = embytvshow['Id']
title = embytvshow['Name']
all_embytvshowsIds.add(itemid)
self.update_pdialog()
self.add_update(embytvshow, view)
self.count += 1
else:
# Get all episodes in view
if pdialog:
pdialog.update(heading=lang(29999),
message="%s %s..." %
(lang(33030), viewName))
all_embyepisodes = self.emby.getEpisodes(viewId,
basic=True,
dialog=pdialog)
for embyepisode in all_embyepisodes['Items']:
if self.should_stop():
return False
API = api.API(embyepisode)
itemid = embyepisode['Id']
all_embyepisodesIds.add(itemid)
if "SeriesId" in embyepisode:
all_embytvshowsIds.add(embyepisode['SeriesId'])
if all_kodiepisodes.get(itemid) != API.get_checksum():
# Only update if movie is not in Kodi or checksum is different
updatelist.append(itemid)
log.info("Episodes to update for %s: %s", viewName, updatelist)
embyepisodes = self.emby.getFullItems(updatelist)
self.total = len(updatelist)
del updatelist[:]
self.count = 0
for episode in embyepisodes:
# Process individual episode
if self.should_stop():
return False
self.title = "%s - %s" % (episode.get(
'SeriesName', "Unknown"), episode['Name'])
self.add_updateEpisode(episode)
self.count += 1
##### PROCESS DELETES #####
log.info("all_embytvshowsIds = %s ", all_embytvshowsIds)
for koditvshow in all_koditvshows:
if koditvshow not in all_embytvshowsIds:
self.remove(koditvshow)
log.info("TVShows compare finished.")
for kodiepisode in all_kodiepisodes:
if kodiepisode not in all_embyepisodesIds:
self.remove(kodiepisode)
log.info("Episodes compare finished.")
return True
def add_shows(self, items, total=None, view=None):
for item in self.added(items, total):
if self.add_update(item, view):
# Add episodes
all_episodes = self.emby.getEpisodesbyShow(item['Id'])
self.add_episodes(all_episodes['Items'])
def add_seasons(self, items, total=None, view=None):
update = True if not self.total else False
for item in self.added(items, total, update):
self.title = "%s - %s" % (item.get('SeriesName',
"Unknown"), self.title)
if self.add_updateSeason(item):
# Add episodes
all_episodes = self.emby.getEpisodesbySeason(item['Id'])
self.add_episodes(all_episodes['Items'])
def add_episodes(self, items, total=None, view=None):
update = True if not self.total else False
for item in self.added(items, total, update):
self.title = "%s - %s" % (item.get('SeriesName',
"Unknown"), self.title)
self.add_updateEpisode(item)
def add_update(self, item, view=None):
kodicursor = self.kodicursor
# If the item already exist in the local Kodi DB we'll perform a full item update
# If the item doesn't exist, we'll add it to the database
update_item = True
force_episodes = False
itemid = item['source_id']
source_type = item['source_type']
source_item = self.source_db.getItem_byId(itemid)
try:
showid = source_item[0]
pathid = source_item[2]
log.info("showid: %s pathid: %s", showid, pathid)
except TypeError:
update_item = False
log.debug("showid: %s not found", itemid)
showid = self.kodi_db.create_entry()
else:
# Verification the item is still in Kodi
if self.kodi_db.get_tvshow(showid) is None:
# item is not found, let's recreate it.
update_item = False
log.info("showid: %s missing from Kodi, repairing the entry",
showid)
# Force re-add episodes after the show is re-created.
force_episodes = True
if view is None:
# Get view tag from emby
viewtag, viewid = self.source_db.getView_source_id(itemid)
log.debug("View tag found: %s", viewtag)
else:
viewtag = view['name']
viewid = view['id']
# item details
genres = item.get('genres')
title = item['title']
plot = item.get('plot')
rating = item.get('rating')
votecount = 0
premieredate = "2016-1-3"
tvdb = "tvdb"
imdb = item.get('imdb')
sorttitle = item['sorttitle']
mpaa = item['mpaa']
genre = item.get('genre')
studios = []
studio = " / ".join(studios)
directors = item['directors']
# Verify series pooling
if not update_item and tvdb:
query = "SELECT idShow FROM tvshow WHERE C12 = ?"
kodicursor.execute(query, (tvdb, ))
try:
temp_showid = kodicursor.fetchone()[0]
except TypeError:
pass
else:
emby_other = source_db.getItem_byKodiId(temp_showid, "tvshow")
if emby_other and viewid == emby_other[2]:
log.info("Applying series pooling for %s", title)
emby_other_item = source_db.getItem_byId(emby_other[0])
showid = emby_other_item[0]
pathid = emby_other_item[2]
log.info("showid: %s pathid: %s", showid, pathid)
# Create the reference in emby table
source_db.addReference(itemid,
showid,
"Series",
"tvshow",
pathid=pathid,
checksum=checksum,
mediafolderid=viewid)
update_item = True
##### GET THE FILE AND PATH #####
playurl = item['playurl']
# Set plugin path
toplevelpath = "plugin://plugin.video.emby.tvshows/"
path = "%s%s/" % (toplevelpath, itemid)
path = item.get('path')
##### UPDATE THE TVSHOW #####
if update_item:
log.info("UPDATE tvshow itemid: %s - Title: %s", itemid, title)
# update new ratings Kodi 17
if self.kodi_version > 16:
ratingid = self.kodi_db.get_ratingid("tvshow", showid)
self.kodi_db.update_ratings(showid, "tvshow", "default",
rating, votecount, ratingid)
# update new uniqueid Kodi 17
if self.kodi_version > 16:
uniqueid = self.kodi_db.get_uniqueid("tvshow", showid)
self.kodi_db.update_uniqueid(showid, "tvshow", imdb, "imdb",
uniqueid)
# Update the tvshow entry
if self.kodi_version > 16:
self.kodi_db.update_tvshow(title, plot, uniqueid, premieredate,
genre, title, uniqueid, mpaa,
studio, sorttitle, showid)
else:
self.kodi_db.update_tvshow(title, plot, rating, premieredate,
genre, title, tvdb, mpaa, studio,
sorttitle, showid)
# Update the checksum in emby table
self.source_db.updateReference(itemid, "checksum")
##### OR ADD THE TVSHOW #####
else:
log.info("ADD tvshow itemid: %s - Title: %s", itemid, title)
# add new ratings Kodi 17
if self.kodi_version > 16:
ratingid = self.kodi_db.create_entry_rating()
self.kodi_db.add_ratings(ratingid, showid, "tvshow", "default",
rating, votecount)
# add new uniqueid Kodi 17
if self.kodi_version > 16:
uniqueid = self.kodi_db.create_entry_uniqueid()
self.kodi_db.add_uniqueid(uniqueid, showid, "tvshow", imdb,
"imdb")
# Add top path
toppathid = self.kodi_db.add_path(toplevelpath)
self.kodi_db.update_path(toppathid, toplevelpath, "tvshows",
"metadata.local")
# Add path
pathid = self.kodi_db.add_path(path)
# Create the tvshow entry
if self.kodi_version > 16:
self.kodi_db.add_tvshow(showid, title, plot, uniqueid,
premieredate, genre, title, uniqueid,
mpaa, studio, sorttitle)
else:
self.kodi_db.add_tvshow(showid, title, plot, rating,
premieredate, genre, title, tvdb, mpaa,
studio, sorttitle)
# Create the reference in emby table
self.source_db.addReference(itemid,
showid,
"Series",
"tvshow",
pathid=pathid,
checksum="checksum",
mediafolderid=viewid)
# Link the path
self.kodi_db.link_tvshow(showid, pathid)
# Update the path
self.kodi_db.update_path(pathid, path, None, None)
people = [{
"type": "actor",
"name": actor['name'],
"imageurl": actor.get('pic')
} for actor in item['actors']]
people += [{
"type": "director",
"name": director['name'],
"imageurl": director.get('pic')
} for director in directors]
self.kodi_db.add_people(showid, people, "tvshow")
# Process genres
self.kodi_db.add_genres(showid, genres, "tvshow")
# Process artwork
self.kodi_db.add_artwork(item['artwork'], showid, "tvshow")
# Process studios
# self.kodi_db.add_studios(showid, studios, "tvshow")
# Process tags: view, emby tags
# tags = [viewtag]
# tags.extend(item['Tags'])
# if userdata['Favorite']:
# tags.append("Favorite tvshows")
# self.kodi_db.add_tags(showid, tags, "tvshow")
# Process seasons
all_seasons = item['seasons']
for seasonnum in all_seasons:
seasonid = self.kodi_db.get_season(showid, seasonnum)
# TODO add artwork if needed, season keys {"number","artwork_url", "name"}
# self.add_updateSeason(season, showid=showid)
else:
# Finally, refresh the all season entry
seasonid = self.kodi_db.get_season(showid, -1)
# Process artwork
# artwork.add_artwork(artwork.get_all_artwork(item), seasonid, "season")
# We needed to recreate the show entry. Re-add episodes now.
log.info("Repairing episodes for showid: %s %s", showid, title)
all_episodes = item["episodes"]
self.add_episodes(all_episodes, None)
return True
def add_updateSeason(self, item, showid=None):
kodicursor = self.kodicursor
source_db = self.source_db
seasonnum = item.get('SeasonNumber', 1)
if showid is None:
try:
seriesId = item['SeriesId']
showid = source_db.getItem_byId(seriesId)[0]
except KeyError:
return
except TypeError:
# Show is missing, update show instead.
show = self.emby.getItem(seriesId)
self.add_update(show)
return
seasonid = self.kodi_db.get_season(showid, seasonnum, item['Name'])
# if item['LocationType'] != "Virtual":
# # Create the reference in emby table
# source_db.addReference(item['Id'], seasonid, "Season", "season", parentid=showid)
# Process artwork
# self.kodi_db.add_artwork(artwork.get_all_artwork(item), seasonid, "season", kodicursor)
return True
def add_updateEpisode(self, item):
# Process single episode
kodicursor = self.kodicursor
source_db = self.source_db
if item.get(
'LocationType') == "Virtual": # TODO: Filter via api instead
log.info("Skipping virtual episode: %s", item['Name'])
return
# If the item already exist in the local Kodi DB we'll perform a full item update
# If the item doesn't exist, we'll add it to the database
update_item = True
itemid = item['episode_id']
source_dbitem = source_db.getItem_byId(itemid)
try:
episodeid = source_dbitem[0]
fileid = source_dbitem[1]
pathid = source_dbitem[2]
log.info("episodeid: %s fileid: %s pathid: %s", episodeid, fileid,
pathid)
except TypeError:
update_item = False
log.debug("episodeid: %s not found", itemid)
# episodeid
episodeid = self.kodi_db.create_entry_episode()
else:
# Verification the item is still in Kodi
if self.kodi_db.get_episode(episodeid) is None:
# item is not found, let's recreate it.
update_item = False
log.info(
"episodeid: %s missing from Kodi, repairing the entry",
episodeid)
# fileId information
# checksum = API.get_checksum()
dateadded = item.get('dateadded')
# userdata = API.get_userdata()
# playcount = userdata['PlayCount']
# dateplayed = userdata['LastPlayedDate']
# item details
writer = ""
director = ""
title = item['title']
plot = item['title']
rating = 10.0
runtime = item.get('runtime')
premieredate = item.get('date')
votecount = 0
tvdb = 'tvdb_dd'
# episode details
try:
seriesId = item['show_id']
except KeyError:
# Missing seriesId, skip
log.error("Skipping: %s. SeriesId is missing.", itemid)
return False
season = item.get('season')
episode = item.get('ep_index', -1)
if season is None:
if item.get('AbsoluteEpisodeNumber'):
# Anime scenario
season = 1
episode = item['AbsoluteEpisodeNumber']
else:
season = -1
# Specials ordering within season
if item.get('AirsAfterSeasonNumber'):
airsBeforeSeason = item['AirsAfterSeasonNumber']
airsBeforeEpisode = 4096 # Kodi default number for afterseason ordering
else:
airsBeforeSeason = item.get('AirsBeforeSeasonNumber')
airsBeforeEpisode = item.get('AirsBeforeEpisodeNumber')
# Append multi episodes to title
if item.get('IndexNumberEnd'):
title = "| %02d | %s" % (item['IndexNumberEnd'], title)
# Get season id
show = source_db.getItem_byId(seriesId)
try:
showid = show[0]
except TypeError:
# Show is missing from database
show = self.emby.getItem(seriesId)
self.add_update(show)
show = source_db.getItem_byId(seriesId)
try:
showid = show[0]
except TypeError:
log.error("Skipping: %s. Unable to add series: %s", itemid,
seriesId)
return False
seasonid = self.kodi_db.get_season(showid, season)
##### GET THE FILE AND PATH #####
path = "plugin://plugin.proxy.pptv.tvshows/%s/" % seriesId
filename = item.get('file')
##### UPDATE THE EPISODE #####
if update_item:
log.info("UPDATE episode itemid: %s - Title: %s", itemid, title)
# update new ratings Kodi 17
if self.kodi_version >= 17:
ratingid = self.kodi_db.get_ratingid("episode", episodeid)
self.kodi_db.update_ratings(episodeid, "episode", "default",
rating, votecount, ratingid)
# update new uniqueid Kodi 17
if self.kodi_version >= 17:
uniqueid = self.kodi_db.get_uniqueid("episode", episodeid)
self.kodi_db.update_uniqueid(episodeid, "episode", tvdb,
"tvdb", uniqueid)
# Update the episode entry
if self.kodi_version >= 17:
# Kodi Krypton
self.kodi_db.update_episode_16(title, plot, uniqueid, writer,
premieredate, runtime, director,
season, episode, title,
airsBeforeSeason,
airsBeforeEpisode, seasonid,
showid, episodeid)
elif self.kodi_version == 16:
# Kodi Jarvis
self.kodi_db.update_episode_16(title, plot, rating, writer,
premieredate, runtime, director,
season, episode, title,
airsBeforeSeason,
airsBeforeEpisode, seasonid,
showid, episodeid)
else:
self.kodi_db.update_episode(title, plot, rating, writer,
premieredate, runtime, director,
season, episode, title,
airsBeforeSeason,
airsBeforeEpisode, showid,
episodeid)
# Update the checksum in emby table
source_db.updateReference(itemid, "checksum")
# Update parentid reference
source_db.updateParentId(itemid, seasonid)
##### OR ADD THE EPISODE #####
else:
log.info("ADD episode itemid: %s - Title: %s", itemid, title)
# add new ratings Kodi 17
if self.kodi_version >= 17:
ratingid = self.kodi_db.create_entry_rating()
self.kodi_db.add_ratings(ratingid, episodeid, "episode",
"default", rating, votecount)
# add new uniqueid Kodi 17
if self.kodi_version >= 17:
uniqueid = self.kodi_db.create_entry_uniqueid()
self.kodi_db.add_uniqueid(uniqueid, episodeid, "episode", tvdb,
"tvdb")
# Add path
pathid = self.kodi_db.add_path(path)
# Add the file
fileid = self.kodi_db.add_file(filename, pathid)
# Create the episode entry
if self.kodi_version >= 17:
# Kodi Krypton
self.kodi_db.add_episode_16(episodeid, fileid, title, plot,
uniqueid, writer, premieredate,
runtime, director, season, episode,
title, showid, airsBeforeSeason,
airsBeforeEpisode, seasonid)
elif self.kodi_version >= 16 and self.kodi_version < 17:
# Kodi Jarvis
self.kodi_db.add_episode_16(episodeid, fileid, title, plot,
rating, writer, premieredate,
runtime, director, season, episode,
title, showid, airsBeforeSeason,
airsBeforeEpisode, seasonid)
else:
self.kodi_db.add_episode(episodeid, fileid, title, plot,
rating, writer, premieredate, runtime,
director, season, episode, title,
showid, airsBeforeSeason,
airsBeforeEpisode)
# Create the reference in emby table
source_db.addReference(itemid, episodeid, "Episode", "episode",
fileid, pathid, seasonid, "checksum")
# Update the path
self.kodi_db.update_path(pathid, path, None, None)
# Update the file
self.kodi_db.update_file(fileid, filename, pathid, dateadded)
# Process cast
# people = artwork.get_people_artwork(item['People'])
# self.kodi_db.add_people(episodeid, people, "episode")
# # Process artwork
# artworks = artwork.get_all_artwork(item)
# artwork.add_update_art(
# artworks['Primary'], episodeid, "episode", "thumb", kodicursor)
# Process stream details
# streams = API.get_media_streams()
# self.kodi_db.add_streams(fileid, streams, runtime)
# Process playstates
# resume = API.adjust_resume(userdata['Resume'])
# total = round(float(runtime), 6)
# self.kodi_db.add_playstate(
# fileid, resume, total, playcount, dateplayed)
# if not self.direct_path and resume:
# # Create additional entry for widgets. This is only required for plugin/episode.
# temppathid = self.kodi_db.get_path(
# "plugin://plugin.video.emby.tvshows/")
# tempfileid = self.kodi_db.add_file(filename, temppathid)
# self.kodi_db.update_file(
# tempfileid, filename, temppathid, dateadded)
# self.kodi_db.add_playstate(
# tempfileid, resume, total, playcount, dateplayed)
return True
def remove(self, itemid):
# Remove showid, fileid, pathid, emby reference
source_db = self.source_db
kodicursor = self.kodicursor
source_dbitem = source_db.getItem_byId(itemid)
try:
kodiid = source_dbitem[0]
fileid = source_dbitem[1]
parentid = source_dbitem[3]
mediatype = source_dbitem[4]
log.info("Removing %s kodiid: %s fileid: %s", mediatype, kodiid,
fileid)
except TypeError:
return
##### PROCESS ITEM #####
# Remove the emby reference
source_db.removeItem(itemid)
##### IF EPISODE #####
if mediatype == "episode":
# Delete kodi episode and file, verify season and tvshow
self.removeEpisode(kodiid, fileid)
# Season verification
season = source_db.getItem_byKodiId(parentid, "season")
try:
showid = season[1]
except TypeError:
return
season_episodes = source_db.getItem_byParentId(parentid, "episode")
if not season_episodes:
self.removeSeason(parentid)
source_db.removeItem(season[0])
# Show verification
show = source_db.getItem_byKodiId(showid, "tvshow")
query = ' '.join(
("SELECT totalCount", "FROM tvshowcounts", "WHERE idShow = ?"))
kodicursor.execute(query, (showid, ))
result = kodicursor.fetchone()
if result and result[0] is None:
# There's no episodes left, delete show and any possible remaining seasons
seasons = source_db.getItem_byParentId(showid, "season")
for season in seasons:
self.removeSeason(season[1])
else:
# Delete emby season entries
source_db.removeItems_byParentId(showid, "season")
self.removeShow(showid)
source_db.removeItem(show[0])
##### IF TVSHOW #####
elif mediatype == "tvshow":
# Remove episodes, seasons, tvshow
seasons = source_db.getItem_byParentId(kodiid, "season")
for season in seasons:
seasonid = season[1]
season_episodes = source_db.getItem_byParentId(
seasonid, "episode")
for episode in season_episodes:
self.removeEpisode(episode[1], episode[2])
else:
# Remove emby episodes
source_db.removeItems_byParentId(seasonid, "episode")
else:
# Remove emby seasons
source_db.removeItems_byParentId(kodiid, "season")
# Remove tvshow
self.removeShow(kodiid)
##### IF SEASON #####
elif mediatype == "season":
# Remove episodes, season, verify tvshow
season_episodes = source_db.getItem_byParentId(kodiid, "episode")
for episode in season_episodes:
self.removeEpisode(episode[1], episode[2])
else:
# Remove emby episodes
source_db.removeItems_byParentId(kodiid, "episode")
# Remove season
self.removeSeason(kodiid)
# Show verification
seasons = source_db.getItem_byParentId(parentid, "season")
if not seasons:
# There's no seasons, delete the show
self.removeShow(parentid)
source_db.removeItem_byKodiId(parentid, "tvshow")
log.info("Deleted %s: %s from kodi database", mediatype, itemid)
def removeShow(self, kodiid):
kodicursor = self.kodicursor
self.artwork.delete_artwork(kodiid, "tvshow", kodicursor)
self.kodi_db.remove_tvshow(kodiid)
log.debug("Removed tvshow: %s", kodiid)
def removeSeason(self, kodiid):
kodicursor = self.kodicursor
self.artwork.delete_artwork(kodiid, "season", kodicursor)
self.kodi_db.remove_season(kodiid)
log.debug("Removed season: %s", kodiid)
def removeEpisode(self, kodiid, fileid):
kodicursor = self.kodicursor
self.artwork.delete_artwork(kodiid, "episode", kodicursor)
self.kodi_db.remove_episode(kodiid, fileid)
log.debug("Removed episode: %s", kodiid)
class Movies():
def __init__(self, kodicursor, sources_cursor, pdialog=None):
self.kodicursor = kodicursor
self.kodi_db = _kodi_movies.KodiMovies(self.kodicursor)
self.sources_cursor = sources_cursor
self.source_db = Customdb_Functions(self.sources_cursor)
self.kodi_version = 17
def _get_func(self, item_type, action):
if item_type == "Movie":
actions = {
'added': self.add_movies,
'update': self.add_update,
'userdata': self.updateUserdata,
'remove': self.remove
}
elif item_type == "BoxSet":
actions = {
'added': self.add_boxsets,
'update': self.add_updateBoxset,
'remove': self.remove
}
else:
log.info("Unsupported item_type: %s", item_type)
actions = {}
return actions.get(action)
def compare_all(self):
# Pull the list of movies and boxsets in Kodi
views = self.emby_db.getView_byType('movies')
views += self.emby_db.getView_byType('mixed')
log.info("Media folders: %s", views)
# Process movies
for view in views:
if self.should_stop():
return False
if not self.compare_movies(view):
return False
# Process boxsets
if not self.compare_boxsets():
return False
return True
def compare_movies(self, view):
view_id = view['id']
view_name = view['name']
if self.pdialog:
self.pdialog.update(heading=lang(29999),
message="%s %s..." % (lang(33026), view_name))
movies = dict(self.emby_db.get_checksum_by_view("Movie", view_id))
emby_movies = self.emby.getMovies(view_id,
basic=True,
dialog=self.pdialog)
return self.compare("Movie", emby_movies['Items'], movies, view)
def compare_boxsets(self):
if self.pdialog:
self.pdialog.update(heading=lang(29999), message=lang(33027))
boxsets = dict(self.emby_db.get_checksum('BoxSet'))
emby_boxsets = self.emby.getBoxset(dialog=self.pdialog)
return self.compare("BoxSet", emby_boxsets['Items'], boxsets)
def add_movies(self, items, total=None, view=None):
for item in self.added(items, total):
if self.add_update(item, view):
self.content_pop(item.get('Name', "unknown"))
def add_boxsets(self, items, total=None):
for item in self.added(items, total):
self.add_updateBoxset(item)
def add_update(self, item, view=None):
# If the item already exist in the local Kodi DB we'll perform a full item update
# If the item doesn't exist, we'll add it to the database
update_item = True
title = item['title']
itemid = item['id']
source_item = self.source_db.getItem_byId(itemid)
try:
movieid = source_item[0]
fileid = source_item[1]
pathid = source_item[2]
except TypeError:
update_item = False
movieid = self.kodi_db.create_entry()
# fileId information
dateadded = item.get('dateadded')
# item details
writer = item.get('writer')
director = item.get('director')
genre = item.get('genre')
genres = item.get('genres')
plot = item.get('plot')
tagline = item.get('tagline')
votecount = 0
rating = item.get('rating')
year = item.get('year')
runtime = item.get('runtime')
country = item.get('country')
studio = item.get('studios')
sorttitle = item['sorttitle']
shortplot = item['shortplot']
mpaa = item['mpaa']
imdb = item.get('imdb')
trailer = item['trailer']
##### GET THE FILE AND PATH #####
filename = item.get('playurl')
path = item.get('path')
##### UPDATE THE MOVIE #####
if update_item:
# log.info("UPDATE movie itemid: %s - Title: %s", itemid, title)
# update new ratings Kodi 17
if self.kodi_version >= 17:
ratingid = self.kodi_db.get_ratingid(movieid)
self.kodi_db.update_ratings(movieid, "movie", "default",
rating, votecount, ratingid)
# update new uniqueid Kodi 17
if self.kodi_version >= 17:
uniqueid = self.kodi_db.get_uniqueid(movieid)
self.kodi_db.update_uniqueid(movieid, "movie", "imdb_id",
"imdb", uniqueid)
# Update the movie entry
if self.kodi_version >= 17:
self.kodi_db.update_movie_17(title, plot, shortplot, tagline,
votecount, uniqueid, writer, year,
uniqueid, sorttitle, runtime,
mpaa, genre, director, title,
studio, trailer, country, year,
movieid)
else:
self.kodi_db.update_movie(title, plot, shortplot, tagline,
votecount, rating, writer, year,
imdb, sorttitle, runtime, mpaa,
genre, director, title, studio,
trailer, country, movieid)
# Update the checksum in emby table
# emby_db.updateReference(itemid, checksum)
##### OR ADD THE MOVIE #####
else:
# log.info("ADD movie itemid: %s - Title: %s", itemid, title)
# add new ratings Kodi 17
if self.kodi_version >= 17:
ratingid = self.kodi_db.create_entry_rating()
self.kodi_db.add_ratings(ratingid, movieid, "movie", "default",
rating, votecount)
# add new uniqueid Kodi 17
if self.kodi_version >= 17:
uniqueid = self.kodi_db.create_entry_uniqueid()
self.kodi_db.add_uniqueid(uniqueid, movieid, "movie",
"pptvid3", "imdb")
# Add path
pathid = self.kodi_db.add_path(path)
# Add the file
fileid = self.kodi_db.add_file(filename, pathid)
# Create the movie entry
if self.kodi_version >= 17:
self.kodi_db.add_movie_17(movieid, fileid, title, plot,
shortplot, tagline, votecount,
uniqueid, writer, year, uniqueid,
sorttitle, runtime, mpaa, genre,
director, title, studio, trailer,
country, year)
else:
self.kodi_db.add_movie(movieid, fileid, title, plot, shortplot,
tagline, votecount, rating, writer,
year, imdb, sorttitle, runtime, mpaa,
genre, director, title, studio, trailer,
country)
# Create the reference in emby table
self.source_db.addReference(itemid, movieid, "Movie", "movie",
fileid, pathid, None, "checksum")
# Update the path
self.kodi_db.update_path(pathid, path, "movies", "metadata.local")
# Update the file
self.kodi_db.update_file(fileid, filename, pathid, dateadded)
# Process countries --ignore
# if 'ProductionLocations' in item:
# self.kodi_db.add_countries(movieid, item['ProductionLocations'])
# Process cast
# print([{"type": "actor", "name": actor} for actor in item['actors']])
people = [{"type": "actor", "name": actor} for actor in item['actors']]
self.kodi_db.add_people(movieid, people, "movie")
# Process genres
self.kodi_db.add_genres(movieid, genres, "movie")
# Process artwork
self.kodi_db.add_artwork(item['artwork'], movieid, "movie")
# Process stream details
# streams = API.get_media_streams()
# self.kodi_db.add_streams(fileid, streams, runtime)
# Process studios
# self.kodi_db.add_studios(movieid, studios, "movie")
# Process tags: view, emby tags
# tags = [viewtag]
# tags.extend(item['tags'])
self.kodi_db.add_tags(movieid, item['tags'], "movie")
# Process playstates
return True
def add_updateBoxset(self, boxset):
emby = self.emby
emby_db = self.emby_db
artwork = self.artwork
API = api.API(boxset)
boxsetid = boxset['Id']
title = boxset['Name']
checksum = API.get_checksum()
emby_dbitem = emby_db.getItem_byId(boxsetid)
try:
setid = emby_dbitem[0]
self.kodi_db.update_boxset(setid, title)
except TypeError:
setid = self.kodi_db.add_boxset(title)
# Process artwork
artwork.add_artwork(artwork.get_all_artwork(boxset), setid, "set",
self.kodicursor)
# Process movies inside boxset
current_movies = emby_db.getItemId_byParentId(setid, "movie")
process = []
try:
# Try to convert tuple to dictionary
current = dict(current_movies)
except ValueError:
current = {}
# Sort current titles
for current_movie in current:
process.append(current_movie)
# New list to compare
for movie in emby.getMovies_byBoxset(boxsetid)['Items']:
itemid = movie['Id']
if not current.get(itemid):
# Assign boxset to movie
emby_dbitem = emby_db.getItem_byId(itemid)
try:
movieid = emby_dbitem[0]
except TypeError:
log.info("Failed to add: %s to boxset", movie['Name'])
continue
log.info("New addition to boxset %s: %s", title, movie['Name'])
self.kodi_db.set_boxset(setid, movieid)
# Update emby reference
emby_db.updateParentId(itemid, setid)
else:
# Remove from process, because the item still belongs
process.remove(itemid)
# Process removals from boxset
for movie in process:
movieid = current[movie]
log.info("Remove from boxset %s: %s", title, movieid)
self.kodi_db.remove_from_boxset(movieid)
# Update emby reference
emby_db.updateParentId(movie, None)
# Update the reference in the emby table
emby_db.addReference(boxsetid,
setid,
"BoxSet",
mediatype="set",
checksum=checksum)
def updateUserdata(self, item):
# This updates: Favorite, LastPlayedDate, Playcount, PlaybackPositionTicks
# Poster with progress bar
emby_db = self.emby_db
API = api.API(item)
# Get emby information
itemid = item['Id']
checksum = API.get_checksum()
userdata = API.get_userdata()
runtime = API.get_runtime()
# Get Kodi information
emby_dbitem = emby_db.getItem_byId(itemid)
try:
movieid = emby_dbitem[0]
fileid = emby_dbitem[1]
log.info("Update playstate for movie: %s fileid: %s", item['Name'],
fileid)
except TypeError:
return
# Process favorite tags
if userdata['Favorite']:
self.kodi_db.get_tag(movieid, "Favorite movies", "movie")
else:
self.kodi_db.remove_tag(movieid, "Favorite movies", "movie")
# Process playstates
playcount = userdata['PlayCount']
dateplayed = userdata['LastPlayedDate']
resume = API.adjust_resume(userdata['Resume'])
total = round(float(runtime), 6)
log.debug("%s New resume point: %s", itemid, resume)
self.kodi_db.add_playstate(fileid, resume, total, playcount,
dateplayed)
emby_db.updateReference(itemid, checksum)
def remove(self, itemid):
# Remove movieid, fileid, emby reference
emby_db = self.emby_db
artwork = self.artwork
emby_dbitem = emby_db.getItem_byId(itemid)
try:
kodiid = emby_dbitem[0]
fileid = emby_dbitem[1]
mediatype = emby_dbitem[4]
log.info("Removing %sid: %s fileid: %s", mediatype, kodiid, fileid)
except TypeError:
return
# Remove the emby reference
emby_db.removeItem(itemid)
# Remove artwork
artwork.delete_artwork(kodiid, mediatype, self.kodicursor)
if mediatype == "movie":
self.kodi_db.remove_movie(kodiid, fileid)
elif mediatype == "set":
# Delete kodi boxset
boxset_movies = emby_db.getItem_byParentId(kodiid, "movie")
for movie in boxset_movies:
embyid = movie[0]
movieid = movie[1]
self.kodi_db.remove_from_boxset(movieid)
# Update emby reference
emby_db.updateParentId(embyid, None)
self.kodi_db.remove_boxset(kodiid)
log.info("Deleted %s %s from kodi database", mediatype, itemid)