[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8},"actionData","errors","root",{"_109":110,"_111":112},"routes/embed.x.$handle.$name.$",{"_9":10,"_11":12,"_13":14,"_15":16,"_17":18,"_19":20,"_21":-5},"handle","yoshiokaren","name","eigo-tango-2210","path","backend/db.ts","project",{"_22":48,"_11":12,"_35":49,"_50":-5,"_51":44,"_52":53,"_54":53,"_55":56,"_57":-5,"_58":59,"_60":61,"_62":34,"_63":-5,"_64":-5,"_65":38,"_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":44},"file",{"_22":23,"_11":24,"_25":26,"_27":28,"_29":30,"_31":32,"_33":34,"_35":36,"_37":38,"_39":40,"_41":42,"_43":44,"_45":-5,"_13":46},"permalink","https://www.val.town/x/yoshiokaren/eigo-tango-2210/code/backend/db.ts","extension","id","96762acc-883b-4328-875c-a1b4152e08f0","db.ts","fileId","d7b652ce-ac15-11f1-81bb-1607ee4eb77e","parentId","4fed67ae-277e-46b6-ba1a-08b21bc13fd7","branchId","46e0e8fc-4ff5-4179-8084-4683da63e748","branchVersion",22,"latest",true,"createdAt",["D",1788934523830],"version",0,"fileType","script","content","import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\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 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 // One row per user: the whole rating map as JSON ({ word: \"ok\" | \"mid\" | \"no\" }).\n // Filtering happens client-side, so there is nothing to query per word.\n `CREATE TABLE IF NOT EXISTS user_state (\n user_id INTEGER PRIMARY KEY,\n ratings TEXT NOT NULL DEFAULT '{}',\n updated_at INTEGER NOT NULL DEFAULT (unixepoch() * 1000)\n )`,\n ]);\n await sqlite.execute({ sql: \"DELETE FROM sessions WHERE expires_at < ?\", args: [Date.now()] });\n}\n\nconst VALID = { ok: 1, mid: 1, no: 1 } as Record;\n\n/** Keep only well-formed { word: rating } pairs so a bad client cannot bloat the row. */\nexport function cleanRatings(input: unknown): Record {\n if (!input || typeof input !== \"object\" || Array.isArray(input)) return {};\n const out: Record = {};\n let n = 0;\n for (const [k, v] of Object.entries(input as Record)) {\n if (n >= 5000) break;\n if (typeof k !== \"string\" || !k || k.length > 64) continue;\n if (typeof v !== \"string\" || !VALID[v]) continue;\n out[k] = v;\n n++;\n }\n return out;\n}\n\nexport async function getRatings(userId: number): Promise> {\n const res = await sqlite.execute({ sql: \"SELECT ratings FROM user_state WHERE user_id = ?\", args: [userId] });\n if (!res.rows.length) return {};\n try {\n return cleanRatings(JSON.parse(String((res.rows[0] as any).ratings)));\n } catch {\n return {};\n }\n}\n\nexport async function saveRatings(userId: number, ratings: Record): Promise {\n await sqlite.execute({\n sql: `INSERT INTO user_state (user_id, ratings, updated_at) VALUES (?, ?, ?)\n ON CONFLICT(user_id) DO UPDATE SET ratings = excluded.ratings, updated_at = excluded.updated_at`,\n args: [userId, JSON.stringify(ratings), Date.now()],\n });\n}\n","deleted",false,"label",[47,24],"backend","1dcd1009-103a-4ec4-af86-9e4c37c8e0fd",["D",1788928965379],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","中学英単語2210 - 学年・ページ範囲別の単語カード＋5択問題","imageUrl","userId","2e5f3a11-3ecf-4768-a436-abfe0467880b","pinnedFileId","e6a7dabc-ac08-11f1-b4a1-1607ee4eb77e","pinPreview","pinMigrated","screenshotVersion","likeCount","orgId","019f3378-c037-7109-869d-8900c383fcb3","tursoName","1dcd1009103a4ec4af869e4c37c8e0fd","tursoHostname","1dcd1009103a4ec4af869e4c37c8e0fd-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789455661654],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_9":10,"_108":104},"org",{"_9":10,"_101":102,"_103":104,"_58":59,"_105":106,"_107":44},"branch",{"_37":91,"_11":92,"_22":30,"_93":48,"_94":-5,"_95":-5,"_96":-5,"_97":-5,"_98":-5,"_99":12,"_100":10},"isOwned",83,"main","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","ctx",{"_84":-5,"_142":143,"_144":145,"_146":147,"_148":44,"_149":44,"_150":44,"_151":34,"_152":-5,"_153":-7,"_154":-7,"_155":38,"_156":44,"_157":44,"_158":-5,"_159":44,"_160":44,"_161":44,"_162":-5},"ENV",{"_113":114,"_115":116,"_117":92,"_118":119,"_120":121,"_122":123,"_124":125,"_126":127,"_128":129,"_130":131,"_132":133,"_134":135,"_136":137,"_138":139,"_140":141},"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","orgs",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]