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