sqlobject-discuss

[SQLObject] Unicode problem in .select() and .selectBy() - partially fixed

[Oleg B. <ph...@ma...>]

Hello. I think I fixed a longstanding problem with UnicodeCol - at last you
can use unicode strings in .select() and .selectBy() queries. There are
some limitations, though:

- only simple q-magic fields are supported; no expressions;
- only == and <> operators are supported;

   The following will work::

MyTable.select(u'value' == MyTable.q.name)
MyTable.select(MyTable.q.name <> u'value')
MyTable.selectBy(name = u'value')

   The following will not work::

MyTable.select((MyTable.q.name + MyTable.q.surname) == u'value')

   The patch with tests is attached. I am eagerly waiting for feedback.

   Technically, I've found a way to pass dbEncoding to __sqlrepr__ so that
the column can convert the value to a string - for this I have created a
special field that only overrides __eq__ and __ne__ - I believe these are
the most frequent cases.

Oleg.
-- 
     Oleg Broytmann            http://phd.pp.ru/            ph...@ph...
           Programmers don't die, they just GOSUB without RETURN.

Re: [SQLObject] Unicode problem in .select() and .selectBy() - partially fixed

[Oleg B. <ph...@ma...>]

The following will work too:

MyTable.select(AND(MyTable.q.name == u'value1', MyTable.q.name <> u'value2'))
MyTable.selectBy(col1=u'value1', col2=u'value1')

   The patch is against SVN trunk.

Oleg.
-- 
     Oleg Broytmann            http://phd.pp.ru/            ph...@ph...
           Programmers don't die, they just GOSUB without RETURN.

Re: [SQLObject] Unicode problem in .select() and .selectBy() - partially fixed

[Oleg B. <ph...@ph...>]

On Fri, Aug 25, 2006 at 07:48:41PM +0400, Oleg Broytmann wrote:
> I think I fixed a longstanding problem with UnicodeCol - at last you
> can use unicode strings in .select() and .selectBy() queries.
>    I am eagerly waiting for feedback.

   Nobody's interested? There were so many people who reported the
problem...

Oleg.
-- 
     Oleg Broytmann            http://phd.pp.ru/            ph...@ph...
           Programmers don't die, they just GOSUB without RETURN.

Re: [SQLObject] Unicode problem in .select() and .selectBy() - partially fixed

[Ivan H. <i.h...@al...>]

Dear Oleg,

     for me the
     oResult = VssHistory.selectBy(objectsID = nObjectsId, datetime = oHistDateTime)
     works, it is true these values are not unicode

     but in another example i used unicode value (some hungarian
     chars), it works also
                

Friday, August 25, 2006, 5:52:49 PM, you wrote:

OB> The following will work too:

OB> MyTable.select(AND(MyTable.q.name == u'value1', MyTable.q.name <> u'value2'))
OB> MyTable.selectBy(col1=u'value1', col2=u'value1')

OB>    The patch is against SVN trunk.

OB> Oleg.



-- 
Best regards,
 Ivan Horvath
 Chief Programmer

 Alcatel ISD
 PMS 2000 Product Team

 H-1116, Budapest
 Kondorfa u. 10.
 Tel.: +36 1 209 9546
 Fax.: +36 1 209 9599
 Mobil: +36 30 257 0235
 VOIP: +49 511 676 478010
 mailto:i.h...@al...

Anyone who has never made a mistake has never tried anything new.

/Albert Einstein/ 

Re: [SQLObject] Unicode problem in .select() and .selectBy() - partially fixed

[Oleg B. <ph...@ma...>]

On Wed, Aug 30, 2006 at 05:42:43PM +0200, Ivan Horvath wrote:
>      for me the
>      oResult = VssHistory.selectBy(objectsID = nObjectsId, datetime = oHistDateTime)
>      works, it is true these values are not unicode
> 
>      but in another example i used unicode value (some hungarian
>      chars), it works also

   Thank you for the report!

Oleg.
-- 
     Oleg Broytmann            http://phd.pp.ru/            ph...@ph...
           Programmers don't die, they just GOSUB without RETURN.