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