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

Reply via email to