Oleg,

precisely what I was looking for. Thank you very much!

Cheers,
Florian

Oleg Broytmann wrote:
> On Thu, Sep 04, 2008 at 12:38:02PM +0200, Florian Haas wrote:
>>     def _set_password(self, newpass):
>>         try:
>>             # FIXME: update field with hash generated
>>             # from PASSWORD(newpass)
> 
>    The problem with this approach is that when you set (UPDATE) an
> attribute (SQL field) SQLObject caches the values so it doesn't need to ask
> SQL every time. Unfortunately when you set an attribute using SQL function,
> there is no value to cache. You have to turn off SQLObject caching for the
> class (table).
>    This example works for me:
> 
> class Test(SQLObject):
>    class sqlmeta:
>       cacheValues = False
>    s = StringCol()
> 
> Test.createTable()
> 
> t = Test(s='')
> t.s = func.upper('oops!')
> print t.s
> 
>    and prints "OOPS!". But remember - with caching turned off SQLObject
> issues a separate SELECT for every attribute access.
> 
> Oleg.

-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
sqlobject-discuss mailing list
sqlobject-discuss@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss

Reply via email to