[sqlalchemy] Starting with SQLAlchemy and Oracle: Reflection question

Hi everyone, I am starting out with SQLAlchemy, and I want to use it to reflect tables in an Oracle 10g database. I have been successful in that, but it seems it is not reflecting the primary keys. Any ideas? Or any suggestion about how to check if the keys are getting reflected or not? Thanks!

Re: [sqlalchemy] Starting with SQLAlchemy and Oracle: Reflection question

On May 24, 2010, at 5:34 AM, Urko M. wrote: Hi everyone, I am starting out with SQLAlchemy, and I want to use it to reflect tables in an Oracle 10g database. I have been successful in that, but it seems it is not reflecting the primary keys. Any ideas? Or any suggestion about how to

[sqlalchemy] Window function support?

I have a query which requires the use of windowing functions in postgresql. Specifically, I require select distinct S.c1, first_value(c2) over (partition by S.c1 order by c2 desc) c3 from How might I accomplish this? Will there be windowing function support in an upcoming release of SA? --

Re: [sqlalchemy] Window function support?

we will have it eventually. for now you can build ColumnElement constructs yourself using the @compiles extension, http://www.sqlalchemy.org/docs/reference/ext/compiler.html (or just literal strings if your needs are simple). On May 24, 2010, at 1:13 PM, Jon Nelson wrote: I have a query