2019-08-09 22:25:29 SELECT "CLEARBIT_CACHE".rowid AS "CLEARBIT_CACHE_rowid", "CLEARBIT_CACHE".name_part AS "CLEARBIT_CACHE_name_part", "CLEARBIT_CACHE".name AS "CLEARBIT_CACHE_name", "CLEARBIT_CACHE".domain AS "CLEARBIT_CACHE_domain", "CLEARBIT_CACHE".logo AS "CLEARBIT_CACHE_logo", "CLEARBIT_CACHE".collected_at AS "CLEARBIT_CACHE_collected_at"
FROM "CLEARBIT_CACHE"
WHERE "CLEARBIT_CACHE".name_part = ?
2019-08-09 22:25:29 ('brianne',)
2019-08-09 22:25:29 Job "job_function (trigger: interval[0:02:00], next run at: 2019-08-09 22:27:26.234582)" raised an exception
Traceback (most recent call last):
File "/Users/rj/anaconda3/envs/py36/lib/python3.6/site-packages/apscheduler/scheduler.py", line 512, in _run_job
retval = job.func(*job.args, **job.kwargs)
File "app.py", line 33, in job_function
c_sched.run_site_collector_scheduler()
File "/Users/rj/projects/category_search/scheduler/collector_scheduler.py", line 46, in run_site_collector_scheduler
exec_time_seconds, exec_time_minutes = bs.add_brands_from_search_links(category_id, limit, offset)
File "/Users/rj/projects/category_search/services/brand_service.py", line 48, in add_brands_from_search_links
brand_links = k_util.get_brand_details_with_links(category_type_plain, brand_type, search_links)
File "/Users/rj/projects/category_search/utils/kwikee_util.py", line 127, in get_brand_details_with_links
current_brand_links = nlu.get_category_websites(content, brand_type_plain)
File "/Users/rj/projects/category_search/nltk_util.py", line 149, in get_category_websites
name, domain, logo = cbu.get_domains(brand_name_part)
File "/Users/rj/projects/category_search/clearbit_util.py", line 31, in get_domains
clearbit_cache = dbs.get_clearbit_cache_by_namepart(word)
File "/Users/rj/projects/category_search/services/db_service.py", line 485, in get_clearbit_cache_by_namepart
category_dict = session.query(ClearbitCache).filter_by(name_part = c_name_part).one()
File "/Users/rj/anaconda3/envs/py36/lib/python3.6/site-packages/sqlalchemy/orm/query.py", line 3282, in one
raise orm_exc.NoResultFound("No row was found for one()")
sqlalchemy.orm.exc.NoResultFound: No row was found for one()