[sqlalchemy] Re: Problem when slicing a relation list

2007-10-25 Thread Barry Hart
Credit for this one goes to my colleague Greg Hunt. All I did was tell him to write a test case. :-) Barry - Original Message From: Michael Bayer <[EMAIL PROTECTED]> To: sqlalchemy@googlegroups.com Sent: Thursday, October 25, 2007 6:16:24 PM Subject: [sqlalchemy] Re: Problem when slicin

[sqlalchemy] Re: Problem when slicing a relation list

2007-10-25 Thread Michael Bayer
On Oct 25, 2007, at 3:58 PM, Barry Hart wrote: > Here is a test case for the bug. The bug only manifests itself if > the transaction that slices the list also modifies all the > remaining objects in the list. > hi barry - nice job again. we've narrowed down the specific mechanism in this

[sqlalchemy] Re: Problem when slicing a relation list

2007-10-25 Thread Barry Hart
Here is a test case for the bug. The bug only manifests itself if the transaction that slices the list also modifies all the remaining objects in the list. Barry - Original Message From: Michael Bayer <[EMAIL PROTECTED]> To: sqlalchemy@googlegroups.com Sent: Wednesday, October 24, 2007

[sqlalchemy] Re: "polymorphic" question

2007-10-25 Thread sdobrev
hi, i'm back to the cane field... > do your ABC tests all use select_mapper ? ticket 795 revealed > that totally basic ABC loading was broken if you're using > "secondary" loads of the remaining attributes (which is the default > behavior when you dont specify select_mapper). u mean mapper's se

[sqlalchemy] Re: Two MSSQL databases on one engine?

2007-10-25 Thread Paul Johnston
Hi, > Do have to define two engines to access two databases on the same > database server? With MSSQL, at the moment you do. People have suggested changes to workaround this (using dbname.schema.table), but nothing has been implemented as yet. Paul --~--~-~--~~~-

[sqlalchemy] Re: Read-only Sessions

2007-10-25 Thread Yannick Gingras
Michael Bayer <[EMAIL PROTECTED]> writes: > If you were setting ctx.current.flush to something for every new > session, the approach here would be the same (Session ().flush = > abort_ro). if you were only setting ctx.current.flush to abort_ro() > at the module level, then your 0.3 approach wasn

[sqlalchemy] Re: Read-only Sessions

2007-10-25 Thread Michael Bayer
On Oct 25, 2007, at 12:03 PM, Yannick Gingras wrote: > > > Greetings Alchemists, > I'm using Alchemy for a Pylons application and I just migrated to > 0.4. > My application has a read only mode and even though I do all the > relevant checks all over the place, I know I'm going to forget a >

[sqlalchemy] Two MSSQL databases on one engine?

2007-10-25 Thread Scott Jaderholm
Hi Alchemists, Do have to define two engines to access two databases on the same database server? I am using MSSQL and pylons with the following: sqlalchemy.default.url = mssql://login:[EMAIL PROTECTED]:1272/database1 I would like to autoload a table that is on that same MSSQL server, but in da

[sqlalchemy] Read-only Sessions

2007-10-25 Thread Yannick Gingras
Greetings Alchemists, I'm using Alchemy for a Pylons application and I just migrated to 0.4. My application has a read only mode and even though I do all the relevant checks all over the place, I know I'm going to forget a critical spot one of there days so I used to do: def abort_ro():

[sqlalchemy] Re: In a many to many relationship how to access some properties of that relationship

2007-10-25 Thread Barry Hart
No, the association proxy would be used if you want to let users directly access movies or vice versa. To get the score, you can define a mapper for movie_vote table and define relationships between it and users and movies. Barry - Original Message From: Jason <[EMAIL PROTECTED]> To: s