[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. 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=Fal

[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.

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

2009-10-03 Thread Tomasz Jezierski - Tefnet
Dnia 2009-10-02, Pt o godzinie 10:49 -0400, Michael Bayer pisze: > Tefnet Developers wrote: > > > > Hi, > > > > I need to get a single event at an extension in case of such operation: > > > > obj.colAttr = [x, y, z] > > > > right now I will receive: > > extension.remove(...) for each value curren

[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] 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 sqlalchem