Re: [SQLObject] Intermediate table in RelatedJoins

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

On Wed, Aug 12, 2009 at 02:43:50PM +0100, Miguel Tavares wrote:
> a1 = A ()
> a2 = A ()
> a3 = A ()
> b1 = B ()
> 
> a1.add (b1)
> b1.add (a2)
> b1.add (a3)

a1 = A()
a2 = A()
a3 = A()
b1 = B()

a1.addB1(b1)
b1.addA1(a1)
b1.addA2(a2)

 5/QueryR  :  INSERT INTO a VALUES (NULL)
 6/QueryR  :  SELECT NULL FROM a WHERE ((a.id) = (1))
 7/QueryR  :  INSERT INTO a VALUES (NULL)
 8/QueryR  :  SELECT NULL FROM a WHERE ((a.id) = (2))
 9/QueryR  :  INSERT INTO a VALUES (NULL)
10/QueryR  :  SELECT NULL FROM a WHERE ((a.id) = (3))
11/QueryR  :  INSERT INTO b VALUES (NULL)
12/QueryR  :  SELECT NULL FROM b WHERE ((b.id) = (1))
13/QueryR  :  INSERT INTO a1_b1 (a_id, b_id) VALUES (1, 1)
14/QueryR  :  INSERT INTO a1_b1 (b_id, a_id) VALUES (1, 1)
15/QueryR  :  INSERT INTO a2_b2 (b_id, a_id) VALUES (1, 2)

   M?

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