Method test_options

test/orm/test_deferred.py:494–560

Options on a mapper to create deferred and undeferred columns

(self)

    __dialect__ = "default"

    def test_options(self):
        """Options on a mapper to create deferred and undeferred columns"""

        orders, Order = self.tables.orders, self.classes.Order

        self.mapper_registry.map_imperatively(Order, orders)

        sess = fixture_session()
        q = sess.query(Order).order_by(Order.id).options(defer(Order.user_id))

        def go():
            q.all()[0].user_id

        self.sql_eq_(
            go,
            [
                (
                    "SELECT orders.id AS orders_id, "
                    "orders.address_id AS orders_address_id, "
                    "orders.description AS orders_description, "
                    "orders.isopen AS orders_isopen "
                    "FROM orders ORDER BY orders.id",
                    {},
                ),
                (
                    "SELECT orders.user_id "
                    "FROM orders WHERE orders.id = :pk_1",
                    {"pk_1": 1},
                ),
            ],
        )
        sess.expunge_all()

        # hypothetical for 2.0 - don't overwrite conflicting user-defined
        # options, raise instead.

        # not sure if this behavior will fly with the userbase.  however,
        # it at least gives us a clear place to affirmatively resolve
        # conflicts like this if we see that we need to re-enable overwriting
        # of conflicting options.
        q2 = q.options(undefer(Order.user_id))
        with expect_raises_message(
            sa.exc.InvalidRequestError,
            r"Loader strategies for ORM Path\[Mapper\[Order\(orders\)\] -> "
            r"Order.user_id\] conflict",
        ):
            q2.all()

        q3 = (
            sess.query(Order)
            .order_by(Order.id)
            .options(undefer(Order.user_id))
        )
        self.sql_eq_(
            q3.all,
            [
                (
                    "SELECT orders.id AS orders_id, "