def get_all_movies() -> []: sql_statement = "SELECT * FROM movies" rows = execute_select(sql_statement) rollodex = [] for r in rows: rollodex.append(Movie.from_SQLiteRow(r)) return rollodex
def get_movie(movie_name) -> []: sql_statement = f"SELECT * FROM movies WHERE title LIKE '%{movie_name}%'" rows = execute_select(sql_statement) rollodex = [] for r in rows: rollodex.append(Movie.from_SQLiteRow(r)) return rollodex
def check_movies_exist(movie_name) -> bool: sql_statement = ("Select * from movies where title = ?") rows = execute_select(sql_statement, (movie_name,)) rollodex = [] for r in rows: rollodex.append(Movie.from_SQLiteRow(r)) if len(rollodex) > 0: return True else: return False