def post(self):
radarrIdList = request.form.getlist('radarrid')
profileIdList = request.form.getlist('profileid')
for idx in range(len(radarrIdList)):
radarrId = radarrIdList[idx]
profileId = profileIdList[idx]
if profileId in None_Keys:
profileId = None
else:
try:
profileId = int(profileId)
except Exception:
return '', 400
TableMovies.update({
TableMovies.profileId: profileId
})\
.where(TableMovies.radarrId == radarrId)\
.execute()
list_missing_subtitles_movies(no=radarrId, send_event=False)
event_stream(type='movie', payload=radarrId)
event_stream(type='movie-wanted', payload=radarrId)
event_stream(type='badges')
return '', 204
def wanted_download_subtitles_movie(path):
conn_db = sqlite3.connect(os.path.join(config_dir, 'db/bazarr.db'),
timeout=30)
c_db = conn_db.cursor()
movies_details = c_db.execute(
"SELECT path, missing_subtitles, radarrId, radarrId, hearing_impaired, sceneName, failedAttempts FROM table_movies WHERE path = ? AND missing_subtitles != '[]'",
(path_replace_reverse_movie(path), )).fetchall()
c_db.close()
providers_list = get_providers()
providers_auth = get_providers_auth()
for movie in movies_details:
attempt = movie[6]
if type(attempt) == unicode:
attempt = ast.literal_eval(attempt)
for language in ast.literal_eval(movie[1]):
if attempt is None:
attempt = []
attempt.append([language, time.time()])
else:
att = zip(*attempt)[0]
if language not in att:
attempt.append([language, time.time()])
conn_db = sqlite3.connect(os.path.join(config_dir, 'db/bazarr.db'),
timeout=30)
c_db = conn_db.cursor()
c_db.execute(
'UPDATE table_movies SET failedAttempts = ? WHERE radarrId = ?',
(unicode(attempt), movie[2]))
conn_db.commit()
c_db.close()
for i in range(len(attempt)):
if attempt[i][0] == language:
if search_active(attempt[i][1]) is True:
message = download_subtitle(
path_replace_movie(movie[0]),
str(alpha3_from_alpha2(language)),
movie[4], providers_list, providers_auth,
str(movie[5]), 'movie')
if message is not None:
store_subtitles_movie(path_replace_movie(movie[0]))
list_missing_subtitles_movies(movie[3])
history_log_movie(1, movie[3], message)
send_notifications_movie(movie[3], message)
else:
logging.info('BAZARR Search is not active for movie ' +
movie[0] + ' Language: ' + attempt[i][0])
def clean_desired_languages():
from list_subtitles import list_missing_subtitles, list_missing_subtitles_movies
enabled_languages = []
enabled_languages_temp = database.execute(
"SELECT code2 FROM table_settings_languages WHERE enabled=1")
for language in enabled_languages_temp:
enabled_languages.append(language['code2'])
series_languages = database.execute(
"SELECT sonarrSeriesId, languages FROM table_shows")
movies_languages = database.execute(
"SELECT radarrId, languages FROM table_movies")
for item in series_languages:
if item['languages'] != 'None':
try:
languages_list = ast.literal_eval(item['languages'])
except:
pass
else:
cleaned_languages_list = []
for language in languages_list:
if language in enabled_languages:
cleaned_languages_list.append(language)
if cleaned_languages_list != languages_list:
database.execute(
"UPDATE table_shows SET languages=? WHERE sonarrSeriesId=?",
(str(cleaned_languages_list), item['sonarrSeriesId']))
list_missing_subtitles(no=item['sonarrSeriesId'])
for item in movies_languages:
if item['languages'] != 'None':
try:
languages_list = ast.literal_eval(item['languages'])
except:
pass
else:
cleaned_languages_list = []
for language in languages_list:
if language in enabled_languages:
cleaned_languages_list.append(language)
if cleaned_languages_list != languages_list:
database.execute(
"UPDATE table_movies SET languages=? WHERE radarrId=?",
(str(cleaned_languages_list), item['radarrId']))
list_missing_subtitles_movies(no=item['radarrId'])
def movies_download_subtitles(no):
conn_db = sqlite3.connect(os.path.join(config_dir, 'db/bazarr.db'), timeout=30)
c_db = conn_db.cursor()
movie = c_db.execute("SELECT path, missing_subtitles, radarrId, sceneName, hearing_impaired FROM table_movies WHERE radarrId = ?", (no,)).fetchone()
c_db.close()
providers_list = get_providers()
providers_auth = get_providers_auth()
for language in ast.literal_eval(movie[1]):
if language is not None:
message = download_subtitle(path_replace_movie(movie[0]), str(alpha3_from_alpha2(language)), movie[4], providers_list, providers_auth, str(movie[3]), 'movie')
if message is not None:
store_subtitles_movie(path_replace_movie(movie[0]))
history_log_movie(1, no, message)
send_notifications_movie(no, message)
list_missing_subtitles_movies(no)
def movies_download_subtitles(no):
conn_db = sqlite3.connect(os.path.join(args.config_dir, 'db', 'bazarr.db'),
timeout=30)
c_db = conn_db.cursor()
movie = c_db.execute(
"SELECT path, missing_subtitles, radarrId, sceneName, hearing_impaired, title FROM table_movies WHERE radarrId = ?",
(no, )).fetchone()
c_db.close()
providers_list = get_providers()
providers_auth = get_providers_auth()
count_movie = len(ast.literal_eval(movie[1]))
for i, language in enumerate(ast.literal_eval(movie[1]), 1):
if language is not None:
notifications.write(msg='Searching for movies subtitles',
queue='get_subtitle',
item=i,
length=count_movie)
result = download_subtitle(path_replace_movie(movie[0]),
str(alpha3_from_alpha2(language)),
movie[4],
providers_list, providers_auth,
str(movie[3]), movie[5], 'movie')
if result is not None:
message = result[0]
path = result[1]
language_code = result[2]
provider = result[3]
score = result[4]
store_subtitles_movie(path_replace_movie(movie[0]))
history_log_movie(1, no, message, path, language_code,
provider, score)
send_notifications_movie(no, message)
list_missing_subtitles_movies(no)
if count_movie:
notifications.write(msg='Searching completed. Please reload the page.',
type='success',
duration='permanent',
button='refresh',
queue='get_subtitle')
def update_movies():
logging.debug('BAZARR Starting movie sync from Radarr.')
from get_settings import get_radarr_settings
url_radarr = get_radarr_settings()[6]
apikey_radarr = get_radarr_settings()[4]
movie_default_enabled = get_general_settings()[18]
movie_default_language = get_general_settings()[19]
movie_default_hi = get_general_settings()[20]
if apikey_radarr == None:
pass
else:
get_profile_list()
# Get movies data from radarr
url_radarr_api_movies = url_radarr + "/api/movie?apikey=" + apikey_radarr
try:
r = requests.get(url_radarr_api_movies, timeout=15, verify=False)
r.raise_for_status()
except requests.exceptions.HTTPError as errh:
logging.exception(
"BAZARR Error trying to get movies from Radarr. Http error.")
except requests.exceptions.ConnectionError as errc:
logging.exception(
"BAZARR Error trying to get movies from Radarr. Connection Error."
)
except requests.exceptions.Timeout as errt:
logging.exception(
"BAZARR Error trying to get movies from Radarr. Timeout Error."
)
except requests.exceptions.RequestException as err:
logging.exception("BAZARR Error trying to get movies from Radarr.")
else:
# Get current movies in DB
db = sqlite3.connect(os.path.join(config_dir, 'db/bazarr.db'),
timeout=30)
c = db.cursor()
current_movies_db = c.execute(
'SELECT tmdbId FROM table_movies').fetchall()
db.close()
current_movies_db_list = [x[0] for x in current_movies_db]
current_movies_radarr = []
movies_to_update = []
movies_to_add = []
for movie in r.json():
if movie['hasFile'] is True:
if 'movieFile' in movie:
if movie["path"] != None and movie['movieFile'][
'relativePath'] != None:
try:
overview = unicode(movie['overview'])
except:
overview = ""
try:
poster_big = movie['images'][0]['url']
poster = os.path.splitext(
poster_big)[0] + '-500' + os.path.splitext(
poster_big)[1]
except:
poster = ""
try:
fanart = movie['images'][1]['url']
except:
fanart = ""
if 'sceneName' in movie['movieFile']:
sceneName = movie['movieFile']['sceneName']
else:
sceneName = None
# Add movies in radarr to current movies list
current_movies_radarr.append(
unicode(movie['tmdbId']))
# Detect file separator
if movie['path'][0] == "/":
separator = "/"
else:
separator = "\\"
if unicode(
movie['tmdbId']) in current_movies_db_list:
movies_to_update.append(
(movie["title"],
movie["path"] + separator +
movie['movieFile']['relativePath'],
movie["tmdbId"], movie["id"], overview,
poster, fanart,
profile_id_to_language(
movie['qualityProfileId']), sceneName,
unicode(bool(movie['monitored'])),
movie['sortTitle'], movie["tmdbId"]))
else:
if movie_default_enabled is True:
movies_to_add.append(
(movie["title"],
movie["path"] + separator +
movie['movieFile']['relativePath'],
movie["tmdbId"],
movie_default_language, '[]',
movie_default_hi, movie["id"],
overview, poster, fanart,
profile_id_to_language(
movie['qualityProfileId']),
sceneName,
unicode(bool(movie['monitored'])),
movie['sortTitle']))
else:
movies_to_add.append(
(movie["title"],
movie["path"] + separator +
movie['movieFile']['relativePath'],
movie["tmdbId"], movie["tmdbId"],
movie["tmdbId"], movie["id"],
overview, poster, fanart,
profile_id_to_language(
movie['qualityProfileId']),
sceneName,
unicode(bool(movie['monitored'])),
movie['sortTitle']))
else:
logging.error(
'BAZARR Radarr returned a movie without a file path: '
+ movie["path"] + separator +
movie['movieFile']['relativePath'])
# Update or insert movies in DB
db = sqlite3.connect(os.path.join(config_dir, 'db/bazarr.db'),
timeout=30)
c = db.cursor()
updated_result = c.executemany(
'''UPDATE table_movies SET title = ?, path = ?, tmdbId = ?, radarrId = ?, overview = ?, poster = ?, fanart = ?, `audio_language` = ?, sceneName = ?, monitored = ?, sortTitle= ? WHERE tmdbid = ?''',
movies_to_update)
db.commit()
if movie_default_enabled is True:
added_result = c.executemany(
'''INSERT OR IGNORE INTO table_movies(title, path, tmdbId, languages, subtitles,`hearing_impaired`, radarrId, overview, poster, fanart, `audio_language`, sceneName, monitored, sortTitle) VALUES (?,?,?,?,?, ?, ?, ?, ?, ?, ?, ?, ?, ?)''',
movies_to_add)
db.commit()
else:
added_result = c.executemany(
'''INSERT OR IGNORE INTO table_movies(title, path, tmdbId, languages, subtitles,`hearing_impaired`, radarrId, overview, poster, fanart, `audio_language`, sceneName, monitored, sortTitle) VALUES (?,?,?,(SELECT languages FROM table_movies WHERE tmdbId = ?), '[]',(SELECT `hearing_impaired` FROM table_movies WHERE tmdbId = ?), ?, ?, ?, ?, ?, ?, ?, ?)''',
movies_to_add)
db.commit()
db.close()
removed_movies = list(
set(current_movies_db_list) - set(current_movies_radarr))
db = sqlite3.connect(os.path.join(config_dir, 'db/bazarr.db'),
timeout=30)
c = db.cursor()
for removed_movie in removed_movies:
c.execute('DELETE FROM table_movies WHERE tmdbId = ?',
(removed_movie, ))
db.commit()
db.close()
for added_movie in movies_to_add:
store_subtitles_movie(path_replace_movie(added_movie[1]))
for updated_movie in movies_to_update:
store_subtitles_movie(path_replace_movie(updated_movie[1]))
logging.debug('BAZARR All movies synced from Radarr into database.')
list_missing_subtitles_movies()
logging.debug('BAZARR All movie missing subtitles updated in database.')
def update_movies():
logging.debug('BAZARR Starting movie sync from Radarr.')
apikey_radarr = settings.radarr.apikey
movie_default_enabled = settings.general.getboolean(
'movie_default_enabled')
movie_default_language = settings.general.movie_default_language
movie_default_hi = settings.general.movie_default_hi
movie_default_forced = settings.general.movie_default_forced
if apikey_radarr is None:
pass
else:
get_profile_list()
# Get movies data from radarr
url_radarr_api_movies = url_radarr + "/api/movie?apikey=" + apikey_radarr
try:
r = requests.get(url_radarr_api_movies, timeout=60, verify=False)
r.raise_for_status()
except requests.exceptions.HTTPError as errh:
logging.exception(
"BAZARR Error trying to get movies from Radarr. Http error.")
except requests.exceptions.ConnectionError as errc:
logging.exception(
"BAZARR Error trying to get movies from Radarr. Connection Error."
)
except requests.exceptions.Timeout as errt:
logging.exception(
"BAZARR Error trying to get movies from Radarr. Timeout Error."
)
except requests.exceptions.RequestException as err:
logging.exception("BAZARR Error trying to get movies from Radarr.")
else:
# Get current movies in DB
db = sqlite3.connect(os.path.join(args.config_dir, 'db',
'bazarr.db'),
timeout=30)
c = db.cursor()
current_movies_db = c.execute(
'SELECT tmdbId, path, radarrId FROM table_movies').fetchall()
db.close()
current_movies_db_list = [x[0] for x in current_movies_db]
current_movies_radarr = []
movies_to_update = []
movies_to_add = []
moviesIdListLength = len(r.json())
for i, movie in enumerate(r.json(), 1):
notifications.write(msg="Getting movies data from Radarr...",
queue='get_movies',
item=i,
length=moviesIdListLength)
if movie['hasFile'] is True:
if 'movieFile' in movie:
if movie["path"] != None and movie['movieFile'][
'relativePath'] != None:
try:
overview = unicode(movie['overview'])
except:
overview = ""
try:
poster_big = movie['images'][0]['url']
poster = os.path.splitext(
poster_big)[0] + '-500' + os.path.splitext(
poster_big)[1]
except:
poster = ""
try:
fanart = movie['images'][1]['url']
except:
fanart = ""
if 'sceneName' in movie['movieFile']:
sceneName = movie['movieFile']['sceneName']
else:
sceneName = None
if movie['alternativeTitles'] != None:
alternativeTitles = str([
item['title']
for item in movie['alternativeTitles']
])
if 'imdbId' in movie: imdbId = movie['imdbId']
else: imdbId = None
try:
format, resolution = movie['movieFile'][
'quality']['quality']['name'].split('-')
except:
format = movie['movieFile']['quality'][
'quality']['name']
try:
resolution = movie['movieFile']['quality'][
'quality']['resolution'].lstrip(
'r').lower()
except:
resolution = None
if 'mediaInfo' in movie['movieFile']:
videoFormat = videoCodecID = videoProfile = videoCodecLibrary = None
if 'videoFormat' in movie['movieFile'][
'mediaInfo']:
videoFormat = movie['movieFile'][
'mediaInfo']['videoFormat']
if 'videoCodecID' in movie['movieFile'][
'mediaInfo']:
videoCodecID = movie['movieFile'][
'mediaInfo']['videoCodecID']
if 'videoProfile' in movie['movieFile'][
'mediaInfo']:
videoProfile = movie['movieFile'][
'mediaInfo']['videoProfile']
if 'videoCodecLibrary' in movie['movieFile'][
'mediaInfo']:
videoCodecLibrary = movie['movieFile'][
'mediaInfo']['videoCodecLibrary']
videoCodec = RadarrFormatVideoCodec(
videoFormat, videoCodecID, videoProfile,
videoCodecLibrary)
audioFormat = audioCodecID = audioProfile = audioAdditionalFeatures = None
if 'audioFormat' in movie['movieFile'][
'mediaInfo']:
audioFormat = movie['movieFile'][
'mediaInfo']['audioFormat']
if 'audioCodecID' in movie['movieFile'][
'mediaInfo']:
audioCodecID = movie['movieFile'][
'mediaInfo']['audioCodecID']
if 'audioProfile' in movie['movieFile'][
'mediaInfo']:
audioProfile = movie['movieFile'][
'mediaInfo']['audioProfile']
if 'audioAdditionalFeatures' in movie[
'movieFile']['mediaInfo']:
audioAdditionalFeatures = movie[
'movieFile']['mediaInfo'][
'audioAdditionalFeatures']
audioCodec = RadarrFormatAudioCodec(
audioFormat, audioCodecID, audioProfile,
audioAdditionalFeatures)
else:
videoCodec = None
audioCodec = None
# Add movies in radarr to current movies list
current_movies_radarr.append(
unicode(movie['tmdbId']))
# Detect file separator
if movie['path'][0] == "/":
separator = "/"
else:
separator = "\\"
if unicode(
movie['tmdbId']) in current_movies_db_list:
movies_to_update.append(
(movie["title"],
movie["path"] + separator +
movie['movieFile']['relativePath'],
movie["tmdbId"], movie["id"], overview,
poster, fanart,
profile_id_to_language(
movie['qualityProfileId']), sceneName,
unicode(bool(movie['monitored'])),
movie['sortTitle'], movie['year'],
alternativeTitles, format, resolution,
videoCodec, audioCodec, imdbId,
movie["tmdbId"]))
else:
if movie_default_enabled is True:
movies_to_add.append(
(movie["title"],
movie["path"] + separator +
movie['movieFile']['relativePath'],
movie["tmdbId"],
movie_default_language, '[]',
movie_default_hi, movie["id"],
overview, poster, fanart,
profile_id_to_language(
movie['qualityProfileId']),
sceneName,
unicode(bool(movie['monitored'])),
movie['sortTitle'], movie['year'],
alternativeTitles, format, resolution,
videoCodec, audioCodec, imdbId,
movie_default_forced))
else:
movies_to_add.append(
(movie["title"],
movie["path"] + separator +
movie['movieFile']['relativePath'],
movie["tmdbId"], movie["tmdbId"],
movie["tmdbId"], movie["id"],
overview, poster, fanart,
profile_id_to_language(
movie['qualityProfileId']),
sceneName,
unicode(bool(movie['monitored'])),
movie['sortTitle'], movie['year'],
alternativeTitles, format, resolution,
videoCodec, audioCodec, imdbId,
movie["tmdbId"]))
else:
logging.error(
'BAZARR Radarr returned a movie without a file path: '
+ movie["path"] + separator +
movie['movieFile']['relativePath'])
# Update or insert movies in DB
db = sqlite3.connect(os.path.join(args.config_dir, 'db',
'bazarr.db'),
timeout=30)
c = db.cursor()
updated_result = c.executemany(
'''UPDATE table_movies SET title = ?, path = ?, tmdbId = ?, radarrId = ?, overview = ?, poster = ?, fanart = ?, `audio_language` = ?, sceneName = ?, monitored = ?, sortTitle = ?, year = ?, alternativeTitles = ?, format = ?, resolution = ?, video_codec = ?, audio_codec = ?, imdbId = ? WHERE tmdbid = ?''',
movies_to_update)
db.commit()
if movie_default_enabled is True:
added_result = c.executemany(
'''INSERT OR IGNORE INTO table_movies(title, path, tmdbId, languages, subtitles,`hearing_impaired`, radarrId, overview, poster, fanart, `audio_language`, sceneName, monitored, sortTitle, year, alternativeTitles, format, resolution, video_codec, audio_codec, imdbId, forced) VALUES (?,?,?,?,?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)''',
movies_to_add)
db.commit()
else:
added_result = c.executemany(
'''INSERT OR IGNORE INTO table_movies(title, path, tmdbId, languages, subtitles,`hearing_impaired`, radarrId, overview, poster, fanart, `audio_language`, sceneName, monitored, sortTitle, year, alternativeTitles, format, resolution, video_codec, audio_codec, imdbId, forced) VALUES (?,?,?,(SELECT languages FROM table_movies WHERE tmdbId = ?), '[]',(SELECT `hearing_impaired` FROM table_movies WHERE tmdbId = ?), ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, (SELECT `forced` FROM table_movies WHERE tmdbId = ?))''',
movies_to_add)
db.commit()
removed_movies = list(
set(current_movies_db_list) - set(current_movies_radarr))
for removed_movie in removed_movies:
c.execute('DELETE FROM table_movies WHERE tmdbId = ?',
(removed_movie, ))
db.commit()
# Get movies list after INSERT and UPDATE
movies_now_in_db = c.execute(
'SELECT tmdbId, path, radarrId FROM table_movies').fetchall()
# Close database connection
db.close()
# Get only movies added or modified and store subtitles for them
altered_movies = set(movies_now_in_db).difference(
set(current_movies_db))
for altered_movie in altered_movies:
store_subtitles_movie(path_replace_movie(altered_movie[1]))
list_missing_subtitles_movies(altered_movie[2])
# Search for desired subtitles if no more than 5 movies have been added.
if len(altered_movies) <= 5:
logging.debug(
"BAZARR No more than 5 movies were added during this sync then we'll search for subtitles."
)
for altered_movie in altered_movies:
movies_download_subtitles(altered_movie[2])
else:
logging.debug(
"BAZARR More than 5 movies were added during this sync then we wont search for subtitles."
)
logging.debug('BAZARR All movies synced from Radarr into database.')
def update_movies():
logging.debug('BAZARR Starting movie sync from Radarr.')
apikey_radarr = settings.radarr.apikey
movie_default_enabled = settings.general.getboolean(
'movie_default_enabled')
movie_default_language = settings.general.movie_default_language
movie_default_hi = settings.general.movie_default_hi
movie_default_forced = settings.general.movie_default_forced
if apikey_radarr is None:
pass
else:
audio_profiles = get_profile_list()
# Get movies data from radarr
url_radarr_api_movies = url_radarr + "/api/movie?apikey=" + apikey_radarr
try:
r = requests.get(url_radarr_api_movies, timeout=60, verify=False)
r.raise_for_status()
except requests.exceptions.HTTPError as errh:
logging.exception(
"BAZARR Error trying to get movies from Radarr. Http error.")
return
except requests.exceptions.ConnectionError as errc:
logging.exception(
"BAZARR Error trying to get movies from Radarr. Connection Error."
)
return
except requests.exceptions.Timeout as errt:
logging.exception(
"BAZARR Error trying to get movies from Radarr. Timeout Error."
)
return
except requests.exceptions.RequestException as err:
logging.exception("BAZARR Error trying to get movies from Radarr.")
return
else:
# Get current movies in DB
current_movies_db = TableMovies.select(TableMovies.tmdb_id,
TableMovies.path,
TableMovies.radarr_id)
current_movies_db_list = [x.tmdb_id for x in current_movies_db]
current_movies_radarr = []
movies_to_update = []
movies_to_add = []
altered_movies = []
moviesIdListLength = len(r.json())
for i, movie in enumerate(r.json(), 1):
notifications.write(msg="Getting movies data from Radarr...",
queue='get_movies',
item=i,
length=moviesIdListLength)
if movie['hasFile'] is True:
if 'movieFile' in movie:
# Detect file separator
if movie['path'][0] == "/":
separator = "/"
else:
separator = "\\"
if movie["path"] != None and movie['movieFile'][
'relativePath'] != None:
try:
overview = unicode(movie['overview'])
except:
overview = ""
try:
poster_big = movie['images'][0]['url']
poster = os.path.splitext(
poster_big)[0] + '-500' + os.path.splitext(
poster_big)[1]
except:
poster = ""
try:
fanart = movie['images'][1]['url']
except:
fanart = ""
if 'sceneName' in movie['movieFile']:
sceneName = movie['movieFile']['sceneName']
else:
sceneName = None
if 'alternativeTitles' in movie:
alternativeTitles = str([
item['title']
for item in movie['alternativeTitles']
])
else:
alternativeTitles = None
if 'imdbId' in movie: imdbId = movie['imdbId']
else: imdbId = None
try:
format, resolution = movie['movieFile'][
'quality']['quality']['name'].split('-')
except:
format = movie['movieFile']['quality'][
'quality']['name']
try:
resolution = movie['movieFile']['quality'][
'quality']['resolution'].lstrip(
'r').lower()
except:
resolution = None
if 'mediaInfo' in movie['movieFile']:
videoFormat = videoCodecID = videoProfile = videoCodecLibrary = None
if 'videoFormat' in movie['movieFile'][
'mediaInfo']:
videoFormat = movie['movieFile'][
'mediaInfo']['videoFormat']
if 'videoCodecID' in movie['movieFile'][
'mediaInfo']:
videoCodecID = movie['movieFile'][
'mediaInfo']['videoCodecID']
if 'videoProfile' in movie['movieFile'][
'mediaInfo']:
videoProfile = movie['movieFile'][
'mediaInfo']['videoProfile']
if 'videoCodecLibrary' in movie['movieFile'][
'mediaInfo']:
videoCodecLibrary = movie['movieFile'][
'mediaInfo']['videoCodecLibrary']
videoCodec = RadarrFormatVideoCodec(
videoFormat, videoCodecID, videoProfile,
videoCodecLibrary)
audioFormat = audioCodecID = audioProfile = audioAdditionalFeatures = None
if 'audioFormat' in movie['movieFile'][
'mediaInfo']:
audioFormat = movie['movieFile'][
'mediaInfo']['audioFormat']
if 'audioCodecID' in movie['movieFile'][
'mediaInfo']:
audioCodecID = movie['movieFile'][
'mediaInfo']['audioCodecID']
if 'audioProfile' in movie['movieFile'][
'mediaInfo']:
audioProfile = movie['movieFile'][
'mediaInfo']['audioProfile']
if 'audioAdditionalFeatures' in movie[
'movieFile']['mediaInfo']:
audioAdditionalFeatures = movie[
'movieFile']['mediaInfo'][
'audioAdditionalFeatures']
audioCodec = RadarrFormatAudioCodec(
audioFormat, audioCodecID, audioProfile,
audioAdditionalFeatures)
else:
videoCodec = None
audioCodec = None
# Add movies in radarr to current movies list
current_movies_radarr.append(
unicode(movie['tmdbId']))
if unicode(
movie['tmdbId']) in current_movies_db_list:
movies_to_update.append({
'radarr_id':
movie["id"],
'title':
unicode(movie["title"]),
'path':
unicode(
movie["path"] + separator +
movie['movieFile']['relativePath']),
'tmdb_id':
unicode(movie["tmdbId"]),
'poster':
unicode(poster),
'fanart':
unicode(fanart),
'audio_language':
unicode(
profile_id_to_language(
movie['qualityProfileId'],
audio_profiles)),
'scene_name':
sceneName,
'monitored':
unicode(bool(movie['monitored'])),
'year':
unicode(movie['year']),
'sort_title':
unicode(movie['sortTitle']),
'alternative_titles':
unicode(alternativeTitles),
'format':
unicode(format),
'resolution':
unicode(resolution),
'video_codec':
unicode(videoCodec),
'audio_codec':
unicode(audioCodec),
'overview':
unicode(overview),
'imdb_id':
unicode(imdbId),
'movie_file_id':
movie['movieFile']['id']
})
else:
if movie_default_enabled is True:
movies_to_add.append({
'radarr_id':
movie["id"],
'title':
movie["title"],
'path':
movie["path"] + separator +
movie['movieFile']['relativePath'],
'tmdb_id':
movie["tmdbId"],
'languages':
movie_default_language,
'subtitles':
'[]',
'hearing_impaired':
movie_default_hi,
'overview':
overview,
'poster':
poster,
'fanart':
fanart,
'audio_language':
profile_id_to_language(
movie['qualityProfileId'],
audio_profiles),
'scene_name':
sceneName,
'monitored':
unicode(bool(movie['monitored'])),
'sort_title':
movie['sortTitle'],
'year':
movie['year'],
'alternative_titles':
alternativeTitles,
'format':
format,
'resolution':
resolution,
'video_codec':
videoCodec,
'audio_codec':
audioCodec,
'imdb_id':
imdbId,
'forced':
movie_default_forced,
'movie_file_id':
movie['movieFile']['id']
})
else:
movies_to_add.append({
'radarr_id':
movie["id"],
'title':
movie["title"],
'path':
movie["path"] + separator +
movie['movieFile']['relativePath'],
'tmdb_id':
movie["tmdbId"],
'overview':
overview,
'poster':
poster,
'fanart':
fanart,
'audio_language':
profile_id_to_language(
movie['qualityProfileId'],
audio_profiles),
'scene_name':
sceneName,
'monitored':
unicode(bool(movie['monitored'])),
'sort_title':
movie['sortTitle'],
'year':
movie['year'],
'alternative_titles':
alternativeTitles,
'format':
format,
'resolution':
resolution,
'video_codec':
videoCodec,
'audio_codec':
audioCodec,
'imdb_id':
imdbId,
'movie_file_id':
movie['movieFile']['id']
})
else:
logging.error(
'BAZARR Radarr returned a movie without a file path: '
+ movie["path"] + separator +
movie['movieFile']['relativePath'])
# Update or insert movies in DB
movies_in_db_list = []
movies_in_db = TableMovies.select(
TableMovies.radarr_id, TableMovies.title, TableMovies.path,
TableMovies.tmdb_id, TableMovies.overview, TableMovies.poster,
TableMovies.fanart, TableMovies.audio_language,
TableMovies.scene_name, TableMovies.monitored,
TableMovies.sort_title, TableMovies.year,
TableMovies.alternative_titles, TableMovies.format,
TableMovies.resolution, TableMovies.video_codec,
TableMovies.audio_codec, TableMovies.imdb_id,
TableMovies.movie_file_id).dicts()
for item in movies_in_db:
movies_in_db_list.append(item)
movies_to_update_list = [
i for i in movies_to_update if i not in movies_in_db_list
]
for updated_movie in movies_to_update_list:
TableMovies.update(updated_movie).where(
TableMovies.radarr_id ==
updated_movie['radarr_id']).execute()
altered_movies.append([
updated_movie['tmdb_id'], updated_movie['path'],
updated_movie['radarr_id']
])
# Insert new movies in DB
for added_movie in movies_to_add:
TableMovies.insert(added_movie).on_conflict_ignore().execute()
altered_movies.append([
added_movie['tmdb_id'], added_movie['path'],
added_movie['radarr_id']
])
# Remove old movies from DB
removed_movies = list(
set(current_movies_db_list) - set(current_movies_radarr))
for removed_movie in removed_movies:
TableMovies.delete().where(
TableMovies.tmdb_id == removed_movie).execute()
# Store subtitles for added or modified movies
for i, altered_movie in enumerate(altered_movies, 1):
notifications.write(
msg='Indexing movies embedded subtitles...',
queue='get_movies',
item=i,
length=len(altered_movies))
store_subtitles_movie(path_replace_movie(altered_movie[1]))
list_missing_subtitles_movies(altered_movie[2])
logging.debug(
'BAZARR All movies synced from Radarr into database.')
# Search for desired subtitles if no more than 5 movies have been added.
if len(altered_movies) <= 5:
logging.debug(
"BAZARR No more than 5 movies were added during this sync then we'll search for subtitles."
)
for altered_movie in altered_movies:
movies_download_subtitles(altered_movie[2])
else:
logging.debug(
"BAZARR More than 5 movies were added during this sync then we wont search for subtitles."
)
def update_all_movies():
movies_full_scan_subtitles()
logging.info('BAZARR All existing movie subtitles indexed from disk.')
list_missing_subtitles_movies()
logging.info('BAZARR All missing movie subtitles updated in database.')
wal_cleaning()
