I'm trying to filter a selection from one table by looking up a
referenced value in another table. An example is probably the easiest
explanation:
----
class DocumentType (SQLObject) :
""" What type the document is assigned to.
"""
dbType = StringCol()
class Document (SQLObject) :
""" Location of stored documents
"""
dbPath = StringCol()
dbDocumentType = ForeignKey('DocumentType')
def DocumentSearch(text, type=None):
# initial query with text
docs = dbase.dbase.SVNDocument.select(...)
if type:
docs.filter(...)
return list(docs)
----
The "docs.filter(...): is where I want to allow only those Documents
whose dbDocumentType refers to the DocumentType with dbType == type. I
know this must be simple, but it's been a while since I used SQLObject
and I just can't see it.
Cheers,
Jason
------------------------------------------------------------------------------
The ultimate all-in-one performance toolkit: Intel(R) Parallel Studio XE:
Pinpoint memory and threading errors before they happen.
Find and fix more than 250 security defects in the development cycle.
Locate bottlenecks in serial and parallel code that limit performance.
http://p.sf.net/sfu/intel-dev2devfeb
_______________________________________________
sqlobject-discuss mailing list
sqlobject-discuss@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
