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)
