Fetch Meta from KB

Workflow

1. Read DB env vars from .env or process env: KB_DB_HOST, KB_DB_PORT, KB_DB_NAME, KB_DB_USER, KB_DB_PASSWORD.
2. Query journals where created_at >= now_utc - DAYS, ordered by created_at DESC, selecting only doi, title, abstract, date.
3. Return/write JSON array records with exactly these fields: doi, title, abstract, date.

Script

Run:

cd fetch-meta-from-kb
python3 scripts/fetch_meta_from_kb.py --days 7 --output selected-abstract.json

Env example: