def _computed_dates(self, actual_startdate, actual_enddate):
filter = ReportFilter(compare_as_string=False,
field=u'submission_date',
slug=u'submitted_on',
type=u'date',
required=False)
value = DateSpan(actual_startdate, actual_enddate)
filter_value = DateFilterValue(filter, value)
computed_values = filter_value.to_sql_values()
startdate = computed_values['%s_startdate' % filter.slug]
enddate = computed_values['%s_enddate' % filter.slug]
return startdate, enddate
def _computed_dates(self, actual_startdate, actual_enddate):
filter = {
'compare_as_string': False,
'field': 'submission_date',
'slug': 'submitted_on',
'type': 'date',
'required': False
}
value = DateSpan(actual_startdate, actual_enddate)
filter_value = DateFilterValue(filter, value)
computed_values = filter_value.to_sql_values()
startdate = computed_values['%s_startdate' % filter['slug']]
enddate = computed_values['%s_enddate' % filter['slug']]
return startdate, enddate
def _computed_dates(self, actual_startdate, actual_enddate):
filter = ReportFilter(
compare_as_string=False,
field=u'submission_date',
slug=u'submitted_on',
type=u'date',
required=False
)
value = DateSpan(actual_startdate, actual_enddate)
filter_value = DateFilterValue(filter, value)
computed_values = filter_value.to_sql_values()
startdate = computed_values['%s_startdate' % filter.slug]
enddate = computed_values['%s_enddate' % filter.slug]
return startdate, enddate
def _computed_dates(self, actual_startdate, actual_enddate):
filter = {
'compare_as_string': False,
'field': 'submission_date',
'slug': 'submitted_on',
'type': 'date',
'required': False
}
value = DateSpan(actual_startdate, actual_enddate)
filter_value = DateFilterValue(filter, value)
computed_values = filter_value.to_sql_values()
startdate = computed_values['%s_startdate' % filter['slug']]
enddate = computed_values['%s_enddate' % filter['slug']]
return startdate, enddate
def test_dates_use_iso_formatting(self):
spec = {
'slug': 'opened_on',
'type': 'date',
'compare_as_string': True,
}
start = datetime(year=2021, month=1, day=5)
end = datetime(year=2021, month=1, day=5, hour=7)
value = DateSpan(inclusive=False, startdate=start, enddate=end)
filter_value = DateFilterValue(spec, value)
sql_values = filter_value.to_sql_values()
self.assertEqual(sql_values['opened_on_startdate'],
'2021-01-05T00:00:00')
self.assertEqual(sql_values['opened_on_enddate'],
'2021-01-05T07:00:00')
