def _test_select(connector, uri):
# ...
__set_data(connector, uri)
# check select
_r = connector.select("animal", column_list=["category"], order_list=["category"], uri=uri)
# check select
assert _r == [u"amphibian", u"reptile"], "select found: %s" % _r
# check select
_r = connector.select("animal", column_list=["category"], order_list=["category"], order="desc", uri=uri)
# check select
assert _r == [u"reptile", u"amphibian"], "select found: %s" % _r
# check select
_r = connector.select("animal", column_list=["name"], where=and_(["name='snake'", "category='reptile'"]), uri=uri)
# check select
assert _r == [u"snake"], "select found: %s" % _r
# check select
_r = connector.select("animal", column_list=["category"], where=or_(["name='snake'", "name='frog'"]), uri=uri)
# check select
assert _r == [u"reptile", u"amphibian"], "select found: %s" % _r
# check eager_select
_generator = connector.eager_select(
"animal", column_list=["category"], where=or_(["name='snake'", "name='frog'"]), uri=uri
)
# check eager_select
_all = [_r for _c, _r in _generator]
assert _all == [u"reptile", u"amphibian"], "eager_select found: %s" % _all
def test_or(self):
_or = or_(['name = \'snake\'', 'name = \'frog\''])
# serialize
_c = _or.serialize()
# test
assert _c == 'name = \'snake\' or name = \'frog\'',\
'or_ found: %s' % _c
def test_mixed(self):
# build where clause
_and = and_(['name = \'snake\''])
_or = or_(['category = \'reptile\'', 'category = \'amphibian\''])
_mixed = and_([_and, _or])
# serialize
_c = _mixed.serialize()
# test
assert _c == '(name = \'snake\') and'\
' (category = \'reptile\' or category = \'amphibian\')',\
'or_ found: %s' % _c
