[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_312":313,"_314":315},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":-7,"_18":19,"_17":-7,"_236":-5,"_20":237,"_22":238,"_239":240,"_241":242,"_26":243,"_24":244,"_245":-5,"_246":-5,"_247":53,"_248":249,"_250":45,"_251":-5,"_252":-5,"_253":254},"routes/_app.x.$handle.$name.code.$",{"_11":12,"_13":14,"_15":16,"_17":-7,"_18":19,"_20":21,"_22":23,"_24":25,"_26":27,"_28":-5,"_29":-5,"_30":-5,"_31":-5,"_32":-5},"handle","yoshiokaren","name","pronunciation-flashcards","branchName","main","version","path","frontend/index.html","project",{"_33":178,"_13":14,"_46":179,"_180":-5,"_181":53,"_182":183,"_184":183,"_185":186,"_187":-5,"_188":189,"_190":-5,"_191":53,"_192":-5,"_193":-5,"_194":48,"_195":196,"_197":198,"_199":200,"_201":202,"_203":-5,"_204":205,"_206":205,"_207":208,"_209":208,"_210":208,"_211":205,"_212":205,"_213":214,"_215":216,"_217":218,"_219":53},"tree",[57,58,59],"file",{"_33":34,"_13":35,"_36":37,"_38":39,"_40":41,"_42":43,"_44":45,"_46":47,"_17":48,"_49":24,"_50":51,"_52":53,"_54":-5,"_18":55},"contents",[],"upstream","pull","ahead","behind","envVars","id","5ae790cb-8bc0-4d25-b838-0e23ec8e24c7","index.html","fileId","3432a250-7de0-11f1-babe-1607ee4eb77e","parentId","873be4d0-fa78-4b5f-83d1-d5e8d1bd0fae","branchId","b3e7c51c-aea8-4acd-9488-a54b3a91aca6","branchVersion",4,"latest",true,"createdAt",["D",1783853732693],0,"fileType","content","\n\n\n \n \n 発音単語帳\n \n \n \n\n\n

\n \n\n\n","deleted",false,"label",[56,35],"frontend",{"_33":154,"_13":155,"_36":156,"_38":-5,"_40":41,"_42":157,"_44":45,"_46":158,"_17":48,"_49":72,"_50":-5,"_52":53,"_54":-5,"_67":159,"_18":160},{"_33":70,"_13":56,"_36":39,"_38":-5,"_40":41,"_42":43,"_44":45,"_46":71,"_17":48,"_49":72,"_50":-5,"_52":53,"_54":-5,"_67":73,"_18":74},{"_33":60,"_13":61,"_36":62,"_38":-5,"_40":41,"_42":63,"_44":45,"_46":64,"_17":43,"_49":65,"_50":66,"_52":53,"_54":-5,"_67":68,"_18":69},"2f4ca16b-e276-4017-bbd4-f3cb379a55d2","main.ts","1183fb6e-7de0-11f1-9593-1607ee4eb77e",23,["D",1783875055919],"http","import { Hono } from \"npm:hono\";\nimport { OpenAI } from \"https://esm.town/v/std/openai\";\nimport { parseVal, serveFile } from \"https://esm.town/v/std/utils/index.ts\";\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { initDb } from \"./backend/db.ts\";\nimport {\n bearerToken,\n createSession,\n deleteSession,\n getUserFromRequest,\n hashPassword,\n newSalt,\n} from \"./backend/auth.ts\";\n\nawait initDb();\n\nconst app = new Hono();\napp.onError((err) => Promise.reject(err));\n\n// ---------- auth ----------\n\napp.post(\"/api/register\", async (c) => {\n const { username, password } = await c.req.json().catch(() => ({}));\n if (!username || typeof username !== \"string\" || !password || String(password).length < 6) {\n return c.json({ error: \"ユーザー名と6文字以上のパスワードを入力してください\" }, 400);\n }\n const existing = await sqlite.execute({ sql: \"SELECT id FROM users WHERE username = ?\", args: [username] });\n if (existing.rows.length) return c.json({ error: \"このユーザー名は既に使われています\" }, 409);\n const salt = newSalt();\n const hash = await hashPassword(password, salt);\n const res = await sqlite.execute({\n sql: \"INSERT INTO users (username, password_hash, salt, is_admin) VALUES (?, ?, ?, 0)\",\n args: [username, hash, salt],\n });\n const userId = Number(res.lastInsertRowid);\n const token = await createSession(userId);\n return c.json({ token, user: { id: userId, username, isAdmin: false } });\n});\n\napp.post(\"/api/login\", async (c) => {\n const { username, password } = await c.req.json().catch(() => ({}));\n if (!username || !password) return c.json({ error: \"ユーザー名とパスワードを入力してください\" }, 400);\n const res = await sqlite.execute({ sql: \"SELECT * FROM users WHERE username = ?\", args: [username] });\n if (!res.rows.length) return c.json({ error: \"ユーザー名またはパスワードが違います\" }, 401);\n const u = res.rows[0] as Record;\n const hash = await hashPassword(String(password), String(u.salt));\n if (hash !== String(u.password_hash)) return c.json({ error: \"ユーザー名またはパスワードが違います\" }, 401);\n const token = await createSession(Number(u.id));\n return c.json({\n token,\n user: { id: Number(u.id), username: String(u.username), isAdmin: Number(u.is_admin) === 1 },\n });\n});\n\nconst requireAuth = async (c: any, next: any) => {\n const user = await getUserFromRequest(c.req.raw);\n if (!user) return c.json({ error: \"ログインが必要です\" }, 401);\n c.set(\"user\", user);\n await next();\n};\n\nconst requireAdmin = async (c: any, next: any) => {\n const user = c.get(\"user\");\n if (!user?.isAdmin) return c.json({ error: \"管理者権限が必要です\" }, 403);\n await next();\n};\n\napp.post(\"/api/logout\", requireAuth, async (c) => {\n const token = bearerToken(c.req.raw);\n if (token) await deleteSession(token);\n return c.json({ ok: true });\n});\n\napp.get(\"/api/me\", requireAuth, (c) => {\n const user = c.get(\"user\");\n return c.json({ user: { id: user.id, username: user.username, isAdmin: user.isAdmin } });\n});\n\n// ---------- data (any logged-in user) ----------\n\napp.get(\"/api/data\", requireAuth, async (c) => {\n const user = c.get(\"user\");\n const [fields, words, mine] = await Promise.all([\n sqlite.execute(\"SELECT * FROM fields ORDER BY sort_order, id\"),\n sqlite.execute(\"SELECT * FROM words ORDER BY id\"),\n sqlite.execute({ sql: \"SELECT word_id FROM user_words WHERE user_id = ?\", args: [user.id] }),\n ]);\n return c.json({\n fields: fields.rows.map((r: any) => ({\n id: Number(r.id),\n name: String(r.name),\n side: String(r.side),\n speak: Number(r.speak),\n sort_order: Number(r.sort_order),\n })),\n words: words.rows.map((r: any) => ({ id: Number(r.id), data: JSON.parse(String(r.data)) })),\n myWordIds: mine.rows.map((r: any) => Number(r.word_id)),\n });\n});\n\n// ---------- my word deck (per user) ----------\n\napp.post(\"/api/my-words\", requireAuth, async (c) => {\n const user = c.get(\"user\");\n const { wordId } = await c.req.json().catch(() => ({}));\n const id = Number(wordId);\n if (!id) return c.json({ error: \"単語IDが不正です\" }, 400);\n const w = await sqlite.execute({ sql: \"SELECT id FROM words WHERE id = ?\", args: [id] });\n if (!w.rows.length) return c.json({ error: \"単語が見つかりません\" }, 404);\n await sqlite.execute({\n sql: \"INSERT OR IGNORE INTO user_words (user_id, word_id) VALUES (?, ?)\",\n args: [user.id, id],\n });\n return c.json({ ok: true });\n});\n\napp.delete(\"/api/my-words/:id\", requireAuth, async (c) => {\n const user = c.get(\"user\");\n const id = Number(c.req.param(\"id\"));\n await sqlite.execute({\n sql: \"DELETE FROM user_words WHERE user_id = ? AND word_id = ?\",\n args: [user.id, id],\n });\n return c.json({ ok: true });\n});\n\n// ---------- admin ----------\n\napp.use(\"/api/admin/*\", requireAuth, requireAdmin);\n\napp.post(\"/api/admin/fields\", async (c) => {\n const { name, side, speak } = await c.req.json().catch(() => ({}));\n if (!name || typeof name !== \"string\" || !name.trim()) return c.json({ error: \"項目名を入力してください\" }, 400);\n const s = side === \"front\" ? \"front\" : \"back\";\n const max = await sqlite.execute(\"SELECT COALESCE(MAX(sort_order), 0) AS m FROM fields\");\n const res = await sqlite.execute({\n sql: \"INSERT INTO fields (name, side, speak, sort_order) VALUES (?, ?, ?, ?)\",\n args: [name.trim(), s, speak ? 1 : 0, Number((max.rows[0] as any).m) + 1],\n });\n return c.json({ ok: true, id: Number(res.lastInsertRowid) });\n});\n\napp.delete(\"/api/admin/fields/:id\", async (c) => {\n const id = Number(c.req.param(\"id\"));\n const f = await sqlite.execute({ sql: \"SELECT * FROM fields WHERE id = ?\", args: [id] });\n if (!f.rows.length) return c.json({ error: \"項目が見つかりません\" }, 404);\n if (String((f.rows[0] as any).side) === \"front\") {\n const fronts = await sqlite.execute(\"SELECT COUNT(*) AS n FROM fields WHERE side = 'front'\");\n if (Number((fronts.rows[0] as any).n) <= 1) {\n return c.json({ error: \"表面に表示する項目が無くなるため削除できません\" }, 400);\n }\n }\n await sqlite.execute({ sql: \"DELETE FROM fields WHERE id = ?\", args: [id] });\n return c.json({ ok: true });\n});\n\nfunction cleanWordData(data: unknown): Record | null {\n if (!data || typeof data !== \"object\" || Array.isArray(data)) return null;\n const clean: Record = {};\n for (const [k, v] of Object.entries(data as Record)) {\n if (typeof v === \"string\" && v.trim()) clean[k] = v.trim();\n }\n return Object.keys(clean).length ? clean : null;\n}\n\napp.post(\"/api/admin/words\", async (c) => {\n const { data } = await c.req.json().catch(() => ({}));\n const clean = cleanWordData(data);\n if (!clean) return c.json({ error: \"少なくとも1つの項目を入力してください\" }, 400);\n const res = await sqlite.execute({\n sql: \"INSERT INTO words (data) VALUES (?)\",\n args: [JSON.stringify(clean)],\n });\n return c.json({ ok: true, id: Number(res.lastInsertRowid) });\n});\n\n// Add a word from just the English word — every other field is filled in by an LLM\napp.post(\"/api/admin/words/auto\", async (c) => {\n const { word } = await c.req.json().catch(() => ({}));\n if (!word || typeof word !== \"string\" || !word.trim()) {\n return c.json({ error: \"英単語を入力してください\" }, 400);\n }\n const w = word.trim();\n\n const fieldsRes = await sqlite.execute(\"SELECT * FROM fields ORDER BY sort_order, id\");\n const fields = fieldsRes.rows as any[];\n const frontField = fields.find((f) => String(f.side) === \"front\");\n if (!frontField) return c.json({ error: \"表面の項目が設定されていません\" }, 400);\n const otherFields = fields.filter((f) => Number(f.id) !== Number(frontField.id));\n\n // Reject duplicates (case-insensitive match on the front field)\n const dup = await sqlite.execute({\n sql: \"SELECT id FROM words WHERE lower(json_extract(data, ?)) = lower(?)\",\n args: [`$.${Number(frontField.id)}`, w],\n });\n if (dup.rows.length) return c.json({ error: `「${w}」は既に登録されています` }, 409);\n\n const fieldNames = otherFields.map((f) => String(f.name));\n const openai = new OpenAI();\n const completion = await openai.chat.completions.create({\n model: \"gpt-4o-mini\",\n response_format: { type: \"json_object\" },\n messages: [\n {\n role: \"system\",\n content:\n \"You are a Japanese-English dictionary assistant for an English vocabulary flashcard app used by Japanese learners. Reply with a single JSON object only.\",\n },\n {\n role: \"user\",\n content: `英単語 \"${w}\" について、次のフィールドをすべて埋めてください。\nJSONオブジェクトで返し、キーは以下のフィールド名と完全に一致させてください。\n\nフィールド: ${fieldNames.join(\" / \")}\n\nガイドライン:\n- 「発音記号」: アメリカ英語のIPA表記（例: /ˈæp.əl/）\n- 「日本語での意味」: 簡潔な日本語訳（複数の意味は「、」区切り）\n- 「例文」: その単語を使った自然で平易な英語の例文を1文\n- 「例文の日本語訳」: その例文の自然な日本語訳\n- 上記以外のフィールドも、名前から役割を判断して適切な内容を日本語学習者向けに埋めてください`,\n },\n ],\n });\n\n let generated: Record = {};\n try {\n generated = JSON.parse(completion.choices[0]?.message?.content ?? \"{}\");\n } catch {\n return c.json({ error: \"自動補完の生成に失敗しました。もう一度お試しください\" }, 502);\n }\n\n const data: Record = { [String(frontField.id)]: w };\n for (const f of otherFields) {\n const v = generated[String(f.name)];\n if (typeof v === \"string\" && v.trim()) data[String(f.id)] = v.trim();\n }\n\n const res = await sqlite.execute({\n sql: \"INSERT INTO words (data) VALUES (?)\",\n args: [JSON.stringify(data)],\n });\n return c.json({ ok: true, id: Number(res.lastInsertRowid), data });\n});\n\napp.put(\"/api/admin/words/:id\", async (c) => {\n const id = Number(c.req.param(\"id\"));\n const existing = await sqlite.execute({ sql: \"SELECT id FROM words WHERE id = ?\", args: [id] });\n if (!existing.rows.length) return c.json({ error: \"単語が見つかりません\" }, 404);\n const { data } = await c.req.json().catch(() => ({}));\n const clean = cleanWordData(data);\n if (!clean) return c.json({ error: \"少なくとも1つの項目を入力してください\" }, 400);\n await sqlite.execute({\n sql: \"UPDATE words SET data = ? WHERE id = ?\",\n args: [JSON.stringify(clean), id],\n });\n return c.json({ ok: true });\n});\n\napp.delete(\"/api/admin/words/:id\", async (c) => {\n const id = Number(c.req.param(\"id\"));\n await sqlite.batch([\n { sql: \"DELETE FROM words WHERE id = ?\", args: [id] },\n { sql: \"DELETE FROM user_words WHERE word_id = ?\", args: [id] },\n ]);\n return c.json({ ok: true });\n});\n\n// ---------- frontend ----------\n\napp.get(\"/source\", (c) => c.redirect(parseVal().links.self.val));\napp.get(\"/frontend/**/*\", (c) => serveFile(c.req.path));\napp.get(\"/\", () => serveFile(\"/frontend/index.html\"));\n\nexport default app.fetch;\n","children",[],[61],"13a74445-c574-4f4f-b085-d54ce5b1f523",["D",1783853732693],"directory",[75,76,77,78,79,80,81,82,83],[56],{"_33":146,"_13":147,"_36":148,"_38":39,"_40":41,"_42":149,"_44":45,"_46":150,"_17":108,"_49":90,"_50":151,"_52":53,"_54":-5,"_67":152,"_18":153},{"_33":138,"_13":139,"_36":140,"_38":39,"_40":41,"_42":141,"_44":45,"_46":142,"_17":89,"_49":90,"_50":143,"_52":53,"_54":-5,"_67":144,"_18":145},{"_33":129,"_13":130,"_36":131,"_38":39,"_40":41,"_42":132,"_44":45,"_46":133,"_17":134,"_49":90,"_50":135,"_52":53,"_54":-5,"_67":136,"_18":137},{"_33":121,"_13":122,"_36":123,"_38":39,"_40":41,"_42":124,"_44":45,"_46":125,"_17":48,"_49":90,"_50":126,"_52":53,"_54":-5,"_67":127,"_18":128},{"_33":113,"_13":114,"_36":115,"_38":39,"_40":41,"_42":116,"_44":45,"_46":117,"_17":48,"_49":90,"_50":118,"_52":53,"_54":-5,"_67":119,"_18":120},{"_33":105,"_13":106,"_36":107,"_38":39,"_40":41,"_42":108,"_44":45,"_46":109,"_17":48,"_49":90,"_50":110,"_52":53,"_54":-5,"_67":111,"_18":112},{"_33":34,"_13":35,"_36":37,"_38":39,"_40":41,"_42":43,"_44":45,"_46":102,"_17":48,"_49":24,"_50":51,"_52":53,"_54":-5,"_67":103,"_18":104},{"_33":94,"_13":95,"_36":96,"_38":39,"_40":41,"_42":97,"_44":45,"_46":98,"_17":48,"_49":90,"_50":99,"_52":53,"_54":-5,"_67":100,"_18":101},{"_33":84,"_13":85,"_36":86,"_38":39,"_40":41,"_42":87,"_44":45,"_46":88,"_17":89,"_49":90,"_50":91,"_52":53,"_54":-5,"_67":92,"_18":93},"aaa970f0-0e77-4ca2-9f84-eb75a7ba9ff3","speech.ts","38d0a140-7de0-11f1-b3d5-1607ee4eb77e",14,["D",1783856261442],1,"script","let voices: SpeechSynthesisVoice[] = [];\n// Keep a reference to the active utterance: some mobile browsers\n// garbage-collect it mid-speech, cutting the audio off.\nlet current: SpeechSynthesisUtterance | null = null;\n\nfunction loadVoices() {\n voices = window.speechSynthesis?.getVoices() ?? [];\n}\n\nif (\"speechSynthesis\" in window) {\n loadVoices();\n window.speechSynthesis.onvoiceschanged = loadVoices;\n}\n\n// Prefer natural-sounding voices: platform \"neural/natural\" voices first,\n// then Google voices (Android/Chrome), then enhanced/premium (iOS), then\n// well-known high-quality named voices.\nfunction scoreVoice(v: SpeechSynthesisVoice, lang: string): number {\n const vlang = v.lang.replace(\"_\", \"-\").toLowerCase();\n if (!vlang.startsWith(lang.slice(0, 2).toLowerCase())) return -1;\n const name = v.name.toLowerCase();\n let s = 0;\n if (/natural|neural/.test(name)) s += 100;\n if (name.includes(\"google\")) s += 80;\n if (/enhanced|premium/.test(name)) s += 60;\n if (/samantha|aria|ava|jenny|allison|joanna|kyoko/.test(name)) s += 40;\n if (vlang === lang.toLowerCase()) s += 20;\n if (!v.localService) s += 10;\n if (v.default) s += 5;\n return s;\n}\n\nfunction pickVoice(lang: string): SpeechSynthesisVoice | null {\n if (!voices.length) loadVoices();\n let best: SpeechSynthesisVoice | null = null;\n let bestScore = -1;\n for (const v of voices) {\n const s = scoreVoice(v, lang);\n if (s > bestScore) {\n bestScore = s;\n best = v;\n }\n }\n return bestScore >= 0 ? best : null;\n}\n\nexport function speak(text: string): void {\n if (!(\"speechSynthesis\" in window) || !text) return;\n const synth = window.speechSynthesis;\n const isJapanese = /[぀-ヿ一-鿿]/.test(text);\n const lang = isJapanese ? \"ja-JP\" : \"en-US\";\n\n const u = new SpeechSynthesisUtterance(text);\n u.lang = lang;\n const voice = pickVoice(lang);\n if (voice) u.voice = voice;\n u.rate = 1.0;\n u.pitch = 1.0;\n u.onend = () => {\n if (current === u) current = null;\n };\n current = u;\n\n // iOS Safari sometimes leaves the synthesizer stuck in a paused state,\n // which silently drops every subsequent utterance.\n try {\n synth.resume();\n } catch { /* not supported */ }\n\n if (synth.speaking || synth.pending) {\n // iOS swallows a speak() issued synchronously right after cancel().\n // The audio unlock already happened on the first user tap, so a short\n // delay before re-speaking is safe here.\n synth.cancel();\n setTimeout(() => synth.speak(u), 80);\n } else {\n synth.speak(u);\n }\n}\n",[],[56,85],"a3ee06bc-2cc7-4929-aea5-45e13f72edba","index.tsx","3e6bac62-7de0-11f1-9921-1607ee4eb77e",7,["D",1783853749849],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { createRoot } from \"https://esm.sh/react-dom@18.2.0/client\";\nimport App from \"./App.tsx\";\n\ncreateRoot(document.getElementById(\"root\")!).render();\n",[],[56,95],["D",1783853732693],[],[56,35],"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",[],[56,106],"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",[],[56,114],"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",[],[56,122],"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",[],[56,130],"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",[],[56,139],"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",[],[56,147],"220ad4f1-5d52-4c85-b95d-d8681cf9dbf8","backend","bc0cc0c3-e517-4e74-9e58-d314b7ca4588",2,["D",1783853691891],[161,162],[155],{"_33":171,"_13":172,"_36":173,"_38":156,"_40":41,"_42":157,"_44":45,"_46":174,"_17":48,"_49":90,"_50":175,"_52":53,"_54":-5,"_67":176,"_18":177},{"_33":163,"_13":164,"_36":165,"_38":156,"_40":41,"_42":166,"_44":45,"_46":167,"_17":89,"_49":90,"_50":168,"_52":53,"_54":-5,"_67":169,"_18":170},"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",[],[155,164],"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",[],[155,172],"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,"_235":231},"org",{"_11":12,"_228":229,"_230":231,"_188":189,"_232":233,"_234":53},"branch",{"_17":149,"_13":16,"_33":41,"_220":178,"_221":-5,"_222":-5,"_223":-5,"_224":-5,"_225":-5,"_226":14,"_227":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",{"_33":178,"_13":14,"_46":307,"_180":-5,"_181":53,"_182":183,"_184":183,"_185":186,"_187":-5,"_188":189,"_190":-5,"_191":53,"_192":-5,"_193":-5,"_194":48,"_195":196,"_197":198,"_199":200,"_201":308,"_203":-5,"_204":205,"_206":205,"_207":208,"_209":208,"_210":208,"_211":205,"_212":205,"_213":309,"_215":310,"_217":311,"_219":53},[265,268,278],"files",[265,266,267,268,269,270,271,272,273,274,275,276,277,278],"counts",{"_256":48,"_257":89,"_258":48,"_32":259,"_260":261},[],{"_33":34,"_13":35,"_36":37,"_38":39,"_40":41,"_42":43,"_44":45,"_46":47,"_17":48,"_49":24,"_50":51,"_52":53,"_54":-5,"_18":255},"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},[56,35],"pulls","branches","forks",{"_262":48,"_264":48},"connections",{"_262":48,"_263":48},"count","unfilledCount","emptyCount",{"_33":154,"_13":155,"_36":156,"_38":-5,"_40":41,"_42":157,"_44":45,"_46":158,"_17":48,"_49":72,"_50":-5,"_52":53,"_54":-5,"_67":305,"_18":306},{"_33":171,"_13":172,"_36":173,"_38":156,"_40":41,"_42":157,"_44":45,"_46":174,"_17":48,"_49":90,"_50":175,"_52":53,"_54":-5,"_67":303,"_18":304},{"_33":163,"_13":164,"_36":165,"_38":156,"_40":41,"_42":166,"_44":45,"_46":167,"_17":89,"_49":90,"_50":168,"_52":53,"_54":-5,"_67":301,"_18":302},{"_33":70,"_13":56,"_36":39,"_38":-5,"_40":41,"_42":43,"_44":45,"_46":71,"_17":48,"_49":72,"_50":-5,"_52":53,"_54":-5,"_67":299,"_18":300},{"_33":146,"_13":147,"_36":148,"_38":39,"_40":41,"_42":149,"_44":45,"_46":150,"_17":108,"_49":90,"_50":151,"_52":53,"_54":-5,"_67":297,"_18":298},{"_33":138,"_13":139,"_36":140,"_38":39,"_40":41,"_42":141,"_44":45,"_46":142,"_17":89,"_49":90,"_50":143,"_52":53,"_54":-5,"_67":295,"_18":296},{"_33":129,"_13":130,"_36":131,"_38":39,"_40":41,"_42":132,"_44":45,"_46":133,"_17":134,"_49":90,"_50":135,"_52":53,"_54":-5,"_67":293,"_18":294},{"_33":121,"_13":122,"_36":123,"_38":39,"_40":41,"_42":124,"_44":45,"_46":125,"_17":48,"_49":90,"_50":126,"_52":53,"_54":-5,"_67":291,"_18":292},{"_33":113,"_13":114,"_36":115,"_38":39,"_40":41,"_42":116,"_44":45,"_46":117,"_17":48,"_49":90,"_50":118,"_52":53,"_54":-5,"_67":289,"_18":290},{"_33":105,"_13":106,"_36":107,"_38":39,"_40":41,"_42":108,"_44":45,"_46":109,"_17":48,"_49":90,"_50":110,"_52":53,"_54":-5,"_67":287,"_18":288},{"_33":34,"_13":35,"_36":37,"_38":39,"_40":41,"_42":43,"_44":45,"_46":102,"_17":48,"_49":24,"_50":51,"_52":53,"_54":-5,"_67":285,"_18":286},{"_33":94,"_13":95,"_36":96,"_38":39,"_40":41,"_42":97,"_44":45,"_46":98,"_17":48,"_49":90,"_50":99,"_52":53,"_54":-5,"_67":283,"_18":284},{"_33":84,"_13":85,"_36":86,"_38":39,"_40":41,"_42":87,"_44":45,"_46":88,"_17":89,"_49":90,"_50":91,"_52":53,"_54":-5,"_67":281,"_18":282},{"_33":60,"_13":61,"_36":62,"_38":-5,"_40":41,"_42":63,"_44":45,"_46":64,"_17":43,"_49":65,"_50":66,"_52":53,"_54":-5,"_67":279,"_18":280},[],[61],[],[56,85],[],[56,95],[],[56,35],[],[56,106],[],[56,114],[],[56,122],[],[56,130],[],[56,139],[],[56,147],[269,270,271,272,273,274,275,276,277],[56],[],[155,164],[],[155,172],[266,267],[155],["D",1783853674493],["D",1789560647748],{"_11":12,"_235":231},{"_11":12,"_228":229,"_230":231,"_188":189,"_232":233,"_234":53},{"_17":149,"_13":16,"_33":41,"_220":178,"_221":-5,"_222":-5,"_223":-5,"_224":-5,"_225":-5,"_226":14,"_227":12},"ctx",{"_213":-5,"_252":345,"_346":347,"_348":349,"_350":53,"_351":53,"_352":53,"_353":45,"_354":-5,"_355":-7,"_356":-7,"_357":48,"_358":53,"_359":53,"_360":-5,"_361":53,"_362":53,"_363":53,"_364":-5},"ENV",{"_316":317,"_318":319,"_320":16,"_321":322,"_323":324,"_325":326,"_327":328,"_329":330,"_331":332,"_333":334,"_335":336,"_337":338,"_339":340,"_341":342,"_343":344},"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"]