for b in rating_table:
cursor.execute("insert into rating (user_id, movie_id, rating) values('{}','{}','{}')\n".format(rating_table[b]['user_id'],rating_table[b]['movie_id'],rating_table[b]['rating'].strip()))
for k in movieid_genresid:
cursor.execute("insert into genre_id (movies_id, genreid) values('{}','{}')\n".format(movieid_genresid[k]['movies_id'],movieid_genresid[k]['genreid']))
#EIGUM NÚ SAMSKIPTI VIÐ NOTANDA
print("Enter the names of 3 movies you like: ")
movie1 = input("First movie: ")
movie1 = F.check_movie(movie1, cursor)
movie2 = input("Second movie: ")
movie2 = F.many_movies(movie2, cursor)
movie3 = input("Last movie: ")
movie3 = F.many_movies(movie3, cursor)
print('\n')
#Finn id-ið á myndunum sem eru slegnar inn
s = """
create view movieid_view as
select movieid
from movies
where title in ( '%s', '%s', '%s')""" % (movie1, movie2, movie3)
cursor.execute(s)
