[sqlalchemy] Autoload, Oracle and unicode conversion

2009-09-24 Thread Ivo
When working with Oracle, we use the `convert_unicode` parameter, and use Python unicode objects everywhere. This works fabulously, and we even set `assert_unicode` to 'error' to make sure that nothing else is ever used. However, when reflecting a table using the `autoload` keyword, these

[sqlalchemy] Sprox 0.6.6 Released

2009-09-24 Thread percious
I lied, we found a few more ways to tweak sprox 0.6. (www.sprox.org) Thanks to Alessandro Molina (amol) for providing a speed enhancement when rendering dictionaries. Thanks to Temmu Yli-Elsila for his help in debugging the preventCache problem with DojoGrid in IE. Sprox will now work

[sqlalchemy] Re: Want a custom implementation of get_bind that ignores metadata bindings

2009-09-24 Thread phrrn...@googlemail.com
Yup. We screwed up by using metadata.bind but I think we may be stuck with it. Is it possible to bind a metadata collection within a session? i.e would session.configure(binds={metadata_collection_1 : e1, metadata_collection_2 : e2}) work? We would like to be able to bind groups of tables at the

[sqlalchemy] Re: unexpected chained relations and append behaviour

2009-09-24 Thread King Simon-NFHD78
-Original Message- From: sqlalchemy@googlegroups.com [mailto:sqlalch...@googlegroups.com] On Behalf Of Crusty Sent: 24 September 2009 16:16 To: sqlalchemy@googlegroups.com Subject: [sqlalchemy] Re: unexpected chained relations and append behaviour Hello Simon, thanks for

[sqlalchemy] Re: Want a custom implementation of get_bind that ignores metadata bindings

2009-09-24 Thread Michael Bayer
phrrn...@googlemail.com wrote: Yup. We screwed up by using metadata.bind but I think we may be stuck with it. why is that ? just detach it. Unless you have lots of mytable.select().execute() types of statements going on, nothing will really happen. But also, if you are setting

[sqlalchemy] Text vs. PGText possible bug

2009-09-24 Thread David Gardner
Ran across something that I suspect might be a bug. If I define my table like: asset_table = Table('asset', metadata, Column('path', Text, primary_key=True, server_default=FetchedValue(), server_onupdate=FetchedValue()),