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
