[sqlalchemy] Re: Compound Join

2011-01-28 Thread Eric N
the original post. Thanks again, - Eric On Jan 27, 7:02 pm, Michael Bayer mike...@zzzcomputing.com wrote: On Jan 27, 2011, at 8:06 PM, Eric N wrote: I'm trying to construct a query where in the from clause I would end up with something like SELECT foo FROM table1 JOIN           table2

[sqlalchemy] Compound Join

2011-01-27 Thread Eric N
I'm trying to construct a query where in the from clause I would end up with something like SELECT foo FROM table1 JOIN table2 ON table1.id1 = table2.id1 JOIN table3 ON table1.id1=table3.id1 JOIN table4 ON table2.id2=table4.id2 AND table3.id3=table4.id3 I have

[sqlalchemy] Re: Accessing multiple databases with same schema

2010-12-03 Thread Eric N
I had a similar issue that I resolved by creating a set_data_model function that when I called in it would set some global variable to the table objects based on the product passed in to the function. I'm using multiple schemas in a Postgres database and wanted to try to limit the number of

[sqlalchemy] Dynamically changing the model

2010-08-16 Thread Eric N
This problem involves Pylons as well, but I believe the problem involves how I'm using SQLAlchemy and therfore I'm posting here first. I have a peculiar situation where I am trying to dynamically flip back and forth between data models and running into problems. I am using PostgreSQL with multiple

[sqlalchemy] OID usage

2007-09-27 Thread Eric N
I apologize in advance for the size of this post, but I want to provide as much info as possible. I work for a large company and I am trying to use SqlAlchemy to implement a cleaner interface to one of our databases. The database is Sql Server 2005, the app runs on RHEL 3 under Python 2.5. I am