Hours Counter

[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_174":175,"_176":177},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":16,"_18":19,"_17":-7,"_132":-5,"_20":133,"_22":134,"_135":136,"_137":138,"_25":139,"_24":-5,"_140":-5,"_141":-5,"_142":54,"_143":144,"_145":45,"_146":-5,"_147":-5,"_148":149},"routes/_app.x.$handle.$name.branch.$branch.code.$",{"_11":12,"_13":14,"_15":16,"_17":-7,"_18":19,"_20":21,"_22":23,"_24":-7,"_25":26,"_27":-5,"_28":-5,"_29":-5,"_30":-5,"_31":-5},"handle","bawer","name","hours-counter","branchName","main","version","path","","project",{"_34":74,"_13":14,"_46":75,"_76":-5,"_77":54,"_78":79,"_80":79,"_81":82,"_83":-5,"_84":85,"_86":38,"_87":45,"_88":-5,"_89":-5,"_90":48,"_91":92,"_93":94,"_95":96,"_97":98,"_99":-5,"_100":101,"_102":101,"_103":104,"_105":104,"_106":104,"_107":101,"_108":101,"_109":110,"_111":112,"_113":114,"_115":54},"tree",[65,66],"file","contents",[32,33],"upstream","pull","ahead","behind","envVars",{"_34":57,"_13":58,"_37":59,"_39":-5,"_40":41,"_42":60,"_44":45,"_46":61,"_17":62,"_49":24,"_51":63,"_53":54,"_55":-5,"_18":64},{"_34":35,"_13":36,"_37":38,"_39":-5,"_40":41,"_42":43,"_44":45,"_46":47,"_17":48,"_49":50,"_51":52,"_53":54,"_55":-5,"_18":56},"id","01902cd0-4d16-4346-ae84-94a0100af9f1","main.ts","fileId","db46247e-7b95-11f1-9911-1607ee4eb77e","parentId","branchId","bad665fb-e63a-4ece-8b91-3a18ef6e4da9","branchVersion",1,"latest",true,"createdAt",["D",1783601898416],0,"fileType","http","content","import { Hono } from \"npm:hono\";\nimport { serveFile } from \"https://esm.town/v/std/utils/index.ts\";\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nawait sqlite.execute(`CREATE TABLE IF NOT EXISTS hours (id INTEGER PRIMARY KEY, value REAL NOT NULL DEFAULT 0)`);\nawait sqlite.execute(`INSERT OR IGNORE INTO hours (id, value) VALUES (1, 0)`);\n\nconst app = new Hono();\n\napp.get(\"/api/hours\", async (c) => {\n const r = await sqlite.execute(\"SELECT value FROM hours WHERE id = 1\");\n return c.json({ hours: r.rows[0].value });\n});\n\napp.post(\"/api/hours\", async (c) => {\n const { delta } = await c.req.json();\n if (typeof delta !== \"number\") return c.json({ error: \"delta required\" }, 400);\n await sqlite.execute({ sql: \"UPDATE hours SET value = value + ? WHERE id = 1\", args: [delta] });\n const r = await sqlite.execute(\"SELECT value FROM hours WHERE id = 1\");\n return c.json({ hours: r.rows[0].value });\n});\n\napp.post(\"/api/hours/reset\", async (c) => {\n await sqlite.execute({ sql: \"UPDATE hours SET value = 0 WHERE id = 1\" });\n return c.json({ hours: 0 });\n});\n\napp.get(\"/\", (c) => serveFile(\"/index.html\", import.meta.url));\n\napp.onError((err) => Promise.reject(err));\n\nexport default app.fetch;\n","deleted",false,"label",[36],"b7f57e6e-da6b-4eff-83d9-eacff1d3641b","index.html","e1fef4b2-7b95-11f1-adc4-1607ee4eb77e",9,["D",1783602257389],7,"\n\n\n \n \n Hours Counter\n \n\n\n

Hours Owed

\n\n

\n \n \n

\n\n

\n \n \n

\n\n \n\n\n",[58],{"_34":57,"_13":58,"_37":59,"_39":-5,"_40":41,"_42":60,"_44":45,"_46":71,"_17":62,"_49":24,"_51":63,"_53":54,"_55":-5,"_68":72,"_18":73},{"_34":35,"_13":36,"_37":38,"_39":-5,"_40":41,"_42":43,"_44":45,"_46":67,"_17":48,"_49":50,"_51":52,"_53":54,"_55":-5,"_68":69,"_18":70},["D",1783601898416],"children",[],[36],["D",1783602257389],[],[58],"40604a4e-5cf2-4175-a5dd-93bfefa43d78",["D",1783601898338],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Track work hours owed with + and - buttons","imageUrl","userId","a13fe2e3-cd4d-4c85-b346-caa204be526b","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","orgId","019f1374-c3bb-7729-9f32-28ccc62b14e3","tursoName","40604a4e5cf24175a5dd93bfefa43d78","tursoHostname","40604a4e5cf24175a5dd93bfefa43d78-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789438866375],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_131":127},"org",{"_11":12,"_124":125,"_126":127,"_84":85,"_128":129,"_130":54},"branch",{"_17":60,"_13":16,"_34":41,"_116":74,"_117":-5,"_118":-5,"_119":-5,"_120":-5,"_121":-5,"_122":14,"_123":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","Muhammed Bavver Yavuzatmaca","avatar","https://lh3.googleusercontent.com/a/ACg8ocJOy2LVOslCVCMDjQ2YwyCEintc_wbxQ4x3fKfiXIQMG7qc=s96-c","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_34":74,"_13":14,"_46":169,"_76":-5,"_77":54,"_78":79,"_80":79,"_81":82,"_83":-5,"_84":85,"_86":38,"_87":45,"_88":-5,"_89":-5,"_90":48,"_91":92,"_93":94,"_95":96,"_97":170,"_99":-5,"_100":101,"_102":101,"_103":104,"_105":104,"_106":104,"_107":101,"_108":101,"_109":171,"_111":172,"_113":173,"_115":54},[163,164],"files",[163,164],"counts",{"_154":48,"_155":43,"_156":48,"_31":157,"_158":159},[150,151],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_34":57,"_13":58,"_37":59,"_39":-5,"_40":41,"_42":60,"_44":45,"_46":61,"_17":62,"_49":24,"_51":63,"_53":54,"_55":-5,"_18":153},{"_34":35,"_13":36,"_37":38,"_39":-5,"_40":41,"_42":43,"_44":45,"_46":47,"_17":48,"_49":50,"_51":52,"_53":54,"_55":-5,"_18":152},[36],[58],"pulls","branches","forks",{"_160":48,"_162":48},"connections",{"_160":48,"_161":48},"count","unfilledCount","emptyCount",{"_34":57,"_13":58,"_37":59,"_39":-5,"_40":41,"_42":60,"_44":45,"_46":71,"_17":62,"_49":24,"_51":63,"_53":54,"_55":-5,"_68":167,"_18":168},{"_34":35,"_13":36,"_37":38,"_39":-5,"_40":41,"_42":43,"_44":45,"_46":67,"_17":48,"_49":50,"_51":52,"_53":54,"_55":-5,"_68":165,"_18":166},[],[36],[],[58],["D",1783601898338],["D",1789438866375],{"_11":12,"_131":127},{"_11":12,"_124":125,"_126":127,"_84":85,"_128":129,"_130":54},{"_17":60,"_13":16,"_34":41,"_116":74,"_117":-5,"_118":-5,"_119":-5,"_120":-5,"_121":-5,"_122":14,"_123":12},"ctx",{"_109":-5,"_147":207,"_208":209,"_210":211,"_212":54,"_213":54,"_214":54,"_215":45,"_216":-5,"_217":-7,"_218":-7,"_219":48,"_220":54,"_221":54,"_222":-5,"_223":54,"_224":54,"_225":54,"_226":-5},"ENV",{"_178":179,"_180":181,"_182":16,"_183":184,"_185":186,"_187":188,"_189":190,"_191":192,"_193":194,"_195":196,"_197":198,"_199":200,"_201":202,"_203":204,"_205":206},"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"]

Code