[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_210":211,"_212":213},"routes/_app.x.$handle.$name",{"_103":102,"_37":48,"_112":93,"_32":113,"_13":14,"_114":-5,"_11":115,"_116":117,"_118":119,"_120":121,"_122":123,"_26":-5,"_124":-5,"_125":-5,"_126":30,"_127":128,"_129":30,"_130":-5,"_131":-5,"_132":133},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":18,"_19":-5},"project",{"_46":47,"_37":48,"_41":49,"_50":-5,"_51":30,"_52":53,"_54":53,"_55":56,"_57":-5,"_19":58,"_59":60,"_61":62,"_63":-5,"_64":-5,"_65":66,"_67":68,"_69":70,"_71":72,"_73":74,"_75":-5,"_76":77,"_78":77,"_79":80,"_81":80,"_82":80,"_83":77,"_84":77,"_85":86,"_87":88,"_89":90,"_91":30},"version",5,"changes",[25],"aiChatInfo",{"_20":21,"_22":-5,"_23":-5,"_24":-5},"userId","aiChatMessageId","5188f035-19e6-4ca8-809f-015faf0f2f76","aiChatThreadId","aiChatThreadUserId","aiChatThreadTitle",{"_26":27,"_28":-7,"_29":30,"_31":30,"_32":33,"_34":33},"file",{"_35":36,"_37":33,"_38":26,"_39":40,"_41":42,"_43":14,"_44":45,"_29":30},"previous","deleted",false,"deletedHere","path","index.html","latestPath","fileId","74d2ced0-5611-11f1-b8f4-ee650bb23af1","name","fileType","content","\n\n\n \n \n Flashcard Piles\n \n \n \n\n\n

\n \n\n\n","createdAt",["D",1779476839670],"branchVersion","branchId","29815618-5611-11f1-a10c-ee650bb23af1","id","2980556a-5611-11f1-a10c-ee650bb23af1","flashcard-piles",["D",1779476713589],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Spaced repetition flashcards with customizable piles","imageUrl","b0f66e5e-509d-4872-b86b-f608f2d6cc3b","pinnedFileId","796f4bf8-5611-11f1-b4db-ee650bb23af1","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","019e510c-5932-7040-9f60-46e5ec60f549","tursoName","2980556a561111f1a10cee650bb23af1","tursoHostname","2980556a561111f1a10cee650bb23af1-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789502486629],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_103":102,"_111":107},"org",{"_103":102,"_104":105,"_106":107,"_19":58,"_108":109,"_110":30},"branch",{"_13":92,"_37":93,"_46":45,"_94":47,"_95":-5,"_96":-5,"_97":-5,"_98":-5,"_99":-5,"_100":48,"_101":102},"isOwned",11,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","CharChar","handle","displayName","Charlotte Bao","avatar","https://lh3.googleusercontent.com/a/ACg8ocIqmNj7v64SVTYRk3nZFJfhCni10VosdvUrXQSPY0urAhk6Iw=s96-c","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_46":47,"_37":48,"_41":205,"_50":-5,"_51":30,"_52":53,"_54":53,"_55":56,"_57":-5,"_19":58,"_59":60,"_61":62,"_63":-5,"_64":-5,"_65":66,"_67":68,"_69":70,"_71":72,"_73":206,"_75":-5,"_76":77,"_78":77,"_79":80,"_81":80,"_82":80,"_83":77,"_84":77,"_85":207,"_87":208,"_89":209,"_91":30},"tree",[184,185,186,187,188],"files",[184,185,186,187,188],"counts",{"_174":66,"_175":148,"_176":66,"_177":178,"_179":180},"contents",[134,135,136,137,138],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_46":167,"_37":168,"_35":169,"_140":-5,"_44":45,"_43":170,"_141":30,"_41":171,"_13":66,"_38":150,"_39":172,"_29":30,"_143":-5,"_32":173},{"_46":160,"_37":161,"_35":162,"_140":-5,"_44":45,"_43":163,"_141":30,"_41":164,"_13":66,"_38":150,"_39":165,"_29":30,"_143":-5,"_32":166},{"_46":153,"_37":154,"_35":155,"_140":-5,"_44":45,"_43":156,"_141":62,"_41":157,"_13":66,"_38":150,"_39":158,"_29":30,"_143":-5,"_32":159},{"_46":145,"_37":146,"_35":147,"_140":-5,"_44":45,"_43":148,"_141":62,"_41":149,"_13":66,"_38":150,"_39":151,"_29":30,"_143":-5,"_32":152},{"_46":139,"_37":33,"_35":36,"_140":-5,"_44":45,"_43":14,"_141":62,"_41":142,"_13":66,"_38":26,"_39":40,"_29":30,"_143":-5,"_32":144},"74d2ce30-5611-11f1-b8f4-ee650bb23af1","parentId","latest",["D",1779476839670],"label",[33],"2f1dcc46-5611-11f1-8683-ee650bb23af1","db.ts","2f1dcd04-5611-11f1-8683-ee650bb23af1",1,["D",1779476723001],"script","import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nexport async function initDB() {\n await sqlite.batch([\n `CREATE TABLE IF NOT EXISTS users (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n username TEXT UNIQUE NOT NULL,\n password_hash TEXT NOT NULL,\n created_at TEXT DEFAULT (datetime('now'))\n )`,\n `CREATE TABLE IF NOT EXISTS piles (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n user_id INTEGER NOT NULL,\n pile_number INTEGER NOT NULL,\n label TEXT NOT NULL,\n review_interval_days REAL NOT NULL DEFAULT 1,\n FOREIGN KEY (user_id) REFERENCES users(id),\n UNIQUE(user_id, pile_number)\n )`,\n `CREATE TABLE IF NOT EXISTS cards (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n user_id INTEGER NOT NULL,\n front TEXT NOT NULL,\n back TEXT NOT NULL,\n pile_number INTEGER NOT NULL DEFAULT 1,\n last_reviewed TEXT,\n next_review TEXT DEFAULT (datetime('now')),\n created_at TEXT DEFAULT (datetime('now')),\n FOREIGN KEY (user_id) REFERENCES users(id)\n )`,\n ]);\n}\n\nexport { sqlite };\n",[146],"36bc2ee8-5611-11f1-8e65-ee650bb23af1","auth.ts","36bc2f9c-5611-11f1-8e65-ee650bb23af1",2,["D",1779476735785],"import { sqlite } from \"./db.ts\";\n\n// Simple hash function (no external deps needed)\nasync function hashPassword(password: string): Promise {\n const encoder = new TextEncoder();\n const data = encoder.encode(password + \"flashcard-salt-v1\");\n const hash = await crypto.subtle.digest(\"SHA-256\", data);\n return Array.from(new Uint8Array(hash)).map(b => b.toString(16).padStart(2, \"0\")).join(\"\");\n}\n\n// Simple token: base64(userId:timestamp:hash)\nfunction generateToken(userId: number): string {\n const payload = `${userId}:${Date.now()}`;\n const token = btoa(payload + \":\" + payload.split(\"\").reverse().join(\"\"));\n return token;\n}\n\nexport function parseToken(token: string): number | null {\n try {\n const decoded = atob(token);\n const userId = parseInt(decoded.split(\":\")[0]);\n return isNaN(userId) ? null : userId;\n } catch {\n return null;\n }\n}\n\nexport async function register(username: string, password: string): Promise<{ token: string; userId: number } | string> {\n if (!username || username.length < 2) return \"Username must be at least 2 characters\";\n if (!password || password.length < 4) return \"Password must be at least 4 characters\";\n\n const existing = await sqlite.execute({ sql: \"SELECT id FROM users WHERE username = ?\", args: [username] });\n if (existing.rows.length > 0) return \"Username already taken\";\n\n const hash = await hashPassword(password);\n const result = await sqlite.execute({\n sql: \"INSERT INTO users (username, password_hash) VALUES (?, ?)\",\n args: [username, hash],\n });\n\n const userId = result.lastInsertRowid as number;\n\n // Create default 5 piles\n const defaultPiles = [\n { num: 1, label: \"Pile 1\", days: 1 },\n { num: 2, label: \"Pile 2\", days: 2 },\n { num: 3, label: \"Pile 3\", days: 4 },\n { num: 4, label: \"Pile 4\", days: 7 },\n { num: 5, label: \"Pile 5\", days: 14 },\n ];\n await sqlite.batch(\n defaultPiles.map(p => ({\n sql: \"INSERT INTO piles (user_id, pile_number, label, review_interval_days) VALUES (?, ?, ?, ?)\",\n args: [userId, p.num, p.label, p.days],\n })),\n );\n\n return { token: generateToken(userId), userId };\n}\n\nexport async function login(username: string, password: string): Promise<{ token: string; userId: number } | string> {\n const hash = await hashPassword(password);\n const result = await sqlite.execute({\n sql: \"SELECT id FROM users WHERE username = ? AND password_hash = ?\",\n args: [username, hash],\n });\n if (result.rows.length === 0) return \"Invalid username or password\";\n const userId = result.rows[0].id as number;\n return { token: generateToken(userId), userId };\n}\n",[154],"6ffa68d2-5611-11f1-b997-ee650bb23af1","app.tsx","6ffa69ae-5611-11f1-b997-ee650bb23af1",4,["D",1779476831513],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\n\nimport React, { useState, useEffect, useCallback } from \"https://esm.sh/react@18.2.0\";\n\nconst API_BASE = \"\";\n\nfunction api(path: string, opts: any = {}) {\n const token = localStorage.getItem(\"fc_token\");\n return fetch(`${API_BASE}/api${path}`, {\n ...opts,\n headers: {\n \"Content-Type\": \"application/json\",\n ...(token ? { Authorization: `Bearer ${token}` } : {}),\n ...opts.headers,\n },\n body: opts.body ? JSON.stringify(opts.body) : undefined,\n }).then(async (r) => {\n const data = await r.json();\n if (!r.ok) throw new Error(data.error || \"Request failed\");\n return data;\n });\n}\n\n// ---- Auth Screen ----\nfunction AuthScreen({ onLogin }: { onLogin: () => void }) {\n const [isRegister, setIsRegister] = useState(false);\n const [username, setUsername] = useState(\"\");\n const [password, setPassword] = useState(\"\");\n const [error, setError] = useState(\"\");\n\n const handleSubmit = async (e: React.FormEvent) => {\n e.preventDefault();\n setError(\"\");\n try {\n const endpoint = isRegister ? \"/auth/register\" : \"/auth/login\";\n const data = await api(endpoint, { method: \"POST\", body: { username, password } });\n localStorage.setItem(\"fc_token\", data.token);\n onLogin();\n } catch (err: any) {\n setError(err.message);\n }\n };\n\n return (\n

📚 Flashcard Piles

Spaced repetition made simple

\n setUsername(e.target.value)}\n className=\"w-full px-4 py-3 border border-gray-300 rounded-lg focus:ring-2 focus:ring-indigo-400 focus:outline-none\"\n />\n setPassword(e.target.value)}\n className=\"w-full px-4 py-3 border border-gray-300 rounded-lg focus:ring-2 focus:ring-indigo-400 focus:outline-none\"\n />\n {error &&

{error}

}\n \n \n

\n {isRegister ? \"Already have an account?\" : \"Don't have an account?\"}{\" \"}\n \n

\n );\n}\n\n// ---- Review Screen ----\nfunction ReviewScreen({ onDone }: { onDone: () => void }) {\n const [cards, setCards] = useState([]);\n const [index, setIndex] = useState(0);\n const [flipped, setFlipped] = useState(false);\n const [loading, setLoading] = useState(true);\n const [feedback, setFeedback] = useState(null);\n\n useEffect(() => {\n api(\"/review\").then((c) => { setCards(c); setLoading(false); });\n }, []);\n\n const handleAnswer = async (correct: boolean) => {\n const card = cards[index];\n const result = await api(`/review/${card.id}`, { method: \"POST\", body: { correct } });\n setFeedback(correct ? `✅ Moved to Pile ${result.newPileNumber}` : `❌ Back to Pile 1`);\n setTimeout(() => {\n setFeedback(null);\n setFlipped(false);\n if (index + 1 >= cards.length) {\n onDone();\n } else {\n setIndex(index + 1);\n }\n }, 1000);\n };\n\n if (loading) return

;\n if (cards.length === 0) return (\n

🎉

No cards due for review!

\n \n

\n );\n\n const card = cards[index];\n return (\n

\n Card {index + 1} of {cards.length}\n Pile {card.pile_number}\n

\n\n setFlipped(!flipped)}\n className=\"bg-white rounded-2xl shadow-lg p-8 min-h-[250px] flex items-center justify-center cursor-pointer hover:shadow-xl transition border-2 border-gray-100\"\n >\n

{flipped ? \"ANSWER\" : \"QUESTION\"}

{flipped ? card.back : card.front}

\n {!flipped &&

Click to reveal answer

}\n

\n\n {feedback && (\n

{feedback}

\n )}\n\n {flipped && !feedback && (\n

\n \n \n

\n )}\n\n \n \n );\n}\n\n// ---- Pile Settings ----\nfunction PileSettings({ piles, onSave }: { piles: any[]; onSave: (p: any[]) => void }) {\n const [editing, setEditing] = useState(piles.map(p => ({ ...p })));\n\n const addPile = () => {\n const maxNum = editing.length > 0 ? Math.max(...editing.map(p => p.pile_number)) : 0;\n setEditing([...editing, { pile_number: maxNum + 1, label: `Pile ${maxNum + 1}`, review_interval_days: Math.pow(2, maxNum) }]);\n };\n\n const removePile = (idx: number) => {\n if (editing.length <= 1) return;\n setEditing(editing.filter((_, i) => i !== idx));\n };\n\n const update = (idx: number, field: string, value: any) => {\n const updated = [...editing];\n updated[idx] = { ...updated[idx], [field]: value };\n setEditing(updated);\n };\n\n return (\n

⚙️ Pile Settings

\n {editing.map((pile, idx) => (\n

\n #{pile.pile_number}\n update(idx, \"label\", e.target.value)}\n className=\"flex-1 px-3 py-2 border rounded-lg text-sm\"\n placeholder=\"Label\"\n />\n

\n Every\n update(idx, \"review_interval_days\", parseFloat(e.target.value) || 1)}\n className=\"w-16 px-2 py-2 border rounded-lg text-sm text-center\"\n min=\"0.01\"\n step=\"0.5\"\n />\n day(s)\n

\n \n

\n ))}\n

\n \n onSave(editing)}\n className=\"bg-indigo-600 text-white px-6 py-2 rounded-lg text-sm font-semibold hover:bg-indigo-700\"\n >\n Save Changes\n \n

\n );\n}\n\n// ---- Card Manager ----\nfunction CardManager({ cards, piles, onRefresh }: { cards: any[]; piles: any[]; onRefresh: () => void }) {\n const [front, setFront] = useState(\"\");\n const [back, setBack] = useState(\"\");\n const [editingId, setEditingId] = useState(null);\n const [editFront, setEditFront] = useState(\"\");\n const [editBack, setEditBack] = useState(\"\");\n const [filter, setFilter] = useState(\"all\");\n\n const addCard = async () => {\n if (!front.trim() || !back.trim()) return;\n await api(\"/cards\", { method: \"POST\", body: { front, back } });\n setFront(\"\");\n setBack(\"\");\n onRefresh();\n };\n\n const deleteCard = async (id: number) => {\n await api(`/cards/${id}`, { method: \"DELETE\" });\n onRefresh();\n };\n\n const startEdit = (card: any) => {\n setEditingId(card.id);\n setEditFront(card.front);\n setEditBack(card.back);\n };\n\n const saveEdit = async () => {\n if (!editingId) return;\n await api(`/cards/${editingId}`, { method: \"PUT\", body: { front: editFront, back: editBack } });\n setEditingId(null);\n onRefresh();\n };\n\n const filtered = filter === \"all\" ? cards : cards.filter(c => c.pile_number === filter);\n\n return (\n

🗂️ My Cards ({cards.length})

\n\n {/* Add card form */}\n

\n setFront(e.target.value)}\n placeholder=\"Front (question)\"\n className=\"flex-1 px-3 py-2 border rounded-lg text-sm\"\n onKeyDown={(e) => e.key === \"Enter\" && document.getElementById(\"backInput\")?.focus()}\n />\n setBack(e.target.value)}\n placeholder=\"Back (answer)\"\n className=\"flex-1 px-3 py-2 border rounded-lg text-sm\"\n onKeyDown={(e) => e.key === \"Enter\" && addCard()}\n />\n \n

\n\n {/* Filter by pile */}\n

\n setFilter(\"all\")}\n className={`px-3 py-1 rounded-full text-xs font-semibold ${filter === \"all\" ? \"bg-indigo-600 text-white\" : \"bg-gray-100 text-gray-600\"}`}\n >\n All\n \n {piles.map(p => (\n setFilter(p.pile_number)}\n className={`px-3 py-1 rounded-full text-xs font-semibold ${filter === p.pile_number ? \"bg-indigo-600 text-white\" : \"bg-gray-100 text-gray-600\"}`}\n >\n {p.label} ({cards.filter(c => c.pile_number === p.pile_number).length})\n \n ))}\n

\n\n {/* Card list */}\n

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

No cards yet. Add one above!

}\n {filtered.map((card) => (\n

\n {editingId === card.id ? (\n <>\n setEditFront(e.target.value)} className=\"flex-1 px-2 py-1 border rounded text-sm\" />\n setEditBack(e.target.value)} className=\"flex-1 px-2 py-1 border rounded text-sm\" />\n \n \n \n ) : (\n <>\n P{card.pile_number}\n {card.front}\n {card.back}\n \n \n \n )}\n

\n ))}\n

\n );\n}\n\n// ---- Main Dashboard ----\nfunction Dashboard({ onLogout }: { onLogout: () => void }) {\n const [view, setView] = useState<\"dashboard\" | \"review\" | \"settings\">(\"dashboard\");\n const [cards, setCards] = useState([]);\n const [piles, setPiles] = useState([]);\n const [stats, setStats] = useState(null);\n\n const refresh = useCallback(async () => {\n const [c, p, s] = await Promise.all([api(\"/cards\"), api(\"/piles\"), api(\"/stats\")]);\n setCards(c);\n setPiles(p);\n setStats(s);\n }, []);\n\n useEffect(() => { refresh(); }, [refresh]);\n\n const savePiles = async (newPiles: any[]) => {\n // Re-number piles sequentially\n const renumbered = newPiles.map((p, i) => ({ ...p, pile_number: i + 1, label: p.label || `Pile ${i + 1}` }));\n await api(\"/piles\", { method: \"PUT\", body: { piles: renumbered } });\n await refresh();\n setView(\"dashboard\");\n };\n\n if (view === \"review\") return { setView(\"dashboard\"); refresh(); }} />;\n\n return (\n

\n {/* Header */}\n

setView(\"dashboard\")}>📚 Flashcard Piles

\n view source\n \n

\n\n

\n {view === \"settings\" ? (\n <>\n \n \n \n ) : (\n <>\n {/* Stats bar */}\n

{cards.length}

Total Cards

{stats?.dueCount || 0}

Due for Review

{piles.length}

Piles

stats?.dueCount > 0 && setView(\"review\")}>\n

{stats?.dueCount > 0 ? \"🔥\" : \"✅\"}

{stats?.dueCount > 0 ? \"Start Review!\" : \"All caught up!\"}

\n\n {/* Pile visualization */}\n

📊 Pile Overview

\n \n

\n {piles.map((pile) => {\n const count = cards.filter(c => c.pile_number === pile.pile_number).length;\n const maxCount = Math.max(...piles.map(p => cards.filter(c => c.pile_number === p.pile_number).length), 1);\n const height = Math.max(20, (count / maxCount) * 100);\n return (\n

\n {count}\n \n

{pile.label}

Every {pile.review_interval_days}d

\n );\n })}\n

\n\n {/* Action buttons */}\n {stats?.dueCount > 0 && (\n setView(\"review\")}\n className=\"w-full bg-indigo-600 text-white py-4 rounded-xl font-bold text-lg hover:bg-indigo-700 transition shadow-lg\"\n >\n 📖 Review {stats.dueCount} Due Card{stats.dueCount !== 1 ? \"s\" : \"\"}\n \n )}\n\n {/* Card manager */}\n \n \n )}\n

\n );\n}\n\n// ---- App Root ----\nexport default function App() {\n const [loggedIn, setLoggedIn] = useState(!!localStorage.getItem(\"fc_token\"));\n\n const handleLogout = () => {\n localStorage.removeItem(\"fc_token\");\n setLoggedIn(false);\n };\n\n if (!loggedIn) return setLoggedIn(true)} />;\n return ;\n}\n",[161],"4698ff3a-5611-11f1-8e65-ee650bb23af1","api.ts","4698ffee-5611-11f1-8e65-ee650bb23af1",3,["D",1779476762394],"import { Hono } from \"npm:hono@4\";\nimport { sqlite, initDB } from \"./db.ts\";\nimport { register, login, parseToken } from \"./auth.ts\";\n\nconst api = new Hono();\n\n// Auth middleware\nfunction getUserId(c: any): number | null {\n const auth = c.req.header(\"Authorization\");\n if (!auth?.startsWith(\"Bearer \")) return null;\n return parseToken(auth.slice(7));\n}\n\nfunction requireAuth(c: any): number {\n const userId = getUserId(c);\n if (!userId) throw new Error(\"Unauthorized\");\n return userId;\n}\n\n// Auth routes\napi.post(\"/auth/register\", async (c) => {\n await initDB();\n const { username, password } = await c.req.json();\n const result = await register(username, password);\n if (typeof result === \"string\") return c.json({ error: result }, 400);\n return c.json(result);\n});\n\napi.post(\"/auth/login\", async (c) => {\n await initDB();\n const { username, password } = await c.req.json();\n const result = await login(username, password);\n if (typeof result === \"string\") return c.json({ error: result }, 400);\n return c.json(result);\n});\n\n// Piles routes\napi.get(\"/piles\", async (c) => {\n await initDB();\n const userId = requireAuth(c);\n const piles = await sqlite.execute({ sql: \"SELECT * FROM piles WHERE user_id = ? ORDER BY pile_number\", args: [userId] });\n return c.json(piles.rows);\n});\n\napi.put(\"/piles\", async (c) => {\n await initDB();\n const userId = requireAuth(c);\n const { piles } = await c.req.json() as { piles: { pile_number: number; label: string; review_interval_days: number }[] };\n\n // Get current max pile number\n const currentPiles = await sqlite.execute({ sql: \"SELECT pile_number FROM piles WHERE user_id = ?\", args: [userId] });\n const currentNums = new Set(currentPiles.rows.map((r: any) => r.pile_number));\n const newNums = new Set(piles.map(p => p.pile_number));\n\n const statements: any[] = [];\n\n // Remove piles that no longer exist — move their cards to pile 1\n for (const num of currentNums) {\n if (!newNums.has(num)) {\n statements.push({ sql: \"UPDATE cards SET pile_number = 1, next_review = datetime('now') WHERE user_id = ? AND pile_number = ?\", args: [userId, num] });\n statements.push({ sql: \"DELETE FROM piles WHERE user_id = ? AND pile_number = ?\", args: [userId, num] });\n }\n }\n\n // Upsert piles\n for (const p of piles) {\n if (currentNums.has(p.pile_number)) {\n statements.push({\n sql: \"UPDATE piles SET label = ?, review_interval_days = ? WHERE user_id = ? AND pile_number = ?\",\n args: [p.label, p.review_interval_days, userId, p.pile_number],\n });\n } else {\n statements.push({\n sql: \"INSERT INTO piles (user_id, pile_number, label, review_interval_days) VALUES (?, ?, ?, ?)\",\n args: [userId, p.pile_number, p.label, p.review_interval_days],\n });\n }\n }\n\n // Cards in piles beyond the new max go to the highest pile\n const maxPile = Math.max(...piles.map(p => p.pile_number));\n statements.push({\n sql: \"UPDATE cards SET pile_number = ? WHERE user_id = ? AND pile_number > ?\",\n args: [maxPile, userId, maxPile],\n });\n\n if (statements.length > 0) await sqlite.batch(statements);\n\n const updated = await sqlite.execute({ sql: \"SELECT * FROM piles WHERE user_id = ? ORDER BY pile_number\", args: [userId] });\n return c.json(updated.rows);\n});\n\n// Cards routes\napi.get(\"/cards\", async (c) => {\n await initDB();\n const userId = requireAuth(c);\n const cards = await sqlite.execute({ sql: \"SELECT * FROM cards WHERE user_id = ? ORDER BY pile_number, created_at\", args: [userId] });\n return c.json(cards.rows);\n});\n\napi.post(\"/cards\", async (c) => {\n await initDB();\n const userId = requireAuth(c);\n const { front, back } = await c.req.json();\n if (!front || !back) return c.json({ error: \"Front and back are required\" }, 400);\n const result = await sqlite.execute({\n sql: \"INSERT INTO cards (user_id, front, back, pile_number, next_review) VALUES (?, ?, ?, 1, datetime('now'))\",\n args: [userId, front, back],\n });\n return c.json({ id: result.lastInsertRowid, front, back, pile_number: 1 });\n});\n\napi.put(\"/cards/:id\", async (c) => {\n await initDB();\n const userId = requireAuth(c);\n const id = parseInt(c.req.param(\"id\"));\n const { front, back } = await c.req.json();\n await sqlite.execute({\n sql: \"UPDATE cards SET front = ?, back = ? WHERE id = ? AND user_id = ?\",\n args: [front, back, id, userId],\n });\n return c.json({ ok: true });\n});\n\napi.delete(\"/cards/:id\", async (c) => {\n await initDB();\n const userId = requireAuth(c);\n const id = parseInt(c.req.param(\"id\"));\n await sqlite.execute({ sql: \"DELETE FROM cards WHERE id = ? AND user_id = ?\", args: [id, userId] });\n return c.json({ ok: true });\n});\n\n// Review routes\napi.get(\"/review\", async (c) => {\n await initDB();\n const userId = requireAuth(c);\n // Get cards due for review (next_review <= now)\n const cards = await sqlite.execute({\n sql: \"SELECT * FROM cards WHERE user_id = ? AND next_review <= datetime('now') ORDER BY pile_number ASC, next_review ASC\",\n args: [userId],\n });\n return c.json(cards.rows);\n});\n\napi.post(\"/review/:id\", async (c) => {\n await initDB();\n const userId = requireAuth(c);\n const cardId = parseInt(c.req.param(\"id\"));\n const { correct } = await c.req.json();\n\n // Get card and piles\n const cardResult = await sqlite.execute({ sql: \"SELECT * FROM cards WHERE id = ? AND user_id = ?\", args: [cardId, userId] });\n if (cardResult.rows.length === 0) return c.json({ error: \"Card not found\" }, 404);\n const card = cardResult.rows[0] as any;\n\n const pilesResult = await sqlite.execute({ sql: \"SELECT * FROM piles WHERE user_id = ? ORDER BY pile_number\", args: [userId] });\n const piles = pilesResult.rows as any[];\n const maxPile = Math.max(...piles.map(p => p.pile_number));\n\n let newPileNumber: number;\n if (correct) {\n newPileNumber = Math.min(card.pile_number + 1, maxPile);\n } else {\n newPileNumber = 1;\n }\n\n // Find the interval for the new pile\n const targetPile = piles.find(p => p.pile_number === newPileNumber);\n const intervalDays = targetPile ? targetPile.review_interval_days : 1;\n\n // Calculate next review as fractional days (supports hours)\n const intervalHours = intervalDays * 24;\n\n await sqlite.execute({\n sql: `UPDATE cards SET pile_number = ?, last_reviewed = datetime('now'), next_review = datetime('now', '+${Math.round(intervalHours)} hours') WHERE id = ? AND user_id = ?`,\n args: [newPileNumber, cardId, userId],\n });\n\n return c.json({ newPileNumber, nextReviewIn: `${intervalDays} day(s)` });\n});\n\n// Stats\napi.get(\"/stats\", async (c) => {\n await initDB();\n const userId = requireAuth(c);\n const stats = await sqlite.execute({\n sql: \"SELECT pile_number, COUNT(*) as count FROM cards WHERE user_id = ? GROUP BY pile_number ORDER BY pile_number\",\n args: [userId],\n });\n const dueCount = await sqlite.execute({\n sql: \"SELECT COUNT(*) as count FROM cards WHERE user_id = ? AND next_review <= datetime('now')\",\n args: [userId],\n });\n return c.json({ pileStats: stats.rows, dueCount: (dueCount.rows[0] as any).count });\n});\n\nexport default api;\n",[168],"pulls","branches","forks","envVars",{"_181":66,"_183":66},"connections",{"_181":66,"_182":66},"count","unfilledCount","emptyCount",{"_46":167,"_37":168,"_35":169,"_140":-5,"_44":45,"_43":170,"_141":30,"_41":202,"_13":66,"_38":150,"_39":172,"_29":30,"_143":-5,"_190":203,"_32":204},{"_46":160,"_37":161,"_35":162,"_140":-5,"_44":45,"_43":163,"_141":30,"_41":199,"_13":66,"_38":150,"_39":165,"_29":30,"_143":-5,"_190":200,"_32":201},{"_46":153,"_37":154,"_35":155,"_140":-5,"_44":45,"_43":156,"_141":62,"_41":196,"_13":66,"_38":150,"_39":158,"_29":30,"_143":-5,"_190":197,"_32":198},{"_46":145,"_37":146,"_35":147,"_140":-5,"_44":45,"_43":148,"_141":62,"_41":193,"_13":66,"_38":150,"_39":151,"_29":30,"_143":-5,"_190":194,"_32":195},{"_46":139,"_37":33,"_35":36,"_140":-5,"_44":45,"_43":14,"_141":62,"_41":189,"_13":66,"_38":26,"_39":40,"_29":30,"_143":-5,"_190":191,"_32":192},["D",1779476839670],"children",[],[33],["D",1779476723001],[],[146],["D",1779476735785],[],[154],["D",1779476831513],[],[161],["D",1779476762394],[],[168],["D",1779476713589],["D",1789502486629],{"_103":102,"_111":107},{"_103":102,"_104":105,"_106":107,"_19":58,"_108":109,"_110":30},{"_13":92,"_37":93,"_46":45,"_94":47,"_95":-5,"_96":-5,"_97":-5,"_98":-5,"_99":-5,"_100":48,"_101":102},"ctx",{"_85":-5,"_131":243,"_244":245,"_246":247,"_248":30,"_249":30,"_250":30,"_251":62,"_252":-5,"_253":-7,"_254":-7,"_255":66,"_256":30,"_257":30,"_258":-5,"_259":30,"_260":30,"_261":30,"_262":-5},"ENV",{"_214":215,"_216":217,"_218":93,"_219":220,"_221":222,"_223":224,"_225":226,"_227":228,"_229":230,"_231":232,"_233":234,"_235":236,"_237":238,"_239":240,"_241":242},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","5015b8df46402d8bba4f485ecc37aec202b0e06b","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"]

Diff · v5