I think so
On Apr 20, 6:09 pm, Rafael Sales <rafael...@gmail.com> wrote:
> Hello,
> I'm facing a very tricky error with JSON.
> I have an action that must return a json object with the results of a
> select. The select must return fields from two tables. When I use this
> kind of select return fields from two or more tables, the simple json
> cannot serialize the result of the select.
> [Code A] Here's my code:
> def getDespesasPorHospedagem():
> id_locado = request.vars.id_locado
> if id_locado == None:
> return response.json({'despesas': []})
>
> orderBy = db.despesa.id.lower()
> query = ((db.despesa.id_locado == id_locado) &
> (db.despesa.id_servico == db.servico.id))
> despesas = db(query).select(db.despesa.ALL, db.servico.ALL,
> orderby = orderBy)
>
> return response.json({'despesas': despesas})
>
> Invoking the URL (.../getDespesasPorHospedagem?id_locado=100) throws
> the following error:http://pastebin.com/PsX8dD4e
> Changing the return expressions respectively to: "return dict(despesas
> = [])" and "return dict(despesas = despesas)", the URL above works
> without any error and shows the result dictionary, but:
> - the URL (.../getDespesasPorHospedagem.json?id_locado=100) returns
> "no json" and
> - the URL (.../getDespesasPorHospedagem.xml?id_locado=100) returns
> the correct XML.
>
> [Code B]
> When I change my action as below, which have the same effect for me
> although less concise, the return object can be serialized
> successfully. And note that I'm using the same queries:
> def getDespesasPorHospedagem():
> id_locado = request.vars.id_locado
> if id_locado == None:
> return response.json({'despesas': [], 'servicos': []})
>
> orderBy = db.despesa.id.lower()
> query = ((db.despesa.id_locado == id_locado) &
> (db.despesa.id_servico == db.servico.id))
> despesas = db(query).select(db.despesa.ALL, orderby = orderBy)
>
> orderBy = db.despesa.id.lower()
> query = ((db.despesa.id_locado == id_locado) &
> (db.despesa.id_servico == db.servico.id))
> servicos = db(query).select(db.servico.ALL, orderby = orderBy)
>
> return response.json({'despesas': despesas, 'servicos': servicos})
>
> So... is this a bug?
> Rafael Sales
