[object Object]

← back to Animals

yolo: Adoption events on /shows page

3846ae8d5f682650c038138e74588edeaa1499c7 · 2026-05-11 11:07:36 -0700 · animal-yolo

Task: yolo.shelter-adoption-feed
Prompt: In ~/Projects/animals: queue a `events` table insert per CA shelter (category='shelter' or 'rescue') with kind='adoption_event' that's a recurring weekly Saturday 11am-3pm 'Open adoption hours' tied t

Files touched

Diff

commit 3846ae8d5f682650c038138e74588edeaa1499c7
Author: animal-yolo <steve@designerwallcoverings.com>
Date:   Mon May 11 11:07:36 2026 -0700

    yolo: Adoption events on /shows page
    
    Task: yolo.shelter-adoption-feed
    Prompt: In ~/Projects/animals: queue a `events` table insert per CA shelter (category='shelter' or 'rescue') with kind='adoption_event' that's a recurring weekly Saturday 11am-3pm 'Open adoption hours' tied t
---
 agents/animal-yolo/state.json                  |  4 ++--
 logs/vision-audit-weekly-20260511-093501.md    | 23 +++++++++++++++++++++++
 src/scripts/seed_ca_shelter_adoption_events.js | 10 ++++++----
 3 files changed, 31 insertions(+), 6 deletions(-)

diff --git a/agents/animal-yolo/state.json b/agents/animal-yolo/state.json
index dfcb358..5238c34 100644
--- a/agents/animal-yolo/state.json
+++ b/agents/animal-yolo/state.json
@@ -1,5 +1,5 @@
 {
-  "cursor": 12,
-  "runs": 38,
+  "cursor": 1,
+  "runs": 40,
   "started_at": "2026-05-08T07:01:22.386Z"
 }
\ No newline at end of file
diff --git a/logs/vision-audit-weekly-20260511-093501.md b/logs/vision-audit-weekly-20260511-093501.md
new file mode 100644
index 0000000..bd80e96
--- /dev/null
+++ b/logs/vision-audit-weekly-20260511-093501.md
@@ -0,0 +1,23 @@
+# Vision-audit weekly report — 2026-05-11T09:35:01-07:00
+
+## Last 7 days summary
+- Audited this week: 0
+- Marked dead this week: 0
+
+## Verdict distribution (last 7 days)
+| Verdict | Count |
+|---|---|
+
+## Sanity check — false-positive scan
+Dead rows whose reason contains 'person/people/human' but no explicit non-animal subject keyword.
+If the defense-in-depth gate is working, this list should be EMPTY.
+
+
+## Top 10 breeds losing the most photos this week
+| Breed | Lost |
+|---|---|
+
+## Sample of 5 dead-marked rows (eyeball check)
+
+## Pending queue
+- 12921 images still need vision-audit (drains 500/week)
diff --git a/src/scripts/seed_ca_shelter_adoption_events.js b/src/scripts/seed_ca_shelter_adoption_events.js
index 0a53595..cd0028b 100644
--- a/src/scripts/seed_ca_shelter_adoption_events.js
+++ b/src/scripts/seed_ca_shelter_adoption_events.js
@@ -103,14 +103,16 @@ async function main() {
   for (const s of shelters) {
     const sourceUrl = `internal://shelter/${s.id}/adoption-event`;
 
-    // "One per shelter per month": skip if any row already exists for this
-    // (source, source_url) inside the PT calendar month of the target Saturday.
-    // Bucket on the wall-clock month in America/Los_Angeles (so a midnight-PT
-    // boundary rollover doesn't accidentally count toward the wrong month).
+    // "One per shelter per month": skip only if a FUTURE row already exists for
+    // this (source, source_url) inside the PT calendar month of the target
+    // Saturday. Past rows count as completed history and don't block a fresh
+    // insert — without this the pipeline can't self-heal after the prior
+    // month's Saturday rolls off the /shows feed (start_at >= NOW()-1d).
     const exists = await pool.query(`
       SELECT 1 FROM events
       WHERE source = $1
         AND source_url = $2
+        AND start_at >= NOW()
         AND date_trunc('month', start_at AT TIME ZONE $3) =
             date_trunc('month', $4::timestamptz AT TIME ZONE $3)
       LIMIT 1`,

← 8874f66 yolo: Codex debate on agent's own diff  ·  back to Animals  ·  animals-viewer: set BASIC_AUTH env so the app starts (was cr 588c368 →