Method test_basic_w_new_style

test/orm/test_deferred.py:100–139

sanity check that mapped_column(deferred=True) works

(self)

        )

    def test_basic_w_new_style(self):
        """sanity check that mapped_column(deferred=True) works"""

        class Base(DeclarativeBase):
            pass

        class Order(Base):
            __tablename__ = "orders"

            id: Mapped[int] = mapped_column(primary_key=True)
            user_id: Mapped[int]
            address_id: Mapped[int]
            isopen: Mapped[bool]
            description: Mapped[str] = mapped_column(deferred=True)

        q = fixture_session().query(Order).order_by(Order.id)

        def go():
            result = q.all()
            o2 = result[2]
            o2.description

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

    @testing.combinations(True, False, None, argnames="deferred_parameter")
    def test_group_defer_newstyle(self, deferred_parameter: Union[bool, None]):