[sqlalchemy] how to get duplicated Key Error?

2009-10-03 Thread 李白,字一日
any code snippets? thanks. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to

[sqlalchemy] Re: how to get duplicated Key Error?

2009-10-03 Thread Tomasz Jezierski - Tefnet
Dnia 2009-10-02, Pt o godzinie 21:22 -0700, 李白,字一日 pisze: any code snippets? thanks. How to handle unique constraint exception? http://www.sqlalchemy.org/trac/wiki/UsageRecipes/UniqueConstraintExceptionHandling --- Tomasz Jezierski Tefnet www.tefnet.pl

[sqlalchemy] Re: support for set/replace on a collection in AttributeExtension

2009-10-03 Thread Michael Bayer
On Oct 3, 2009, at 7:53 AM, Tomasz Jezierski - Tefnet wrote: if it were me, I'd just constrain access to a set of methods, such as: def set_col_attr(*values) We don't like polluting our namespace with useless get/set_col_attr etc... its useful depending on your use case.I have a

[sqlalchemy] Re: padding of CHAR fields, inconsistent where clause; Oracle example

2009-10-03 Thread Michael Bayer
On Oct 2, 2009, at 6:05 PM, volx wrote: My module is called sandbox.py After importing it to ipython and letting it run, here's what I get for the test you suggested: In [47]: (sandbox.price_sources.c.desciption=='EJV').right.type Out[47]: OracleChar(length=100, convert_unicode=False,

[sqlalchemy] Re: padding of CHAR fields, inconsistent where clause; Oracle example

2009-10-03 Thread volx
Hi Mike: Thank you for that. I will try it out on Monday. I see there is a major refactoring around types in version 0.6. One would be expected to define table classes with generic SQL types like CHAR or generic language types like String and not with dialect implementations like OracleChar. Am