← Back to branch summary

~ubuntu-branches/debian/sid/sqlalchemy/sid

« back to all changes in this revision

Viewing changes to test/orm/test_subquery_relations.py

  • Committer: Bazaar Package Importer
  • Author(s): Piotr Ożarowski
  • Date: 2011-10-18 00:02:50 UTC
  • mfrom: (1.4.16 upstream)
  • Revision ID: james.westby@ubuntu.com-20111018000250-prowqcleosluapxg
Tags: 0.7.3-2
http://bugs.debian.org/645697
remove build-indep from build target's dependencies (closes: 645697)

Show diffs side-by-side

added added

removed removed

Lines of Context:
test/orm/test_subquery_relations.py
671
671
        l = q.order_by(sa.desc(User.id)).limit(2).offset(2).all()
672
672
        eq_(list(reversed(self.static.user_all_result[0:2])), l)
673
673
 
 
674
    def test_mapper_order_by(self):
 
675
        users, User, Address, addresses = (self.tables.users,
 
676
                                self.classes.User,
 
677
                                self.classes.Address,
 
678
                                self.tables.addresses)
 
679
 
 
680
        mapper(Address, addresses)
 
681
        mapper(User, users, properties={
 
682
            'addresses':relationship(Address,
 
683
                            lazy='subquery',
 
684
                            order_by=addresses.c.id),
 
685
        },order_by=users.c.id.desc())
 
686
 
 
687
        sess = create_session()
 
688
        q = sess.query(User)
 
689
 
 
690
        l = q.limit(2).all()
 
691
        eq_(l, list(reversed(self.static.user_address_result[2:4])))
 
692
 
 
693
 
674
694
    def test_one_to_many_scalar(self):
675
695
        Address, addresses, users, User = (self.classes.Address,
676
696
                                self.tables.addresses,