[SQL-CVS] r4549 - SQLObject/branches/1.2/sqlobject/tests

[<sub...@co...>]

Author: phd
Date: Sat Oct  6 09:26:59 2012
New Revision: 4549

Log:
Neil Muller fixed the order.

Modified:
   SQLObject/branches/1.2/sqlobject/tests/test_sqlbuilder_joins_instances.py

Modified: SQLObject/branches/1.2/sqlobject/tests/test_sqlbuilder_joins_instances.py
==============================================================================
--- SQLObject/branches/1.2/sqlobject/tests/test_sqlbuilder_joins_instances.py	Sat Oct  6 09:24:46 2012	(r4548)
+++ SQLObject/branches/1.2/sqlobject/tests/test_sqlbuilder_joins_instances.py	Sat Oct  6 09:26:59 2012	(r4549)
@@ -33,8 +33,9 @@
     assert list(SBPerson.select(AND(SBPerson.q.id==SBAddress.q.personID, SBAddress.q.city=='London'))) == \
            list(SBAddress.selectBy(city='London').throughTo.person)
 
-    assert list(SBAddress.select(AND(SBPerson.q.id==SBAddress.q.personID, SBPerson.q.name=='Julia'))) == \
-           list(SBPerson.selectBy(name='Julia').throughTo.addresses)
+
+    assert list(SBAddress.select(AND(SBPerson.q.id==SBAddress.q.personID, SBPerson.q.name=='Julia')).orderBy(SBAddress.q.city)) == \
+           list(SBPerson.selectBy(name='Julia').throughTo.addresses.orderBy(SBAddress.q.city))
 
 def testRelatedJoin():
     assert list(SBPerson.selectBy(name='Julia').throughTo.sharedAddresses) == \
@@ -53,9 +54,9 @@
            list(SBPerson.select(SBPerson.q.name=='Julia').throughTo.sharedAddresses)
 
 def testJoin2():
-    assert list(SBAddress.select(AND(SBPerson.j.addresses, SBPerson.q.name=='Julia'))) == \
-            list(SBAddress.select(AND(SBPerson.q.id==SBAddress.q.personID, SBPerson.q.name=='Julia'))) == \
-            list(SBPerson.selectBy(name='Julia').throughTo.addresses)
+    assert list(SBAddress.select(AND(SBPerson.j.addresses, SBPerson.q.name=='Julia')).orderBy(SBAddress.q.city)) == \
+            list(SBAddress.select(AND(SBPerson.q.id==SBAddress.q.personID, SBPerson.q.name=='Julia')).orderBy(SBAddress.q.city)) == \
+            list(SBPerson.selectBy(name='Julia').throughTo.addresses.orderBy(SBAddress.q.city))
 
 def testFK2():
     assert list(SBAddress.select(AND(SBAddress.j.person, SBPerson.q.name=='Julia'))) == \