def hourly_download(request):
form = TimeSeriesFilterForm(request.GET)
if form.is_valid():
gages = form.cleaned_data["site_list"]
_logger.info("hourly csv download, gages is %s" % (gages))
beginDate = form.cleaned_data["timeseries_start"]
endDate = form.cleaned_data["timeseries_end"]
station_dict = stage_queries.station_dict(gages)
beginDate = form.cleaned_data["timeseries_start"]
endDate = form.cleaned_data["timeseries_end"]
q, dt = stage_queries.hourly_query(*station_dict.values())
if beginDate:
q = q.where(dt >= beginDate)
if endDate:
q = q.where(dt <= endDate)
data = q.execute()
# data_type = 'Hourly Water Level, NAVD88(ft)' # hard coded for now... maybe this could be in the form where the user's can selected between hourly and daily data
query_metadata_list = create_metadata_header(
HEADER_MESSAGE, EDEN_CONTACT, END_OF_HEADER, form.cleaned_data, station_dict.values()
)
response = HttpResponse(content_type="text/csv")
stage_data.write_rdb(data, response, metadata=query_metadata_list)
return response
else:
return HttpResponseBadRequest(",".join(form.errors))
def hourly_download(request):
form = TimeSeriesFilterForm(request.GET)
if (form.is_valid()):
gages = form.cleaned_data['site_list']
_logger.info("hourly csv download, gages is %s" % (gages))
beginDate = form.cleaned_data["timeseries_start"]
endDate = form.cleaned_data["timeseries_end"]
station_dict = stage_queries.station_dict(gages)
beginDate = form.cleaned_data["timeseries_start"]
endDate = form.cleaned_data["timeseries_end"]
q, dt = stage_queries.hourly_query(*station_dict.values())
if beginDate:
q = q.where(dt >= beginDate)
if endDate:
q = q.where(dt <= endDate)
data = q.execute()
# data_type = 'Hourly Water Level, NAVD88(ft)' # hard coded for now... maybe this could be in the form where the user's can selected between hourly and daily data
query_metadata_list = create_metadata_header(HEADER_MESSAGE, EDEN_CONTACT, END_OF_HEADER, form.cleaned_data, station_dict.values())
response = HttpResponse(content_type='text/csv')
stage_data.write_rdb(data, response, metadata=query_metadata_list)
return response
else:
return HttpResponseBadRequest(",".join(form.errors))
def test_hourly_navd_88(self):
s = stations[0]
gage = s.station_name_web
s.id = None
s.stationdatum.convert_to_navd88_feet = 200
q, _ = station_data.hourly_query(s)
rs = q.execute()
for r in rs:
v = r[gage]
if v is not None:
self.assertGreater(v, 100, "navd 88 correction, got " + str(v))
def test_hourly_navd_88(self):
s = stations[0]
gage = s.station_name_web
s.id = None
s.stationdatum.convert_to_navd88_feet = 200
q, _ = station_data.hourly_query(s)
rs = q.execute()
for r in rs:
v = r[gage]
if v is not None:
self.assertGreater(v, 100, "navd 88 correction, got " + str(v))
def test_hourly(self):
q, dt = station_data.hourly_query(*stations)
q = q.where(dt >= '2003-07-20')
self.check(q, ['G-3567', '2A300'], ['G-3567 flag', '2A300 flag'])
def test_hourly(self):
q, dt = station_data.hourly_query(*stations)
q = q.where(dt >= '2003-07-20')
self.check(q, ['G-3567', '2A300'], ['G-3567 flag', '2A300 flag'])
