Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- try:
- page = graph.get_object(id=company, fields=fields)
- for key in keys:
- page.setdefault(key, '')
- values = ','.join(['%({})s'.format(k) for k in keys])
- cur.execute("INSERT INTO companies ({0}) VALUES ({1})".format(fields, values), page)
- counter += 1
- except facebook.GraphAPIError:
- pages = graph.search(type='page', q=company, fields=['id', 'category'])
- counter += 1
- if pages['data'] != []:
- page_id = min([int(page['id']) for page in pages['data']])
- page = graph.get_object(id=page_id, fields=fields)
- for key in keys:
- page.setdefault(key, '')
- values = ','.join(['%({})s'.format(k) for k in keys])
- cur.execute("INSERT INTO companies ({0}) VALUES ({1})".format(fields, values), page)
- counter += 1
- else:
- not_found.append(company)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement