Hello,
I trying to parse a JSON result sent by Google Custom Search in
web2py. I have the code working in python, but for some reason, it
doesn't work right in web2py and I can't figure out why.
desired output:
----
Title: title_of_the_link
url: URL_of_the_result
----
Title: title_of_the_link
url: URL_of_the_result
----
etc...
here is the python code that works, with just a standard output of the
results
sr = urllib.urlopen(url)
search_results = json.loads(sr.read())
for i in search_results['items']:
print '---'
print 'title:', i['title']
print 'url:', i['link'], '\n'
here is the web2py code with a insert in a db (the db works, so as the
view, the problem is that the information stored is incorrect)
sr = urllib.urlopen(url)
search_results = json.loads(sr.read())
for i in search_results['items']:
db.results.insert(link_title=i['title'])
db.results.insert(url=i['link'])
I am not sure how this works in the first place, I debugged the code,
so I know that the loop works, but it won't catch the title and link.
Any help welcome :-)
