Python get_sql_id_by_name_in_movie Examples

Example #1

File: stars_2.py Project: dannykh/imdb_project

def process_star(conn, mov_id, star, index):
    star_id = get_sql_id_by_name_in_movie(conn, star, mov_id, (1, 2))

    insert_query = "INSERT INTO stars (movie_id,person_id,`index`) " \
                   "VALUES (%s,%s,%s) ;"

    return conn.execute_query(insert_query, mov_id, star_id, index)

Example #2

File: http_cast.py Project: dannykh/imdb_project

def get_actor_sql_id(conn, http_conn, actor, movie_id):
    return get_sql_id_by_name_in_movie(conn, actor['name'], movie_id, roles=(1, 2))