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]), )