[sqlalchemy] Re: multiple databases with same table names not working

2011-11-24 Thread dangel
Are the table structures identical in both databases ?  if so, then I would not double up the declarative classes in this way - I'd use one class to represent a particular table structure, which can then be used in either session.   You're already using two different Session objects, so

Re: [sqlalchemy] Re: Multiple databases or multiple schemas?

2010-06-14 Thread Henry Precheur
On Sun, Jun 13, 2010 at 09:23:22PM +, Faheem Mitha wrote: Sqlalchemy's table can take the qschema as argument, eg. pheno_table = Table( 'pheno', metadata, Column('patientid', String(60), primary_key=True), Column('famid', String(60), nullable=True), Column('sex_id',

[sqlalchemy] Re: Multiple databases or multiple schemas?

2010-06-13 Thread Faheem Mitha
[This message has also been posted.] On Sun, 13 Jun 2010 13:27:34 -0700, Henry Precheur he...@precheur.org wrote: I'm starting a new project which is roughly hosting a bunch of sites. I want the sites to be isolated, they'll all have the same schema (data definition), but will store their data

[sqlalchemy] Re: multiple databases ?

2008-04-23 Thread Lukasz Szybalski
On Tue, Apr 22, 2008 at 11:54 AM, Lukasz Szybalski [EMAIL PROTECTED] wrote: Hello again, So now that I have mssql connection ready and data filtered out and processed I need to save it to a different database. mssql - process data - save to mysql I am wondering how should I create a

[sqlalchemy] Re: multiple databases ?

2008-04-22 Thread az
On Tuesday 22 April 2008 19:54:16 Lukasz Szybalski wrote: Hello again, So now that I have mssql connection ready and data filtered out and processed I need to save it to a different database. mssql - process data - save to mysql I am wondering how should I create a second database

[sqlalchemy] Re: multiple databases ?

2008-04-22 Thread Lukasz Szybalski
On Tue, Apr 22, 2008 at 6:00 PM, [EMAIL PROTECTED] wrote: On Tuesday 22 April 2008 19:54:16 Lukasz Szybalski wrote: Hello again, So now that I have mssql connection ready and data filtered out and processed I need to save it to a different database. mssql - process data - save