def cadastraNoticia(file, noticia, foto):
connection, cursor = connection_dao.get_connection(file)
query = f"INSERT INTO isdb.netflix ( noticia, foto) VALUES ('{noticia}', '{foto}');"
cursor.execute(query)
connection.commit()
def excluiNoticia(file, idnetflix):
connection, cursor = connection_dao.get_connection(file)
query = f"DELETE FROM isdb.netflix WHERE idnetflix = '{idnetflix}'"
cursor.execute(query)
connection.commit()
def excluir_serie(file, idserie):
connection, cursor = connection_dao.get_connection(file)
query = f"DELETE FROM isdb.serie WHERE idserie = '{idserie}'"
cursor.execute(query)
connection.commit()
def delete_episode(file, id_episode):
connection, cursor = connection_dao.get_connection(file)
query = f"DELETE FROM isdb.episode WHERE id_episode = {id_episode}"
cursor.execute(query)
connection.commit()
def delete_cast_member(file, id_cast_member):
connection, cursor = connection_dao.get_connection(file)
query = f"DELETE FROM isdb.cast WHERE id_cast = {id_cast_member}"
cursor.execute(query)
connection.commit()
def cadastraAvaliacao(file, idserie, nome, avaliacao, avatar):
connection, cursor = connection_dao.get_connection(file)
query = f"INSERT INTO isdb.avaliacao (idserie, nome, avaliacao, avatar) VALUES ('{idserie}', '{nome}', '{avaliacao}', '{avatar}');"
cursor.execute(query)
connection.commit()
def excluir_ator(file, idator):
connection, cursor = connection_dao.get_connection(file)
query = f"DELET FROM isdb.ator where idator = '{idator}''"
cursor.execute(query)
connection.commit()
def delete_tv_show(file, id_tv_show):
connection, cursor = connection_dao.get_connection(file)
query = f"DELETE FROM isdb.tvshows WHERE id_tv_show = {id_tv_show}"
cursor.execute(query)
connection.commit()
def cadastra_serie(file, nome, genero, canal, sinopse, banner):
connection, cursor = connection_dao.get_connection(file)
query = f"INSERT INTO isdb.serie (nome, genero, canal, sinopse, banner) VALUES ('{nome}', '{genero}', '{canal}', '{sinopse}', '{banner}');"
cursor.execute(query)
connection.commit()
def register_tv_show(file, tv_show_name, tv_show_genre, tv_show_poster,
tv_show_description):
connection, cursor = connection_dao.get_connection(file)
query = f"INSERT INTO isdb.tvshows (name, genre, poster, description) " \
f"VALUES ('{tv_show_name}', '{tv_show_genre}', '{tv_show_poster}', '{tv_show_description}')"
cursor.execute(query)
connection.commit()
def delete_director(file, id_director):
connection, cursor = connection_dao.get_connection(file)
query = f"DELETE FROM isdb.director WHERE id_director = {id_director}"
cursor.execute(query)
connection.commit()
connection.close()
def atualizar_serie(file, idserie, nome, genero, canal, sinopse, banner):
connection, cursor = connection_dao.get_connection(file)
query = f"UPDATE isdb.serie SET nome = '{nome}', genero = '{genero}, canal = '{canal}', " \
f"sinopse = '{sinopse}', banner = '{banner}' " \
f"WHERE idserie = '{idserie}"
cursor.execute(query)
connection.commit()
def cadastrar_ator(file, nome, biografia, datanascimento, nascionalidade,
foto):
connection, cursor = connection_dao.get_connection(file)
query = f"INSERT INTO isdb.ator (nome, biografia, datanascimento, nascionalidade, foto) " \
f"VALUES ('{nome}', '{biografia}', '{datanascimento}', '{nascionalidade}', '{foto}')"
cursor.execute(query)
connection.commit()
def register_cast_member(file, cast_name, cast_date_of_birth,
cast_place_of_birth, cast_picture):
connection, cursor = connection_dao.get_connection(file)
query = f"INSERT INTO isdb.cast (name, date_of_birth, place_of_birth, picture) " \
f"VALUES ('{cast_name}', '{cast_date_of_birth}', '{cast_place_of_birth}', '{cast_picture}')"
cursor.execute(query)
connection.commit()
def register_episode(file, episode_name, episode_season,
episode_original_air_date, episode_id_tv_show):
connection, cursor = connection_dao.get_connection(file)
query = f"INSERT INTO isdb.episodes (id_tv_show, name, season, original_air_date)" \
f"VALUES ({episode_id_tv_show}, '{episode_name}', '{episode_season}', '{episode_original_air_date}')"
cursor.execute(query)
connection.commit()
def get_cadastraTrabalho(file, idator, idserie, idtemporada):
connection, cursor = connection_dao.get_connection(file)
query = f"INSERT INTO isdb.trabalhos (idator, idserie, idtemporada) " \
f"VALUES ('{idator}', '{idserie}', '{idtemporada}')"
cursor.execute(query)
connection.commit()
def atualizar_ator(file, idator, nome, datanascimento, nascionalidade, foto):
connection, cursor = connection_dao.get_connection(file)
query = f"UPDATE isdb.ator SET nome = '{nome}', datanascimento = '{datanascimento}', " \
f"nascionalidade = '{nascionalidade}', " \
f"foto) = {foto}' WHERE idator = '{idator}'"
cursor.execute(query)
connection.commit()
def get_tv_show_cast_members_ids(file, id_tv_show):
connection, cursor = connection_dao.get_connection(file)
query = f"SELECT DISTINCT (id_cast) FROM isdb.cast_tvshows WHERE id_tv_show = '{id_tv_show}'"
cursor.execute(query)
tv_show_data = cursor.fetchall()
connection.close()
return tv_show_data
def register_director(file, director_name, director_date_of_birth,
director_place_of_birth, director_picture):
connection, cursor = connection_dao.get_connection(file)
query = f"INSERT INTO isdb.director (name, date_of_birth, place_of_birth, picture)" \
f"VALUES ('{director_name}', '{director_date_of_birth}', '{director_place_of_birth}', '{director_picture}')"
cursor.execute(query)
connection.commit()
connection.close()
def get_director_tv_shows_ids(file, id_director):
connection, cursor = connection_dao.get_connection(file)
query = f"SELECT id_tv_show FROM isdb.directors_tvshow WHERE id_director = {id_director}"
cursor.execute(query)
director_data = cursor.fetchall()
connection.close()
return director_data
def get_tv_show_episodes_ids(file, id_tv_show):
connection, cursor = connection_dao.get_connection(file)
query = f"SELECT id_episode FROM isdb.episodes WHERE id_tv_show = {id_tv_show}"
cursor.execute(query)
tv_show_data = cursor.fetchall()
connection.close()
return tv_show_data
def get_episode_tv_show_id(file, id_episode):
connection, cursor = connection_dao.get_connection(file)
query = f"SELECT id_tvshow FROM isdb.cast_tvshows WHERE id_episode = {id_episode}"
cursor.execute(query)
episodes_data = cursor.fetchall()
connection.close()
return episodes_data
def get_tv_show_directors_ids(file, id_episode):
connection, cursor = connection_dao.get_connection(file)
query = f"SELECT id_director FROM isdb.directors_tvshow WHERE id_episode = {id_episode}"
cursor.execute(query)
episodes_data = cursor.fetchall()
connection.close()
return episodes_data
def get_cast_member_episodes_ids(file, id_cast):
connection, cursor = connection_dao.get_connection(file)
query = f"SELECT id_episode FROM isdb.cast_tvshows WHERE id_cast = {id_cast}"
cursor.execute(query)
cast_member_data = cursor.fetchall()
connection.close()
return cast_member_data
def register_tv_show_cast_episode(file, ids_episode, id_tv_show,
id_cast_member):
connection, cursor = connection_dao.get_connection(file)
for id_episode in ids_episode:
query = f"INSERT INTO isdb.cast_tvshows (id_tv_show, id_cast, id_episode)" \
f"VALUES ({id_tv_show}, {id_cast_member}, {id_episode})"
cursor.execute(query)
connection.commit()
connection.close()
def get_ator(file, idator):
connection, cursor = connection_dao.get_connection(file)
cursor.execute(f"SELECT * FROM isdb.ator where idator = '{idator}'")
data = cursor.fetchone()
ator = elenco_model.Ator(idator, data[1], data[2], data[3], data[4],
data[5])
return ator
def get_diretor(file, iddiretor):
connection, cursor = connection_dao.get_connection(file)
cursor.execute(
f"SELECT * FROM isdb.diretor where iddiretor = '{iddiretor}'")
data = cursor.fetchone()
diretor = diretor_model.Diretor(iddiretor, data[1], data[2], data[3],
data[4])
return diretor
def get_seasons(file, id_tv_show):
connection, cursor = connection_dao.get_connection(file)
query = f"SELECT DISTINCT (season) FROM isdb.episodes WHERE id_tv_show = '{id_tv_show}'"
cursor.execute(query)
data = cursor.fetchall()
seasons_list = [i for i, in data]
connection.close()
return seasons_list
def buscaIdSerieTemporada(file):
connection, cursor = connection_dao.get_connection(file)
query = f"SELECT distinct idserie FROM isdb.temporada;"
cursor.execute(query)
data = cursor.fetchall()
series = []
for tmp in data:
ser = idSerie_model.IdSerie(tmp[0])
series.append(ser)
return series
def get_cast_member(file, id_cast):
connection, cursor = connection_dao.get_connection(file)
query = f"SELECT name, date_of_birth, place_of_birth, picture FROM isdb.cast WHERE id_cast = '{id_cast}'"
cursor.execute(query)
data = cursor.fetchone()
cast_member = cast_model.Cast(id_cast, data[0], data[1], data[2], data[3])
connection.close()
return cast_member
