def create_movie(movie, studio, boxOffice, director, actor, genre): query = """INSERT INTO movies VALUES (?, ?, ?, ?, ?), SELECT (SELECT studioId FROM studios WHERE studioName=(?)), SELECT (SELECT boxofficeId FROM box_offices WHERE gross=(?)), SELECT (SELECT directorsId FROM directors WHERE Name=(?)), SELECT (SELECT actorsId FROM actors WHERE name=(?)), SELECT (SELECT genresId FROM genres WHERE name=(?)) """ params = (movie.moviesId, movie.movie_name, movie.release_date, movie.rating, movie.genre, studio.studioId, studio.studioName, boxOffice.boxofficeId, boxOffice.gross, director.directorsId, director.Name, actor.actorsId, actor.name, genre.genresId, genre.name) query_database(query, params)
from database.database import create_table_database, query_database from entities.genre import Genre def create_genres_table(): query = """CREATE TABLE IF NOT EXISTS genres ( genresId INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT)""" create_table_database(query) def create_movies_genres_table(): query = """CREATE TABLE IF NOT EXISTS movies_genres ( movies_genres_Id INTEGER PRIMARY KEY AUTOINCREMENT, genresId int, moviesId int, FOREIGN KEY (genresId) REFERENCES genres(genresId), FOREIGN KEY (moviesId) REFERENCES movies(moviesId))""" create_table_database(query) create_genres_table() create_movies_genres_table() query_database("PRAGMA table_info(genres)") query_database("PRAGMA table_info(movies_genres)")
def get_movie(Movie): query = """SELECT * FROM movies WHERE moviesId = (?) OR movie_name = (?) OR release_date = (?) OR rating = (?) OR genre = (?) OR studioId = (?) OR boxofficeId = (?)""" params = (Movie.moviesId, Movie.movie_name, Movie.release_date, Movie.rating, Movie.genre, Movie.studioId, Movie.boxofficeId) query_database(query, params, True)
def create_movie(Movie): query = """INSERT INTO movies VALUES (?, ?, ?, ? ,? ,?, ?)""" params = (Movie.moviesId, Movie.movie_name, Movie.release_date, Movie.rating, Movie.genre, Movie.studioId, Movie.boxofficeId) query_database(query, params)
def get_box_offices_table(): query = "SELECT * FROM box_offices" query_database(query)
def update_actors_table(actor): query = "UPDATE actors SET name = ? WHERE actorsId = ?" params = (actor.name, actor.actorsId) query_database(query, params)
def insert_actors_movies(name, movie_name): query = """INSERT INTO actors_movies (actorsId, moviesId) SELECT(SELECT actorsId FROM actors WHERE name=?), (SELECT moviesId FROM movies WHERE movie_name=?)""" params = (name, movie_name) query_database(query, params)
def get_actors(Actor): query = """SELECT * FROM actors WHERE actorsId = (?) OR name = (?)""" params = (Actor.actorsId, Actor.name) query_database(query, params, True)
def update_directors_table(director): query = "UPDATE director SET Name = ? WHERE directorsId = ?" params = (director.Name, director.directorsId) query_database(query, params)
def insert_directors_movies(Name, movie_name): query = """INSERT INTO directors_movies (directorsId, moviesId) SELECT(SELECT directorsId FROM directors WHERE Name=?), (SELECT moviesId FROM movies WHERE movie_name=?)""" params = (Name, movie_name) query_database(query, params)
def get_directors_table(): query = "SELECT * FROM directors" query_database(query)
def insert_into_directors_table(directors): # funkcija laukianti parametro query = """INSERT INTO directors (directorsId, Name) VALUES(?, ?)""" params = (directors.directorsId, directors.Name ) # paduodu funkcijos laukiamo parametro reiksmes query_database(query, params)
def delete_box_offices_table(boxofficeId): query = "DELETE FROM box_offices WHERE boxofficeId = ?" params = (boxofficeId, ) #python tuple, jei be skliaustu ir kablelio, butu variable query_database(query, params)
def update_box_offices_table(boxoffices): query = "UPDATE box_offices SET gross = ? WHERE boxofficeId = ?" params = (boxoffices.gross, boxoffices.boxofficeId) query_database(query, params)
from database.database import create_table_database, query_database def create_actors_table(): query = """CREATE TABLE IF NOT EXISTS actors ( actorsId INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT)""" create_table_database(query) def create_actors_movies_table(): query = """CREATE TABLE IF NOT EXISTS actors_movies ( actors_movies_Id INTEGER PRIMARY KEY AUTOINCREMENT, actorsId INTEGER, moviesId INTEGER, FOREIGN KEY (actorsId) REFERENCES actors(actorsId), FOREIGN KEY (moviesId) REFERENCES movies(moviesId))""" create_table_database(query) create_actors_table() create_actors_movies_table() query_database("PRAGMA table info(movies)")
def insert_intoStudio_table(studio): # funkcija laukianti parametro query = """INSERT INTO studios (studioId, studioName) VALUES(?, ?)""" params = (studio.studioId, studio.studioName ) # paduodu funkcijos laukiamo parametro reiksmes query_database(query, params)
def create_actor(Actor): query = """INSERT INTO actors VALUES (?, ?)""" params = (Actor.actorsId, Actor.name) query_database(query, params, True)
def get_studio_table(): query = "SELECT * FROM studios" query_database(query)
def insert_into_actors_table(actor): # funkcija laukianti parametro query = """INSERT INTO actors (actorsId, name) VALUES(?, ?)""" params = (actor.actorsId, actor.name ) # paduodu funkcijos laukiamo parametro reiksmes query_database(query, params)
def update_studio_table(studio): query = "UPDATE studios SET studioName = ? WHERE studioId = ?" params = (studio.studioName, studio.studioId) query_database(query, params)
def get_actors_movies_table(): query = "SELECT * FROM actors_movies" query_database(query)
def delete_studio_table(studioId): query = "DELETE FROM studios WHERE studioId = ?" params = (studioId, ) #python tuple, jei be skliaustu ir kablelio, butu variable query_database(query, params)
def delete_actors_table(actorsId): query = "DELETE FROM actors WHERE actorsId = ?" params = (actorsId, ) # python tuple, jei be skliaustu ir kablelio, butu variable query_database(query, params)
def insert_into_box_offices_table(boxoffices): # funkcija laukianti parametro query = """INSERT INTO box_offices (boxofficeId, gross) VALUES(?, ?)""" params = (boxoffices.boxofficeId, boxoffices.gross ) # paduodu funkcijos laukiamo parametro reiksmes query_database(query, params)