Hi,
I wonder how one can use select together with MultipleJoin. The full code is
available at https://fedorahosted.org/bodhi/browser, but here are imho the
relevant lines.
class PackageUpdate(SQLObject):
title = UnicodeCol(notNone=True, alternateID=True)
builds = RelatedJoin("PackageBuild")#
class PackageBuild(SQLObject):
nvr = UnicodeCol(notNone=True, alternateID=True)
package = ForeignKey('Package')
updates = RelatedJoin("PackageUpdate")
class Package(SQLObject):
name = UnicodeCol(alternateID=True, notNone=True)
builds = MultipleJoin('PackageBuild', joinColumn='package_id')
This does not work, but I cannot find any hint how I can use SQLObject to
get all package updates that contain builds for a certain package.
A SQL query would look like this:
SELECT package_update.title
FROM package_update, package_build_package_update, package_build, package
WHERE package_update.id = package_build_package_update.package_update_id
AND package_build.id = package_build_package_update.package_build_id
AND package_build.package_id = package.id
AND package.name = "bash";
Regards
Till
------------------------------------------------------------------------------
This SF.net email is sponsored by Sprint
What will you do first with EVO, the first 4G phone?
Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first
_______________________________________________
sqlobject-discuss mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
