\n \n\n\n",[],[59,109],"d575e13e-f5ef-481a-b5c6-9878aac203f9","api.ts","3682dcd2-7de0-11f1-80e2-1607ee4eb77e",5,["D",1783853736579],"const KEY = \"vocab_token\";\n\nexport const getToken = (): string | null => localStorage.getItem(KEY);\nexport const setToken = (t: string | null): void => {\n if (t) localStorage.setItem(KEY, t);\n else localStorage.removeItem(KEY);\n};\n\nexport async function api(path: string, opts: RequestInit = {}): Promise {\n const headers: Record = {\n \"Content-Type\": \"application/json\",\n ...(opts.headers as Record || {}),\n };\n const t = getToken();\n if (t) headers.Authorization = `Bearer ${t}`;\n const res = await fetch(path, { ...opts, headers });\n let data: any = {};\n try {\n data = await res.json();\n } catch { /* non-JSON response */ }\n if (!res.ok) throw new Error(data.error || `エラーが発生しました (${res.status})`);\n return data;\n}\n",[],[59,116],"061dd3dd-dbdc-413a-9793-c6ad7999ad20","WordPicker.tsx","dce212ae-7e0e-11f1-8d9a-1607ee4eb77e",17,["D",1783873772549],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useState } from \"https://esm.sh/react@18.2.0\";\nimport { api } from \"./api.ts\";\n\nexport default function WordPicker(\n { fields, words, myWordIds, refresh }: {\n fields: any[];\n words: any[];\n myWordIds: number[];\n refresh: () => Promise;\n },\n) {\n const [q, setQ] = useState(\"\");\n const [busyId, setBusyId] = useState(null);\n const [error, setError] = useState(\"\");\n\n const my = new Set(myWordIds);\n const frontField = fields.find((f) => f.side === \"front\");\n const meaningField = fields.find((f) => f.name.includes(\"意味\") && !f.name.includes(\"例文\"));\n\n const label = (w: any) => (frontField ? w.data[String(frontField.id)] || \"\" : \"\");\n const sub = (w: any) => (meaningField ? w.data[String(meaningField.id)] || \"\" : \"\");\n\n const needle = q.trim().toLowerCase();\n const filtered = needle\n ? words.filter((w) => Object.values(w.data).some((v) => String(v).toLowerCase().includes(needle)))\n : words;\n\n const toggle = async (w: any) => {\n setBusyId(w.id);\n setError(\"\");\n try {\n if (my.has(w.id)) {\n await api(`/api/my-words/${w.id}`, { method: \"DELETE\" });\n } else {\n await api(\"/api/my-words\", { method: \"POST\", body: JSON.stringify({ wordId: w.id }) });\n }\n await refresh();\n } catch (e: any) {\n setError(e.message);\n } finally {\n setBusyId(null);\n }\n };\n\n return (\n

🗂 単語を選んでマイ単語帳を作る

\n マイ単語帳: {myWordIds.length} 語\n

\n\n {error &&

{error}

}\n\n setQ(e.target.value)}\n placeholder=\"検索（単語・意味など）\"\n className=\"border border-gray-200 rounded-xl px-4 py-2.5 bg-white focus:outline-none focus:ring-2 focus:ring-indigo-300\"\n />\n\n

\n {filtered.length === 0 && (\n

該当する単語がありません

\n )}\n {filtered.map((w) => {\n const added = my.has(w.id);\n return (\n \n

{label(w)}

{sub(w)}

\n toggle(w)}\n disabled={busyId === w.id}\n className={`shrink-0 rounded-xl px-4 py-2 text-sm font-bold transition disabled:opacity-50 ${\n added\n ? \"bg-white border border-gray-200 text-gray-500 hover:bg-gray-50\"\n : \"bg-indigo-600 text-white hover:bg-indigo-700\"\n }`}\n >\n {busyId === w.id ? \"...\" : added ? \"✓ 追加済み\" : \"＋追加\"}\n \n

\n );\n })}\n

\n \n );\n}\n",[],[59,124],"f21049dc-92f1-4d50-a5ad-f9755c7beb3c","Login.tsx","4439f784-7de0-11f1-938d-1607ee4eb77e",8,["D",1783853759578],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useState } from \"https://esm.sh/react@18.2.0\";\nimport { api, setToken } from \"./api.ts\";\n\nexport default function Login({ onLogin }: { onLogin: (user: any) => void }) {\n const [mode, setMode] = useState<\"login\" | \"register\">(\"login\");\n const [username, setUsername] = useState(\"\");\n const [password, setPassword] = useState(\"\");\n const [error, setError] = useState(\"\");\n const [busy, setBusy] = useState(false);\n\n const submit = async (e: any) => {\n e.preventDefault();\n setBusy(true);\n setError(\"\");\n try {\n const r = await api(mode === \"login\" ? \"/api/login\" : \"/api/register\", {\n method: \"POST\",\n body: JSON.stringify({ username, password }),\n });\n setToken(r.token);\n onLogin(r.user);\n } catch (err: any) {\n setError(err.message);\n } finally {\n setBusy(false);\n }\n };\n\n return (\n

📖

発音単語帳

タップして発音を聞ける英単語カード

\n {error &&

{error}

}\n setUsername(e.target.value)}\n placeholder=\"ユーザー名\"\n autoComplete=\"username\"\n className=\"border border-gray-200 rounded-xl px-4 py-2.5 focus:outline-none focus:ring-2 focus:ring-indigo-300\"\n />\n setPassword(e.target.value)}\n placeholder=\"パスワード（6文字以上）\"\n autoComplete={mode === \"login\" ? \"current-password\" : \"new-password\"}\n className=\"border border-gray-200 rounded-xl px-4 py-2.5 focus:outline-none focus:ring-2 focus:ring-indigo-300\"\n />\n \n {busy ? \"処理中...\" : mode === \"login\" ? \"ログイン\" : \"新規登録\"}\n \n { setMode(mode === \"login\" ? \"register\" : \"login\"); setError(\"\"); }}\n className=\"text-sm text-indigo-500 hover:underline\"\n >\n {mode === \"login\" ? \"アカウントを作成する\" : \"ログイン画面へ戻る\"}\n \n \n

\n );\n}\n",[],[59,132],"f774106e-017b-45a6-81a1-5a450b38728f","FlashCards.tsx","5280c30e-7de0-11f1-bc93-1607ee4eb77e",20,["D",1783873824417],3,"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useRef, useState } from \"https://esm.sh/react@18.2.0\";\nimport { speak } from \"./speech.ts\";\n\ninterface Field {\n id: number;\n name: string;\n side: string;\n speak: number;\n sort_order: number;\n}\n\ninterface Word {\n id: number;\n data: Record;\n}\n\nexport default function FlashCards(\n { fields, words, onGoPick }: { fields: Field[]; words: Word[]; onGoPick?: () => void },\n) {\n const [index, setIndex] = useState(0);\n const [flipped, setFlipped] = useState(false);\n const [slide, setSlide] = useState(\"\");\n const start = useRef<{ x: number; y: number } | null>(null);\n const handled = useRef(false);\n const captured = useRef(false);\n const swiped = useRef(false);\n\n const frontFields = fields.filter((f) => f.side === \"front\");\n const backFields = fields.filter((f) => f.side !== \"front\");\n const n = words.length;\n\n if (!n) {\n return (\n

マイ単語帳はまだ空です。
単語一覧から学習したい単語を追加しましょう。

\n {onGoPick && (\n \n 🗂 単語を選ぶ\n \n )}\n

\n );\n }\n\n const i = ((index % n) + n) % n;\n const word = words[i];\n const val = (f: Field) => word.data[String(f.id)] ?? \"\";\n const frontText = frontFields.map(val).filter(Boolean).join(\", \");\n\n const go = (dir: number) => {\n setFlipped(false);\n setSlide(dir > 0 ? \"slide-next\" : \"slide-prev\");\n setIndex((p) => ((p + dir) % n + n) % n);\n };\n\n // Gesture handling: act as soon as the movement threshold is crossed\n // (during pointermove), instead of waiting for pointerup. The pointer is\n // captured once a drag starts so the gesture completes even when the\n // pointer leaves the card (mouse drag on PC) or crosses the speak button\n // / back face (touch on mobile).\n const onPointerDown = (e: any) => {\n start.current = { x: e.clientX, y: e.clientY };\n handled.current = false;\n captured.current = false;\n swiped.current = false;\n };\n\n const onPointerMove = (e: any) => {\n if (!start.current || handled.current) return;\n const dx = e.clientX - start.current.x;\n const dy = e.clientY - start.current.y;\n\n // Capture only after real movement so plain taps still deliver\n // normal click events to the card / speak buttons.\n if (!captured.current && (Math.abs(dx) > 8 || Math.abs(dy) > 8)) {\n captured.current = true;\n try {\n e.currentTarget.setPointerCapture(e.pointerId);\n } catch { /* capture unsupported */ }\n }\n\n if (Math.abs(dx) > 40 && Math.abs(dx) > Math.abs(dy) * 1.2) {\n handled.current = true;\n swiped.current = true;\n setFlipped((f) => !f);\n } else if (Math.abs(dy) > 50 && Math.abs(dy) > Math.abs(dx) * 1.2) {\n handled.current = true;\n swiped.current = true;\n go(dy < 0 ? 1 : -1);\n }\n };\n\n const onPointerEnd = (e: any) => {\n start.current = null;\n if (captured.current) {\n try {\n e.currentTarget.releasePointerCapture(e.pointerId);\n } catch { /* already released */ }\n captured.current = false;\n }\n };\n\n // Swallow the click that fires right after a swipe so it doesn't trigger speech\n const onClickCapture = (e: any) => {\n if (swiped.current) {\n e.stopPropagation();\n e.preventDefault();\n swiped.current = false;\n }\n };\n\n return (\n

{i + 1} / {n}

\n\n setSlide(\"\")}\n >\n \n {/* 表面 */}\n speak(frontText)}\n >\n {frontFields.map((f) => (\n

\n {val(f)}\n

\n ))}\n

🔊 タップで発音　⇄ 横スワイプでめくる

\n\n {/* 裏面 — overflow は hidden にする（スクロール可能領域があると\n モバイルブラウザがスワイプを横取りしてしまうため） */}\n

\n {backFields.map((f) => (\n

{f.name}

\n {f.speak ? (\n { e.stopPropagation(); speak(val(f)); }}\n >\n 🔊\n {val(f)}\n \n ) : (\n

\n {val(f)}\n

\n )}\n

\n ))}\n

\n \n \n\n

\n \n \n \n

↕ 上下スワイプで前後のカードへ

\n \n );\n}\n",[],[59,140],"a1f23d37-f29b-414b-b604-17ea6974c16b","App.tsx","672a889e-7de0-11f1-a514-1607ee4eb77e",18,["D",1783873794425],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useCallback, useEffect, useState } from \"https://esm.sh/react@18.2.0\";\nimport { api, getToken, setToken } from \"./api.ts\";\nimport Login from \"./Login.tsx\";\nimport FlashCards from \"./FlashCards.tsx\";\nimport WordPicker from \"./WordPicker.tsx\";\nimport Admin from \"./Admin.tsx\";\n\nexport default function App() {\n const [user, setUser] = useState(null);\n const [checking, setChecking] = useState(true);\n const [view, setView] = useState<\"cards\" | \"pick\" | \"admin\">(\"cards\");\n const [data, setData] = useState(null);\n\n useEffect(() => {\n if (!getToken()) {\n setChecking(false);\n return;\n }\n api(\"/api/me\")\n .then((r) => setUser(r.user))\n .catch(() => setToken(null))\n .finally(() => setChecking(false));\n }, []);\n\n const refresh = useCallback(async () => {\n const d = await api(\"/api/data\");\n setData(d);\n }, []);\n\n useEffect(() => {\n if (user) refresh().catch((e) => console.error(e));\n }, [user, refresh]);\n\n const logout = async () => {\n try {\n await api(\"/api/logout\", { method: \"POST\" });\n } catch { /* session may already be gone */ }\n setToken(null);\n setUser(null);\n setData(null);\n setView(\"cards\");\n };\n\n if (checking) {\n return

読み込み中...

;\n }\n if (!user) return ;\n\n const tab = (active: boolean) =>\n `px-3 py-1.5 rounded-lg text-sm transition ${active ? \"bg-indigo-600 text-white font-bold\" : \"text-gray-600 hover:bg-indigo-50\"}`;\n\n const myIdSet = new Set(data?.myWordIds ?? []);\n const myWords = data ? data.words.filter((w: any) => myIdSet.has(w.id)) : [];\n\n return (\n

📖 発音単語帳

\n \n

\n\n

\n {!data ? (\n

読み込み中...

\n ) : view === \"admin\" && user.isAdmin ? (\n \n ) : view === \"pick\" ? (\n \n ) : (\n setView(\"pick\")} />\n )}\n

\n\n \n

\n );\n}\n",[],[59,149],"caa2d4e3-41de-4db4-8a6a-bf54476459d6","Admin.tsx","61518896-7de0-11f1-bd63-1607ee4eb77e",27,["D",1783875097403],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useState } from \"https://esm.sh/react@18.2.0\";\nimport { api } from \"./api.ts\";\n\nexport default function Admin({ fields, words, refresh }: { fields: any[]; words: any[]; refresh: () => Promise }) {\n const [newField, setNewField] = useState({ name: \"\", side: \"back\", speak: false });\n const [autoWord, setAutoWord] = useState(\"\");\n const [editId, setEditId] = useState(null);\n const [editData, setEditData] = useState>({});\n const [error, setError] = useState(\"\");\n const [busy, setBusy] = useState(false);\n\n const run = async (fn: () => Promise) => {\n setBusy(true);\n setError(\"\");\n try {\n await fn();\n await refresh();\n } catch (e: any) {\n setError(e.message);\n } finally {\n setBusy(false);\n }\n };\n\n const addField = () => run(async () => {\n if (!newField.name.trim()) throw new Error(\"項目名を入力してください\");\n await api(\"/api/admin/fields\", { method: \"POST\", body: JSON.stringify(newField) });\n setNewField({ name: \"\", side: \"back\", speak: false });\n });\n\n const delField = (f: any) => {\n if (!confirm(`項目「${f.name}」を削除しますか？（各単語のこの項目の内容も表示されなくなります）`)) return;\n run(() => api(`/api/admin/fields/${f.id}`, { method: \"DELETE\" }));\n };\n\n const autoAdd = () => run(async () => {\n if (!autoWord.trim()) throw new Error(\"英単語を入力してください\");\n await api(\"/api/admin/words/auto\", { method: \"POST\", body: JSON.stringify({ word: autoWord }) });\n setAutoWord(\"\");\n });\n\n const delWord = (w: any) => {\n if (!confirm(\"このレコードを削除しますか？（各ユーザーのマイ単語帳からも消えます）\")) return;\n run(() => api(`/api/admin/words/${w.id}`, { method: \"DELETE\" }));\n };\n\n const startEdit = (w: any) => {\n setEditId(w.id);\n setEditData({ ...w.data });\n setError(\"\");\n };\n\n const saveEdit = () => run(async () => {\n await api(`/api/admin/words/${editId}`, { method: \"PUT\", body: JSON.stringify({ data: editData }) });\n setEditId(null);\n setEditData({});\n });\n\n const cancelEdit = () => {\n setEditId(null);\n setEditData({});\n };\n\n return (\n

\n {error &&

{error}

}\n\n

📋 データ項目の管理

\n \n \n \n \n \n \n \n \n \n \n {fields.map((f) => (\n \n \n \n \n \n \n ))}\n \n

項目名	面	音声
{f.name}	{f.side === \"front\" ? \"表\" : \"裏\"}	{f.speak ? \"🔊 あり\" : \"－\"}	\n \n

\n setNewField({ ...newField, name: e.target.value })}\n placeholder=\"新しい項目名\"\n className=\"border border-gray-200 rounded-lg px-3 py-1.5 text-sm flex-1 min-w-[8rem]\"\n />\n setNewField({ ...newField, side: e.target.value })}\n className=\"border border-gray-200 rounded-lg px-2 py-1.5 text-sm bg-white\"\n >\n \n \n \n \n setNewField({ ...newField, speak: e.target.checked })}\n />\n タップで音声\n \n \n

\n\n

📚 単語データの管理（{words.length}件）

\n setAutoWord(e.target.value)}\n onKeyDown={(e) => { if (e.key === \"Enter\" && !busy) autoAdd(); }}\n placeholder=\"英単語を入力（例: adventure）\"\n className=\"border border-gray-200 rounded-lg px-3 py-2 text-sm flex-1 min-w-[10rem] bg-white\"\n />\n \n {busy ? \"生成中...\" : \"✨ 自動補完して追加\"}\n \n

\n 発音記号・意味・例文・日本語訳などの項目はAIが自動で補完します。追加後に「編集」で修正できます。\n

\n \n \n \n {fields.map((f) => )}\n \n \n \n \n {words.map((w) => (\n editId === w.id\n ? (\n \n {fields.map((f) => (\n \n ))}\n \n \n )\n : (\n \n {fields.map((f) => )}\n \n \n )\n ))}\n \n

{f.name}
\n setEditData({ ...editData, [String(f.id)]: e.target.value })}\n placeholder={f.name}\n className=\"border border-indigo-300 rounded-lg px-2 py-1 text-sm w-full min-w-[6rem] bg-white\"\n />\n	\n \n \n
{w.data[String(f.id)] \|\| \"\"}	\n \n \n

\n );\n}\n",[],[59,157],["D",1783853691891],[167,168],[66],{"_35":177,"_13":178,"_38":179,"_40":67,"_41":42,"_43":68,"_45":46,"_47":180,"_17":62,"_50":96,"_52":181,"_54":55,"_56":-5,"_75":182,"_18":183},{"_35":169,"_13":170,"_38":171,"_40":67,"_41":42,"_43":172,"_45":46,"_47":173,"_17":95,"_50":96,"_52":174,"_54":55,"_56":-5,"_75":175,"_18":176},"10dcad7e-323a-4e60-bf1e-756cf6543373","db.ts","2c26b704-7de0-11f1-8ee6-1607ee4eb77e",15,["D",1783873717457],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { hashPassword, newSalt } from \"./auth.ts\";\n\n// [word, phonetic, meaning, example]\nconst SEED_WORDS: [string, string, string, string][] = [\n [\"apple\", \"/ˈæp.əl/\", \"りんご\", \"I eat an apple every morning.\"],\n [\"beautiful\", \"/ˈbjuː.tɪ.fəl/\", \"美しい\", \"The sunset was beautiful tonight.\"],\n [\"comfortable\", \"/ˈkʌmf.tə.bəl/\", \"快適な\", \"This sofa is very comfortable.\"],\n [\"decide\", \"/dɪˈsaɪd/\", \"決める\", \"I decided to study abroad next year.\"],\n [\"environment\", \"/ɪnˈvaɪ.rən.mənt/\", \"環境\", \"We must protect the environment.\"],\n [\"February\", \"/ˈfeb.ru.er.i/\", \"2月\", \"My birthday is in February.\"],\n [\"government\", \"/ˈɡʌv.ərn.mənt/\", \"政府\", \"The government announced a new policy.\"],\n [\"hour\", \"/ˈaʊər/\", \"1時間\", \"The meeting lasted an hour.\"],\n [\"interesting\", \"/ˈɪn.trə.stɪŋ/\", \"興味深い\", \"I read an interesting book yesterday.\"],\n [\"journey\", \"/ˈdʒɜːr.ni/\", \"旅\", \"Life is a long journey.\"],\n [\"knowledge\", \"/ˈnɑː.lɪdʒ/\", \"知識\", \"Knowledge is power.\"],\n [\"language\", \"/ˈlæŋ.ɡwɪdʒ/\", \"言語\", \"English is a global language.\"],\n [\"mountain\", \"/ˈmaʊn.tən/\", \"山\", \"We climbed the mountain last summer.\"],\n [\"necessary\", \"/ˈnes.ə.ser.i/\", \"必要な\", \"Sleep is necessary for good health.\"],\n [\"opportunity\", \"/ˌɑː.pərˈtuː.nə.ti/\", \"機会\", \"This is a great opportunity to learn.\"],\n [\"probably\", \"/ˈprɑː.bə.bli/\", \"おそらく\", \"It will probably rain tomorrow.\"],\n [\"question\", \"/ˈkwes.tʃən/\", \"質問\", \"May I ask you a question?\"],\n [\"restaurant\", \"/ˈres.tə.rɑːnt/\", \"レストラン\", \"We had dinner at an Italian restaurant.\"],\n [\"schedule\", \"/ˈskedʒ.uːl/\", \"予定\", \"My schedule is full this week.\"],\n [\"vegetable\", \"/ˈvedʒ.tə.bəl/\", \"野菜\", \"You should eat more vegetables.\"],\n];\n\n// Japanese translations of the seed example sentences, keyed by word\nconst EXAMPLE_JA: Record = {\n apple: \"私は毎朝りんごを食べます。\",\n beautiful: \"今夜の夕日は美しかった。\",\n comfortable: \"このソファはとても快適です。\",\n decide: \"私は来年留学することに決めました。\",\n environment: \"私たちは環境を守らなければなりません。\",\n February: \"私の誕生日は2月です。\",\n government: \"政府は新しい政策を発表しました。\",\n hour: \"会議は1時間続きました。\",\n interesting: \"昨日、興味深い本を読みました。\",\n journey: \"人生は長い旅です。\",\n knowledge: \"知識は力なり。\",\n language: \"英語は世界共通の言語です。\",\n mountain: \"私たちは去年の夏、その山に登りました。\",\n necessary: \"睡眠は健康のために必要です。\",\n opportunity: \"これは学ぶ絶好の機会です。\",\n probably: \"明日はおそらく雨が降るでしょう。\",\n question: \"質問してもいいですか？\",\n restaurant: \"私たちはイタリアンレストランで夕食をとりました。\",\n schedule: \"今週は予定がいっぱいです。\",\n vegetable: \"もっと野菜を食べるべきです。\",\n};\n\nexport async function initDb(): Promise {\n await sqlite.batch([\n `CREATE TABLE IF NOT EXISTS users (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n username TEXT NOT NULL UNIQUE,\n password_hash TEXT NOT NULL,\n salt TEXT NOT NULL,\n is_admin INTEGER NOT NULL DEFAULT 0,\n created_at INTEGER NOT NULL DEFAULT (unixepoch() * 1000)\n )`,\n `CREATE TABLE IF NOT EXISTS sessions (\n token TEXT PRIMARY KEY,\n user_id INTEGER NOT NULL,\n expires_at INTEGER NOT NULL\n )`,\n `CREATE TABLE IF NOT EXISTS fields (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL,\n side TEXT NOT NULL DEFAULT 'back',\n speak INTEGER NOT NULL DEFAULT 0,\n sort_order INTEGER NOT NULL DEFAULT 0\n )`,\n `CREATE TABLE IF NOT EXISTS words (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n data TEXT NOT NULL,\n created_at INTEGER NOT NULL DEFAULT (unixepoch() * 1000)\n )`,\n `CREATE TABLE IF NOT EXISTS user_words (\n user_id INTEGER NOT NULL,\n word_id INTEGER NOT NULL,\n added_at INTEGER NOT NULL DEFAULT (unixepoch() * 1000),\n PRIMARY KEY (user_id, word_id)\n )`,\n ]);\n\n // Seed initial fields\n const fieldCount = await sqlite.execute(\"SELECT COUNT(*) AS n FROM fields\");\n if (Number((fieldCount.rows[0] as any).n) === 0) {\n await sqlite.batch([\n { sql: \"INSERT INTO fields (name, side, speak, sort_order) VALUES (?, ?, ?, ?)\", args: [\"単語\", \"front\", 1, 1] },\n { sql: \"INSERT INTO fields (name, side, speak, sort_order) VALUES (?, ?, ?, ?)\", args: [\"発音記号\", \"back\", 0, 2] },\n { sql: \"INSERT INTO fields (name, side, speak, sort_order) VALUES (?, ?, ?, ?)\", args: [\"日本語での意味\", \"back\", 0, 3] },\n { sql: \"INSERT INTO fields (name, side, speak, sort_order) VALUES (?, ?, ?, ?)\", args: [\"例文\", \"back\", 1, 4] },\n ]);\n }\n\n // Seed initial words\n const wordCount = await sqlite.execute(\"SELECT COUNT(*) AS n FROM words\");\n if (Number((wordCount.rows[0] as any).n) === 0) {\n const fields = await sqlite.execute(\"SELECT id, name FROM fields\");\n const idByName: Record = {};\n for (const r of fields.rows as any[]) idByName[String(r.name)] = Number(r.id);\n const [wId, pId, mId, eId] = [idByName[\"単語\"], idByName[\"発音記号\"], idByName[\"日本語での意味\"], idByName[\"例文\"]];\n if (wId && pId && mId && eId) {\n await sqlite.batch(SEED_WORDS.map(([word, phonetic, meaning, example]) => ({\n sql: \"INSERT INTO words (data) VALUES (?)\",\n args: [JSON.stringify({ [wId]: word, [pId]: phonetic, [mId]: meaning, [eId]: example })],\n })));\n }\n }\n\n // Migration: add the 例文の日本語訳 field and backfill translations for seed words\n const ejName = \"例文の日本語訳\";\n let ej = await sqlite.execute({ sql: \"SELECT id FROM fields WHERE name = ?\", args: [ejName] });\n if (!ej.rows.length) {\n const max = await sqlite.execute(\"SELECT COALESCE(MAX(sort_order), 0) AS m FROM fields\");\n await sqlite.execute({\n sql: \"INSERT INTO fields (name, side, speak, sort_order) VALUES (?, 'back', 0, ?)\",\n args: [ejName, Number((max.rows[0] as any).m) + 1],\n });\n ej = await sqlite.execute({ sql: \"SELECT id FROM fields WHERE name = ?\", args: [ejName] });\n }\n const ejId = Number((ej.rows[0] as any).id);\n const wf = await sqlite.execute({ sql: \"SELECT id FROM fields WHERE name = ?\", args: [\"単語\"] });\n if (wf.rows.length) {\n const wId = Number((wf.rows[0] as any).id);\n const all = await sqlite.execute(\"SELECT id, data FROM words\");\n const updates: { sql: string; args: (string | number)[] }[] = [];\n for (const r of all.rows as any[]) {\n const data = JSON.parse(String(r.data));\n const wordText = data[String(wId)];\n if (data[String(ejId)] === undefined && wordText && EXAMPLE_JA[wordText]) {\n data[String(ejId)] = EXAMPLE_JA[wordText];\n updates.push({ sql: \"UPDATE words SET data = ? WHERE id = ?\", args: [JSON.stringify(data), Number(r.id)] });\n }\n }\n if (updates.length) await sqlite.batch(updates);\n }\n\n // Seed admin account\n const admin = await sqlite.execute(\"SELECT id FROM users WHERE is_admin = 1 LIMIT 1\");\n if (!admin.rows.length) {\n const salt = newSalt();\n const hash = await hashPassword(\"admin1234\", salt);\n await sqlite.execute({\n sql: \"INSERT OR IGNORE INTO users (username, password_hash, salt, is_admin) VALUES (?, ?, ?, 1)\",\n args: [\"admin\", hash, salt],\n });\n }\n}\n",[],[66,170],"3251c776-2094-4870-8ddf-d95bddf18d3e","auth.ts","1be18464-7de0-11f1-aa5c-1607ee4eb77e",["D",1783853691891],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nconst THIRTY_DAYS = 30 * 24 * 60 * 60 * 1000;\n\nfunction toHex(bytes: Uint8Array): string {\n return [...bytes].map((b) => b.toString(16).padStart(2, \"0\")).join(\"\");\n}\n\nexport function newSalt(): string {\n return toHex(crypto.getRandomValues(new Uint8Array(16)));\n}\n\nexport async function hashPassword(password: string, salt: string): Promise {\n const enc = new TextEncoder();\n const key = await crypto.subtle.importKey(\"raw\", enc.encode(password), \"PBKDF2\", false, [\"deriveBits\"]);\n const bits = await crypto.subtle.deriveBits(\n { name: \"PBKDF2\", salt: enc.encode(salt), iterations: 100_000, hash: \"SHA-256\" },\n key,\n 256,\n );\n return toHex(new Uint8Array(bits));\n}\n\nexport async function createSession(userId: number): Promise {\n const token = crypto.randomUUID().replaceAll(\"-\", \"\") + crypto.randomUUID().replaceAll(\"-\", \"\");\n await sqlite.execute({\n sql: \"INSERT INTO sessions (token, user_id, expires_at) VALUES (?, ?, ?)\",\n args: [token, userId, Date.now() + THIRTY_DAYS],\n });\n return token;\n}\n\nexport async function deleteSession(token: string): Promise {\n await sqlite.execute({ sql: \"DELETE FROM sessions WHERE token = ?\", args: [token] });\n}\n\nexport function bearerToken(req: Request): string | null {\n const h = req.headers.get(\"Authorization\") || \"\";\n return h.startsWith(\"Bearer \") ? h.slice(7) : null;\n}\n\nexport interface AuthUser {\n id: number;\n username: string;\n isAdmin: boolean;\n token: string;\n}\n\nexport async function getUserFromRequest(req: Request): Promise {\n const token = bearerToken(req);\n if (!token) return null;\n const res = await sqlite.execute({\n sql: `SELECT u.id, u.username, u.is_admin\n FROM sessions s JOIN users u ON u.id = s.user_id\n WHERE s.token = ? AND s.expires_at > ?`,\n args: [token, Date.now()],\n });\n if (!res.rows.length) return null;\n const r = res.rows[0] as Record;\n return { id: Number(r.id), username: String(r.username), isAdmin: Number(r.is_admin) === 1, token };\n}\n",[],[66,178],"6e165e38-56b2-4876-b810-9593b0bda755",["D",1783853674493],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","発音単語帳 - English pronunciation flashcards app","imageUrl","userId","2e5f3a11-3ecf-4768-a436-abfe0467880b","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","orgId","019f3378-c037-7109-869d-8900c383fcb3","tursoName","6e165e3856b24876b8109593b0bda755","tursoHostname","6e165e3856b24876b8109593b0bda755-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789560647748],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_241":237},"org",{"_11":12,"_234":235,"_236":237,"_194":195,"_238":239,"_240":55},"branch",{"_17":159,"_13":16,"_35":42,"_226":184,"_227":-5,"_228":-5,"_229":-5,"_230":-5,"_231":-5,"_232":14,"_233":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","吉岡蓮","avatar","https://lh3.googleusercontent.com/a/ACg8ocJoAQzKMObUH_Y10IrLwHP-VLUVThbIP7Q-p0QkGvJB2Re_AQ=s96-c","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_35":184,"_13":14,"_47":317,"_186":-5,"_187":55,"_188":189,"_190":189,"_191":192,"_193":-5,"_194":195,"_196":-5,"_197":55,"_198":-5,"_199":-5,"_200":62,"_201":202,"_203":204,"_205":206,"_207":318,"_209":-5,"_210":211,"_212":211,"_213":214,"_215":214,"_216":214,"_217":211,"_218":211,"_219":319,"_221":320,"_223":321,"_225":55},[275,278,288],"files",[275,276,277,278,279,280,281,282,283,284,285,286,287,288],"counts",{"_266":62,"_267":95,"_268":62,"_31":269,"_270":271},[260,261,262],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_35":65,"_13":66,"_38":67,"_40":-5,"_41":42,"_43":68,"_45":46,"_47":69,"_17":62,"_50":63,"_52":-5,"_54":55,"_56":-5,"_18":265},{"_35":58,"_13":59,"_38":60,"_40":-5,"_41":42,"_43":49,"_45":46,"_47":61,"_17":62,"_50":63,"_52":-5,"_54":55,"_56":-5,"_18":264},{"_35":36,"_13":37,"_38":39,"_40":-5,"_41":42,"_43":44,"_45":46,"_47":48,"_17":49,"_50":51,"_52":53,"_54":55,"_56":-5,"_18":263},[37],[59],[66],"pulls","branches","forks",{"_272":62,"_274":62},"connections",{"_272":62,"_273":62},"count","unfilledCount","emptyCount",{"_35":65,"_13":66,"_38":67,"_40":-5,"_41":42,"_43":68,"_45":46,"_47":164,"_17":62,"_50":63,"_52":-5,"_54":55,"_56":-5,"_75":315,"_18":316},{"_35":177,"_13":178,"_38":179,"_40":67,"_41":42,"_43":68,"_45":46,"_47":180,"_17":62,"_50":96,"_52":181,"_54":55,"_56":-5,"_75":313,"_18":314},{"_35":169,"_13":170,"_38":171,"_40":67,"_41":42,"_43":172,"_45":46,"_47":173,"_17":95,"_50":96,"_52":174,"_54":55,"_56":-5,"_75":311,"_18":312},{"_35":58,"_13":59,"_38":60,"_40":-5,"_41":42,"_43":49,"_45":46,"_47":78,"_17":62,"_50":63,"_52":-5,"_54":55,"_56":-5,"_75":309,"_18":310},{"_35":156,"_13":157,"_38":158,"_40":60,"_41":42,"_43":159,"_45":46,"_47":160,"_17":118,"_50":96,"_52":161,"_54":55,"_56":-5,"_75":307,"_18":308},{"_35":148,"_13":149,"_38":150,"_40":60,"_41":42,"_43":151,"_45":46,"_47":152,"_17":95,"_50":96,"_52":153,"_54":55,"_56":-5,"_75":305,"_18":306},{"_35":139,"_13":140,"_38":141,"_40":60,"_41":42,"_43":142,"_45":46,"_47":143,"_17":144,"_50":96,"_52":145,"_54":55,"_56":-5,"_75":303,"_18":304},{"_35":131,"_13":132,"_38":133,"_40":60,"_41":42,"_43":134,"_45":46,"_47":135,"_17":62,"_50":96,"_52":136,"_54":55,"_56":-5,"_75":301,"_18":302},{"_35":123,"_13":124,"_38":125,"_40":60,"_41":42,"_43":126,"_45":46,"_47":127,"_17":62,"_50":96,"_52":128,"_54":55,"_56":-5,"_75":299,"_18":300},{"_35":115,"_13":116,"_38":117,"_40":60,"_41":42,"_43":118,"_45":46,"_47":119,"_17":62,"_50":96,"_52":120,"_54":55,"_56":-5,"_75":297,"_18":298},{"_35":108,"_13":109,"_38":110,"_40":60,"_41":42,"_43":49,"_45":46,"_47":111,"_17":62,"_50":24,"_52":112,"_54":55,"_56":-5,"_75":295,"_18":296},{"_35":100,"_13":101,"_38":102,"_40":60,"_41":42,"_43":103,"_45":46,"_47":104,"_17":62,"_50":96,"_52":105,"_54":55,"_56":-5,"_75":293,"_18":294},{"_35":90,"_13":91,"_38":92,"_40":60,"_41":42,"_43":93,"_45":46,"_47":94,"_17":95,"_50":96,"_52":97,"_54":55,"_56":-5,"_75":291,"_18":292},{"_35":36,"_13":37,"_38":39,"_40":-5,"_41":42,"_43":44,"_45":46,"_47":74,"_17":49,"_50":51,"_52":53,"_54":55,"_56":-5,"_75":289,"_18":290},[],[37],[],[59,91],[],[59,101],[],[59,109],[],[59,116],[],[59,124],[],[59,132],[],[59,140],[],[59,149],[],[59,157],[279,280,281,282,283,284,285,286,287],[59],[],[66,170],[],[66,178],[276,277],[66],["D",1783853674493],["D",1789560647748],{"_11":12,"_241":237},{"_11":12,"_234":235,"_236":237,"_194":195,"_238":239,"_240":55},{"_17":159,"_13":16,"_35":42,"_226":184,"_227":-5,"_228":-5,"_229":-5,"_230":-5,"_231":-5,"_232":14,"_233":12},"ctx",{"_219":-5,"_257":355,"_356":357,"_358":359,"_360":55,"_361":55,"_362":55,"_363":46,"_364":-5,"_365":-7,"_366":-7,"_367":62,"_368":55,"_369":55,"_370":-5,"_371":55,"_372":55,"_373":55,"_374":-5},"ENV",{"_326":327,"_328":329,"_330":16,"_331":332,"_333":334,"_335":336,"_337":338,"_339":340,"_341":342,"_343":344,"_345":346,"_347":348,"_349":350,"_351":352,"_353":354},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","811aa22498c9b0b5a47e8d778de579cdb990f332","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

Code