object_o = db.t_table(f_name='same name') or db.t_table[db.t_table.insert(f_name="some name")]
On Mar 25, 7:21 am, Sergey Ozhigin <ser...@ozhigin.com> wrote: > Thanks for answers, i will try that. > > Now, what about task "get object if exists, or create and get object > if it doesn't exist"? > > I use folowing construction: > > object_o="" > try: > q= db.t_table.f_name == "some name" > object_o=next(iter(db(q).select())) > except: > object_o=db.t_table(db.t_table.insert(f_name="some name")) > > As result i have a database-wired object_o > > Any ideas how to make this piece of code more beautiful? > > On Mar 25, 10:50 am, carlo <syseng...@gmail.com> wrote: > > > > > > > > > This is the kind of thing I would love to find in a handy Web2py > > Cookbook! > > > carlo > > > On 24 Mar, 14:27, Massimo Di Pierro <massimo.dipie...@gmail.com> > > wrote: > > > > You can do it without if as well: > > > > db(query).update(...) or db.mytable.insert(...) > > > > On Mar 24, 8:26 am, Massimo Di Pierro <massimo.dipie...@gmail.com> > > > wrote: > > > > > To know if it exist or not you must have condition in the form of a > > > > query. You can do > > > > > if not db(query).update(...): db.mytable.insert(...) > > > > > where ... is the field='value' list. > > > > > On Mar 24, 4:46 am, Sergey Ozhigin <ser...@ozhigin.com> wrote: > > > > > > Hello, > > > > > > Is it possible in web2py to update or insert object (if doesn't exist) > > > > > to database in one command? > > > > > > Does anybody know an answer? > > > > > > wbr