def create_movies(movie):
query = """INSERT INTO movies (movie_id, movie_title, movie_director, release_date, rating, genre, box_office_id, studio_id)
VALUES(?, ?, ?, ?, ?, ?, ?)"""
params = (movie.movie_id, movie.movie_title, movie.movie_director,
movie.release_date, movie.rating, movie.genre,
movie.box_office_id, movie.studio_id)
query_database(query, params)
def delete_actors(actor_id):
query = "DELETE FROM actors WHERE actor_id = ?"
params = (actor_id, )
query_database(query, params)
def update_actors(actor):
query = "UPDATE actors SET actor.name = ? WHERE actor_id = ?"
params = (actor.actor_name, actor.actor_id)
query_database(query, params)
def get_actors_movies():
query = "SELECT * FROM actors_movies"
query_database(query)
def insert_directors_movies(director_name, movie_title):
query = """INSERT INTO directors_movies (director_id, movie_id)
SELECT(SELECT director_id FROM directors WHERE director_name=?),
(SELECT movie_id FROM movies WHERE movie_title=?)"""
params = (director_name, movie_title)
query_database(query, params)
def update_movies(movie):
query = "UPDATE movies SET movie_title = ? WHERE movie_id = ?"
params = (movie.movie_title, movie.movie_id)
query_database(query, params)
def update_studio(studio):
query = "UPDATE studios SET studioName = ? WHERE studioId = ?"
params = (studio.studio_name, studio.studio_id)
query_database(query, params)
def update_box_office(box_office):
query = "UPDATE box_offices SET sales = ? WHERE box_office_id = ?"
params = (box_office.sales, box_office.box_office_id)
query_database(query, params)
def insert_studio(studio):
query = """INSERT INTO studios (studioId, studioName)
VALUES(?, ?)"""
params = (studio.studio_id, studio.studio_name)
query_database(query, params)
def get_studio():
query = "SELECT * FROM studio"
query_database(query)
def delete_directors(director_id):
query = "DELETE FROM directors WHERE director_id = ?"
params = (director_id,)
query_database(query, params)
def update_directors(director):
query = "UPDATE director SET director_name = ? WHERE director_id = ?"
params = (director.director_name, director.director_id)
query_database(query, params)
def get_directors():
query = "SELECT * FROM directors"
query_database(query)
def insert_box_office(box_office):
query = """INSERT INTO box_office (box_office_id, sales)
VALUES(?, ?)"""
params = (box_office.boxoffice_id, box_office.sales)
query_database(query, params)
def delete_studio(studio_id):
query = "DELETE FROM studios WHERE studio_id = ?"
params = (studio_id, )
query_database(query, params)
def get_box_office():
query = "SELECT * FROM box_office"
query_database(query)
def insert_actor(actor):
query = """INSERT INTO actors (actor_id, actor_name)
VALUES(?, ?)"""
params = (actor.actor_id, actor.actor_name)
query_database(query, params)
def delete_box_offices_table(box_office_id):
query = "DELETE FROM box_office WHERE box_office_id = ?"
params = (box_office_id, )
query_database(query, params)
def insert_actors_movies(actor_name, movie_title):
query = """INSERT INTO actors_movies (actors_id, movies_id)
SELECT(SELECT actors_id FROM actors WHERE actor_name=?),
(SELECT movies_id FROM movies WHERE movie_title=?)"""
params = (actor_name, movie_title)
query_database(query, params)
def get_movies():
query = "SELECT * FROM movies"
query_database(query)
def get_actor():
query = "SELECT * FROM actors"
query_database(query)
def delete_movies(movie_id):
query = "DELETE FROM movies WHERE movie_id = ?"
params = (movie_id)
query_database(query, params)
def insert_directors(directors):
query = """INSERT INTO directors (director_is, director_name)
VALUES(?, ?)"""
params = (directors.director_id, directors.director_name)
query_database(query, params)
