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):
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("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, 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"})