Not great if you need pagination, though (you'd need to fetch all the data
from the API and put it in the temporary in-memory DB).
Perhaps another option would be to create a custom DAL adapter and override
the .select() and .count() methods to pull data and counts from the API.
Could get complicated, though.
Anthony
On Sunday, September 8, 2013 9:47:03 AM UTC-4, Massimo Di Pierro wrote:
>
> You cannot unless you first load the data in a database. You can use a
> temporary in memory database like this:
>
> fields = [Field('one'), Field('two'), Field('three'), ...]
> temp_db = cache.ram('tmp_db',lambda:
> DAL('sqlite:memory').define_table('mytable',*fields)._db, None)
>
> temp_db.mytable.truncate()
> temp_db.mytable.insert(....)
> form = SQLFORM.grid(temp_db.mytable)
>
>
> On Sunday, 8 September 2013 05:35:13 UTC-5, Gliese 581 g wrote:
>>
>> Hi Massimo,
>> I will try to be more specific.
>> I am developing a web2py application(APP1) which works on the data which
>> it gets from another web2py application(APP2).
>> We do not have access to the database of APP2, we access their data
>> through jsonrpc web services exposed by APP2.
>> Now, there is an API(get_objects) of APP2 which gives us a list of
>> certain type of objects. APP2 internally fetch this data from its database
>> and convert it to a list of specific type of objects.
>> I want it to be displayed in a table with sorting and paging
>> capabilities.
>> Can I use web2py's SQLFORM.grid to achieve this?
>> Please suggest me any solution.
>>
>> Thank you.
>>
>> On Friday, 6 September 2013 20:26:54 UTC+5:30, Gliese 581 g wrote:
>>>
>>> **
>>>
>>> I am working on a project where we have a different subsystem whose API
>>> returns a list of certain type of objects.
>>>
>>> I want it to be displayed on my form. Can I use SQLForm.grid for this?
>>> Please suggest.
>>>
>>
--
---
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.
