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