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