Does this mean that your code relied on rows.json() and now the output is
different ?
In other words: can you please state what your application needs from 2.5.1
to work and doesn't with 2.9.5 ?
Did you try with the trunk version ?
On Wednesday, June 4, 2014 11:13:17 AM UTC+2, Massimiliano wrote:
>
> I think that is the problem.
>
> Data from rows.json()
>
> Look at the data structure:
>
> version 2.5.1
>
> u'[{"SUM(qviewriepilogoprevisioni.motrici)": 0, "zona": "ABRUZZO",
> "SUM(qviewriepilogoprevisioni.bilici)": 2,
> "SUM(qviewriepilogoprevisioni.abbinati)": 0, "tratta": "ASCOLI (Ascoli
> Piceno)"}, {"SUM(qviewriepilogoprevisioni.motrici)": 0, "zona": "ABRUZZO",
> "SUM(qviewriepilogoprevisioni.bilici)": 3,
> "SUM(qviewriepilogoprevisioni.abbinati)": 0, "tratta": "C. ABRUZZO
> (Pescara)"}]'
>
> version 2.9.5 Now aggregate fields are under "_extra"
>
> [{"cooptratte": {"tratta": "ASCOLI (Ascoli Piceno)"}, "coopzone": {"zona":
> "ABRUZZO"}, "_extra": {"SUM(qviewriepilogoprevisioni.bilici)": 1,
> "SUM(qviewriepilogoprevisioni.motrici)": 0,
> "SUM(qviewriepilogoprevisioni.abbinati)": 1}}]
>
> Thank you
>
> On Wed, Jun 4, 2014 at 10:47 AM, Niphlod <[email protected] <javascript:>>
> wrote:
>
>> I don't know what to suggest unless you show some code.
>>
>>
>> On Wednesday, June 4, 2014 10:23:29 AM UTC+2, Massimiliano wrote:
>>
>>> I think I explained the problem in the wrong way.
>>>
>>> Before, with the old version of web2py some procedures that make use of
>>> datatable worked very well.
>>> Today we miss some fields... aggregate fields.
>>>
>>> So I was looking for an hint to make the system work again with little
>>> effort :D
>>>
>>> Thank you
>>>
>>>
>>> On Tue, Jun 3, 2014 at 5:26 PM, Niphlod <[email protected]> wrote:
>>>
>>>> it's not a problem. we just changed the way a Rows class gets
>>>> represented (printing resultsets with 1k rows was kynda lame ^_^)
>>>> if you do
>>>>
>>>> print rows
>>>>
>>>> things "change", but
>>>>
>>>> for row in rows:
>>>> print row
>>>>
>>>> doesn't change a bit.
>>>>
>>>>
>>>> On Tuesday, June 3, 2014 12:53:08 PM UTC+2, Massimiliano wrote:
>>>>>
>>>>> Hello,
>>>>>
>>>>> I've an application in production with 2.5.1-stable+timestamp.2013.06
>>>>> .06.15.39.19, and I would like to update at the newest
>>>>> web2py 2.9.5-stable+timestamp.2014.03.16.02.35.39, but I could a
>>>>> problem with aggregate fields.
>>>>>
>>>>> That is what's happen:
>>>>>
>>>>> If I print my Rows var I get:
>>>>> print rows:
>>>>>
>>>>> zone.zona,tratte.tratta,SUM(qviewriepilogoprevisioni.bilici),SUM(
>>>>> qviewriepilogoprevisioni.motrici),SUM(qviewriepilogoprevisioni.
>>>>> abbinati)
>>>>> ABRUZZO,ASCOLI (Ascoli Piceno),3,0,0
>>>>> ABRUZZO,C. ABRUZZO (Pescara),2,0,0
>>>>> ABRUZZO,S.BENEDETTO (),1,0,1
>>>>>
>>>>> BUT if I do something like that:
>>>>>
>>>>> TABLE(rows)
>>>>>
>>>>> I got ONLY the 2 fields zone.zona,tratte.tratta
>>>>>
>>>>> With the old web2py version this wasn't happen.
>>>>> Where can I start to look at this problem?
>>>>>
>>>>> Thank you
>>>>>
>>>>> --
>>>>> Massimiliano
>>>>>
>>>> --
>>>> Resources:
>>>> - http://web2py.com
>>>> - http://web2py.com/book (Documentation)
>>>> - http://github.com/web2py/web2py (Source code)
>>>> - https://code.google.com/p/web2py/issues/list (Report Issues)
>>>> ---
>>>> 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/d/optout.
>>>>
>>>
>>>
>>>
>>> --
>>> Massimiliano
>>>
>> --
>> Resources:
>> - http://web2py.com
>> - http://web2py.com/book (Documentation)
>> - http://github.com/web2py/web2py (Source code)
>> - https://code.google.com/p/web2py/issues/list (Report Issues)
>> ---
>> 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] <javascript:>.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>
>
> --
> Massimiliano
>
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
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/d/optout.
