Hi Oleg!

A second intermediate table can be used to state a second many-to-many
relationship and it might make more sense to have it  in reverse
order.

Imagine this scenario:

class Address(SQLObject):
    Address = sqlobject.StringCol ()
    People = sqlobject.RelatedJoin ('Person')

class Person(SQLObject):
    Name = sqlobject.StringCol ()
    Addresses = sqlobject.RelatedJoin ('Address')

So a Person can have several addresses (House, Work, Beach House, etc)
and each Address can be for several Persons (all the member of the
family for example).

Does this makes any sense?


Now, if I wanted to implement the support for several intermediate
tables where should I begin? Any ideas?

Best regards,

Miguel Tavares

2009/8/12 Oleg Broytmann <p...@phd.pp.ru>:
> On Wed, Aug 12, 2009 at 10:14:38AM +0100, Miguel Tavares wrote:
>> But creating the two table might be exactly was is intended
>> Hum... shouldn't it create a target_capability too?
>
>   No. SQLObject can use only one intermediate table. Wanna extend this?
> Patches (with tests) should be put to the SF tracker.
>
>   But I wonder - what could be the use for a second intermediate table?
>
> Oleg.
> --
>     Oleg Broytmann            http://phd.pp.ru/            ...@phd.pp.ru
>           Programmers don't die, they just GOSUB without RETURN.
>

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day 
trial. Simplify your report design, integration and deployment - and focus on 
what you do best, core application coding. Discover what's new with 
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
sqlobject-discuss mailing list
sqlobject-discuss@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss

Reply via email to