Re: [SQLObject] Substitute fieldID for fieldName

[Oleg B. <ph...@ma...>]

On Mon, May 08, 2006 at 02:28:03PM +0200, Felix wrote:
> 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)?

class rank(SQLObject):
	id = IntCol()
	title = StringCol()
	persons = MultipleJoin('person', joinColumn="rank_id")

class kind(SQLObject):
	id = IntCol()
	kindName = StringCol()
	persons = MultipleJoin('person', joinColumn="kind_id")

class person(SQLObject):
	id = IntCol()
	name = StringCol()
	rank = ForeignKey('rank')
	kind = ForeignKey('kind')

person.get(1).rank

Oleg.
-- 
     Oleg Broytmann            http://phd.pp.ru/            ph...@ph...
           Programmers don't die, they just GOSUB without RETURN.