[SQL-CVS] r777 - trunk/SQLObject/sqlobject/tests

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

Author: daverz
Date: 2005-05-07 05:38:05 +0000 (Sat, 07 May 2005)
New Revision: 777

Added:
   trunk/SQLObject/sqlobject/tests/test_NoneValuedResultItem.py
Log:
Test that query results with None IDs (e.g. some outer join cases) 
are handled correctly, i.e. return None for that object.


Added: trunk/SQLObject/sqlobject/tests/test_NoneValuedResultItem.py
===================================================================
--- trunk/SQLObject/sqlobject/tests/test_NoneValuedResultItem.py	2005-05-06 17:07:38 UTC (rev 776)
+++ trunk/SQLObject/sqlobject/tests/test_NoneValuedResultItem.py	2005-05-07 05:38:05 UTC (rev 777)
@@ -0,0 +1,28 @@
+'''Test that selectResults handle NULL values 
+from, for example, outer joins.'''
+from sqlobject import *
+from sqlobject.tests.dbtest import *
+
+class TestComposer(SQLObject):
+    name = StringCol()
+
+class TestWork(SQLObject):
+    class sqlmeta:
+        idName = "work_id"
+
+    composer = ForeignKey('TestComposer')
+    title = StringCol()
+
+def test1():
+    setupClass(TestComposer)
+    setupClass(TestWork)
+
+    c = TestComposer(name='Mahler, Gustav')
+    w = TestWork(composer=c, title='Symphony No. 9')
+    c2 = TestComposer(name='Bruckner, Anton')
+    # but don't add any works for Bruckner
+
+    # do a left join, a common use case that often involves NULL results
+    s = TestWork.select(join=sqlbuilder.LEFTJOINOn(TestComposer, TestWork, 
+	                TestComposer.q.id==TestWork.q.composerID))
+    assert tuple(s)==(w, None)