Mind that this is old syntax:
r._extra['sum(panel_1hrs.Po_avg)']
it is equivalent and better to use:
r[db.panel_1hrs.Po_avg.sum()]
On Jan 15, 2:29 pm, Michael Toomim <too...@gmail.com> wrote:
> I find it easiest and cleanest to reformat data structures in python,
> using list comprehensions. Javascript sucks for loops. So instead of
> jsonifying the raw database output, fix it first:
>
> export_optimizer_records = [{'FreezeTime': r.panel_1hrs.FreezeTime,
> 'StringID': r.panel_1hrs.StringID, 'Po_avg_sum':
> r._extra['sum(panel_1hrs.Po_avg)']} for r in export_optimizer_records]
>
> Basically, just add this line to your controller.
>
> On Jan 14, 5:58 pm, Lorin Rivers <lriv...@mosasaur.com> wrote:
>
>
>
>
>
>
>
> > Controller:
> > export_optimizer_records =
> > dbset(db.table.FreezeTime,db.table.StringID,db.table.Po_avg.sum(),groupby=.
> > .FreezeTime|..StringID).as_list()
>
> > View:
> > var optimizerdata = {{response.write(json(export_optimizer_records),
> > escape=False)}};
>
> > The JSON looks like this:
>
> > [{
> > "panel_1hrs": {
> > "FreezeTime": "2010-12-12 19:00:00",
> > "StringID": "S00000001"
> > },
> > "_extra": {
> > "sum(panel_1hrs.Po_avg)": 519.912549612443
> > }},
>
> > {
> > "panel_1hrs": {
> > "FreezeTime": "2010-12-12 19:00:00",
> > "StringID": "S00000002"
> > },
> > "_extra": {
> > "sum(panel_1hrs.Po_avg)": 532.390706326218
> > }
>
> > }]
>
> > What I want is this:
>
> > [{
> > "FreezeTime": "2010-12-12 19:00:00",
> > "StringID": "S00000001",
> > "Po_avg_sum": 519.912549612443},
>
> > {
> > "FreezeTime": "2010-12-12 19:00:00",
> > "StringID": "S00000002",
> > "Po_avg_sum": 532.390706326218
>
> > }]
>
> > What's the easiest way to get that?
> > --
> > Lorin Rivers
> > Mosasaur: Killer Technical Marketing <http://www.mosasaur.com>
> > <mailto:lriv...@mosasaur.com>
> > 512/203.3198 (m)
