[sqlalchemy] Session management with mod_wsgi and webapp2

2012-05-25 Thread Bradley Mclain
Hi, Currently working on a project that use SQL alchemy with mod_wsgi, webapp2 and prestans (python REST framework). The backend is Oracle XE using cx_Oracle. What is the appropriate way to manage sessions in a multithreading app such as this? Currently I have been following the guide found

[sqlalchemy] Combine attributes from two objects in parent object

2012-05-25 Thread Stephan Hügel
I'd like to represent a Correspondent object, which can refer to two separate objects Corr_1 - id - email_address Corr_2 - id - email_address Correspondent - id - corr_1.id - corr_2.id But I have two problems: I'm using MySQL, so I can't use a check constraint to ensure that only one of the

Re: [sqlalchemy] Session management with mod_wsgi and webapp2

2012-05-25 Thread Michael Bayer
On May 24, 2012, at 11:28 PM, Bradley Mclain wrote: Hi, Currently working on a project that use SQL alchemy with mod_wsgi, webapp2 and prestans (python REST framework). The backend is Oracle XE using cx_Oracle. What is the appropriate way to manage sessions in a multithreading app

Re: [sqlalchemy] Combine attributes from two objects in parent object

2012-05-25 Thread Michael Bayer
On May 25, 2012, at 4:53 PM, Stephan Hügel wrote: I'd like to represent a Correspondent object, which can refer to two separate objects Corr_1 - id - email_address Corr_2 - id - email_address Correspondent - id - corr_1.id - corr_2.id But I have two problems: I'm using