Method test_empty_scalars

test/ext/test_associationproxy.py:1225–1270

(self)

    @testing.provide_metadata
    def test_empty_scalars(self):
        metadata = self.metadata

        a = Table(
            "a",
            metadata,
            Column("id", Integer, primary_key=True),
            Column("name", String(50)),
        )
        a2b = Table(
            "a2b",
            metadata,
            Column("id", Integer, primary_key=True),
            Column("id_a", Integer, ForeignKey("a.id")),
            Column("id_b", Integer, ForeignKey("b.id")),
            Column("name", String(50)),
        )
        b = Table(
            "b",
            metadata,
            Column("id", Integer, primary_key=True),
            Column("name", String(50)),
        )

        class A:
            a2b_name = association_proxy("a2b_single", "name")
            b_single = association_proxy("a2b_single", "b")

        class A2B:
            pass

        class B:
            pass

        self.mapper_registry.map_imperatively(
            A, a, properties=dict(a2b_single=relationship(A2B, uselist=False))
        )

        self.mapper_registry.map_imperatively(
            A2B, a2b, properties=dict(b=relationship(B))
        )
        self.mapper_registry.map_imperatively(B, b)

        a1 = A()
        assert a1.a2b_name is None
        assert a1.b_single is None

    def test_custom_getset(self):
        metadata = MetaData()