I´m using a copy of your products function, just changed the database
and commented out some of the virtual function under class Virtual. So I
have the some order as you have in the example.
But I´ll study the book and I´ll try to find out what I´m doing wrong.
Kenneth
Try to fetch it without 'virtual' just use Row.fieldname instead of
Row.virtual.fieldname
It depends on how did you set the virtualfields, if you do
Rows.setvirtualfields(virtual=someClass()) you'll get a sub dictionary
for every row and you need to use 'virtual' to access it, I think this
works in this way because you are defining virtualfields after the
Rows object.
If you do it before with: db.table.virtualfields.append(someClass())
it works in another way.
Take a look at virtual fields on the book:
http://web2py.com/book/default/chapter/06#Virtual-Fields
Bruno
2010/12/30 Kenneth Lundström <kenneth.t.lundst...@gmail.com
<mailto:kenneth.t.lundst...@gmail.com>>
I´m still trying to understand the power of powerTable and copied
code from your default.py example, I tried to get the products
function working. What I can´t seem to get working is the virtual
bit.
I get KeyError: 'virtual' any ideas why?
Kenneth
2010/12/29 Kenneth Lundström <kenneth.t.lundst...@gmail.com
<mailto:kenneth.t.lundst...@gmail.com>>
Hi Bruno,
waauu what a Plugin your working on, very nice.
What does the productdetails function look like?
In the main table every row has two attributes
ID = it is the record id from rows object, if there is not an id
field it will be the first row value.
Key = tablename.fieldname to query against
In that example the category table is passing i.e:
key=products.category.1 cols=[a list of columns to fetch in detail]
the productdetails functions just splits the key and creates a
new SQLTABLE
<example>
def productdetails():
tablename,fieldname,value = key.split('.')
return
SQLTABLE(powertable_db(powertable_db.tablename.fieldname==value).select(**cols))
</example>
Following this model it is possible to do whatever you need,
bulld any html object to return in detail table, by default,
wthout writing any code i can return a update/insert FORM, a
TABLE, a UL list.
Now I am trying to include tabs within details to return multiple
objects.
--
Bruno Rocha
http://about.me/rochacbruno/bio
--
Bruno Rocha
http://about.me/rochacbruno/bio