Add lists feature (band recommendation lists with history)

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>

1 files changed, 137 insertions, 0 deletions

diff --git a/app/routes/list-edit.tsx b/app/routes/list-edit.tsx
new file mode 100644
index 0000000..5d47737
--- /dev/null
+++ b/app/routes/list-edit.tsx
@@ -0,0 +1,137 @@
+import { useState } from "react";
+import { data, Form, Link, redirect, useActionData, useLoaderData } from "react-router";
+import type { ActionFunctionArgs, LoaderFunctionArgs } from "react-router";
+import {
+  getBandListById,
+  getListEntries,
+  getIpAddress,
+  updateBandList,
+  type ListEntryInput,
+} from "~/lib/db.server";
+
+export async function loader({ params }: LoaderFunctionArgs) {
+  const list = getBandListById(params.uuid!);
+  if (!list) throw data("Not found", { status: 404 });
+  const entries = getListEntries(list.id);
+  return { list, entries };
+}
+
+export async function action({ params, request }: ActionFunctionArgs) {
+  const list = getBandListById(params.uuid!);
+  if (!list) throw data("Not found", { status: 404 });
+
+  const fd = await request.formData();
+  const title = (fd.get("title") as string).trim();
+  const slug = (fd.get("slug") as string).trim();
+  const description = (fd.get("description") as string).trim();
+  const message = (fd.get("message") as string).trim();
+  const entries: ListEntryInput[] = JSON.parse((fd.get("entries") as string) || "[]");
+
+  const errors: Record<string, string> = {};
+  if (!title) errors.title = "必須です";
+  if (!slug) errors.slug = "必須です";
+  if (!message) errors.message = "必須です";
+  if (Object.keys(errors).length > 0) return { errors };
+
+  try {
+    updateBandList(list.id, { slug, title, description, entries, message, ip_address: getIpAddress(request) });
+  } catch (e) {
+    if (e instanceof Error && e.message.includes("UNIQUE constraint failed: lists.slug")) {
+      return { errors: { slug: "このslugは既に使用されています" } };
+    }
+    throw e;
+  }
+  return redirect(`/lists/of/${list.id}`);
+}
+
+type EntryRow = { key: string; band_name: string; note: string };
+
+export default function ListEdit() {
+  const { list, entries: initEntries } = useLoaderData<typeof loader>();
+  const actionData = useActionData<typeof action>();
+  const errors = actionData?.errors ?? {};
+
+  const [title, setTitle] = useState(list.title);
+  const [slug, setSlug] = useState(list.slug);
+  const [description, setDescription] = useState(list.description);
+  const [entries, setEntries] = useState<EntryRow[]>(
+    initEntries.map((e) => ({ key: crypto.randomUUID(), band_name: e.band_name, note: e.note }))
+  );
+
+  function addEntry() {
+    setEntries((prev) => [...prev, { key: crypto.randomUUID(), band_name: "", note: "" }]);
+  }
+
+  function removeEntry(key: string) {
+    setEntries((prev) => prev.filter((e) => e.key !== key));
+  }
+
+  function updateEntry(key: string, field: "band_name" | "note", value: string) {
+    setEntries((prev) => prev.map((e) => e.key === key ? { ...e, [field]: value } : e));
+  }
+
+  return (
+    <main>
+      <div className="page-header">
+        <Link to={`/lists/of/${list.id}`} className="back">←</Link>
+        <h1>{list.title} — 編集</h1>
+      </div>
+
+      <Form method="post">
+        <input type="hidden" name="entries" value={JSON.stringify(entries.map(({ band_name, note }) => ({ band_name, note })))} />
+
+        <div>
+          <label>タイトル <span className="req">*</span></label>
+          <input name="title" value={title} onChange={(e) => setTitle(e.target.value)} />
+          {errors.title && <p className="error">{errors.title}</p>}
+        </div>
+
+        <div>
+          <label>Slug <span className="req">*</span></label>
+          <input name="slug" value={slug} onChange={(e) => setSlug(e.target.value)} className="mono" />
+          {errors.slug && <p className="error">{errors.slug}</p>}
+        </div>
+
+        <div>
+          <label>説明</label>
+          <input name="description" value={description} onChange={(e) => setDescription(e.target.value)} />
+        </div>
+
+        <div>
+          <label>エントリ</label>
+          <div>
+            {entries.map((entry) => (
+              <div key={entry.key} className="entry-row">
+                <input
+                  className="band-input"
+                  value={entry.band_name}
+                  onChange={(e) => updateEntry(entry.key, "band_name", e.target.value)}
+                  placeholder="バンド名"
+                />
+                <input
+                  className="note-input"
+                  value={entry.note}
+                  onChange={(e) => updateEntry(entry.key, "note", e.target.value)}
+                  placeholder="メモ"
+                />
+                <button type="button" className="btn-icon" onClick={() => removeEntry(entry.key)}>×</button>
+              </div>
+            ))}
+          </div>
+          <button type="button" className="btn-text" onClick={addEntry}>+ エントリを追加</button>
+        </div>
+
+        <div>
+          <label>更新メッセージ <span className="req">*</span></label>
+          <input name="message" placeholder="例: エントリ追加" />
+          {errors.message && <p className="error">{errors.message}</p>}
+        </div>
+
+        <div className="actions">
+          <button type="submit">保存</button>
+          <Link to={`/lists/of/${list.id}`} className="btn">キャンセル</Link>
+        </div>
+      </Form>
+    </main>
+  );
+}