Python hourly_query_split Exemples

Exemple #1

Fichier : data_views.py Projet : bmccloskey/EDEN-hydrograph-data

def plot_data_hourly(request):
    form = TimeSeriesFilterForm(request.GET)

    if form.is_valid():
        gages = form.cleaned_data["site_list"]
        _logger.info("plot_data, gages is %s" % (gages))

        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_split(*station_dict.values())
        if beginDate:
            q = q.where(dt >= beginDate)
        if endDate:
            q = q.where(dt <= endDate)
        data = q.execute()

        if len(gages) == 1:
            site_name = "%s_NGVD29" % gages[0]
        else:
            site_name = None

        response = HttpResponse(content_type="text/csv")
        stage_data.write_csv_for_plot(results=data, outfile=response, column_name=site_name)
        return response
    else:
        return HttpResponseBadRequest(",".join(form.errors))

Exemple #2

def plot_data_hourly(request):
    form = TimeSeriesFilterForm(request.GET)

    if form.is_valid():
        gages = form.cleaned_data['site_list']
        _logger.info("plot_data, gages is %s" % (gages))

        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_split(*station_dict.values())
        if beginDate:
            q = q.where(dt >= beginDate)
        if endDate:
            q = q.where(dt <= endDate)
        data = q.execute()

        if len(gages) == 1:
            site_name = '%s_NGVD29' % gages[0]
        else:
            site_name = None

        response = HttpResponse(content_type='text/csv')
        stage_data.write_csv_for_plot(results=data, outfile=response, column_name=site_name)
        return response
    else:
        return HttpResponseBadRequest(",".join(form.errors))

Exemple #3

Fichier : station_data_test.py Projet : ayan-usgs/EDEN-hydrograph-data

    def test_hourly_split(self):

        q, dt = station_data.hourly_query_split(*stations)
        q = q.where(dt >= '2003-07-20')
        rs = q.execute()
        rsk = rs.keys()
        for s in stations:
            web_name = s.station_name_web
            for suffix in ["", " est", " dry"]:
                self.assertIn(web_name + suffix, rsk, "expected rs to have key " + web_name + suffix)
        for r in rs:
            self.assertTrue(r, "valid result row")

Exemple #4

    def test_hourly_split(self):

        q, dt = station_data.hourly_query_split(*stations)
        q = q.where(dt >= '2003-07-20')
        rs = q.execute()
        rsk = rs.keys()
        for s in stations:
            web_name = s.station_name_web
            for suffix in ["", " est", " dry"]:
                self.assertIn(web_name + suffix, rsk,
                              "expected rs to have key " + web_name + suffix)
        for r in rs:
            self.assertTrue(r, "valid result row")

Exemple #5

Fichier : data_views.py Projet : bmccloskey/EDEN-hydrograph-data

def _hourly_plot_data(form):
    gages = form.cleaned_data["site_list"]
    _logger.info("plot_data, gages is %s" % (gages))
    station_dict = stage_queries.station_dict(gages)
    station1 = station_dict.values()[0]

    beginDate = form.cleaned_data["timeseries_start"]
    endDate = form.cleaned_data["timeseries_end"]
    q, dt = stage_queries.hourly_query_split(*station_dict.values())
    if beginDate:
        q = q.where(dt >= beginDate)
    if endDate:
        q = q.where(dt <= endDate)
    data = q.execute()
    return data, beginDate, endDate, station1

Exemple #6

def _hourly_plot_data(form):
    gages = form.cleaned_data['site_list']
    _logger.info("plot_data, gages is %s" % (gages))
    station_dict = stage_queries.station_dict(gages)
    station1 = station_dict.values()[0]

    beginDate = form.cleaned_data["timeseries_start"]
    endDate = form.cleaned_data["timeseries_end"]
    q, dt = stage_queries.hourly_query_split(*station_dict.values())
    if beginDate:
        q = q.where(dt >= beginDate)
    if endDate:
        q = q.where(dt <= endDate)
    data = q.execute()
    return data, beginDate, endDate, station1