[web2py] Re: Is there a way to use an Alias for a COUNT() field

[Massimo Di Pierro]

You can still do rows.json() even if you add columns to rows or you change 
their values.

On Saturday, 12 May 2012 00:27:49 UTC-5, Franklin Freitas wrote:
>
> If I use what you recommend then what would be the best way to generate 
> the JSON output
>
> Thanks Massimo
>
>
> On Saturday, May 12, 2012 12:29:09 AM UTC-4:30, Massimo Di Pierro wrote:
>>
>> No, but you can do
>>
>> for row in rows: row['count'] = row[count]
>>  
>>
>>
>> On Friday, 11 May 2012 23:44:57 UTC-5, Franklin Freitas wrote:
>>>
>>> Having the following 
>>>
>>> def by_country():
>>> count = db.procesados.idpublicacion.count() 
>>> rows = db().select(db.procesados.pais, count, 
>>> groupby=db.procesados.pais)
>>> return rows.json()
>>>
>>> It generates the JSON:
>>>
>>> [{"pais": "", "COUNT(procesados.idpublicacion)": 236}, {"pais": "AE", 
>>> "COUNT(procesados.idpublicacion)": 3}]
>>>
>>>
>>> Is there a way to assign an Alias to the COUNT field so I won't have that 
>>> long name "COUNT(procesados.idpublicacion)" in the JSON output
>>>
>>>
>>>
>>> Thanks
>>>
>>>

[web2py] Re: Is there a way to use an Alias for a COUNT() field

[Franklin Freitas]

If I use what you recommend then what would be the best way to generate the 
JSON output

Thanks Massimo


On Saturday, May 12, 2012 12:29:09 AM UTC-4:30, Massimo Di Pierro wrote:
>
> No, but you can do
>
> for row in rows: row['count'] = row[count]
>  
>
>
> On Friday, 11 May 2012 23:44:57 UTC-5, Franklin Freitas wrote:
>>
>> Having the following 
>>
>> def by_country():
>> count = db.procesados.idpublicacion.count() 
>> rows = db().select(db.procesados.pais, count, 
>> groupby=db.procesados.pais)
>> return rows.json()
>>
>> It generates the JSON:
>>
>> [{"pais": "", "COUNT(procesados.idpublicacion)": 236}, {"pais": "AE", 
>> "COUNT(procesados.idpublicacion)": 3}]
>>
>>
>> Is there a way to assign an Alias to the COUNT field so I won't have that 
>> long name "COUNT(procesados.idpublicacion)" in the JSON output
>>
>>
>>
>> Thanks
>>
>>

[web2py] Re: Is there a way to use an Alias for a COUNT() field

[Massimo Di Pierro]

No, but you can do

for row in rows: row['count'] = row[count]
 


On Friday, 11 May 2012 23:44:57 UTC-5, Franklin Freitas wrote:
>
> Having the following 
>
> def by_country():
> count = db.procesados.idpublicacion.count() 
> rows = db().select(db.procesados.pais, count, 
> groupby=db.procesados.pais)
> return rows.json()
>
> It generates the JSON:
>
> [{"pais": "", "COUNT(procesados.idpublicacion)": 236}, {"pais": "AE", 
> "COUNT(procesados.idpublicacion)": 3}]
>
>
> Is there a way to assign an Alias to the COUNT field so I won't have that 
> long name "COUNT(procesados.idpublicacion)" in the JSON output
>
>
>
> Thanks
>
>