def test_where(self):
s = Search(self.Donkey, "people", self.session)
query = QueryFromStringParam(s, """ name = ? or email.email = {} """, pos_args = ["david"], named_args = {"email.email": "*****@*****.**"})
query.sa_query = s.search_base
join_tree = query.make_join_tree()
query.recurse_join_tree(join_tree)
where = query.convert_where(query.ast[0])
assert str(where.compile()) == "people.name = ? AND people.id IS NOT NULL OR email_1.email = ? AND email_1.id IS NOT NULL"
assert where.compile().params == {u'email_2': '*****@*****.**', u'name_1': 'david'}
s = Search(self.Donkey, "people", self.session)
query = QueryFromStringParam(s, """ name = ? or not (email.email < {} and donkey.name = ?) """, pos_args = ["david", "fred"], named_args = {"email.email" : "*****@*****.**"})
query.sa_query = s.search_base
join_tree = query.make_join_tree()
query.recurse_join_tree(join_tree)
where = query.convert_where(query.ast[0])
assert str(where.compile()) == "people.name = ? AND people.id IS NOT NULL OR NOT ((email_1.email < ? OR email_1.id IS NULL) AND donkey_1.name = ? AND donkey_1.id IS NOT NULL)"
assert where.compile().params == {u'name_2': 'fred', u'email_2': '*****@*****.**', u'name_1': 'david'}
assert query.covering_ors == set(["email","donkey"])
assert query.inner_joins == set(["email"])
assert query.outer_joins == set(["donkey"])
