SDCC Stories — build journal

Search the build

5 commits indexed

dbfa7ca 2026-06-01 Global search across candidates + stories + settings
8c69aad 2026-05-30 gitignore: add *.bak-* *.pre-* *.orig patterns to prevent backup file leaks
795a4f4 2026-05-30 security: strip hardcoded dw_admin DSN password -> env-first. No rotation/deploy.
ae4222d 2026-05-13 snapshot: 2 file(s) changed, ~2 modified
5f05dd4 2026-05-06 initial scaffold (gitify-all 2026-05-06)

Authors

Steve4
steve1

Agents used

none detected

Skills used

/candidates1
/search1
/token1
/index1
/styles1
/app1
/deploy1

Creative ideas + design notes

Commits with substantial prose (≥120 chars) — the rationale behind each move.

dbfa7ca · 2026-06-01 · Global search across candidates + stories + settings

Add a unified search bar to the SDCC-Stories admin header. Replaces the
narrow ?search= filter on /api/candidates (which only hit 3 columns)
with cross-table coverage.

server.js
  GET /api/search?q=<query>&limit=25 — searches:
    · candidates (name, email, zip, story, key_quote, demographics,
      district, representative, story_category, press_pitch_angle,
      story_type, tier — 18 LIKE columns)
    · stories (one_liner, instagram_caption, x_post, hashtags,
      story_category, lane, status)
    · settings (key + value — credential values masked as
      '(set — N chars)' for keys matching /token|secret|password|key$/i)
  Returns unified {results, query, counts, total} grouped by type.

public/index.html
  Add header-center search input + results panel.

public/css/styles.css
  .global-search-* styles matching the existing light theme.

public/js/app.js
  Debounced 220ms search → fetch → grouped render.
  Cmd+K / Ctrl+K focuses input. Esc closes. Arrow keys + Enter.
  Click-through: candidate → switchTab + openCandidate;
                  story → switchTab + scroll-into-view;
                  setting → switchTab('settings').
  Story cards get data-story-id so the scroll-into-view works.

Co-Authored-By: Claude Opus 4.7 (1M context) <noreply@anthropic.com>

File tree

15 files tracked. Click any to browse the source at HEAD.

Other build journals

← PoppyPetitions · all 4 projects · Sascha →

Export

commits.csv · feed.atom · project.json · commits.json