← Back to branch summary

~j5-dev/+junk/sqlalchemy-0.6.1

« back to all changes in this revision

Viewing changes to test/orm/lazy_relations.py

  • Committer: Bazaar Package Importer
  • Author(s): Piotr Ożarowski
  • Date: 2009-05-27 19:31:25 UTC
  • mfrom: (1.1.19 upstream) (6.1.6 squeeze)
  • Revision ID: james.westby@ubuntu.com-20090527193125-el85evabz23xjhud
Tags: 0.5.4p2-1
New upstream release

Show diffs side-by-side

added added

removed removed

Lines of Context:
test/orm/lazy_relations.py
174
174
        assert [User(id=7, address=Address(id=1))] == l
175
175
 
176
176
    @testing.resolve_artifact_names
 
177
    def test_many_to_one_binds(self):
 
178
        mapper(Address, addresses, primary_key=[addresses.c.user_id, addresses.c.email_address])
 
179
        
 
180
        mapper(User, users, properties = dict(
 
181
            address = relation(Address, uselist=False,
 
182
                primaryjoin=sa.and_(users.c.id==addresses.c.user_id, addresses.c.email_address=='ed@bettyboop.com')
 
183
            )
 
184
        ))
 
185
        q = create_session().query(User)
 
186
        eq_(
 
187
            [
 
188
                User(id=7, address=None),
 
189
                User(id=8, address=Address(id=3)),
 
190
                User(id=9, address=None),
 
191
                User(id=10, address=None),
 
192
            ], 
 
193
            list(q)
 
194
        )
 
195
        
 
196
 
 
197
    @testing.resolve_artifact_names
177
198
    def test_double(self):
178
199
        """tests lazy loading with two relations simulatneously, from the same table, using aliases.  """
179
200