Could you write a function that handles the inserts/selects instead?
class MY_PICKLE():
@classmethod
def get(keyname):
pkldump = db(db.pickle_table.keyname == keyname).select().first()
return pickle.loads(pkldump.value)
@classmethod
def save(keyname, value):
pkldump = db(db.pickle_table.keyname == keyname).select().first()
if pkldump:
pkldump.update_record(value=pickle.dumps(value))
else:
db.picke_table.insert(keyname=keyname,value=pickle.dumps(value))
a_list = MY_PICKLE.get("listkey")
# do some stuff to list
MY_PICKLE.save("listkey", a_list)
-Thadeus
On Wed, Feb 17, 2010 at 1:20 PM, spiffytech <spiffyt...@gmail.com> wrote:
> I'm serializing with Pickle in my app, but it's a hassle to dump/load
> the data every time I mess with it. Is there a way to make the
> serializing happen automatically with DB access?
>
> -Brian
>
>
> On Feb 17, 1:46 pm, Carl <carl.ro...@gmail.com> wrote:
>> thanks Jorge; most helpful in pointing me in the right direction.
>>
>> The python to pickle is simply; for example:
>> import pickle
>> flat_retort = pickle.dumps(retort)
>>
>> and to unpickle; for example:
>> import pickle
>> options = pickle.loads(rows[0].retort)
>>
>> On Feb 17, 3:57 pm, JorgeRpo <jorgeh...@gmail.com> wrote:
>>
>> > On Feb 17, 10:47 am, Carl <carl.ro...@gmail.com> wrote:
>>
>> > > I have a Python list that I want to store and retrieve from the data
>> > > store.
>>
>> > > The individual items of the list are of no use unless used with the
>> > > items of the complete list and there are no use-cases requiring
>> > > searching for a specified list item. The number of items in the list
>> > > is between one and fifteen (any more is beyond end users to manage).
>>
>> > > I'd like to store and retrieve the list in a single field. On
>> > > retrieval the data would be in a Python list object.
>>
>> > > What's an approach I can use?
>>
>> > serialize
>> > --
>> > sig text
>
> --
> You received this message because you are subscribed to the Google Groups
> "web2py-users" group.
> To post to this group, send email to web...@googlegroups.com.
> To unsubscribe from this group, send email to
> web2py+unsubscr...@googlegroups.com.
> For more options, visit this group at
> http://groups.google.com/group/web2py?hl=en.
>
>
--
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To post to this group, send email to web...@googlegroups.com.
To unsubscribe from this group, send email to
web2py+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en.
