This is great, thank you! And I don't know why but this is great too, the
update applies *directly* to the data object (I therefore don't have to
create a new one).
Le jeudi 8 novembre 2012 19:27:29 UTC+1, Massimo Di Pierro a écrit :
>
> You can try this. Yet I found some problem as data.json() does not behave
> well as json(data) while they should be the same.
>
> from gluon.serializers import json
>
> db =DAL()
> db.define_table('test',Field('name'),Field('firstname'))
> db.test.insert(name='Test',firstname='Test')
> count = db.test.id.count()
> data = db().select(db.test.ALL,
> count,
> groupby=db.test.id,
> orderby=db.test.name)
> for row in data:
> row.test.newName = row(count)
> del row._extra
> print row
>
> print json(data)
>
> On Thursday, 8 November 2012 11:24:14 UTC-6, dederocks wrote:
>>
>> Hello,
>>
>> If I define a table with
>> define_table('test',Field('name'),Field('firstname'))
>>
>> Then in the controller, I have:
>> count = db.test.id.count()
>> data = db().select(db.test.ALL,
>> count.with_alias('newName'),
>> groupby=db.test.id,
>> orderby=db.test.name)
>>
>> In the view displaying data as json (view.jason) I get:
>>
>> {"data": [{"test": {"name": "UserName", "firstname": "FirstName"},
>> "newName": 1, "_extra": {"COUNT(test.id) AS newName": 1}}, ...
>>
>> Which I thought was not correct, but Massimo said this is the intended
>> behaviour as 'count' does not belong necessarily to a table.
>>
>> So can someone help me and give me a hint on how I could format the json
>> output like:
>>
>> {"data": [{"test": {"name": "UserName", "firstname": "FirstName",
>> "newName": 1}, ... ?
>>
>> Thanks in advance for your feedback!
>> Andre
>>
>
--
