While it would be easy to create a torows function it would not help you.
The grid does not take rows, it takes a query and modifies when you
interact with it. It paginates it, sorts it, etc. You cannot do these
things with a rows object.
On Monday, 9 September 2013 04:10:37 UTC-5, keiser1080 wrote:
>
> thanks massimo that work.
> But that could be more simple if there are an opposit methode to
>
> rows.as_list()
>
> Is there any function in web2py like this rows = torows(mylistofdict)?
>
> With a function like tihs we can easy past any data to a grid, smartgrid and
> sqltable.
>
>
> Le lundi 9 septembre 2013 02:56:24 UTC+2, Massimo Di Pierro a écrit :
>>
>> You can make is unique
>>
>> unique_key = response.session_id+'.temptable'
>> db = cache.ram(unique_key,lambda:DAL('sqlite:memory'), None)
>>
>>
>> On Sunday, 8 September 2013 09:40:53 UTC-5, keiser1080 wrote:
>>>
>>> thanks
>>> this kinfd of table is unique for each session or user?
>>>
>>> Le dimanche 8 septembre 2013 04:03:40 UTC+2, Massimo Di Pierro a écrit :
>>>>
>>>> You can make a fate table in ram or in cache (DAL('sqlite:memory') or
>>>> MEMDB),
>>>>
>>>> On Saturday, 7 September 2013 16:49:12 UTC-5, Anthony wrote:
>>>>>
>>>>> I think he wants the list of dictionaries to be the data displayed in
>>>>> the table, not to be used to construct a query.
>>>>>
>>>>> On Saturday, September 7, 2013 2:34:01 PM UTC-4, Massimo Di Pierro
>>>>> wrote:
>>>>>>
>>>>>> Something like this?
>>>>>>
>>>>>> def parse(table,d):
>>>>>> return reduce(lambda a,b:a&b,[table[k]==v for k,v in
>>>>>> d.iteritems()])
>>>>>>
>>>>>> SQLFORM.smartgrid(parse(db.yourtable, {'name':'alex', 'age':'55'}))
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>> On Saturday, 7 September 2013 11:07:31 UTC-5, keiser1080 wrote:
>>>>>>>
>>>>>>> hi,
>>>>>>>
>>>>>>> It is possible tu use smartgrid with a list of dictionary in place
>>>>>>> of a query?
>>>>>>> Can i do something like this?
>>>>>>>
>>>>>>> smartgrid<http://www.web2py.com/examples/static/epydoc/gluon.sqlhtml.SQLFORM-class.html#smartgrid>
>>>>>>> (table, constraints=None, linked_tables=None, links=None,
>>>>>>> links_in_grid=True, args=None,user_signature=True, divider='>',
>>>>>>> breadcrumbs_class='', **kwargs)
>>>>>>>
>>>>>>> smartgrid([{'name':'alex', 'age':'55'}, {'name':'albert', 'age':'44
>>>>>>> '}])
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
--
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
