def get(self):
try:
conectar = Connection_pg("terrama2")
data = conectar.load_data("SELECT * FROM public.dcp_series_24")
return jsonify(data.to_dict())
except:
return jsonify({'info': 'Impossivel ler os dados das pcds'})
def get(self):
try:
conectar = Connection_pg("merge_monthly")
data = conectar.load_data(
"SELECT * FROM public.an_munc_merge_yearly WHERE maxima IS NOT NULL AND media IS NOT NULL"
)
return jsonify(data.to_dict())
except:
return jsonify({'info': 'Impossivel ler acumulado anual'})
def get(self, uf):
try:
conectar = Connection_pg("chuva")
data = conectar.readFileSQL("sql/cities_by_state",
{'uf': str(uf).upper()})
print(data)
return jsonify(data.to_dict())
except:
return jsonify(
{'info': 'uf {} não existe'.format(str(uf).upper())})
def get(self, uf):
try:
conectar = Connection_pg("merge_monthly")
data = conectar.load_data(
"SELECT nome1, geocodigo FROM public.municipios_brasil WHERE uf='{}'"
.format(str(uf).upper()))
return jsonify(data.to_dict())
except:
return jsonify(
{'info': 'uf {} não existe'.format(str(uf).upper())})
def get(self, id):
try:
conectar = Connection_pg("terrama2")
data = conectar.load_data(
"SELECT table_name FROM public.dcp_series_24 WHERE id={}".
format(str(id)))
history = conectar.load_data("SELECT * FROM public.{}".format(
str(data["table_name"][0])))
return jsonify(history.to_dict())
except:
return jsonify({'info': 'pcd não encontrada'})
def get(self, geocodigo):
try:
conectar = Connection_pg("chuva")
data = conectar.readFileSQL("sql/an_merge_monthly",
{'geocodigo': str(geocodigo)})
print(data)
return jsonify(data.to_dict())
except:
return jsonify({
'info':
'Impossível ler o geocodigo {}'.format(str(geocodigo))
})
def get(self, geocodigo):
try:
conectar = Connection_pg("merge_monthly")
data = conectar.load_data(
"SELECT nome_municipio, maxima, media, mes FROM public.an_munc_merge_monthly "
+ "WHERE geocodigo='{}' ".format(str(geocodigo)) +
"AND media IS NOT NULL AND maxima IS NOT NULL")
print(data)
return jsonify(data.to_dict())
except:
return jsonify({
'info':
'Impossível ler o geocodigo {}'.format(str(geocodigo))
})
def get(self, id):
try:
conectar = Connection_pg("terrama2")
data = conectar.load_data(
"SELECT * FROM public.dcp_series_24 WHERE id={}".format(
str(id)))
pcd = {
"id": str(data["id"][0]),
"geom": data["geom"][0],
"alias": data["alias"][0],
"table_name": data["table_name"][0]
}
return jsonify(pcd)
except:
return jsonify({"alias": "não existe"})
def get(self, geocodigo, mes_inicio, ano_inicio, mes_fim, ano_fim):
try:
conectar = Connection_pg("chuva")
mes, ano = (int(mes_fim) + 1), int(ano_fim)
if mes > 12: mes, ano = 1, ano + 1
data = conectar.readFileSQL(
"sql/an_monthly_limit_date", {
"geocodigo": str(geocodigo),
"mes_inicio": str(mes_inicio),
"ano_inicio": str(ano_inicio),
"mes_fim": str(mes),
"ano_fim": str(ano)
})
print(data)
return jsonify(data.to_dict())
except:
return jsonify({
'info':
'Impossível ler o geocodigo {}'.format(str(geocodigo))
})
def get(self):
try:
conectar = Connection_pg("merge_monthly")
# data = pd.DataFrame(data = { 'uf' : list(set(conectar.load_data("SELECT uf FROM public.municipios_brasil")["uf"])) })
data = pd.DataFrame(
data={
'estado': open('states.txt', 'r').read().split('\n'),
'uf': open('states-sigla.txt', 'r').read().split('\n')
})
# states = open('states.txt', 'r').read().split('\n')
return jsonify(data.to_dict())
except:
return jsonify({'info': 'Impossível fazer a leitura'})