just testing several code that return json *e.g.* *controllers/api.py* def json_rows_as_list(): import json query = (db.auth_user.id > 0) rows = db(query).select() json_list = json.dumps(rows.as_list(), default = str, sort_keys = True) return dict(results = XML(json_list) )
""" curl -X GET --user admin:password -i http://127.0.0.1:8000/test/api/json_rows_as_list curl -X GET --user admin:password -i http://127.0.0.1:8000/test/api/json_rows_as_list.json """ def simplejson_rows_as_list(): import gluon.contrib.simplejson query = (db.auth_user.id > 0) rows = db(query).select() json_list = gluon.contrib.simplejson.dumps(rows.as_list(), default = str, sort_keys = True) return dict(results = XML(json_list) ) """ curl -X GET --user admin:password -i http://127.0.0.1:8000/test/api/simplejson_rows_as_list curl -X GET --user admin:password -i http://127.0.0.1:8000/test/api/simplejson_rows_as_list.json """ def response_json_rows_as_list(): query = (db.auth_user.id > 0) rows = db(query).select() return response.json(rows.as_list() ) """ curl -X GET --user admin:password -i http://127.0.0.1:8000/test/api/response_json_rows_as_list curl -X GET --user admin:password -i http://127.0.0.1:8000/test/api/response_json_rows_as_list.json """ @request.restful() def restful_json_rows_as_list(): def GET(): query = (db.auth_user.id > 0) rows = db(query).select() return response.json(rows.as_list() ) return locals() """ curl -X GET --user admin:password -i http://127.0.0.1:8000/test/api/restful_json_rows_as_list curl -X GET --user admin:password -i http://127.0.0.1:8000/test/api/restful_json_rows_as_list.json """ is there any different in performance or anything between the way to return json ? thanks and best regards, stifan -- 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 web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.