def test_date_value_with_hour_interval_is_returned_as_date_string_to_the_minute_rounded_to_hour(
self, ):
self.assertEqual(
"2019-01-01 12:00",
formats.display_value(datetime(2019, 1, 1, 12, 30, 2),
hour(date_field)),
)
def test_build_query_with_datetime_interval_hourly(self):
queries = (mock_dataset.query().widget(
f.ReactTable(mock_dataset.fields.votes)).dimension(
f.hour(mock_dataset.fields.timestamp)).sql)
self.assertEqual(len(queries), 1)
self.assertEqual(
"SELECT "
'TRUNC("timestamp",\'HH\') "$timestamp",'
'SUM("votes") "$votes" '
'FROM "politics"."politician" '
'GROUP BY "$timestamp" '
'ORDER BY "$timestamp" '
'LIMIT 200000',
str(queries[0]),
)