def test_query_single_dimension(self):
query = mock_dataset.latest(mock_dataset.fields.timestamp).sql[0]
self.assertEqual(
'SELECT '
'MAX("timestamp") "$timestamp" '
'FROM "politics"."politician"', str(query))
def test_query_multiple_dimensions(self):
query = mock_dataset.latest(mock_dataset.fields.timestamp, mock_dataset.fields.timestamp2) \
.sql[0]
self.assertEqual(
'SELECT '
'MAX("timestamp") "$timestamp",'
'MAX("timestamp2") "$timestamp2" '
'FROM "politics"."politician"', str(query))
def test_query_latest_value_for_timestamp_dimension_using_join(self):
query = mock_dataset.latest(mock_dataset.fields.join_timestamp).sql[0]
self.assertEqual(
'SELECT '
'MAX("voter"."timestamp") "$join_timestamp" '
'FROM "politics"."politician" '
'JOIN "politics"."voter" ON "politician"."id"="voter"."politician_id"',
str(query))