[sqlalchemy] Re: eagerload vs having the object and lazy

2008-10-03 Thread Michael Bayer
On Oct 3, 2008, at 5:39 AM, [EMAIL PROTECTED] wrote: >> B joins to A1 on A1.db_id, which is not the primary key of the "A" >> mapper series. the PK is A0.db_id. thats how it does that part. > i've no manual code, whatever relation is producing. > they're same, no? at least A0.ids contains all

[sqlalchemy] Re: eagerload vs having the object and lazy

2008-10-03 Thread az
On Friday 03 October 2008 03:50:14 Michael Bayer wrote: > On Oct 2, 2008, at 5:43 PM, [EMAIL PROTECTED] wrote: > > * SA: INFO SELECT "B".v_id AS "B_v_id", "B".db_id > > AS "B_db_id", "B".ax_id AS "B_ax_id" > > FROM "B" > > WHERE "B".ax_id = ? > > * SA: INFO [1] > > BBB:1 > > * SA: INFO SELECT "A0"

[sqlalchemy] Re: eagerload vs having the object and lazy

2008-10-02 Thread az
On Thursday 02 October 2008 22:48:23 Michael Bayer wrote: > On Oct 2, 2008, at 4:05 PM, [EMAIL PROTECTED] wrote: > > On Thursday 02 October 2008 22:26:06 Michael Bayer wrote: > >> On Oct 2, 2008, at 11:57 AM, [EMAIL PROTECTED] wrote: > >>> hi > >>> lets say, A points to B. > >>> i do a query again

[sqlalchemy] Re: eagerload vs having the object and lazy

2008-10-02 Thread Michael Bayer
On Oct 2, 2008, at 5:43 PM, [EMAIL PROTECTED] wrote: > * SA: INFO SELECT "B".v_id AS "B_v_id", "B".db_id > AS "B_db_id", "B".ax_id AS "B_ax_id" > FROM "B" > WHERE "B".ax_id = ? > * SA: INFO [1] > BBB:1 > * SA: INFO SELECT "A0".pp AS "A0_pp", "A0".atype > AS "A0_atype", "A0".db_id AS "A0_db_id",

[sqlalchemy] Re: eagerload vs having the object and lazy

2008-10-02 Thread az
seems that A0.dbid = A1.dbid = Ax.dbid are not equivalent, in regards to the relation/get(). On Thursday 02 October 2008 22:48:23 Michael Bayer wrote: > On Oct 2, 2008, at 4:05 PM, [EMAIL PROTECTED] wrote: > > On Thursday 02 October 2008 22:26:06 Michael Bayer wrote: > >> On Oct 2, 2008, at 11:5

[sqlalchemy] Re: eagerload vs having the object and lazy

2008-10-02 Thread Michael Bayer
On Oct 2, 2008, at 4:05 PM, [EMAIL PROTECTED] wrote: > > On Thursday 02 October 2008 22:26:06 Michael Bayer wrote: >> On Oct 2, 2008, at 11:57 AM, [EMAIL PROTECTED] wrote: >>> hi >>> lets say, A points to B. >>> i do a query against A about which things link to some instance >>> of B. then, >>>

[sqlalchemy] Re: eagerload vs having the object and lazy

2008-10-02 Thread az
On Thursday 02 October 2008 22:26:06 Michael Bayer wrote: > On Oct 2, 2008, at 11:57 AM, [EMAIL PROTECTED] wrote: > > hi > > lets say, A points to B. > > i do a query against A about which things link to some instance > > of B. then, > > 1) if i specify eagerload, i get many times same object-data

[sqlalchemy] Re: eagerload vs having the object and lazy

2008-10-02 Thread Michael Bayer
On Oct 2, 2008, at 11:57 AM, [EMAIL PROTECTED] wrote: > > hi > lets say, A points to B. > i do a query against A about which things link to some instance of B. > then, > 1) if i specify eagerload, i get many times same object-data being > piped from the server; ok but i dont want it > 2) if i do