def populate_topsites(num=100):
sites = alexa.topsites(num)
for s in sites:
q = db.session.query(Website).filter_by(url=s['url'])
w = q.first()
if not w:
w = Website(url=s['url'])
w.global_rank = s['global_rank']
w.reach_per_million = s['reach_per_million']
w.page_views_per_million = s['page_views_per_million']
w.page_views_per_user = s['page_views_per_user']
print "Adding %s" % w.url
db.session.add(w)
db.session.commit()
print "Finished updating topsites ====================\n"
