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