def all_series():
"""
Get all series in alphabetical order.
"""
result = list_all("series", "title ASC")
series = []
for row in result:
series.append((row["series_id"], row["title"]))
return series
def all_genres():
"""
Get all genres in alphabetical order.
"""
result = list_all("genre", "genre_name ASC")
genres = []
for row in result:
genres.append((row["genre_id"], row["genre_name"]))
return genres
def all_cast(role):
"""
Get all cast in alphabetical order by last name.
"""
if role not in ("author", "star", "director"):
return None
result = list_all(role, "last_name ASC")
cast = []
for row in result:
role_id = row[role + "_id"]
name = "%s %s" % (row["first_name"], row["last_name"])
cast.append((role_id, name))
return cast
