[sqlalchemy] ConcurrentModificationError with transactional sessions

2008-04-14 Thread Tim Lesher
! -- Tim Lesher [EMAIL PROTECTED] --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL

[sqlalchemy] Re: ConcurrentModificationError with transactional sessions

2008-04-14 Thread Tim Lesher
usually needs to be cleared out   (or at least expire_all() called) after a rollback() occurs. Thanks--explicitly clearing out the session after any rollback fixed the problem. -- Tim Lesher [EMAIL PROTECTED] --~--~-~--~~~---~--~~ You received this message because you

[sqlalchemy] Re: has() and multiple tables

2008-04-08 Thread Tim Lesher
that as both are relatively cheap EXISTS queries. -- Tim Lesher [EMAIL PROTECTED] --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to sqlalchemy@googlegroups.com

[sqlalchemy] has() and multiple tables

2008-04-07 Thread Tim Lesher
I'm having some trouble using the has() operator to avoid a long chain of joins in a select. A stripped-down version of my schema looks like this: a Caller has a (phone) number. A Caller can create Connections (each to a phone number). A Connection can involve one or more Tasks, each of which

[sqlalchemy] Reflection + override error with SA 0.3.10 and MySQL

2008-02-25 Thread Tim Lesher
I'm using SQLAlchemy, reflecting from an existing MySQL database. I want to override two DateTime columns to provide proper created and updated timestamps (since MySQL can't handle auto-updating two TIMESTAMP columns in the same row). According to the SA docs, this should work; however, when I

[sqlalchemy] Re: SQLAlchemy advanced tutorial at PyCon

2008-01-30 Thread Tim Lesher
On Jan 28, 4:23 pm, Jonathan Ellis [EMAIL PROTECTED] wrote: What would you like to see covered in an advanced SQLAlchemy session? Something on association objects would be good. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the