sqlobject-discuss

[SQLObject] UnicodeCol

[Ian B. <ia...@co...>]

I was going to add a FAQ entry about unicode, but then it had a bunch of 
code, and I figured I should just include the code.  Now there is a 
UnicodeCol, mostly the same as what Oleg described before.

This doesn't solve the query issue, since queries involving unicode will 
fail currently.  There's a couple ways to do that:
   * Process-global encodings, added to sqlobject.converters
   * If we move to database parameters instead of building SQL textually,
     we could do per-database default encodings.  The dbconnection
     instance would loop through the parameters and convert any unicode
     strings it found.
   * sqlbuilder.SQLObjectField could pay attention to encoding.
     Actually, I want to get rid of the .q stuff, and just make
     cls.column into a descriptor, so that when fetched from a class it's
     an object that can be used in a query.  But either way this is
     fairly doable.

-- 
Ian Bicking  /  ia...@co...  /  http://blog.ianbicking.org

Re: [SQLObject] UnicodeCol bug

[Max I. <ma...@uc...>]

Ian Bicking wrote:
> I was going to add a FAQ entry about unicode, but then it had a bunch of 
> code, and I figured I should just include the code.  Now there is a 
> UnicodeCol, mostly the same as what Oleg described before.

The implementation contains a bug: it doesn't handle None property, when 
you try to read or set a NULL value:

   File "D:\Python23\Lib\site-packages\sqlobject\main.py", line 890, in 
__init__
     self._create(id, **kw)
   File "D:\Python23\Lib\site-packages\sqlobject\main.py", line 920, in 
_create
     self.set(**kw)
   File "D:\Python23\Lib\site-packages\sqlobject\main.py", line 774, in set
     kw[name] = dbValue = fromPython(value, self._SO_validatorState)
   File "D:\Python23\Lib\site-packages\sqlobject\col.py", line 347, in 
fromPython
     return value.encode(self.db_encoding)
AttributeError: 'NoneType' object has no attribute 'encode'

Re: [SQLObject] UnicodeCol bug

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

On Fri, Dec 10, 2004 at 02:58:31PM +0200, Max Ischenko wrote:
>     return value.encode(self.db_encoding)
> AttributeError: 'NoneType' object has no attribute 'encode'

   Fixed in revision 476.

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

Re: [SQLObject] UnicodeCol bug

[Max I. <ma...@uc...>]

>>    return value.encode(self.db_encoding)
>>AttributeError: 'NoneType' object has no attribute 'encode'
> 
> 
>    Fixed in revision 476.
>

Thanks.

Kinda nice to have project maintainers in different time zones. Your bug 
report gets noticed and fixed at any time of the day. ;-)