\n \n

\n );\n}\n\nfunction HowLongToBeatForm({ result }: { result?: string }) {\n return (\n <>\n \n {result\n ? (\n \n

{result}

\n \n )\n : null}\n \n );\n}","deleted","label","children",[],[101],{"_105":178,"_97":179,"_158":180,"_160":-5,"_161":144,"_162":181,"_164":165,"_107":182,"_102":183,"_168":184,"_170":185,"_172":22,"_173":-5,"_174":186,"_100":187},"999bf59c-dd8b-11f0-9090-42dde27851f2","how-long-to-beat.ts","c05cf11e-dd80-11f0-b62e-42dde27851f2",179,["D",1766225209573],24,"script","import { sqlite } from \"https://esm.town/v/std/sqlite\";\nimport Fraction from \"https://esm.sh/fraction.js@5.3.4\";\n\nexport async function getHowLongToBeat(name: string): Promise {\n try {\n const { terms, key } = normalizeSearch(name);\n\n const cached = await getCached(key);\n if (cached) {\n return Number(cached);\n }\n\n const token = await getSearchToken();\n\n const res = await howLongToBeatSearch(terms, token);\n const result = buildResult(res);\n\n await cacheResult(key, result);\n\n return Number(result);\n } catch (err) {\n console.error(err);\n return -1;\n }\n}\n\nlet cachedTokenP: Promise = null;\nfunction getSearchToken(): Promise {\n if (!cachedTokenP) {\n cachedTokenP = fetch(\n `https://howlongtobeat.com/api/search/init?t=${Date.now()}`,\n {\n headers: {\n \"user-agent\":\n \"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36\",\n referer: \"https://howlongtobeat.com\",\n },\n },\n ).then((initRes) => initRes.json()).then(({ token }) => token);\n }\n\n return cachedTokenP;\n}\n\nconst movedTerms = new Set([\n \"(the)\",\n \"(a)\",\n \"(an)\",\n]);\nfunction normalizeSearch(name: string): { terms: string[]; key: string } {\n let terms = name.toLowerCase().replace(\"®\", \"\").split(/\\s+/);\n if (movedTerms.has(terms.at(-1))) {\n terms = [\n terms.at(-1).slice(1, -1),\n ...terms.slice(0, -1),\n ];\n }\n const key = terms.join(\" \");\n return { terms, key };\n}\n\nconst HOWLONGTOBEAT_CACHE_BUST = 1766183360;\nasync function getCached(key: string): Promise {\n const cached = await sqlite.execute({\n sql:\n \"SELECT time FROM howlongtobeat WHERE key = :key AND datetime(expiry) >= datetime('now') AND datetime(cached_at) >= datetime(:cacheBust, 'unixepoch')\",\n args: { key, cacheBust: HOWLONGTOBEAT_CACHE_BUST },\n });\n return cached.rows.at(0)?.at(0);\n}\n\nasync function howLongToBeatSearch(\n terms: string[],\n token: string,\n): Promise {\n const res = await fetch(\"https://howlongtobeat.com/api/search\", {\n body: JSON.stringify({\n \"searchType\": \"games\",\n searchTerms: terms,\n \"searchPage\": 1,\n \"size\": 20,\n \"searchOptions\": {\n \"games\": {\n \"userId\": 0,\n \"platform\": \"\",\n \"sortCategory\": \"popular\",\n \"rangeCategory\": \"main\",\n \"rangeTime\": {\n \"min\": null,\n \"max\": null,\n },\n \"gameplay\": {\n \"perspective\": \"\",\n \"flow\": \"\",\n \"genre\": \"\",\n \"difficulty\": \"\",\n },\n \"rangeYear\": {\n \"min\": \"\",\n \"max\": \"\",\n },\n \"modifier\": \"\",\n },\n \"users\": {\n \"sortCategory\": \"postcount\",\n },\n \"lists\": {\n \"sortCategory\": \"follows\",\n },\n \"filter\": \"\",\n \"sort\": 0,\n \"randomizer\": 0,\n },\n \"useCache\": true,\n }),\n headers: {\n \"content-type\": \"application/json\",\n \"x-auth-token\": token,\n referer: \"https://howlongtobeat.com\",\n \"user-agent\":\n \"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36\",\n },\n method: \"POST\",\n });\n return await res.json();\n}\n\nfunction buildResult(json: any): string {\n if (typeof json?.data?.[0]?.comp_all !== \"number\") {\n return (-1).toString();\n }\n const fraction = new Fraction(json.data[0].comp_all / 60 / 60).simplify(\n 0.001,\n ).roundTo(1, 2);\n const result = fraction.toString();\n return result;\n}\n\nasync function cacheResult(key: string, result: string): Promise {\n await sqlite.execute({\n sql:\n \"INSERT INTO howlongtobeat (key, time, cached_at, expiry) VALUES (:key, :time, datetime('now'), datetime(unixepoch() + ABS(RANDOM() % 604800), 'unixepoch')) ON CONFLICT (key) DO UPDATE set time = :time, cached_at = datetime('now'), expiry = datetime('now') + ABS(RANDOM() % 604800)\",\n args: { key, time: result },\n });\n}",[],[179],{"_105":189,"_97":190,"_158":191,"_160":-5,"_161":144,"_162":143,"_164":165,"_107":192,"_102":193,"_168":169,"_170":194,"_172":22,"_173":-5,"_174":195,"_100":196},"9fd44c48-dd8b-11f0-80c1-42dde27851f2","main.ts","4d2671fa-db93-11f0-a7ae-42dde27851f2",["D",1766225220009],105,"import { Hono } from \"https://esm.sh/hono@3\";\nimport { getHowLongToBeat } from \"./how-long-to-beat.ts\";\nimport { render } from \"./frontend.tsx\";\n\nconst app = new Hono();\n\napp.get(\"/*\", (c) => {\n return c.html(render({}));\n});\n\napp.post(\"/form/howlongtobeat\", async (c) => {\n const data = await c.req.formData();\n const query = data.get(\"query\").toString();\n if (!query) {\n return c.html(render({}), 400);\n }\n const result = await getHowLongToBeat(query);\n return c.html(render({ howLongToBeatResult: result.toString() }));\n});\n\napp.post(\"/howlongtobeat\", async (c) => {\n const rows = await c.req.json();\n\n if (!Array.isArray(rows)) {\n return c.json({ ok: false, error: \"expected array\" }, 400);\n }\n\n const data = await Promise.all(rows.map(async ([name]) => {\n const howLongToBeat = await getHowLongToBeat(name);\n return howLongToBeat ?? -1;\n }));\n\n return Response.json({\n ok: true,\n data,\n });\n});\n\nexport default app.fetch;",[],[190],{"_105":198,"_97":199,"_158":200,"_160":-5,"_161":144,"_162":201,"_164":165,"_107":202,"_102":203,"_168":184,"_170":204,"_172":22,"_173":-5,"_174":205,"_100":206},"6a594190-dd8b-11f0-b506-42dde27851f2","reset.ts","c27d5d5c-dc28-11f0-bfb5-42dde27851f2",176,["D",1766225130249],3,"/**\n * Run this manually to reset the database\n */\n\nimport { sqlite } from \"https://esm.town/v/std/sqlite\";\n\nawait sqlite.execute(\"DROP TABLE IF EXISTS howlongtobeat\");",[],[199],{"_105":208,"_97":209,"_158":210,"_160":-5,"_161":144,"_162":211,"_164":165,"_107":212,"_102":203,"_168":184,"_170":213,"_172":22,"_173":-5,"_174":214,"_100":215},"7024ce14-dd8b-11f0-b555-42dde27851f2","setup.ts","c9f6716e-dd80-11f0-8103-42dde27851f2",177,["D",1766225140004],"/**\n * Run this manually to set up the database\n */\n\nimport { sqlite } from \"https://esm.town/v/std/sqlite\";\n\nawait sqlite.execute(\n \"CREATE TABLE IF NOT EXISTS howlongtobeat (key TEXT PRIMARY KEY, time INT, cached_at INT, expiry INT)\",\n);",[],[209],"files",[156,177,188,197,207],"counts",{"_220":33,"_221":222,"_223":33,"_224":225,"_228":229},"pulls","branches",1,"forks","envVars",{"_226":33,"_227":33},"count","emptyCount","connections",{"_226":33,"_230":33},"unfilledCount","contents",[],"file",{"_105":157,"_97":101,"_158":159,"_160":-5,"_161":144,"_162":163,"_164":165,"_107":235,"_102":167,"_168":169,"_170":171,"_172":22,"_173":-5,"_100":236},["D",1766225078573],[101],"upstreamProject","upstreamBranch","emptyEnvVars","isNew","flags",[],"routes/_app.x.$handle.$name.branch.$branch.history_.$",{"_95":96,"_97":98,"_99":45,"_100":101,"_103":245,"_233":250,"_253":254,"_303":304,"_315":-7,"_316":222,"_317":22},{"_105":106,"_97":98,"_107":246,"_109":-5,"_110":22,"_111":112,"_113":-5,"_114":-5,"_14":115,"_116":-5,"_117":22,"_118":-5,"_119":-5,"_120":33,"_16":121,"_122":-5,"_123":-5,"_124":125,"_126":125,"_127":128,"_129":128,"_130":128,"_131":125,"_132":125,"_23":247,"_136":248,"_141":249,"_153":22},["D",1766008614937],{"_95":96,"_134":135},{"_95":96,"_138":135,"_14":115,"_139":140},{"_102":143,"_97":45,"_105":144,"_145":106,"_146":-5,"_147":-5,"_148":-5,"_149":-5,"_150":-5,"_151":98,"_152":96},{"_105":157,"_97":101,"_158":159,"_160":-5,"_161":144,"_162":163,"_164":165,"_107":251,"_102":167,"_168":169,"_170":171,"_172":22,"_173":-5,"_100":252},["D",1766225078573],[101],"history",[255,261,267,273,279,285,289,294,298],{"_105":256,"_161":144,"_158":159,"_97":101,"_170":257,"_168":169,"_102":258,"_160":-5,"_107":259,"_162":260,"_173":-5},"af681df8-dd84-11f0-9887-42dde27851f2","/** @jsxImportSource https://esm.sh/react */\nimport { renderToString } from \"npm:react-dom/server\";\n\nexport const render = () => renderToString();\n\nfunction App() {\n return (\n

\n );\n}\n\nfunction HowLongToBeatForm() {\n return (\n \n

How Long To Beat

\n \n Query: \n \n \n \n );\n}",8,["D",1766222239666],134,{"_105":262,"_161":144,"_158":159,"_97":101,"_170":263,"_168":169,"_102":264,"_160":-5,"_107":265,"_162":266,"_173":-5},"79a73410-dd84-11f0-969d-42dde27851f2","/** @jsxImportSource https://esm.sh/react */\nimport { renderToString } from \"npm:react-dom/server\";\n\nexport const render = () => renderToString();\n\nfunction App() {\n return (\n

\n \n

\n );\n}",7,["D",1766222149482],132,{"_105":268,"_161":144,"_158":159,"_97":101,"_170":269,"_168":169,"_102":270,"_160":-5,"_107":271,"_162":272,"_173":-5},"592d8248-dd84-11f0-8bdf-42dde27851f2","/** @jsxImportSource https://esm.sh/react */\nimport { renderToString } from \"npm:react-dom/server\";\n\nexport const render = () => renderToString();\n\nfunction App() {\n return (\n

\n \n

\n );\n}",6,["D",1766222094995],131,{"_105":274,"_161":144,"_158":159,"_97":275,"_170":269,"_168":169,"_102":276,"_160":-5,"_107":277,"_162":278,"_173":-5},"5387bc64-dd84-11f0-bd9c-42dde27851f2","frontend.ts",5,["D",1766222085522],130,{"_105":280,"_161":144,"_158":159,"_97":275,"_170":281,"_168":169,"_102":282,"_160":-5,"_107":283,"_162":284,"_173":-5},"acf175a0-dd80-11f0-9bf4-42dde27851f2","/** @jsxImportSource https://esm.sh/react */\nimport { renderToString } from \"npm:react-dom/server\";\n\n// Learn more: https://docs.val.town/vals/http/jsx/\nexport const reactExample = (request: Request) =>\n new Response(renderToString(

Test {1 + 1}

), {\n headers: {\n \"Content-Type\": \"text/html\",\n },\n });",4,["D",1766220517546],106,{"_105":286,"_161":144,"_158":159,"_97":287,"_170":281,"_168":169,"_102":203,"_160":-5,"_107":288,"_162":193,"_173":-5},"a1b78c06-dd80-11f0-b718-42dde27851f2",".ts",["D",1766220498680],{"_105":290,"_161":144,"_158":159,"_97":287,"_170":281,"_168":184,"_102":291,"_160":-5,"_107":292,"_162":293,"_173":-5},"a1b2aca4-dd80-11f0-b57d-42dde27851f2",2,["D",1766220498679],104,{"_105":295,"_161":144,"_158":159,"_97":287,"_170":74,"_168":184,"_102":222,"_160":-5,"_107":296,"_162":297,"_173":-5},"a1a09208-dd80-11f0-acdb-42dde27851f2",["D",1766220498558],103,{"_105":299,"_161":144,"_158":159,"_97":300,"_170":74,"_168":184,"_102":33,"_160":-5,"_107":301,"_162":302,"_173":-5},"9c9ed26a-dd80-11f0-861f-42dde27851f2","new-file-9716.ts",["D",1766220490162],102,"versions",[305,307,308,309,310,311,312,313,314],{"_233":255,"_306":261},"previous",{"_233":261,"_306":267},{"_233":267,"_306":273},{"_233":273,"_306":279},{"_233":279,"_306":285},{"_233":285,"_306":289},{"_233":289,"_306":294},{"_233":294,"_306":298},{"_233":298,"_306":-5},"versionNumber","page","hasNext","actionData","errors"]

beecodes

booooof

History for frontend.tsx