def test_against_select(self):

        users, items, order_items, orders, Item, User, Order = (
            self.tables.users,
            self.tables.items,
            self.tables.order_items,
            self.tables.orders,
            self.classes.Item,
            self.classes.User,
            self.classes.Order)

        s = sa.select([orders], orders.c.isopen == 1).alias('openorders')

        mapper(Order, s, properties={
            'user': relationship(User, lazy='joined')
        })
        mapper(User, users)
        mapper(Item, items)

        q = create_session().query(Order)
        eq_([
            Order(id=3, user=User(id=7)),
            Order(id=4, user=User(id=9))
            ], q.all())

        q = q.select_from(s.join(order_items).join(items)).filter(
            ~Item.id.in_([1, 2, 5]))
        eq_([
            Order(id=3, user=User(id=7)),
            ], q.all())
Create a command to return the name of the bridge with the interface
dataset/ETHPy150Open zzzeek/sqlalchemy/test/orm/test_eager_relations.py/EagerTest.test_against_select--crossover with--dataset/ETHPy150Open openstack/neutron/neutron/agent/ovsdb/api.py/API.iface_to_br