Advertisement
Guest User

Untitled

a guest
Mar 18th, 2018
106
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Python 0.84 KB | None | 0 0
  1. try:
  2.     page = graph.get_object(id=company, fields=fields)
  3.     for key in keys:
  4.         page.setdefault(key, '')
  5.     values = ','.join(['%({})s'.format(k) for k in keys])
  6.     cur.execute("INSERT INTO companies ({0}) VALUES ({1})".format(fields, values), page)
  7.     counter += 1
  8. except facebook.GraphAPIError:
  9.     pages = graph.search(type='page', q=company, fields=['id', 'category'])
  10.     counter += 1
  11.     if pages['data'] != []:
  12.         page_id = min([int(page['id']) for page in pages['data']])
  13.         page = graph.get_object(id=page_id, fields=fields)
  14.         for key in keys:
  15.             page.setdefault(key, '')
  16.         values = ','.join(['%({})s'.format(k) for k in keys])
  17.         cur.execute("INSERT INTO companies ({0}) VALUES ({1})".format(fields, values), page)
  18.         counter += 1
  19.     else:
  20.         not_found.append(company)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement