I cannot make JSON data correctly. (The result of below has duplicate data
with the word <Row:
result = dict()
for r in new_roots:
result[r] = '{"title": ' + '"' + r.taxonomy_column_name + '"' + ',
"key":' + str(r.id) + ', "parentId":' + '2' + ', "folder": false,
"lazy": true},'
Output looks like below.
{<Row {'taxonomy_column_name': 'Battlespace Networks',
'taxonomy_column_parent_fk': 17L, 'id': 18L}>: '{"title": "Battlespace
Networks", "key":18, "parentId":2, "folder": false, "lazy": true},', <Row
{'taxonomy_column_name': 'Municipality', 'taxonomy_column_parent_fk': 24L,
'id': 26L}>: '{"title": "Municipality", "key":26, "parentId":2, "folder":
false, "lazy": true},', <Row {'taxonomy_column_name': 'Service cross
reference', 'taxonomy_column_parent_fk': 14L, 'id': 15L}>: '{"title":
"Service cross reference", "key":15, "parentId":2, "folder": false, "lazy":
true},', <Row {'taxonomy_column_name': 'IT System',
'taxonomy_column_parent_fk': None, 'id': 32L}>: '{"title": "IT System",
"key":32, "parentId":2, "folder": false, "lazy": true},', <Row
{'taxonomy_column_name': 'Federal US government',
'taxonomy_column_parent_fk': None, 'id': 3L}>: '{"title": "Federal US
government", "key":3, "parentId":2, "folder": false, "lazy": true},', <Row
{'taxonomy_column_name': 'Province', 'taxonomy_column_parent_fk': 24L,
'id': 25L}>: '{"title": "Province", "key":25, "parentId":2, "folder":
false, "lazy": true},', <Row {'taxonomy_column_name': 'County',
'taxonomy_column_parent_fk': 4L, 'id': 5L}>: '{"title": "County", "key":5,
"parentId":2, "folder": false, "lazy": true},', <Row
{'taxonomy_column_name': 'Executive Branch', 'taxonomy_column_parent_fk':
None, 'id': 8L}>: '{"title": "Executive Branch", "key":8, "parentId":2,
"folder": false, "lazy": true},', <Row {'taxonomy_column_name': 'Council of
Ministers', 'taxonomy_column_parent_fk': None, 'id': 20L}>: '{"title":
"Council of Ministers", "key":20, "parentId":2, "folder": false, "lazy":
true},'}
Is there a python "JSON.parse" function I can use to make it valid JSON
(https://jsonformatter.curiousconcept.com/)?
I tried this
for r in new_roots:
result[r] = gluon.contrib.simplejson.loads('{"title": ' + '"' +
r.taxonomy_column_name
+ '"' + ', "key":' + str(r.id) + ', "parentId":' + '2' + ', "folder":
false, "lazy": true}')
but data came out encoded as below:
{<Row {'taxonomy_column_name': 'Province', 'taxonomy_column_parent_fk':
24L, 'id': 25L}>: {u'folder': False, u'parentId': 2, u'lazy': True, u'key':
25, u'title': u'Province'},
Tried this:
result[r] = json.dumps({"title" + ':' + str(r.taxonomy_column_name) + ',
' + "key" + ':' + str(r.id) + ', ' + "parentId" + ':' + '2' + ', ' +
"folder" + ':' + 'false' + ', ' + "lazy" + ':' + 'true'})
but data resulted in:
*<type 'exceptions.TypeError'> set(['title:Defense and National Security,
key:16, parentId:2, folder:false, lazy:true']) is not JSON serializable*
Is it supposed to go into a dict like that?
thanks,
Alex Glaros
--
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.
