def build_query():
qb = QueryBuilder()
start = datetime.strptime("2015-11-17 00:00:00", "%Y-%m-%d %H:%M:%S")
end = datetime.strptime("2015-11-20 23:59:59", "%Y-%m-%d %H:%M:%S")
qb.between(start, end)
qb.orderbydesc("sys_created_on")
return qb.return_query
def test_order_by(self):
# sysparm_query=active=true^ORDERBYnumber^ORDERBYDESCcategory
#
# xxxmockrefactor
# this test needs refactoring: its just checking mock data
# but service now server-side responds with the data correctly (the orderby query).
qb = QueryBuilder()
qb.orderby('sys_created_on')
lst = self.client.list("original_table", sysparm_limit=5,sysparm_query=qb.return_query)
# fixme this is a moot assertion, because I'm not actually comparing it with the limit
# oh well this whole sanbox thing is kind of moot really.
assert(lst[0].sys_created_on < lst[-1].sys_created_on)
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_order_by(self):
# sysparm_query=active=true^ORDERBYnumber^ORDERBYDESCcategory
#
# xxxmockrefactor
# this test needs refactoring: its just checking mock data
# but service now server-side responds with the data correctly (the orderby query).
qb = QueryBuilder()
qb.orderby('sys_created_on')
lst = self.client.list("original_table",
sysparm_limit=5,
sysparm_query=qb.return_query)
# fixme this is a moot assertion, because I'm not actually comparing it with the limit
# oh well this whole sanbox thing is kind of moot really.
assert (lst[0].sys_created_on < lst[-1].sys_created_on)
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 build_query():
qb = QueryBuilder()
start = datetime.strptime('2015-11-17 00:00:00', "%Y-%m-%d %H:%M:%S")
end = datetime.strptime('2015-11-20 23:59:59', "%Y-%m-%d %H:%M:%S")
qb.between(start, end)
qb.orderbydesc("sys_created_on")
return qb.return_query
