Hi all !

I can not create sqlbuilder queries on foreign key fields for inherited tables. Attached there is a patch for the test suite explaing how the problem happens.

The problem is that we don't have a sqlmeta.columns key entry in the inherited table for that field defined in the parent.

--

Evandro Vale Miquelito : [EMAIL PROTECTED]
Async Open Source - Brazil | http://www.async.com.br
Index: inheritance/tests/test_deep_inheritance.py
===================================================================
--- inheritance/tests/test_deep_inheritance.py	(revision 1472)
+++ inheritance/tests/test_deep_inheritance.py	(working copy)
@@ -34,6 +34,10 @@
 
     employees = list(DIEmployee.select())
     assert len(employees) == 2
+    
+    query = DIEmployee.q.managerID == manager.id
+    assert DIEmployee.select(query).count() == 1
+    
 
     persons = list(DIPerson.select())
     assert len(persons) == 3

Reply via email to