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.