def tvshow_detail(tvshow_id):
client = KodiMysqlClient()
db_show = client.get_tvshow_info(show_id=tvshow_id)
db_episodes = client.get_episode_count_per_season_by_tvshow(
show_id=tvshow_id)
return render_template("tvshow_detail.html",
tvshow=db_show,
episodes=db_episodes)
def movie_detail(movie_id):
client = KodiMysqlClient()
db_movie = client.get_movie_info(movie_id=movie_id)
db_actors = client.get_actors_by_movie(movie_id=movie_id)
db_tags = client.get_movie_tags(movie_id=movie_id)
return render_template("movie_detail.html",
movie=db_movie,
actors=db_actors,
tags=db_tags)
def tvshow_season_episodes(tvshow_id, season):
client = KodiMysqlClient()
db_show = client.get_tvshow_info(show_id=tvshow_id)
db_season_id = client.get_season_id(tvshow_id, season)
db_episodes = client.get_episode_titles_by_tvshow_and_season(
season_id=db_season_id, show_id=db_show['id'])
return render_template("tvshow_season_episodes.html",
tvshow=db_show,
episodes=db_episodes,
season=season)
def person_detail(person_name):
client = KodiMysqlClient()
db_movies_dir = client.get_movies_by_director(person_name)
db_movies_dir_dict = client.convert_db_movie_list_to_dict(db_movies_dir)
db_movies_wri = client.get_movies_by_writer(person_name)
db_movies_wri_dict = client.convert_db_movie_list_to_dict(db_movies_wri)
db_movies_act = client.get_movies_by_actor(actor_name=person_name)
db_movies_act_dict = client.convert_db_movie_list_to_dict(db_movies_act)
try:
tmdb_person = TMDBApi.Person(name=person_name)
except TMDBApi.TMDBSearchException:
return render_template("person.html",
db_movies_act=db_movies_act,
db_movies_wri=db_movies_wri,
db_movies_dir=db_movies_dir)
return render_template(
"person.html",
db_movies_act_dict=db_movies_act_dict,
db_movies_wri_dict=db_movies_wri_dict,
db_movies_dir_dict=db_movies_dir_dict,
tmdb_movies_act=tmdb_person.get_movies_as_actor(),
tmdb_movies_wri=tmdb_person.get_movies_as_writer(),
info=tmdb_person.info,
tmdb_movies_dir=tmdb_person.get_movies_as_director())
def directors():
client = KodiMysqlClient()
db_directors = client.get_all_movie_directors()
return render_template("directors.html", directors=db_directors)
def actors():
client = KodiMysqlClient()
db_actors = client.get_all_actors()
return render_template("actors.html", actors=db_actors)
def tvshows():
client = KodiMysqlClient()
db_tvshows = client.get_all_tvshow_titles()
return render_template("tvshows.html", tvshows=db_tvshows)
def movies():
client = KodiMysqlClient()
db_movies = client.get_all_movie_titles()
return render_template("movies.html", movies=db_movies)
def taglist_by_name(list_name):
tags_added = None
client = KodiMysqlClient()
taglist = Taglist(list_name)
if request.method == "POST" and 'create_tag' in request.form and request.form[
'create_tag'] == 'true':
client.create_tag(taglist.metadata['name'])
db_tag = client.get_tag_by_name(taglist.metadata['name'])
if db_tag:
db_tag_movies = client.get_movie_title_and_release_by_tag(
db_tag['tag_id'])
db_tag_movies_dict = client.convert_db_movie_list_to_dict(
db_tag_movies)
else:
db_tag_movies = []
db_tag_movies_dict = {}
db_movies = client.get_movies_from_title_list(taglist.movies_tuple())
db_movies_dict = client.convert_db_movie_list_to_dict(db_movies)
if request.method == "POST" and 'add_tags' in request.form and request.form[
'add_tags'] == 'true':
db_movies_no_tag = client.get_movie_list_difference(
db_movies, db_tag_movies)
tags_added = client.add_tag_to_movies_check_year(
db_tag, db_movies_no_tag, taglist.movies)
db_tag_movies_dict, db_tag = client.get_movies_dict_by_tag_name(
taglist.metadata['name'])
return render_template("tag_list_detail.html",
taglist=taglist.metadata,
taglist_movies=taglist.movies,
db_tag=db_tag,
db_movies_dict=db_movies_dict,
db_tag_movies_dict=db_tag_movies_dict,
tags_added=tags_added)
def movies_by_tag(tag_id):
client = KodiMysqlClient()
db_movies = client.get_movie_title_and_release_by_tag(tag_id)
return render_template("tag_detail.html", movies=db_movies)
def tags():
client = KodiMysqlClient()
db_tags = client.get_all_tags()
return render_template("tags.html", tags=db_tags)
def tvshows_by_genre(genre_name):
client = KodiMysqlClient()
db_tvshows = client.get_tvshows_by_genre(genre_name)
return render_template("tvshows.html", tvshows=db_tvshows)
def movies_by_genre(genre_name):
client = KodiMysqlClient()
db_movies = client.get_movies_by_genre(genre_name)
return render_template("movies.html", movies=db_movies)