def get_serie(file, idserie):
connection, cursor = connection_dao.get_connection(file)
query = f"SELECT * FROM isdb.serie WHERE idserie = '{idserie}'"
cursor.execute(query)
data = cursor.fetchone()
serie = serie_model.Serie(idserie, data[1], data[2], data[3], data[4],
data[5])
connection.close()
return serie
def buscaSerie(file, palavraChave):
connection, cursor = connection_dao.get_connection(file)
query = f"SELECT * FROM isdb.serie WHERE upper(nome) like upper('%{palavraChave}%') or upper(sinopse) like upper('%{palavraChave}%');"
cursor.execute(query)
data = cursor.fetchall()
series = []
for srt in data:
sr = serie_model.Serie(srt[0], srt[1], srt[2], srt[3], srt[4], srt[5])
series.append(sr)
# connection.close()
return series
def get_series(file):
connection, cursor = connection_dao.get_connection(file)
query = f"SELECT * FROM isdb.serie order by nome asc"
cursor.execute(query)
data = cursor.fetchall()
series = []
for srt in data:
sr = serie_model.Serie(srt[0], srt[1], srt[2], srt[3], srt[4], srt[5])
series.append(sr)
# connection.close()
return series
def get_seriesAleatoria(file):
connection, cursor = connection_dao.get_connection(file)
query = f"SELECT * FROM isdb.serie ORDER BY RAND() LIMIT 18;"
cursor.execute(query)
data = cursor.fetchall()
series = []
for serie in data:
sr = serie_model.Serie(serie[0], serie[1], serie[2], serie[3],
serie[4], serie[5])
series.append(sr)
#connection.close()
return series