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