Method test_get_bind

test/orm/test_bind.py:262–325

(self, testcase, expected)

        ),
    )
    def test_get_bind(self, testcase, expected):
        users, Address, addresses, User = (
            self.tables.users,
            self.classes.Address,
            self.tables.addresses,
            self.classes.User,
        )
        Dingaling = self.classes.Dingaling

        self.mapper_registry.map_imperatively(
            User, users, properties={"addresses": relationship(Address)}
        )
        self.mapper_registry.map_imperatively(Address, addresses)

        users_view = table("users", Column("id", Integer, primary_key=True))
        addresses_view = table(
            "addresses",
            Column("id", Integer, primary_key=True),
            Column("user_id", Integer),
            Column("email_address", String),
        )
        j = users_view.join(
            addresses_view, users_view.c.id == addresses_view.c.user_id
        )
        self.mapper_registry.map_imperatively(
            Dingaling,
            j,
            properties={
                "user_t_id": users_view.c.id,
                "address_id": addresses_view.c.id,
            },
        )

        e1 = engines.testing_engine()
        e2 = engines.testing_engine()
        e3 = engines.testing_engine()
        e4 = engines.testing_engine()

        testcase = testing.resolve_lambda(
            testcase,
            User=User,
            Address=Address,
            Dingaling=Dingaling,
            e1=e1,
            e2=e2,
            e3=e3,
            e4=e4,
            users_view=users_view,
            addresses_view=addresses_view,
            addresses=addresses,
            users=users,
        )

        sess = Session(e3)
        sess.bind_mapper(User, e1)
        sess.bind_mapper(Address, e2)
        sess.bind_mapper(Dingaling, e4)
        sess.bind_table(users_view, e2)