def fill_movie_imdbid():
imdb_conn = IMDb('sql', DB_URI)
cust_conn = IMDB()
ids = cust_conn.fetch_vec('SELECT id FROM title WHERE imdb_id IS NULL;')
for id in ids:
print id
imdb_conn.get_imdbMovieID(id)
cust_conn.execute_query(
'UPDATE movie,title SET movie.imdb_id=title.imdb_id WHERE title.id=movie.id;')
cust_conn.execute_query("INSERT INTO missing_movies (SELECT * FROM movie WHERE "
"imdb_id IS NULL);")
cust_conn.execute_query("DELETE FROM movie WHERE imdb_id IS NULL;")
