def delete_box_office(box_office_id):
query = "DELETE FROM box_offices WHERE box_office_id = (?)"
params = (box_office_id)
insert_query(query, params)
#create_box_office(box_office1)
#get_box_office(box_office1)
#update_box_office(box_office1)
#delete_box_office(box_office1)
def delete_studio(studio):
query = "DELETE FROM studios WHERE studio_id = (?) OR studio_name = (?)"
params = (studio.studio_id, studio.studio_name)
insert_query(query, params)
# create_studio(studio2)
# get_studio(studio2)
# update_studio(studio2)
# delete_studio(studio2)
def update_genre(genre):
query = "UPDATE genres SET name = 'Comedy' WHERE name = (?)"
params = (genre.name, )
insert_query(query, params)
def create_genre(genre):
query = "INSERT INTO genres VALUES (? ,?)"
params = (genre.genre_id, genre.name)
insert_query(query, params)
def delete_movie(movie):
query = "DELETE FROM movies WHERE movie_id = (?) OR movie_name = (?) OR release_date = (?) OR rating = " \
"(?) OR genre = (?)"
params = (movie.movie_id, movie.movie_name, movie.release_date,
movie.rating, movie.genre)
insert_query(query, params)
def update_movie(movie):
query = "UPDATE movies SET movie_name = 'Harry Potter' WHERE movie_name = (?)"
params = (movie.movie_name, )
insert_query(query, params)
def update_actor(actor):
query = "UPDATE actors SET actor_name = 'Bet kas' WHERE actor_name = (?)"
params = (actor.actor_name, )
insert_query(query, params)
def update_box_office(box_office):
query = "UPDATE box_offices SET box_office_gross = (?) WHERE box_office_id = (?)"
params = (box_office.box_office_id, box_office.box_office_gross)
insert_query(query, params)
def delete_box_office(box_office):
query = "DELETE FROM box_offices WHERE box_office_id = ?"
params = (box_office.box_office_id)
insert_query(query, params)
def update_director(director):
query = "UPDATE directors SET name = 'johnAS' WHERE name = (?)"
params = (director.name, )
insert_query(query, params)
def create_director(director):
query = "INSERT INTO directors VALUES (? ,?)"
params = (director.director_id, director.name)
insert_query(query, params)
def update_studio(studio):
query = "UPDATE studios SET studio_name = 'Picture' WHERE studio_name = (?)"
params = (studio.studio_name, )
insert_query(query, params)
def create_studio(studio):
query = "INSERT INTO studios VALUES (? ,?)"
params = (studio.studio_id, studio.studio_name)
insert_query(query, params)
def create_actor_movie(actor_name, movie_name):
query = """INSERT INTO actors_movies (actor_id, movie_id)
SELECT(SELECT actor_id FROM actors WHERE actor_name= ?),
(SELECT movie_id FROM movies WHERE movie_name= ?)"""
params = (actor_name, movie_name)
insert_query(query, params)
def delete_actor(actor):
query = "DELETE FROM actors WHERE actor_id = (?) OR actor_name = (?)"
params = (actor.actor_id, actor.actor_name)
insert_query(query, params)
def delete_genre(genre):
query = "DELETE FROM genres WHERE genre_id = (?) OR name = (?)"
params = (genre.genre_id, genre.name)
insert_query(query, params)
def create_movie_genre(name, movie_name):
query = """INSERT INTO movies_genre (genre_id, movie_id)
SELECT(SELECT genre_id FROM genres WHERE name=?),
(SELECT movie_id FROM movies WHERE movie_nmae=?)"""
params = (name, movie_name)
insert_query(query, params)
def delete_director(director):
query = "DELETE FROM directors WHERE director_id = (?) OR name = (?)"
params = (director.director_id, director.name)
insert_query(query, params)
def create_box_office(box_office):
query = "INSERT INTO box_offices VALUES (?, ?)"
params = (box_office.box_office_id, box_office.box_office_gross)
insert_query(query, params)
def create_director_movie(name, movie_name):
query = """INSERT INTO directors_movies (director_id, movie_id)
SELECT(SELECT director_id FROM directors WHERE name=?),
(SELECT movie_id FROM movies WHERE movie_name=?)"""
params = (name, movie_name)
insert_query(query, params)
def create_movie(movie):
query = "INSERT INTO movies VALUES (?, ?, ?, ?, ?)"
params = (movie.movie_id, movie.movie_name, movie.release_date,
movie.rating, movie.genre)
insert_query(query, params)
def create_actor(actor):
query = "INSERT INTO actors VALUES (? ,?)"
params = (actor.actor_id, actor.actor_name)
insert_query(query, params)
