[SQLObject] Can't figure out usage of PickleCol...

[Christopher D. <cm...@al...>]

I can use PickleCol in "brute force" mode, but not in "native dict
mode".  Here's my toy program:


# # ## ### ##### ######## ############# #####################

from sqlobject import SQLObject, PickleCol, StringCol
import sys

__connection__ = "sqlite:///home/cmd/tg/test.sqlite?debug=1"

class Test(SQLObject):
    test = PickleCol(default=None)

Test.createTable(ifNotExists=True)
t = Test()
t.test = {'foo': 'bar'}  # This is fine, the sqlite row is filled
t = Test.get(1)          
print t.test             # Also fine
t.test['baz'] = 'mumble'
print t.test             # This is fine
                         # But the row isn't updated in sqlite!

# If at first you don't succeed, force it:
import copy
scratch = copy.copy(t.test)
scratch['baz'] = 'mumble'
t.test = scratch         # now I can see the row in sqlite.


What am I missing?


-- 
Christopher DeMarco <cm...@al...>
Alephant Systems (http://alephant.net)
PGP public key at http://pgp.alephant.net
+1-412-708-9660