Marketplace: scheduled topic discovery and hourly refresh #917

Parent

#913 · #18

What to build

Authors no longer need to paste a URL: a repository that adds the botharness-bot topic appears in the Bot Marketplace after the next daily discovery, and listed entries stay current. Discovery runs a full GitHub topic search sliced by repository creation date so each slice stays under the 1,000-result cap (subdividing a slice that hits the cap). Refresh runs hourly through authenticated GraphQL nodes batches of 100 for stars, pushed_at, topics, description, visibility, archived state and head commit, refetching README only when pushed_at changed. Losing the topic, going private, archived or deleted hides an entry (row kept); a rename or transfer keeps the same entry; a failed batch keeps the last good data.

Acceptance criteria

• Daily scheduled discovery adds new topic repositories and marks no-longer-matching ones hidden_missing.
• Date slicing keeps every search below 1,000 results and subdivides a full slice.
• Hourly refresh updates stars/pushed_at/topics/description/head commit in batches of 100 and refetches README only after a push change.
• Topic removal, private, archived or deleted hides the entry; restoring the condition lists it again.
• A renamed or transferred repository keeps its entry (node ID identity) with the new owner/name/URL.
• A GitHub failure during a batch leaves existing rows untouched.
• Worker boundary tests with a fake GitHub cover slicing, batching, hiding/restoring, rename and failure.

Blocked by

• Tracer: paste a GitHub repo, see it in the Marketplace modal, install it #916