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.

Reply via email to