def testStoredOperationsQueryStringOneDay(self):
date = datetime.datetime(2014, 1, 16)
query_str = GceZoneOperationsInput._StoredOperationsQueryString(
'ds', 'tb', 'zn', date, 1)
self.assertEqual('SELECT id, insertTime FROM [ds.tb] WHERE '
'zoneName = \'zn\' AND DATE(insertTime) = \'2014-01-16\' '
'ORDER BY insertTime DESC', query_str)
def testStoredOperationsQueryStringOneDay(self):
date = datetime.datetime(2014, 1, 16)
query_str = GceZoneOperationsInput._StoredOperationsQueryString("ds", "tb", "zn", date, 1)
self.assertEqual(
"SELECT id, insertTime FROM [ds.tb] WHERE "
"zoneName = 'zn' AND DATE(insertTime) = '2014-01-16' "
"ORDER BY insertTime DESC",
query_str,
)
def testValidateBigQueryIdBadId(self):
test_input = GceZoneOperationsInput({})
self.assertRaises(ValueError, test_input.ValidateBigQueryId, 'table$id')
self.assertRaises(ValueError, test_input.ValidateBigQueryId, '123-table')
self.assertRaises(ValueError, test_input.ValidateBigQueryId, '123:table')
self.assertRaises(ValueError, test_input.ValidateBigQueryId, '')
def testValidateBigQueryId(self):
test_input = GceZoneOperationsInput({})
# If valid, function did not raise an exception and return None.
self.assertIsNone(test_input.ValidateBigQueryId('table'))
self.assertIsNone(test_input.ValidateBigQueryId('test_table'))
self.assertIsNone(test_input.ValidateBigQueryId('test_table_1'))
def testListZoneOperationsFilterThreeDays(self):
date = datetime.datetime(2014, 1, 16)
filter_str = GceZoneOperationsInput._ListZoneOperationsFilter(
date, num_days=3)
self.assertEqual('insertTime eq 2014-01-16.*|2014-01-15.*|2014-01-14.*',
filter_str)
def testListZoneOperationsFilterThreeDays(self):
date = datetime.datetime(2014, 1, 16)
filter_str = GceZoneOperationsInput._ListZoneOperationsFilter(date, num_days=3)
self.assertEqual("insertTime eq 2014-01-16.*|2014-01-15.*|2014-01-14.*", filter_str)