i dZddlmZdZdZy)a  Shared keyword-run tracker. Table: keyword_runs keyword - the keyword (or CPV code) searched source - scraper source name (europa, tendera.at, nipez, etc.) run_date - DATE of the run (today) run_at - full DATETIME when the run completed Usage: from keyword_tracker import is_keyword_done, mark_keyword_done if is_keyword_done(conn, keyword, source): print(f" [SKIP] Already ran today: {keyword}") continue # ... do scraping ... mark_keyword_done(conn, keyword, source) )datec|j}|jd||tjf|j }|j |duS)z4Return True if keyword+source was already run today.zWSELECT 1 FROM keyword_runs WHERE keyword = %s AND source = %s AND run_date = %s LIMIT 1N)cursorexecutertodayfetchoneclose)connkeywordsourcerresults @/var/www/python/tenders/Scrapper/nen.nipez/../keyword_tracker.pyis_keyword_donersN [[]F NNa &$**,'__ F LLN  c|j}|jd||tjf|j |j y)z3Record that keyword+source was completed right now.zWINSERT INTO keyword_runs (keyword, source, run_date, run_at) VALUES (%s, %s, %s, NOW())N)rrrrcommitr )r r r rs rmark_keyword_doner%s@ [[]F NNa &$**,' KKM LLNrN)__doc__datetimerrrrrrs* r