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