[sqlalchemy] db independent way to get id from sequence

Hi, Are there any database independent way to get the id from some sequence - for databases that supports it? For postgres this can be done by issueing select nextval('name_of_the_sequence') statement, but for other databases like oracle, firebird it is maybe different. It seems that there is no

[sqlalchemy] Load Lazy Relation in Separate Thread

Hi, I am doing some optimizations on our app, and one thing I was wondering is if I can have a lazy relation loading in a separate thread. The way I'd like to use it is like this. I have a list with products, and these products show a graph with stock levels. To draw this graph, the object

[sqlalchemy] ForeignKey + schema

SA 0.3* doesn't seem to handle relationships between tables in different schemas very well: it seems to think that schema.A - public.B is: schema.A - schema.B and even specifying primaryjoin= in the mapper won't help it. There seems to be no directive to say use the default /

[sqlalchemy] Why is explicit 'and_' required for filter but not filter_by?

In 0.4: Is there any reason that I (as far as i can tell) need an explicit 'and_' to use multiple parameters with Query.filter, as opposed to filter_by, where I don't need an explicit 'and_'? I think the latter is cleaner. Ryan --~--~-~--~~~---~--~~ You received