summaryrefslogtreecommitdiff
path: root/app/lib/db.server.ts
AgeCommit message (Collapse)AuthorLines
2026-08-15Add site-wide search for bands and artistsyyamashita-0/+19
Adds a nav search box and /search route backed by a LIKE-based searchAll() query over band name/area/description and artist name.
2026-08-15Add Claude-powered band auto-registration from live info textyyamashita-0/+79
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 <noreply@anthropic.com>
2026-05-11Add lists feature (band recommendation lists with history)yyamashita-0/+150
New lists, list_entries, list_revisions tables; full CRUD routes under /lists; nav link in root. Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
2026-05-10Add band index page sorted by slug, show hiatus status onlyyyamashita-1/+1
Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
2026-05-10Separate current/former members with calculable period datesyyamashita-0/+80
- 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 <noreply@anthropic.com>
2026-05-10Add members table with membership period and note supportyyamashita-68/+107
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 <noreply@anthropic.com>
2026-05-09Add /api/export and /api/import endpoints for DB backup and syncyyamashita-0/+119
Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
2026-05-09Add band description/status fields and redesign index pageyyamashita-4/+21
- 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 <noreply@anthropic.com>
2026-05-09Fix Docker startup: add package.json to app stage, respect DB_PATHyyamashita-1/+1
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 <noreply@anthropic.com>
2026-05-09Implement band/artist management with version historyyyamashita-20/+368
Full CRUD for bands and artists: UUID + slug URLs, dynamic link editor, band-artist associations with roles, per-edit revision snapshots (message + IP). Add README and CLAUDE.md. Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
2026-05-08Initial scaffold: React Router v7 + SQLite + Tailwind CSS v4yyamashita-0/+45
generated by cgit v1.2.3 (git 2.25.1) at 2026-09-13 23:15:53 +0000