[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_284":285,"_286":287},"routes/_app.x.$handle.$name",{"_106":105,"_32":46,"_115":92,"_27":116,"_13":14,"_117":-5,"_11":118,"_119":120,"_121":122,"_123":124,"_125":126,"_20":-5,"_127":128,"_129":130,"_131":25,"_132":133,"_134":61,"_135":-5,"_136":-5,"_137":138},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_44":45,"_32":46,"_39":47,"_48":-5,"_49":25,"_50":51,"_52":51,"_53":54,"_55":56,"_18":57,"_58":59,"_60":61,"_62":-5,"_63":-5,"_64":65,"_66":67,"_68":69,"_70":71,"_72":73,"_74":-5,"_75":76,"_77":76,"_78":79,"_80":79,"_81":79,"_82":76,"_83":76,"_84":85,"_86":87,"_88":89,"_90":25},"version",6,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":33,"_34":35,"_36":38,"_39":40,"_41":14,"_42":43,"_24":25},"previous",{"_30":31,"_32":33,"_34":35,"_36":37},"deleted",false,"deletedHere","path","backend/moex.ts","latestPath","fileId","aa14c3b6-7e2d-11f1-8c04-1607ee4eb77e","name","moex.ts","fileType","script","content","// Реальный каталог облигаций с Московской биржи (MOEX ISS, публичный бесплатный API).\n// Кэшируем в памяти на 15 минут, чтобы не долбить биржу на каждый запрос пользователя.\n\nexport interface Bond {\n id: string;\n ticker: string;\n issuer: string;\n rating: string; // MOEX ISS не отдаёт кредитный рейтинг в открытом доступе — помечаем \"—\"\n couponRate: number;\n maturityDate: string;\n hasOffer: boolean;\n liquidity: \"low\" | \"medium\" | \"high\";\n duration: number;\n faceValue: number;\n currency: string;\n}\n\ninterface CacheEntry {\n data: Bond[];\n fetchedAt: number;\n}\n\nlet cache: CacheEntry | null = null;\nconst CACHE_TTL_MS = 15 * 60 * 1000;\n\nconst BOARDS = [\n { board: \"TQCB\", label: \"corporate\" }, // корпоративные облигации\n { board: \"TQOB\", label: \"ofz\" }, // ОФЗ\n];\n\nconst COLUMNS = [\n \"SECID\", \"SHORTNAME\", \"COUPONPERCENT\", \"COUPONVALUE\", \"COUPONPERIOD\",\n \"MATDATE\", \"OFFERDATE\", \"FACEVALUE\", \"ISSUESIZE\", \"CURRENCYID\", \"LOTSIZE\",\n].join(\",\");\n\nfunction computeDuration(matDate: string, offerDate: string | null): number {\n const target = offerDate && offerDate.length === 10 ? offerDate : matDate;\n if (!target) return 0;\n const ms = new Date(target).getTime() - Date.now();\n if (!Number.isFinite(ms) || ms <= 0) return 0;\n return Math.round((ms / (1000 * 60 * 60 * 24 * 365)) * 10) / 10;\n}\n\nfunction liquidityFromIssueSize(issueSize: number): \"low\" | \"medium\" | \"high\" {\n if (issueSize >= 5_000_000_000) return \"high\";\n if (issueSize >= 1_000_000_000) return \"medium\";\n return \"low\";\n}\n\nasync function fetchBoard(board: string): Promise {\n const url = `https://iss.moex.com/iss/engines/stock/markets/bonds/boards/${board}/securities.json?iss.meta=off&securities.columns=${COLUMNS}`;\n const res = await fetch(url);\n if (!res.ok) throw new Error(`MOEX ISS ${board} responded ${res.status}`);\n const json = await res.json();\n const block = json.securities;\n if (!block || !block.columns || !block.data) return [];\n const cols: string[] = block.columns;\n const idx = (name: string) => cols.indexOf(name);\n const bonds: Bond[] = [];\n for (const row of block.data as unknown[][]) {\n const secid = row[idx(\"SECID\")] as string | null;\n const shortname = row[idx(\"SHORTNAME\")] as string | null;\n const coupon = row[idx(\"COUPONPERCENT\")] as number | null;\n const matdate = row[idx(\"MATDATE\")] as string | null;\n const offerdate = row[idx(\"OFFERDATE\")] as string | null;\n const faceValue = (row[idx(\"FACEVALUE\")] as number | null) ?? 1000;\n const issueSize = (row[idx(\"ISSUESIZE\")] as number | null) ?? 0;\n const currency = (row[idx(\"CURRENCYID\")] as string | null) ?? \"SUR\";\n if (!secid || !shortname || !coupon || !matdate) continue;\n bonds.push({\n id: secid,\n ticker: secid,\n issuer: shortname,\n rating: \"—\",\n couponRate: Math.round(coupon * 10) / 10,\n maturityDate: matdate,\n hasOffer: !!offerdate,\n liquidity: liquidityFromIssueSize(issueSize),\n duration: computeDuration(matdate, offerdate),\n faceValue,\n currency: currency === \"SUR\" ? \"RUB\" : currency,\n });\n }\n return bonds;\n}\n\nexport async function getBondCatalog(forceRefresh = false): Promise {\n if (!forceRefresh && cache && Date.now() - cache.fetchedAt < CACHE_TTL_MS) {\n return cache.data;\n }\n const results = await Promise.allSettled(BOARDS.map((b) => fetchBoard(b.board)));\n let all: Bond[] = [];\n for (const r of results) {\n if (r.status === \"fulfilled\") all = all.concat(r.value);\n }\n // Убираем облигации без купона/с погашением в прошлом, сортируем по размеру выпуска (через liquidity/duration уже есть),\n // берём разумное количество, чтобы не отдавать клиенту тысячи строк.\n const now = Date.now();\n all = all.filter((b) => new Date(b.maturityDate).getTime() > now && b.couponRate > 0);\n all.sort((a, b) => (b.liquidity === a.liquidity ? 0 : b.liquidity === \"high\" ? -1 : 1));\n all = all.slice(0, 120);\n if (all.length > 0) {\n cache = { data: all, fetchedAt: Date.now() };\n }\n return all;\n}\n","// Реальный каталог облигаций с Московской биржи (MOEX ISS, публичный бесплатный API).\n// Кэшируем в памяти на 15 минут, чтобы не долбить биржу на каждый запрос пользователя.\n\nexport interface Bond {\n id: string;\n ticker: string;\n issuer: string;\n rating: string; // MOEX ISS не отдаёт кредитный рейтинг в открытом доступе — помечаем \"—\"\n couponRate: number;\n maturityDate: string;\n hasOffer: boolean;\n liquidity: \"low\" | \"medium\" | \"high\";\n duration: number;\n faceValue: number;\n currency: string;\n}\n\ninterface CacheEntry {\n data: Bond[];\n fetchedAt: number;\n}\n\nlet cache: CacheEntry | null = null;\nconst CACHE_TTL_MS = 15 * 60 * 1000;\n\nconst BOARDS = [\n { board: \"TQCB\", label: \"corporate\" }, // корпоративные облигации\n { board: \"TQOB\", label: \"ofz\" }, // ОФЗ\n];\n\nconst COLUMNS = [\n \"SECID\", \"SHORTNAME\", \"COUPONPERCENT\", \"COUPONVALUE\", \"COUPONPERIOD\",\n \"MATDATE\", \"OFFERDATE\", \"FACEVALUE\", \"ISSUESIZE\", \"CURRENCYID\", \"LOTSIZE\",\n].join(\",\");\n\nfunction computeDuration(matDate: string, offerDate: string | null): number {\n const target = offerDate && offerDate.length === 10 ? offerDate : matDate;\n if (!target) return 0;\n const ms = new Date(target).getTime() - Date.now();\n if (!Number.isFinite(ms) || ms <= 0) return 0;\n return Math.round((ms / (1000 * 60 * 60 * 24 * 365)) * 10) / 10;\n}\n\n// ISSUESIZE от MOEX ISS — это количество бумаг в выпуске (штуки), а не сумма в рублях.\nfunction liquidityFromIssueSize(issueSize: number): \"low\" | \"medium\" | \"high\" {\n if (issueSize >= 3_000_000) return \"high\";\n if (issueSize >= 500_000) return \"medium\";\n return \"low\";\n}\n\nasync function fetchBoard(board: string): Promise {\n const url = `https://iss.moex.com/iss/engines/stock/markets/bonds/boards/${board}/securities.json?iss.meta=off&securities.columns=${COLUMNS}`;\n const res = await fetch(url);\n if (!res.ok) throw new Error(`MOEX ISS ${board} responded ${res.status}`);\n const json = await res.json();\n const block = json.securities;\n if (!block || !block.columns || !block.data) return [];\n const cols: string[] = block.columns;\n const idx = (name: string) => cols.indexOf(name);\n const bonds: Bond[] = [];\n for (const row of block.data as unknown[][]) {\n const secid = row[idx(\"SECID\")] as string | null;\n const shortname = row[idx(\"SHORTNAME\")] as string | null;\n const coupon = row[idx(\"COUPONPERCENT\")] as number | null;\n const matdate = row[idx(\"MATDATE\")] as string | null;\n const offerdate = row[idx(\"OFFERDATE\")] as string | null;\n const faceValue = (row[idx(\"FACEVALUE\")] as number | null) ?? 1000;\n const issueSize = (row[idx(\"ISSUESIZE\")] as number | null) ?? 0;\n const currency = (row[idx(\"CURRENCYID\")] as string | null) ?? \"SUR\";\n if (!secid || !shortname || !coupon || !matdate) continue;\n bonds.push({\n id: secid,\n ticker: secid,\n issuer: shortname,\n rating: \"—\",\n couponRate: Math.round(coupon * 10) / 10,\n maturityDate: matdate,\n hasOffer: !!offerdate,\n liquidity: liquidityFromIssueSize(issueSize),\n duration: computeDuration(matdate, offerdate),\n faceValue,\n currency: currency === \"SUR\" ? \"RUB\" : currency,\n });\n }\n return bonds;\n}\n\nexport async function getBondCatalog(forceRefresh = false): Promise {\n if (!forceRefresh && cache && Date.now() - cache.fetchedAt < CACHE_TTL_MS) {\n return cache.data;\n }\n const results = await Promise.allSettled(BOARDS.map((b) => fetchBoard(b.board)));\n let all: Bond[] = [];\n for (const r of results) {\n if (r.status === \"fulfilled\") all = all.concat(r.value);\n }\n // Убираем облигации без купона/с погашением в прошлом, сортируем по размеру выпуска (через liquidity/duration уже есть),\n // берём разумное количество, чтобы не отдавать клиенту тысячи строк.\n const now = Date.now();\n all = all.filter((b) => new Date(b.maturityDate).getTime() > now && b.couponRate > 0);\n all.sort((a, b) => (b.liquidity === a.liquidity ? 0 : b.liquidity === \"high\" ? -1 : 1));\n all = all.slice(0, 120);\n if (all.length > 0) {\n cache = { data: all, fetchedAt: Date.now() };\n }\n return all;\n}\n","createdAt",["D",1783887066382],"branchVersion","branchId","ac24cfe3-aa4a-4a44-ac23-dfa129884367","id","57d5c0ab-460a-4be7-9d20-9cb49eb8f0f0","finsystem-pro",["D",1783886796403],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","ФинСистема — бюджет + портфель облигаций","imageUrl","https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/64dc00cc-94d9-47dd-81b1-dde02610d900/square512?exp=1789556399&sig=39cf692678889e4858e1d3f239cccdbb768d0b4bdeeecb6f122e7581a8e69c0b","7392ed86-5030-4ce7-948e-d7a47fad19d8","pinnedFileId","019f57f0-56c5-76eb-9c36-7947eada3c8f","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","019f57e3-4ff5-7637-8a30-e83785c0308e","tursoName","57d5c0ab460a4be79d209cb49eb8f0f0","tursoHostname","57d5c0ab460a4be79d209cb49eb8f0f0-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789473046147],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_106":105,"_114":110},"org",{"_106":105,"_107":108,"_109":110,"_18":57,"_111":112,"_113":25},"branch",{"_13":91,"_32":92,"_44":43,"_93":45,"_94":95,"_96":97,"_98":51,"_99":100,"_101":102,"_103":46,"_104":105},"isOwned",198,"main","projectId","forkedBranchId","961078ea-f528-11ef-aa68-569c3dd06744","forkedBranchVersion",89,"forkedProjectPrivacy","forkedProjectId","96102714-f528-11ef-aa68-569c3dd06744","forkedProjectOrgId","019aa807-52c2-709c-928b-2029bae9a558","projectName","userHandle","greenpes92","handle","displayName","Иван Забавников","avatar","https://lh3.googleusercontent.com/a/ACg8ocJcdteRlJJiR797nVlMg2OC01cNcvSxYR_S-gOUIwQ2oMi6Ma0p=s96-c","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_44":45,"_32":46,"_39":279,"_48":-5,"_49":25,"_50":51,"_52":51,"_53":54,"_55":56,"_18":57,"_58":59,"_60":61,"_62":-5,"_63":-5,"_64":65,"_66":67,"_68":69,"_70":71,"_72":280,"_74":-5,"_75":76,"_77":76,"_78":79,"_80":79,"_81":79,"_82":76,"_83":76,"_84":281,"_86":282,"_88":283,"_90":25},"tree",[193,197,204,205],"files",[193,194,195,196,197,198,199,200,201,202,203,204,205],"counts",{"_183":65,"_184":160,"_185":65,"_186":187,"_188":189},"contents",[150,151,152,153],"upstreamProject",{"_44":100,"_32":146,"_53":147,"_55":56,"_50":51,"_84":148},"upstreamBranch",{"_44":95,"_39":139,"_140":141,"_32":92,"_93":100,"_13":142,"_94":-5,"_96":-5,"_143":144,"_48":-5,"_90":25,"_50":51,"_104":145,"_66":102,"_103":146},"emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},["D",1740674013689],"updatedAt",["D",1785420707976],91,"lockfileKey","1785420708123-esm.town_v_templates_react-hono-starter@91-main","templates","react-hono-starter","Starter template with client-side React & Hono server",{"_106":145,"_114":149},"https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/129cab32-3bd7-4c3e-f39b-f12900c76100/square512?exp=1789556399&sig=d4d039bf60786a03d56ec8a29ec1b19630253aab318e490fcd07a6f24846b070",{"_44":177,"_32":178,"_30":179,"_156":-5,"_42":43,"_41":180,"_158":61,"_39":181,"_13":65,"_34":175,"_36":-5,"_24":25,"_163":-5,"_27":182},{"_44":171,"_32":172,"_30":173,"_156":-5,"_42":43,"_41":160,"_158":61,"_39":174,"_13":65,"_34":175,"_36":-5,"_24":25,"_163":-5,"_27":176},{"_44":165,"_32":166,"_30":167,"_156":-5,"_42":43,"_41":160,"_158":61,"_39":168,"_13":65,"_34":20,"_36":169,"_24":25,"_163":-5,"_27":170},{"_44":154,"_32":155,"_30":59,"_156":-5,"_42":43,"_41":157,"_158":25,"_39":159,"_13":160,"_34":161,"_36":162,"_24":25,"_163":-5,"_27":164},"07d10b3d-4682-4ab7-885f-b1babc2e05d6","index.ts","parentId",5,"latest",["D",1783887022134],1,"http","import { parseVal, serveFile } from \"https://esm.town/v/std/utils/index.ts\";\nimport { Hono } from \"npm:hono\";\nimport { getCookie, setCookie, deleteCookie } from \"npm:hono/cookie\";\nimport {\n initAuthTables, createUser, findUserByEmail, verifyPassword,\n createSession, getSessionUser, deleteSession,\n} from \"./backend/auth.ts\";\nimport { initDataTable, getUserData, setUserDataKey, DATA_KEYS, type DataKey } from \"./backend/db.ts\";\nimport { getBondCatalog } from \"./backend/moex.ts\";\n\nconst app = new Hono();\n\nconst COOKIE_NAME = \"fsp_session\";\n\nlet tablesReady: Promise | null = null;\nfunction ensureTables() {\n if (!tablesReady) {\n tablesReady = (async () => {\n await initAuthTables();\n await initDataTable();\n })();\n }\n return tablesReady;\n}\napp.use(\"*\", async (c, next) => {\n await ensureTables();\n await next();\n});\n\n// ---------- static frontend ----------\napp.get(\"/\", () => serveFile(\"/frontend/index.html\"));\napp.get(\"/frontend/**/*\", (c) => serveFile(c.req.path));\napp.get(\"/source\", (c) => c.redirect(parseVal().links.self.val));\n\n// ---------- auth helpers ----------\nasync function requireUser(c: any) {\n const token = getCookie(c, COOKIE_NAME);\n const user = await getSessionUser(token);\n return user;\n}\n\nfunction publicUser(u: { id: string; email: string; tier: string }) {\n return { id: u.id, email: u.email, tier: u.tier };\n}\n\n// ---------- auth routes ----------\napp.post(\"/api/register\", async (c) => {\n const body = await c.req.json().catch(() => null);\n const email = (body?.email ?? \"\").toString().trim();\n const password = (body?.password ?? \"\").toString();\n if (!email || !email.includes(\"@\")) return c.json({ error: \"Некорректный email\" }, 400);\n if (!password || password.length < 6) return c.json({ error: \"Пароль должен быть не короче 6 символов\" }, 400);\n const existing = await findUserByEmail(email);\n if (existing) return c.json({ error: \"Пользователь с таким email уже зарегистрирован\" }, 409);\n const user = await createUser(email, password);\n const session = await createSession(user.id);\n setCookie(c, COOKIE_NAME, session.token, {\n httpOnly: true, secure: true, sameSite: \"Lax\", path: \"/\", maxAge: 60 * 60 * 24 * 30,\n });\n return c.json({ user: publicUser(user) });\n});\n\napp.post(\"/api/login\", async (c) => {\n const body = await c.req.json().catch(() => null);\n const email = (body?.email ?? \"\").toString().trim();\n const password = (body?.password ?? \"\").toString();\n const user = await findUserByEmail(email);\n if (!user || !(await verifyPassword(password, user.password_hash))) {\n return c.json({ error: \"Неверный email или пароль\" }, 401);\n }\n const session = await createSession(user.id);\n setCookie(c, COOKIE_NAME, session.token, {\n httpOnly: true, secure: true, sameSite: \"Lax\", path: \"/\", maxAge: 60 * 60 * 24 * 30,\n });\n return c.json({ user: publicUser(user) });\n});\n\napp.post(\"/api/logout\", async (c) => {\n const token = getCookie(c, COOKIE_NAME);\n await deleteSession(token);\n deleteCookie(c, COOKIE_NAME, { path: \"/\" });\n return c.json({ ok: true });\n});\n\napp.get(\"/api/me\", async (c) => {\n const user = await requireUser(c);\n if (!user) return c.json({ user: null }, 200);\n return c.json({ user: publicUser(user) });\n});\n\n// ---------- data routes (require auth) ----------\napp.get(\"/api/data\", async (c) => {\n const user = await requireUser(c);\n if (!user) return c.json({ error: \"Не авторизован\" }, 401);\n const data = await getUserData(user.id);\n return c.json({ data });\n});\n\napp.put(\"/api/data/:key\", async (c) => {\n const user = await requireUser(c);\n if (!user) return c.json({ error: \"Не авторизован\" }, 401);\n const key = c.req.param(\"key\") as DataKey;\n if (!DATA_KEYS.includes(key)) return c.json({ error: \"Неизвестный ключ\" }, 400);\n const value = await c.req.json().catch(() => null);\n if (value === null) return c.json({ error: \"Некорректное тело запроса\" }, 400);\n await setUserDataKey(user.id, key, value);\n return c.json({ ok: true });\n});\n\n// ---------- bonds (public catalog, cached from MOEX ISS) ----------\napp.get(\"/api/bonds\", async (c) => {\n try {\n const bonds = await getBondCatalog();\n return c.json({ bonds, source: \"moex-iss\" });\n } catch (err) {\n return c.json({ bonds: [], source: \"moex-iss\", error: String(err) }, 200);\n }\n});\n\napp.onError((err) => Promise.reject(err));\n\nexport default app.fetch;\n","label",[155],"774b67ca-8942-43db-8feb-ac9009321ab0","README.md","019f57f0-56c5-76eb-9c36-743e935a64fd",["D",1783886796403],"# React + Hono Starter\n\nA minimal starter template for building client-side React apps with a Hono\nbackend on Val Town. Click **Remix** to get your own copy.\n\n## Picking a starter\n\n| Starter | When to pick it |\n| --- | --- |\n| [`basic-html-starter`](https://www.val.town/x/templates/basic-html-starter) | Static HTML pages. Sprinkle of vanilla JS. No server-side rendering. |\n| [`hono-jsx-starter`](https://www.val.town/x/templates/hono-jsx-starter) | Dynamic server-rendered HTML with JSX. API routes. No React, no SPA. |\n| **[`react-hono-starter`](https://www.val.town/x/templates/react-hono-starter)** *(you're here)* | Client-side React SPA with a Hono API backend. |\n\n**Want to build UI?** Start writing React components in\n[`frontend/components/`](/frontend/components/). Import them into `App.tsx` and\nyou're good to go. Styling is [Twind](https://twind.style/) — just use Tailwind\nutility classes, zero config.\n\n**Want to add an API?** Add routes in [`index.ts`](/index.ts) (there's a\ncommented-out example). Fetch them from your React components.\n\n## Architecture\n\n```mermaid\ngraph LR\n Browser -->|\"GET /\"| Hono[\"index.ts
(Hono server)\"]\n Hono -->|serves| HTML[\"index.html\"]\n HTML -->|loads| Entry[\"index.tsx\"]\n Entry -->|renders| App[\"App.tsx\"]\n App -->|renders| Counter[\"Counter.tsx\"]\n```\n\n## File structure\n\n```\nindex.ts ← Hono backend (serves frontend + API routes)\nfrontend/\n index.html ← HTML shell (loads Twind + React)\n index.tsx ← React entrypoint (mounts )\n favicon.svg ← App icon\n components/\n App.tsx ← Root component (layout + view source link)\n Counter.tsx ← Example component with state\n```\n\n## How it works\n\n1. **`index.ts`** is the HTTP entrypoint — a Hono server that serves the\n frontend and any API routes you add.\n2. **`frontend/index.html`** loads Twind and the React entrypoint.\n3. **`frontend/index.tsx`** mounts the React app.\n4. **`frontend/components/App.tsx`** is the root layout — add new components\n alongside it.\n5. **`frontend/components/Counter.tsx`** is an example stateful component —\n replace it with your own!\n\n## Next steps\n\n- Add API routes in `index.ts`\n- Add new components in `frontend/components/`\n- Add a SQLite database — see the\n [React Hono Example](https://www.val.town/x/stevekrouse/reactHonoExample) for\n a full-stack example with database, queries, and shared types\n",[166],"d6492da4-9220-482a-a637-97a20bfd9dfb","frontend","019f57f0-56c5-76eb-9c36-734bcf67f8b7",["D",1783886796403],"directory",[172],"7e51d2b4-be4d-427b-806b-f671fb0c1c28","backend","bff1764e-1bef-4dca-9a79-127f452c3718",2,["D",1783886920336],[178],"pulls","branches","forks","envVars",{"_190":65,"_192":65},"connections",{"_190":65,"_191":65},"count","unfilledCount","emptyCount",{"_44":177,"_32":178,"_30":179,"_156":-5,"_42":43,"_41":180,"_158":61,"_39":276,"_13":65,"_34":175,"_36":-5,"_24":25,"_163":-5,"_207":277,"_27":278},{"_44":269,"_32":270,"_30":271,"_156":179,"_42":43,"_41":180,"_158":25,"_39":272,"_13":65,"_34":35,"_36":273,"_24":25,"_163":-5,"_207":274,"_27":275},{"_44":261,"_32":262,"_30":263,"_156":179,"_42":43,"_41":264,"_158":25,"_39":265,"_13":65,"_34":35,"_36":266,"_24":25,"_163":-5,"_207":267,"_27":268},{"_44":257,"_32":33,"_30":31,"_156":179,"_42":43,"_41":14,"_158":61,"_39":258,"_13":160,"_34":35,"_36":38,"_24":25,"_163":-5,"_207":259,"_27":260},{"_44":171,"_32":172,"_30":173,"_156":-5,"_42":43,"_41":160,"_158":61,"_39":254,"_13":65,"_34":175,"_36":-5,"_24":25,"_163":-5,"_207":255,"_27":256},{"_44":250,"_32":242,"_30":237,"_156":173,"_42":43,"_41":160,"_158":61,"_39":251,"_13":65,"_34":175,"_36":-5,"_24":25,"_163":-5,"_207":252,"_27":253},{"_44":243,"_32":244,"_30":245,"_156":237,"_42":43,"_41":160,"_158":25,"_39":246,"_13":65,"_34":35,"_36":247,"_24":25,"_163":-5,"_207":248,"_27":249},{"_44":234,"_32":235,"_30":236,"_156":237,"_42":43,"_41":160,"_158":25,"_39":238,"_13":65,"_34":35,"_36":239,"_24":25,"_163":-5,"_207":240,"_27":241},{"_44":227,"_32":228,"_30":229,"_156":173,"_42":43,"_41":160,"_158":61,"_39":230,"_13":65,"_34":20,"_36":231,"_24":25,"_163":-5,"_207":232,"_27":233},{"_44":220,"_32":221,"_30":222,"_156":173,"_42":43,"_41":160,"_158":25,"_39":223,"_13":65,"_34":20,"_36":224,"_24":25,"_163":-5,"_207":225,"_27":226},{"_44":213,"_32":214,"_30":215,"_156":173,"_42":43,"_41":160,"_158":61,"_39":216,"_13":65,"_34":35,"_36":217,"_24":25,"_163":-5,"_207":218,"_27":219},{"_44":165,"_32":166,"_30":167,"_156":-5,"_42":43,"_41":160,"_158":61,"_39":210,"_13":65,"_34":20,"_36":169,"_24":25,"_163":-5,"_207":211,"_27":212},{"_44":154,"_32":155,"_30":59,"_156":-5,"_42":43,"_41":157,"_158":25,"_39":206,"_13":160,"_34":161,"_36":162,"_24":25,"_163":-5,"_207":208,"_27":209},["D",1783887022134],"children",[],[155],["D",1783886796403],[],[166],"8247074c-a13d-4598-9f38-dcedb692d6d9","index.tsx","019f57f0-56c5-76eb-9c36-6dc2bc748403",["D",1783886796403],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { createRoot } from \"https://esm.sh/react-dom@18.2.0/client\";\nimport { App } from \"./components/App.tsx\";\n\nconst root = document.getElementById(\"root\");\nif (!root) {\n throw new Error(\"No root element found\");\n}\n\ncreateRoot(root).render();",[],[172,214],"2da1a916-c750-4db7-9575-eb3a93c0017b","index.html","019f57f0-56c5-76eb-9c36-6b11cb2b6576",["D",1783886796403],"\n\n \n \n \n React Hono Val Town Starter\n \n \n \n \n

\n \n \n \n",[],[172,221],"83b222ec-7afd-4131-b39e-3cac6efd7914","favicon.svg","019f57f0-56c5-76eb-9c36-66ee239d7454",["D",1783886796403],"\n",[],[172,228],"b051f559-2578-406c-804a-01dd8f5a0359","Counter.tsx","019f57f0-56c5-76eb-9c36-5f82130e329a","019f57f0-56c5-76eb-9c36-61eb7049bf59",["D",1783886796403],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useState } from \"https://esm.sh/react@18.2.0\";\n\nexport function Counter() {\n const [count, setCount] = useState(0);\n return (\n

\n Clicked\n setCount((c) => c + 1)}\n class=\"bg-blue-500 hover:bg-blue-600 text-white font-medium px-4 py-2 rounded-lg transition-colors cursor-pointer\"\n >\n {count}\n \n times\n

\n );\n}\n",[],[172,242,235],"components","83cf3671-7047-4d90-a511-056218400741","App.tsx","019f57f0-56c5-76eb-9c36-595e39a139ba",["D",1783886796403],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { Counter } from \"./Counter.tsx\";\n\nexport function App() {\n return (\n

React + Hono Starter

\n \n

\n View source\n

\n );\n}\n",[],[172,242,244],"0b791deb-7a88-4686-9392-17b60554e75e",["D",1783886796403],[199,200],[172,242],["D",1783886796403],[198,201,202,203],[172],"41ede8ee-7303-43a3-a7e2-5cc2fa1f02c4",["D",1783887066382],[],[178,33],"c355c2cb-243c-4367-8199-ca34197a5a5f","db.ts","88bcd74e-7e2d-11f1-970e-1607ee4eb77e",3,["D",1783886945722],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nconst KEYS = [\"incomes\", \"expenses\", \"budgetPlan\", \"goals\", \"loans\", \"holdings\", \"settings\"] as const;\nexport type DataKey = typeof KEYS[number];\nexport const DATA_KEYS: readonly DataKey[] = KEYS;\n\nexport async function initDataTable() {\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS user_data (\n user_id TEXT PRIMARY KEY,\n incomes TEXT NOT NULL,\n expenses TEXT NOT NULL,\n budgetPlan TEXT NOT NULL,\n goals TEXT NOT NULL,\n loans TEXT NOT NULL,\n holdings TEXT NOT NULL,\n settings TEXT NOT NULL,\n updated_at TEXT NOT NULL\n )`);\n}\n\nlet seedCounter = 1000;\nfunction nextSeedId() {\n seedCounter += 1;\n return seedCounter;\n}\n\nfunction defaultData() {\n return {\n incomes: [\n { id: nextSeedId(), date: new Date().toISOString().slice(0, 10), source: \"Основной доход\", amount: 0, comment: \"\" },\n ],\n expenses: [] as any[],\n budgetPlan: {\n \"Продукты\": 0, \"Кафе\": 0, \"Рестораны\": 0, \"Авто\": 0, \"Такси\": 0,\n \"Жилье\": 0, \"Ипотека\": 0, \"Связь\": 0, \"Интернет\": 0, \"Дети\": 0,\n \"Одежда\": 0, \"Развлечения\": 0, \"Подписки\": 0, \"Путешествия\": 0,\n \"Здоровье\": 0, \"Прочее\": 0,\n },\n goals: [\n { id: nextSeedId(), name: \"Подушка безопасности\", target: 300000, saved: 0, months: 12 },\n ],\n loans: [] as any[],\n holdings: [] as any[],\n settings: { currency: \"₽\", incomeRate: 10, savingsRate: 20 },\n };\n}\n\nexport async function getUserData(userId: string) {\n const res = await sqlite.execute({ sql: \"SELECT * FROM user_data WHERE user_id = ?\", args: [userId] });\n const row = res.rows[0] as Record | undefined;\n if (!row) {\n const def = defaultData();\n await sqlite.execute({\n sql: `INSERT INTO user_data (user_id, incomes, expenses, budgetPlan, goals, loans, holdings, settings, updated_at)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)`,\n args: [\n userId,\n JSON.stringify(def.incomes),\n JSON.stringify(def.expenses),\n JSON.stringify(def.budgetPlan),\n JSON.stringify(def.goals),\n JSON.stringify(def.loans),\n JSON.stringify(def.holdings),\n JSON.stringify(def.settings),\n new Date().toISOString(),\n ],\n });\n return def;\n }\n return {\n incomes: JSON.parse(row.incomes as string),\n expenses: JSON.parse(row.expenses as string),\n budgetPlan: JSON.parse(row.budgetPlan as string),\n goals: JSON.parse(row.goals as string),\n loans: JSON.parse(row.loans as string),\n holdings: JSON.parse(row.holdings as string),\n settings: JSON.parse(row.settings as string),\n };\n}\n\nexport async function setUserDataKey(userId: string, key: DataKey, value: unknown) {\n if (!DATA_KEYS.includes(key)) throw new Error(\"Invalid key\");\n // Ensure a row exists first\n await getUserData(userId);\n await sqlite.execute({\n sql: `UPDATE user_data SET ${key} = ?, updated_at = ? WHERE user_id = ?`,\n args: [JSON.stringify(value), new Date().toISOString(), userId],\n });\n}\n",[],[178,262],"ff93893a-7a6f-4366-8ade-0e65011946d9","auth.ts","7993ba94-7e2d-11f1-8c23-1607ee4eb77e",["D",1783886920336],"import bcrypt from \"npm:bcryptjs@2.4.3\";\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nexport async function initAuthTables() {\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS users (\n id TEXT PRIMARY KEY,\n email TEXT UNIQUE NOT NULL,\n password_hash TEXT NOT NULL,\n tier TEXT NOT NULL DEFAULT 'free',\n created_at TEXT NOT NULL\n )`);\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS sessions (\n token TEXT PRIMARY KEY,\n user_id TEXT NOT NULL,\n created_at TEXT NOT NULL,\n expires_at TEXT NOT NULL\n )`);\n}\n\nexport function newId() {\n return crypto.randomUUID();\n}\n\nexport function newToken() {\n return crypto.randomUUID().replace(/-/g, \"\") + crypto.randomUUID().replace(/-/g, \"\");\n}\n\nexport async function hashPassword(pw: string) {\n return bcrypt.hash(pw, 10);\n}\n\nexport async function verifyPassword(pw: string, hash: string) {\n return bcrypt.compare(pw, hash);\n}\n\nexport interface UserRow {\n id: string;\n email: string;\n password_hash: string;\n tier: string;\n created_at: string;\n}\n\nexport async function findUserByEmail(email: string): Promise {\n const res = await sqlite.execute({\n sql: \"SELECT * FROM users WHERE email = ?\",\n args: [email.trim().toLowerCase()],\n });\n return (res.rows[0] as unknown as UserRow) ?? null;\n}\n\nexport async function findUserById(id: string): Promise {\n const res = await sqlite.execute({ sql: \"SELECT * FROM users WHERE id = ?\", args: [id] });\n return (res.rows[0] as unknown as UserRow) ?? null;\n}\n\nexport async function createUser(email: string, password: string): Promise {\n const id = newId();\n const passwordHash = await hashPassword(password);\n const createdAt = new Date().toISOString();\n await sqlite.execute({\n sql: \"INSERT INTO users (id, email, password_hash, tier, created_at) VALUES (?, ?, ?, 'free', ?)\",\n args: [id, email.trim().toLowerCase(), passwordHash, createdAt],\n });\n return { id, email: email.trim().toLowerCase(), password_hash: passwordHash, tier: \"free\", created_at: createdAt };\n}\n\nexport async function createSession(userId: string): Promise<{ token: string; expiresAt: string }> {\n const token = newToken();\n const createdAt = new Date().toISOString();\n const expiresAt = new Date(Date.now() + 30 * 24 * 60 * 60 * 1000).toISOString();\n await sqlite.execute({\n sql: \"INSERT INTO sessions (token, user_id, created_at, expires_at) VALUES (?, ?, ?, ?)\",\n args: [token, userId, createdAt, expiresAt],\n });\n return { token, expiresAt };\n}\n\nexport async function getSessionUser(token: string | undefined): Promise {\n if (!token) return null;\n const res = await sqlite.execute({\n sql: \"SELECT users.* FROM sessions JOIN users ON sessions.user_id = users.id WHERE sessions.token = ? AND sessions.expires_at > ?\",\n args: [token, new Date().toISOString()],\n });\n return (res.rows[0] as unknown as UserRow) ?? null;\n}\n\nexport async function deleteSession(token: string | undefined) {\n if (!token) return;\n await sqlite.execute({ sql: \"DELETE FROM sessions WHERE token = ?\", args: [token] });\n}\n",[],[178,270],["D",1783886920336],[194,195,196],[178],["D",1783886796403],["D",1789473046147],{"_106":105,"_114":110},{"_106":105,"_107":108,"_109":110,"_18":57,"_111":112,"_113":25},{"_13":91,"_32":92,"_44":43,"_93":45,"_94":95,"_96":97,"_98":51,"_99":100,"_101":102,"_103":46,"_104":105},"ctx",{"_84":-5,"_136":317,"_318":319,"_320":321,"_322":25,"_323":25,"_324":25,"_325":61,"_326":-5,"_327":-7,"_328":-7,"_329":65,"_330":25,"_331":25,"_332":-5,"_333":25,"_334":25,"_335":25,"_336":-5},"ENV",{"_288":289,"_290":291,"_292":92,"_293":294,"_295":296,"_297":298,"_299":300,"_301":302,"_303":304,"_305":306,"_307":308,"_309":310,"_311":312,"_313":314,"_315":316},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","e87eb04e707cf64e7e532c8e8ec395f209e17f15","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 · v6