Val — Time Dial & Buoy Data

[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_153":154,"_155":156},"routes/_app.x.$handle.$name",{"_95":94,"_32":45,"_103":85,"_27":104,"_13":14,"_105":-5,"_11":106,"_107":108,"_109":110,"_111":112,"_113":114,"_20":-5,"_115":-5,"_116":-5,"_117":25,"_118":119,"_120":57,"_121":-5,"_122":-5,"_123":124},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_43":44,"_32":45,"_38":46,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":-5,"_53":-5,"_18":54,"_55":31,"_56":57,"_58":57,"_59":-5,"_60":61,"_62":63,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":69,"_70":69,"_71":72,"_73":72,"_74":72,"_75":69,"_76":69,"_77":78,"_79":80,"_81":82,"_83":25},"version",16,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":34,"_35":37,"_38":39,"_40":14,"_41":42,"_24":25},"previous",{"_30":31,"_32":28,"_33":34,"_35":36},"deleted",false,"deletedHere","path","main.ts","latestPath","fileId","bd7c5930-89ac-11f0-953c-0224a6c84d84","name","fileType","http","content","// dial_val.ts\nimport { sqlite } from \"https://esm.town/v/std/sqlite\";\n\nconst MAX_ROWS = 5000;\n\nfunction mapSqlResultToObjects(result: any) {\n if (!result) return [];\n if (\n Array.isArray(result) && result.length && typeof result[0] === \"object\" &&\n !Array.isArray(result[0])\n ) {\n return result;\n }\n if (\n result.rows && Array.isArray(result.rows) && Array.isArray(result.columns)\n ) {\n return result.rows.map((row: any[]) =>\n Object.fromEntries(row.map((v, i) => [result.columns[i], v]))\n );\n }\n if (result.rows && Array.isArray(result.rows)) {\n return result.rows;\n }\n return [];\n}\n\nexport default async function (req: Request): Promise {\n const url = new URL(req.url);\n\n // API: returning DB measurements\n if (url.pathname === \"/api/measurements\") {\n const limitParam = Number(url.searchParams.get(\"limit\") ?? 1000);\n const limit = Math.min(\n Number.isFinite(limitParam) && limitParam > 0 ? limitParam : 1000,\n MAX_ROWS,\n );\n try {\n const q = `\n select id, fetched_at, water_temp_f, wave_height_ft, wind_speed_mph\n from clewa_measurements\n order by id asc\n limit :limit\n `;\n const result = await sqlite.execute({ sql: q, args: { limit } });\n const rows = mapSqlResultToObjects(result);\n return new Response(JSON.stringify({ rows }), {\n status: 200,\n headers: { \"Content-Type\": \"application/json; charset=utf-8\" },\n });\n } catch (err) {\n return new Response(JSON.stringify({ rows: [], error: String(err) }), {\n status: 500,\n headers: { \"Content-Type\": \"application/json; charset=utf-8\" },\n });\n }\n }\n\n // UI: serve page (built from an array of lines to avoid server-side interpolation issues)\n const html = [\n \"\",\n '',\n \"\",\n ' ',\n ' ',\n \" Val — Time Dial & Buoy Data\",\n \" \",\n \"\",\n \"\",\n '

',\n '

—

',\n '

Loading…

',\n '

Water (°F)

—

',\n '

Wave (ft)

—

',\n '

Wind (mph)

—

',\n \"

\",\n \"

\",\n '

',\n ' ',\n ' ',\n ' ',\n ' 0 / 0',\n ' ',\n \"

\",\n \" \",\n \"\",\n \"\",\n ].join(\"\\n\");\n\n return new Response(html, {\n status: 200,\n headers: { \"Content-Type\": \"text/html; charset=utf-8\" },\n });\n}","// dial_val.ts\nimport { sqlite } from \"https://esm.town/v/std/sqlite\";\n\nconst MAX_ROWS = 5000;\n\nfunction mapSqlResultToObjects(result: any) {\n if (!result) return [];\n if (Array.isArray(result) && result.length && typeof result[0] === \"object\" && !Array.isArray(result[0])) {\n return result;\n }\n if (result.rows && Array.isArray(result.rows) && Array.isArray(result.columns)) {\n return result.rows.map((row: any[]) =>\n Object.fromEntries(row.map((v, i) => [result.columns[i], v]))\n );\n }\n if (result.rows && Array.isArray(result.rows)) {\n return result.rows;\n }\n return [];\n}\n\nexport default async function (req: Request): Promise {\n const url = new URL(req.url);\n\n // API endpoint returning DB measurements\n if (url.pathname === \"/api/measurements\") {\n const limitParam = Number(url.searchParams.get(\"limit\") ?? 1000);\n const limit = Math.min(Number.isFinite(limitParam) && limitParam > 0 ? limitParam : 1000, MAX_ROWS);\n try {\n const q = `\n select id, fetched_at, water_temp_f, wave_height_ft, wind_speed_mph\n from clewa_measurements\n order by id asc\n limit :limit\n `;\n const result = await sqlite.execute({ sql: q, args: { limit } });\n const rows = mapSqlResultToObjects(result);\n return new Response(JSON.stringify({ rows }), {\n status: 200,\n headers: { \"Content-Type\": \"application/json; charset=utf-8\" },\n });\n } catch (err) {\n return new Response(JSON.stringify({ rows: [], error: String(err) }), {\n status: 500,\n headers: { \"Content-Type\": \"application/json; charset=utf-8\" },\n });\n }\n }\n\n // UI HTML (array-of-strings to avoid server-side interpolation issues)\n const html = [\n'',\n'',\n'',\n' ',\n' ',\n' Val — Time Dial & Buoy Data',\n' ',\n'',\n'',\n'

',\n'

—

',\n'

Loading…

',\n'

Water (°F)

—

',\n'

Wave (ft)

—

',\n'

Wind (mph)

—

',\n'

',\n' ',\n' ',\n' ',\n' 0 / 0',\n' ',\n'

',\n' ',\n'',\n''\n ].join(\"\\n\");\n\n return new Response(html, {\n status: 200,\n headers: { \"Content-Type\": \"text/html; charset=utf-8\" },\n });\n}","createdAt",["D",1757014356886],"branchVersion","branchId","bd7a25ac-89ac-11f0-953c-0224a6c84d84","id","bd79c738-89ac-11f0-953c-0224a6c84d84","untitled-5330",["D",1757003545470],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","d64c506a-4597-4bf9-ba45-8b6a781b5e0a","pinnedFileId","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","f9ac693b-9e35-4e47-8d7a-2fbf852b3f25","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_95":94,"_102":98},"org",{"_95":94,"_96":-5,"_97":98,"_18":54,"_99":100,"_101":25},"branch",{"_13":84,"_32":85,"_43":42,"_86":44,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":45,"_93":94},"isOwned",71,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","chriswmartin","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18yaTBjN1NNRHdvcjN4SFo5UFVJckxsUmZXaFoifQ","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_43":44,"_32":45,"_38":149,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":-5,"_53":-5,"_18":54,"_55":31,"_56":57,"_58":57,"_59":-5,"_60":61,"_62":63,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":69,"_70":69,"_71":72,"_73":72,"_74":72,"_75":69,"_76":69,"_77":150,"_79":151,"_81":152,"_83":25},"tree",[144],"files",[144],"counts",{"_133":61,"_134":135,"_136":61,"_137":138,"_139":140},"contents",[125],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_43":126,"_32":28,"_30":31,"_127":-5,"_41":42,"_40":14,"_128":25,"_38":129,"_13":130,"_33":34,"_35":37,"_24":25,"_131":-5,"_27":132},"e996548a-89c5-11f0-88f0-0224a6c84d84","parentId","latest",["D",1757014356886],15,"label",[28],"pulls","branches",1,"forks","envVars",{"_141":61,"_143":61},"connections",{"_141":61,"_142":61},"count","unfilledCount","emptyCount",{"_43":126,"_32":28,"_30":31,"_127":-5,"_41":42,"_40":14,"_128":25,"_38":145,"_13":130,"_33":34,"_35":37,"_24":25,"_131":-5,"_146":147,"_27":148},["D",1757014356886],"children",[],[28],["D",1757003545470],{"_95":94,"_102":98},{"_95":94,"_96":-5,"_97":98,"_18":54,"_99":100,"_101":25},{"_13":84,"_32":85,"_43":42,"_86":44,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":45,"_93":94},"ctx",{"_77":-5,"_122":186,"_187":188,"_189":190,"_191":25,"_192":25,"_193":25,"_194":57,"_195":-5,"_196":-7,"_197":-7,"_198":61,"_199":25,"_200":25,"_201":-5,"_202":25,"_203":25,"_204":25,"_205":-5},"ENV",{"_157":158,"_159":160,"_161":85,"_162":163,"_164":165,"_166":167,"_168":169,"_170":171,"_172":173,"_174":175,"_176":177,"_178":179,"_180":181,"_182":183,"_184":185},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","fdb67791413f4386b4dbf18f354029a617f6160f","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 · v16