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
-~----------~----~----~----~------~----~------~--~---
