def test_date_range(self):
     qb = QueryBuilder()
     # snow api sucks balls https://community.servicenow.com/thread/181519
     e = "sys_created_on_ze_dateBETWEENjavascript:gs.dateGenerate('2015-04-16','00:10:00')@javascript:gs.dateGenerate('2015-04-22','12:59:59')"
     start = test_helpers.to_date('2015-04-16 00:10:00')
     end = test_helpers.to_date('2015-04-22 12:59:59')
     qb.between(start,end, "sys_created_on_ze_date")
     assert_equal(qb.return_query, e)
 def test_date_range(self):
     qb = QueryBuilder()
     # snow api sucks balls https://community.servicenow.com/thread/181519
     e = "sys_created_on_ze_dateBETWEENjavascript:gs.dateGenerate('2015-04-16','00:10:00')@javascript:gs.dateGenerate('2015-04-22','12:59:59')"
     start = test_helpers.to_date('2015-04-16 00:10:00')
     end = test_helpers.to_date('2015-04-22 12:59:59')
     qb.between(start, end, "sys_created_on_ze_date")
     assert_equal(qb.return_query, e)
 def test_list_date_range(self):
   qb = QueryBuilder()
   # xxxmockrefactor
   # this test needs refactoring: its just checking mock data
   # but service now server-side responds with the data correctly (the date query).
   start = test_helpers.to_date('2013-12-31 00:00:00')
   end = test_helpers.to_date('2014-01-01 00:00:00')
   qb.between(start, end)
   lst = self.client.list("original_table", sysparm_limit=5, sysparm_query=qb.return_query)
   # ensure they are all in the range.
   assert(all(map(lambda x, start=start: test_helpers.to_date(x.sys_created_on) > start,lst)))
   assert(all(map(lambda x, end=end: test_helpers.to_date(x.sys_created_on) < end,lst)))
 def test_list_date_range(self):
     qb = QueryBuilder()
     # xxxmockrefactor
     # this test needs refactoring: its just checking mock data
     # but service now server-side responds with the data correctly (the date query).
     start = test_helpers.to_date('2013-12-31 00:00:00')
     end = test_helpers.to_date('2014-01-01 00:00:00')
     qb.between(start, end)
     lst = self.client.list("original_table",
                            sysparm_limit=5,
                            sysparm_query=qb.return_query)
     # ensure they are all in the range.
     assert (all(
         map(lambda x, start=start: test_helpers.to_date(x.sys_created_on) >
             start,
             lst)))
     assert (all(
         map(lambda x, end=end: test_helpers.to_date(x.sys_created_on) <
             end,
             lst)))