11 lines
586 B
Python
11 lines
586 B
Python
"""SQLite persistence layer: companies table, jobs table, dedup, company cache, CSV export.
|
|
|
|
Scaffold stub -- not implemented yet.
|
|
"""
|
|
# TODO (Stage 4): implement per CLAUDE.md "Stage 4 — Persist & export" and "Data model".
|
|
# Schema:
|
|
# companies(company_key PK, name, website, career_url, first_seen)
|
|
# jobs(job_id PK, company_key, linkedin_url, position_url, status, listed_at, first_seen)
|
|
# CSV export writes output/results.csv with columns: company_name, career_page_url, open_position_url
|
|
# (complete rows — status==position_found — sorted first; incomplete rows follow).
|