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