def create_actors_movies_table():
query = """CREATE TABLE IF NOT EXISTS actors_movies (
actors_movies_Id INTEGER PRIMARY KEY AUTOINCREMENT,
actorsId int,
moviesId int,
FOREIGN KEY (actorsId) REFERENCES actors(actorsId),
FOREIGN KEY (moviesId) REFERENCES movies(moviesId))"""
create_table_database(query)
def create_genres_movies_table():
query = """CREATE TABLE IF NOT EXISTS genres (
Id INTEGER PRIMARY KEY AUTOINCREMENT,
genresId INTEGER,
FOREIGN KEY (genresId) REFERENCES genres(genresId),
moviesId INTEGER,
FOREIGN KEY (moviesId) REFERENCES movies(moviesId)))"""
create_table_database(query)
def create_directors_movie_table():
query = """CREATE TABLE IF NOT EXISTS directors (
Id INTEGER PRIMARY KEY AUTOINCREMENT,
moviesId INTEGER,
FOREIGN KEY (moviesId) REFERENCES movies(moviesId),
directorsId INTEGER
FOREIGN KEY (directorsId) REFERENCES directors(directorsId))"""
create_table_database(query)
def create_directors_movies_table():
query = """CREATE TABLE IF NOT EXISTS actors_movies (
director_movie_id INTEGER PRIMARY KEY AUTOINCREMENT,
director_id int,
movie_id int,
movie_id FOREIGN KEY (movie_id) REFERENCES actors(movie_id),
director_id FOREIGN KEY (director_id) REFERENCES actors(director_id)"""
create_table_database(query)
def create_movies_table():
query = """CREATE TABLE IF NOT EXISTS movies(
movie_id INTEGER PRIMARY KEY AUTOINCREMENT,
movie_name TEXT UNIQUE,
release_date DATE,
rating REAL,
genre TEXT
)"""
create_table_database(query)
def create_movies_table():
query = """CREATE TABLE IF NOT EXISTS movies (
moviesId INTEGER PRIMARY KEY AUTOINCREMENT,
movie_name TEXT,
release_date DATE,
rating REAL,
genre TEXT,
studioId INTEGER,
boxofficeId INTEGER,
FOREIGN KEY (studioId) REFERENCES studios(studioId),
FOREIGN KEY (boxofficeId) REFERENCES box_offices(boxofficeId))"""
create_table_database(query)
def create_actors_table():
query = """CREATE TABLE IF NOT EXISTS actors (
actorsId INTEGER PRIMARY KEY AUTOINCREMENT,
name TEXT)"""
create_table_database(query)
def create_box_offices_table():
query = """CREATE TABLE IF NOT EXISTS box_offices (
box_office_id INTEGER PRIMARY KEY AUTOINCREMENT,
box_office_gross TEXT)"""
create_table_database(query)
def create_genres_table():
query = """CREATE TABLE IF NOT EXISTS genres (
genre_id INTEGER PRIMARY KEY AUTOINCREMENT,
name TEXT)"""
create_table_database(query)
def create_movies_genres_table():
query = """CREATE TABLE IF NOT EXISTS movie_genres (
genre_movie_id INTEGER PRIMARY KEY AUTOINCREMENT,
genre_id FOREIGN KEY (genre_id) REFERENCES actors(genre_id),
movie_id FOREIGN KEY (movie_id) REFERENCES actors(movie_id)"""
create_table_database(query)
def create_studios_table():
query = """CREATE TABLE IF NOT EXISTS studios (
studio_id INTEGER PRIMARY KEY AUTOINCREMENT,
studio_name TEXT)"""
create_table_database(query)
