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
