def _get_wanted_info():
db_service = DBService(host=Config.get('db.url'),
user=Config.get('db.username'),
password=Config.get('db.password'),
db=Config.get('db.name'),
charset='utf8')
return db_service.select_one(QueryMapper.select_recruitment_site_query,
'Wanted')
def store_to_db(recruit_notices, site_seq):
db_service = DBService(host=Config.get('db.url'),
user=Config.get('db.username'),
password=Config.get('db.password'),
db=Config.get('db.name'),
charset='utf8')
cursor = db_service.get_cursor()
for recruit_notice in recruit_notices:
cursor.execute(QueryMapper.insert_raw_collection_query,
(site_seq, recruit_notice['company'],
recruit_notice['condition_type'].value))
raw_collection_id = db_service.get_last_id()
keywords = recruit_notice['keywords']
for keyword in keywords:
cursor.execute(QueryMapper.insert_raw_word_query,
(keyword, raw_collection_id))
db_service.commit_and_close()
