we normally user expressions to refer to things like this
db(query).update(field=db.table.field+1)
How about interface?
On Oct 27, 3:05 pm, Thadeus Burgess <thade...@thadeusb.com> wrote:
> Not meta, too confusing with django stuff.
>
> How about expression, makes much more sense. That is what it is actually
> referred to when talking about SQL. Access calls them expressions as well.
>
> -Thadeus
>
> On Tue, Oct 27, 2009 at 2:32 PM, mdipierro <mdipie...@cs.depaul.edu> wrote:
>
> > should this thing be called meta? interface? extension?
>
> > On Oct 27, 2:26 pm, mdipierro <mdipie...@cs.depaul.edu> wrote:
> > > Simple example:
>
> > > db=DAL('sqlite://test')
> > > db.define_table('purchase',
> > > Field('item'),
> > > Field('unit_price','double'),
> > > Field('quantity','integer'))
> > > db.purchase.insert(item='Box',unit_price=15,quantity=3)
> > > rows=db().select(db.purchase.ALL)
>
> > > class purchase_meta:
> > > _tablename='purchase'
> > > def __init__(self,tax):
> > > self.tax=tax
> > > def revenues(self):
> > > return
> > > self.purchase.unit_price*self.purchase.quantity*self.tax
>
> > > rows.meta=purchase_meta(1.07)
>
> > > for row in rows:
> > > print row.item,
> > > row.unit_price,'*',row.quantity,'*',row.tax,'=',row.revenues
>
> > > More complex example:
>
> > > db.define_table('a',Field('n','integer'))
> > > db.define_table('b',Field('n','integer'),Field('a',db.a))
> > > id = db.a.insert(n=4)
> > > for i in range(3,5): db.b.insert(n=i,a=id)
> > > rows=db(db.b.a==db.a.id).select() ### join
>
> > > class products:
> > > _tablename='c'
> > > def n(self): return self.a.n*self.b.n
>
> > > rows.meta=products()
> > > for row in rows:
> > > print row.a.n,'*',row.b.n,'=' row.c.n
>
> > > Any suggestions on improving the syntax? Django can do the same but
> > > only at the level of the individual table. web2py can now to it for
> > > joins!
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To post to this group, send email to web2py@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
-~----------~----~----~----~------~----~------~--~---
