[sqlalchemy] clause with crossproduct of joined-inheritance

2007-11-26 Thread svilen
hi i have following scenario (excluse the very brief syntax): class BaseAddress: street = ... text class Office( BaseAddress): some_fields class Home( BaseAddress): other_fields class Person: home = reference-to-HomeAdrress office = reference-to-MainAdrress otherstuff now, i need

[sqlalchemy] Re: clause with crossproduct of joined-inheritance

2007-11-26 Thread Michael Bayer
On Nov 26, 2007, at 5:19 AM, svilen wrote: hi i have following scenario (excluse the very brief syntax): class BaseAddress: street = ... text class Office( BaseAddress): some_fields class Home( BaseAddress): other_fields class Person: home = reference-to-HomeAdrress office =

[sqlalchemy] MSSQL and LIMIT/OFFSET

2007-11-26 Thread Paul Johnston
Hi, Can someone (Mike?) give me a hand with this, I've hit the limits of my understanding of the query compiler. The patch I've done on #638 (mostly copied from Oracle) creates a subquery with row_number if there is an OFFSET. It aliases the query, because MSSQL is funny about that, and it

[sqlalchemy] Re: MSSQL and LIMIT/OFFSET

2007-11-26 Thread Michael Bayer
On Nov 26, 2007, at 2:25 PM, Paul Johnston wrote: Hi, Can someone (Mike?) give me a hand with this, I've hit the limits of my understanding of the query compiler. The patch I've done on #638 (mostly copied from Oracle) creates a subquery with row_number if there is an OFFSET. It

[sqlalchemy] Access to the PostgreSQL's NOTIFY/ LISTEN feature?

2007-11-26 Thread Dimitris Karteris
I will be using SQLAlchemy on top of PostgreSQL and I plan to take advantage of this NOTIFY / LISTEN mechanism offered by PostgreSQL. In the psycopg2 distro, I came across an example snippet that shows how to obtain notifications (http://www.initd.org/tracker/psycopg/browser/

[sqlalchemy] Re: Access to the PostgreSQL's NOTIFY/ LISTEN feature?

2007-11-26 Thread Michael Bayer
with a regular SA engine-level Connection, you can get at the psycopg2 connection via conn.connection. the connection and cursor returned by cursor() are proxied for garbage collection/connection pool purposes but call upon the psycopg2 API for their behavior and methods. you also want to make

[sqlalchemy] Re: Access to the PostgreSQL's NOTIFY/ LISTEN feature?

2007-11-26 Thread Michael Bayer
added FAQ entry: http://www.sqlalchemy.org/trac/wiki/FAQ#HowdoIgetattherawDBAPIconnectionwhenusinganEngine --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to