def main():
#Select companies that don't have any articles
companies = Company.raw(
"""
Select *
FROM company
WHERE id not in (
SELECT company_id
from news
)
"""
)
ns = NewsSource.select().where(NewsSource.name=='Reuters').get()
for c in companies:
print "Finding stories about "+c.name
firstURL = baseURL+'/search?blob="'+c.name.replace(' ','+')+'"'
readSearchPage(c,ns,firstURL,1)
print 'DONE!'
