You cannot this way. because the Id is not assigned by the database
until the insert is performed.
You would have to use crud create onaccept method to perform a method
update immediately after it is created and recomputes the slug.
On 15 Ago, 20:26, Bruno Rocha <rochacbr...@gmail.com> wrote:
> # brand table:
> db.define_table('brand', Field('name'))
>
> # The car table with computed field:
> db.define_table('car',
> Field('brand', db.brand),
> Field('model'),
> Field('year', 'integer'),
> Field('slug', notnull=True, compute=*get_slug*)
> )
>
> # That's the function to get the slug:
> import re
> def get_slug(r):
> marca = db(db.brand.id==r.brand).select().first()
> slug_regex = re.compile('[^\w-]')
> return slug_regex.sub('',brand.name+'-%(model)s-%(year)s' %r).lower()
>
> The function above is returning almost what I need, eg:
> 'toyota-corolla-2010' , but I need to put the inserted id to the end as:
> 'toyota-corolla-2010-2 ( 2 is the inserted id)
>
> I am inserting records via "appadmin/insert/db/car", How to get the id
> inside the "get_slug" function scope?
>
> 2010/8/15 mdipierro <mdipie...@cs.depaul.edu>
>
>
>
>
>
> > Sorry. I do not understand what you want to do. Can you provide an
> > example of code and/or desired workflow?
>
> > Massimo
>
> > On Aug 15, 3:18 am, Bruno Rocha <rochacbr...@gmail.com> wrote:
> > > But I cant access form in this case, cause I am doing that inside a
> > model,
> > > and inserting the record via appadmin.
>
> > > File "/home/bruno/web2py/applications/lojadecarro/models/carros.py", line
> > > 20, in get_slug
> > > print form.vars.id
> > > NameError: global name 'form' is not defined
>
> > > Gonna try with crud
>
> > > 2010/8/15 mdipierro <mdipie...@cs.depaul.edu>
>
> > > > form.vars.id contains the id or a newly inserted record.
>
> > > > On Aug 15, 2:58 am, Bruno Rocha <rochacbr...@gmail.com> wrote:
> > > > > I Just can't figure out how to retrive the inserted id as Row object
> > does
> > > > > not have the 'id' key
>
> > > > > 2010/8/15 Bruno Rocha <rochacbr...@gmail.com>
>
> > > > > > I am trying to do everything in the lambda, without the need to def
> > the
> > > > > > function.
>
> > > > > > Tks..
>
> > > > > > 2010/8/15 mdipierro <mdipie...@cs.depaul.edu>
>
> > > > > > If you define a function you do not need the lambda
>
> > > > > >> Field('slug', notnull=True, compute=get_brand),
>
> > > > > >> On Aug 15, 2:45 am, Bruno Rocha <rochacbr...@gmail.com> wrote:
> > > > > >> > Thank you Massimo! works very well. I just needed to change a
> > little
> > > > in
> > > > > >> > order to get the brand.name instead brand.id in the slug
>
> > > > > >> > This:
>
> > > > > >> > def get_brand(r):
> > > > > >> > import re
> > > > > >> > brand = db(db.brand.id==r.brand).select().first()
> > > > > >> > slug_regex = re.compile('[^\w-]')
> > > > > >> > return slug_regex.sub('',brand.nome+'-%(model)s-%(year)s'
> > > > > >> %r).lower()
>
> > > > > >> > and:
>
> > > > > >> > Field('slug', notnull=True, compute= lambda r: get_brand(r)),
>
> > > > > >> > to get: 'toyota-corolla-2010' as slug ( I still wants to get
> > the
> > > > r.idat
> > > > > >> > the end)
>
> > > > > >> > Tks.
>
> > > > > >> > 2010/8/15 mdipierro <mdipie...@cs.depaul.edu>
>
> > > > > >> > > import re
> > > > > >> > > slug_regex = re.compile('[^\w-]')
>
> > > > > >> > > Field('slug',compute=lambda r:
> > > > > >> slug_regex.sub('','%(brand)s-%(model)s-%
> > > > > >> > > (year)s' %r).lower())
>
> > > > > >> > > On Aug 14, 11:12 pm, Bruno Rocha <rochacbr...@gmail.com>
> > wrote:
> > > > > >> > > > I need a page slug for the cars in my car shop,
> > > > > >> > > > instead havinghttp://.../default/car/2,
> > > > > >> > > > I wanthttp://..../default/car/carbrand-carmodel-caryear-id
>
> > > > > >> > > > so I defined a table:
>
> > > > > >> > > > db.define_table('car'
> > > > > >> > > > Field('brand', db.brand),
> > > > > >> > > > Field('model'),
> > > > > >> > > > Field('year','integer'),
> > > > > >> > > > Field('slug')
> > > > > >> > > > )
>
> > > > > >> > > > but I do not want the user to fill the "slug" field, so I
> > have
> > > > to
> > > > > >> define
> > > > > >> > > > default value to the slug field, concatenating 'brand' +
> > 'model'
> > > > +
> > > > > >> 'year'
> > > > > >> > > +
> > > > > >> > > > 'slug' joining with a '-',
> > > > > >> > > > eg:
> > > > > >> > > > id = 2
> > > > > >> > > > brand = 'Toyota'
> > > > > >> > > > model = 'Corolla'
> > > > > >> > > > year = '2010'
> > > > > >> > > > slug = 'toyota-corolla-2010-2'
>
> > > > > >> > > > how can I get this to be automaticaly filled when inserting?
> > > > (just
> > > > > >> like a
> > > > > >> > > > trigger)
>
> > > > > >> > --
>
> > > > > >> >http://rochacbruno.com.br
>
> > > > > > --
>
> > > > > >http://rochacbruno.com.br
>
> > > > > --
>
> > > > >http://rochacbruno.com.br
>
> > > --
>
> > >http://rochacbruno.com.br
>
> --
>
> http://rochacbruno.com.br- Nascondi testo citato
>
> - Mostra testo citato -
