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()