def test_one_and_many(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)

        mapper(User, users, properties={
            'orders': relationship(Order, lazy='joined', order_by=orders.c.id)
        })
        mapper(Item, items)
        mapper(Order, orders, properties=dict(
            items=relationship(
                Item,
                secondary=order_items,
                lazy='joined',
                order_by=items.c.id)
        ))

        q = create_session().query(User)

        l = q.filter(text("users.id in (7, 8, 9)")).order_by(text("users.id"))

        def go():
            eq_(self.static.user_order_result[0:3], l.all())
        self.assert_sql_count(testing.db, go, 1)
Job class for building catkin packages
dataset/ETHPy150Open zzzeek/sqlalchemy/test/orm/test_eager_relations.py/EagerTest.test_one_and_many--crossover with--dataset/ETHPy150Open catkin/catkin_tools/catkin_tools/jobs/catkin.py/create_catkin_build_job