def test_with_value(self):
query = q.Q("a", q.V("=", 1))
assert query.query == ("SELECT parent_id "
"FROM object AS o "
"JOIN value AS v "
"ON o.id = v.id "
"WHERE (o.name = 'a' "
"AND v.value = 1)")
def test_and(aggregator):
construction = ((aggregator.centre == mock.Gaussian) & (aggregator.centre.x == 0))
assert construction == q.Q(
"centre",
q.And(
q.T(mock.Gaussian),
q.Q(
"x",
q.V(
"=", 0
)
)
)
)
def test_greater_than_equals(aggregator):
assert (aggregator.centre >= 1) == q.Q("centre", q.V(">=", 1))
def test_less_than_equals(aggregator):
assert (aggregator.centre <= 1) == q.Q("centre", q.V("<=", 1))
def test_less_than(aggregator):
assert (aggregator.centre < 1) == q.Q("centre", q.V("<", 1))
def test_greater_than(aggregator):
assert (aggregator.centre > 1) == q.Q("centre", q.V(">", 1))
def test_third_level(aggregator):
assert (aggregator.lens.centre.x == 1) == q.Q("lens", q.Q("centre", q.Q("x", q.V("=", 1))))
def test_second_level(aggregator):
assert (aggregator.lens.centre == 1) == q.Q("lens", q.Q("centre", q.V("=", 1)))
def test_with_value(aggregator):
assert (aggregator.centre == 1) == q.Q("centre", q.V("=", 1))
def test_and(aggregator):
construction = ((aggregator.model.centre == af.Gaussian) &
(aggregator.model.centre.x == 0))
assert construction.query == q.Q(
"centre", q.And(q.T(af.Gaussian), q.Q("x", q.V("=", 0)))).query
def test_less_than_equals(aggregator):
assert (aggregator.model.centre <= 1).query == q.Q("centre", q.V("<=",
1)).query
def test_less_than(aggregator):
assert (aggregator.model.centre < 1).query == q.Q("centre", q.V("<",
1)).query
def test_greater_than(aggregator):
assert (aggregator.model.centre > 1).query == q.Q("centre", q.V(">",
1)).query
def test_with_value(aggregator):
assert (aggregator.model.centre == 1).query == q.Q("centre", q.V("=",
1)).query
def make_less_than():
return q.V("<", 1)
def make_greater_than():
return q.V(">", 0)
