Ok, so if I would do it easily I should use directly pymongo, also because
looking at the current DAL seems that the mongoDBadapter doesn't support
raw queries.
But, anyway, if I would achieve the same result with DAL, what would be a
way to do it? Use of computed fields, use of virtual fields, select the
whole table and sort it inside the app code.. Ideas?
Il giorno lunedì 1 luglio 2013 21:17:25 UTC+2, Niphlod ha scritto:
>
> I'd say by hand writing the mongodb specific query, but I didn't follow
> closely the mongodb adapter implementation to say it for sure. AFAIK, using
> DAL you can only order,filter,etc etc by a field specified in your models.
> What instead you're trying to do is to filter/order by a value that is
> stored WITHIN the field (in your case, a json object).
>
> On Monday, July 1, 2013 8:57:25 PM UTC+2, Giovanni Barillari wrote:
>>
>> Hi all,
>> I've encountered a problem developing a web app with web2py, and would
>> like some suggestions on how to handle it.
>>
>> I'm using web2py (one of the latest trunk versions) with MongoDB, and I
>> have a table with a json field:
>>
>> Field("myfield", "json")
>>
>> which would store a dict() from my app with a variable number of keys, so
>> I don't know in advance how many keys are stored in the dict or what keys
>> the dict contains, so as an example I can have:
>>
>> - row n with myfield = {"a"=int, "b"=int}
>>
>> - row n+1 with myfield = {"c"=int}
>>
>> What I would like to do is to select a limited number of rows from my
>> table querying for a specific key (simplifying: something like
>> db(db.mytable.myfield.key=="something").select()), ordering them by the
>> values of that keys (that are always integers), so the result of the select
>> should be:
>>
>> - row n: myfield.a = 0
>>
>> - row n+1: myfield.a = 1
>>
>> How would you do that?
>>
>> Thanks,
>>
>> /Giovanni
>>
>>
--
---
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.
