whois-band/app/lib, branch master

Add site-wide search for bands and artists

2026-08-15T11:12:25+00:00

Adds a nav search box and /search route backed by a LIKE-based
searchAll() query over band name/area/description and artist name.

Add Claude-powered band auto-registration from live info text

2026-08-15T09:57:59+00:00

Extracts band/artist names from pasted live info via Claude (API or CLI
adapter), matches against existing bands, and lets the user review and
bulk-register new ones through a polling job queue. Also adds a
livehouse events import script and recent-bands/artists home page
sections.

Co-Authored-By: Claude Sonnet 5

Add lists feature (band recommendation lists with history)

2026-05-10T15:06:52+00:00

New lists, list_entries, list_revisions tables; full CRUD routes under /lists; nav link in root.

Co-Authored-By: Claude Sonnet 4.6

Add band index page sorted by slug, show hiatus status only

2026-05-10T13:56:42+00:00

Co-Authored-By: Claude Sonnet 4.6

Separate current/former members with calculable period dates

2026-05-10T13:46:59+00:00

- Add MemberGroup/BandGroup types and groupBandMembers/groupArtistMembers helpers
- Calculate membership duration in months from YYYY-MM since/until values
- Band view splits members into 在籍中 / 元メンバー sections with duration label
- Artist view splits bands into 在籍中 / 元在籍 sections with duration label
- Change since/until inputs to type="month" for structured data entry

Co-Authored-By: Claude Sonnet 4.6

Add members table with membership period and note support

2026-05-09T15:21:04+00:00

Replace band_artists + member_periods with a single members table
(id, band_id, artist_id, role, since, until, note, order_index).
Each row represents one membership period, so rejoining artists
get multiple rows. Existing band_artists data is auto-migrated on
startup. Export format bumped to version 3.

Co-Authored-By: Claude Sonnet 4.6

Add /api/export and /api/import endpoints for DB backup and sync

2026-05-09T05:36:28+00:00

Co-Authored-By: Claude Sonnet 4.6

Add predefined link types and artist roles

2026-05-08T15:51:08+00:00

- app/lib/constants.ts: LINK_TYPES (12種) and ARTIST_ROLES (13種)
- Band link forms: label input → type select (公式サイト, X, Instagram, ...)
- Band member forms: role text → role select (Vocal, Guitar, Bass, ...)
- Band detail: resolve link type key to display label via LINK_TYPE_LABEL

Co-Authored-By: Claude Sonnet 4.6

Add band description/status fields and redesign index page

2026-05-08T15:46:32+00:00

- bands table: add description (TEXT) and status (TEXT DEFAULT 'active')
  via ALTER TABLE migrations (active / hiatus / disbanded)
- Home page: minimal monochrome index listing name, area, status
- Band detail: show description below title, status alongside area
- Band new/edit forms: textarea for description, select for status

Co-Authored-By: Claude Sonnet 4.6

Fix Docker startup: add package.json to app stage, respect DB_PATH

2026-05-08T15:38:42+00:00

npm start requires package.json in the working directory. Also wire
up the DB_PATH env var so the DB is created inside the mounted volume.

Co-Authored-By: Claude Sonnet 4.6