Hi everyone !!
I've a question (sorry if the email subject isn't to explicative) that i will
simplify in this example:
Three simple tables with relations:
class rank(SQLObject):
id = IntCol()
title = StringCol()
persons = MultipleJoin('person')
class kind(SQLObject):
id = IntCol()
kindName = StringCol()
persons = MultipleJoin('person')
class person(SQLObject):
id = IntCol()
name = StringCol()
rankID = ForeignKey('rank')
kindID = ForeignKey('kind')
What's the best way to get title and kindName instead rankID and kindID if i do
person.get(1).select() (or else)?
With SQL queries i would do subslects or joins.
I think i could access through something like rank.persons or can i override
_get_rankID() for getting rank title instead
rankID or add new fields in person class like:
class person(SQLObject):
id = IntCol()
name = StringCol()
rankID = ForeignKey('rank')
kindID = ForeignKey('kind')
rankTitle = StringCol()
kindName = StringCol()
def _get_rankTitle(self):
return rank.selectBy(id=self.rankID)
def _get_kindName(self):
return kind.selectBy(id=self.kindID)
Or maybe can i do this through sqlobject.sqlbuilder???
What's the best way ??? I think this is a common problem with documented
solutions
Thanks !
-------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
sqlobject-discuss mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
