postgresql Version: 8.4.12-0squeeze1 (producttion - not tested)
postgresql Version: 9.1.7-0ubuntu12.10 (dev)
I need somethink like:
Field('otherid','string', compute=lambda r: 'SOMETHING%s%s' % (
str(datetime.date.today()),
str(r['id'])))
2013. január 28., hétfő 15:48:24 UTC+1 időpontban Alec Taylor a következőt
írta:
>
> Which DB are you using BTW?
>
> Because if you're using something like MySQL; they have inbuilt
> autoincrement fields which would be much better to utilise than what
> we provide in the DAL.
>
> Maybe we should have an 'autoincrement' field, like we have a 'datetime'
> field?
>
> Gracefully degrade to a lambda if there isn't native autoincrement
> support.
>
> On Tue, Jan 29, 2013 at 1:44 AM, szimszon <[email protected] <javascript:>>
> wrote:
> > Hi!
> >
> > I wonder if somebody could help me.
> >
> > The
> >
> > definet_table('sometable',
> > Field('otherid', compute=lambda r: r['id'])
> > )
> >
> >
> > doesn't work for me. :( Sould it work? With other than r['id'] it's
> working.
> >
> > Version 2.4.1-alpha.2+timestamp.2013.01.27.10.24.17
> >
> >
> > 2010. május 28., péntek 16:02:23 UTC+2 időpontban mdipierro a következőt
> > írta:
> >>
> >> yes
> >>
> >> On May 28, 3:44 am, Mathieu Clabaut <[email protected]> wrote:
> >> > I guess that one may want some more constraints on the autoincrement
> >> > field.
> >> > For example, it shall begin at 100 for ecample.
> >> > It may be because for example, before the application exists some
> paper
> >> > records where made which were referenced by number < 100)
> >> >
> >> > For such a problem, I've set up with:
> >> >
> >> > Field('ref_number', compute=lambda r: r['id'] + 100)
> >> >
> >> > Which I hope would eliminate the race solution as it is calculate
> upon
> >> > insertion in the database... Is it the case ?
> >> >
> >> > -Mathieu
> >> >
> >> > On Thu, May 27, 2010 at 23:25, mdipierro <[email protected]>
> >> > wrote:
> >> > > What is wrong with the default id field that web2py creates for
> every
> >> > > table?
> >> >
> >> > > On May 27, 3:16 pm, matclab <[email protected]> wrote:
> >> > > > Hello,
> >> > > > I'm finding this message in a thread from February...
> >> >
> >> > > > I thought that autoincremented field would guaranty unicity in
> the
> >> > > > table.
> >> > > > I'm afraid the provided solution would allow two record to have
> the
> >> > > > same autonumber field (think about an access from two users at
> the
> >> > > > same time).
> >> > > > I guess the autoincrement should be done on the DAL or database
> >> > > > side,
> >> > > > inside a transaction....
> >> >
> >> > > > What do you think about it ?
> >> >
> >> > > > On 19 jan, 21:38, Thadeus Burgess <[email protected]> wrote:
> >> >
> >> > > > > max_id= db(db.table.autonumber>1).select(db.table.autonumber,
> #
> >> > > > > select all records, and only pull the autonumber column
> >> > > > > orderby=~db.table.autonumber, #
> >> > > > > descending sort on the autonumber, (highest first)
> >> > > > > limitby=(0,1) # limit the query
> >> > > > > and
> >> > > > > only select the first record
> >> > > > > ).first().autonumber # pull the first
> >> > > > > record
> >> > > > > from the web2py rows object, and get its autonumber member
> >> >
> >> > > > > db.table.autonumber.default = max_id + 1 # Set the table
> default
> >> > > > > as
> >> > > > > the last autonumber and incremented by one.
> >> > > > > db.table.autonumber.writable = False
> >> >
> >> > > > > form = crud.create(db.table)
> >> >
> >> > > > > -Thadeus
> >> >
> >> > > > > On Tue, Jan 19, 2010 at 4:32 AM, ceriox <[email protected]>
> wrote:
> >> > > > > > thanks for the reply but i'm not a good web2py programmer ...
> i
> >> > > > > > writing my first real app
> >> > > > > > you can write the code for my request? (i can't understand
> the
> >> > > > > > post
> >> > > of
> >> > > > > > your link)
> >> >
> >> > > > > > --
> >> > > > > > You received this message because you are subscribed to the
> >> > > > > > Google
> >> > > Groups "web2py-users" group.
> >> > > > > > To post to this group, send email to [email protected].
>
> >> > > > > > To unsubscribe from this group, send email to
> >> > > [email protected]<web2py%[email protected]<javascript:>>
> >> > >
>
> >> > > .
> >> > > > > > For more options, visit this group athttp://
> >> > > groups.google.com/group/web2py?hl=en.
> >
> > --
> >
> >
> >
>
--
