def get_related_films(person_id): statement = text( "select * from films where id in (select film_id from relations where person_id = '" + get_person_id(person_id) + "');" ) return db.execute(statement)
def get_related_people(film_id): statement = text( "select * from people where id in (select person_id from relations where film_id = '" + get_film_id(film_id) + "');" ) return db.execute(statement)
def get_people_by_name(name): statement = text( "select * from people where lower(primary_name) LIKE lower('%" + name + "%');") return db.execute(statement)
def get_films_by_title(name): statement = text("select * from films where lower(title) LIKE lower('%" + name + "%');") return db.execute(statement)
def get_film_by_id(id): statement = text("select * from films where id = '" + get_film_id(id) + "';") return db.execute(statement)
def get_person_by_id(id): statement = text("select * from people where id = '" + get_person_id(id) + "';") return db.execute(statement)