def get_actor(name) -> []:
sql_statement = f"SELECT * FROM actors WHERE name LIKE '%{name}%'"
rows = execute_select(sql_statement)
rollodex = []
for r in rows:
rollodex.append(Actor.from_SQLiteRow(r))
return rollodex
def get_all_actors() -> []:
sql_statement = "SELECT * FROM actors"
rows = execute_select(sql_statement)
rollodex = []
for r in rows:
rollodex.append(Actor.from_SQLiteRow(r))
return rollodex
def check_actor_exist(actor_name) -> bool:
sql_statement = ("Select * from actors where name = ?")
rows = execute_select(sql_statement, (actor_name,))
rollodex = []
for r in rows:
rollodex.append(Actor.from_SQLiteRow(r))
if len(rollodex) > 0:
return True
else:
return False
