⚡ FLO — Washington Heights

[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_157":158,"_159":160},"routes/_app.x.$handle.$name",{"_97":96,"_32":45,"_105":87,"_27":100,"_13":14,"_106":-5,"_11":107,"_108":109,"_110":111,"_112":113,"_114":115,"_20":-5,"_116":-5,"_117":-5,"_118":25,"_119":120,"_121":122,"_123":-5,"_124":-5,"_125":126},"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":-5,"_56":25,"_57":-5,"_58":-5,"_59":60,"_61":62,"_63":64,"_65":66,"_67":68,"_69":-5,"_70":71,"_72":71,"_73":74,"_75":74,"_76":74,"_77":71,"_78":71,"_79":80,"_81":82,"_83":84,"_85":25},"version",24,"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","d0bcae8a-38db-11f1-a4d6-42b51c65c3df","name","fileType","http","content","// ============================================================\n// FLO Charger Checker — Val.town HTTP Val\n// Washington Heights — 115 Fort Washington Ave\n// ============================================================\n\nimport { sqlite } from \"https://esm.town/v/std/sqlite\";\n\nconst FLO_API = \"https://emobility.servicesflo.com/v3.0\";\n\nconst STATIONS = [\n { id: \"d38878b4-0a95-455f-9bdd-eee4233a96d1\", name: \"AUA-10259\" },\n { id: \"0c469a93-ecf8-4935-bb03-6343810793c9\", name: \"AUA-10295\" },\n];\n\nasync function getStationData() {\n // Create single simple table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS flo_status (\n station_id TEXT PRIMARY KEY,\n last_status TEXT,\n status_changed_at TEXT\n )\n `);\n\n const results = await Promise.all(\n STATIONS.map(async (s) => {\n // Fetch live data from FLO\n const r = await fetch(`${FLO_API}/parks/station/${s.id}`, {\n headers: {\n Origin: \"https://www.flo.com\",\n Referer: \"https://www.flo.com/\",\n },\n });\n const d = await r.json();\n const st = (d.stations || [])[0] || {};\n const status = st.status || \"Unknown\";\n const lastCheckIn = st.lastCheckIn || null;\n\n // Read existing record\n const existing = await sqlite.execute(\n `SELECT last_status, status_changed_at FROM flo_status WHERE station_id = ?`,\n [s.id],\n );\n const row = existing.rows?.[0];\n const prevStatus = row?.[0] as string | null;\n const statusChangedAt = row?.[1] as string | null;\n\n let newStatusChangedAt = statusChangedAt;\n\n if (status !== prevStatus) {\n // Status changed — record the time\n newStatusChangedAt = new Date().toISOString();\n await sqlite.execute(\n `INSERT OR REPLACE INTO flo_status (station_id, last_status, status_changed_at) VALUES (?, ?, ?)`,\n [s.id, status, newStatusChangedAt],\n );\n }\n\n return {\n id: s.id,\n name: s.name,\n status,\n lastCheckIn,\n statusChangedAt: newStatusChangedAt,\n };\n }),\n );\n return results;\n}\n\nconst HTML = `\n\n\n\n\n⚡ FLO — Washington Heights\n\n\n\n\n

\n \n

⚡

Checking chargers...

\n \n

⚡

Checking chargers...

\n\n\n`;\n\nexport default async function handler(req: Request): Promise {\n const url = new URL(req.url);\n if (url.pathname === \"/api/stations\") {\n try {\n const data = await getStationData();\n return new Response(JSON.stringify(data), {\n headers: {\n \"Content-Type\": \"application/json\",\n \"Access-Control-Allow-Origin\": \"*\",\n \"Cache-Control\": \"no-store\",\n },\n });\n } catch (e: any) {\n return new Response(\n JSON.stringify({ error: e.message, stack: e.stack }),\n {\n status: 500,\n headers: { \"Content-Type\": \"application/json\" },\n },\n );\n }\n }\n return new Response(HTML, {\n headers: { \"Content-Type\": \"text/html; charset=utf-8\" },\n });\n}","createdAt",["D",1776374790737],"branchVersion","branchId","d0b3b0dc-38db-11f1-a4d6-42b51c65c3df","id","d0b2b218-38db-11f1-a4d6-42b51c65c3df","floUI",["D",1776265217555],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","37f688ba-0714-4ed2-aa7f-f2b2d9955904","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","019d91a6-1ac4-772a-b440-6d84c49b2ad2","tursoName","d0b2b21838db11f1a4d642b51c65c3df","tursoHostname","d0b2b21838db11f1a4d642b51c65c3df-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789509672838],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_97":96,"_104":100},"org",{"_97":96,"_98":-5,"_99":100,"_18":54,"_101":102,"_103":25},"branch",{"_13":86,"_32":87,"_43":42,"_88":44,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":45,"_95":96},"isOwned",26,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","ryanhowardmusic","handle","displayName","avatar","","tier","free","canRestrictVals","profileImageUrl","branchName","adoptOrgId",{"_43":44,"_32":45,"_38":152,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":-5,"_53":-5,"_18":54,"_55":-5,"_56":25,"_57":-5,"_58":-5,"_59":60,"_61":62,"_63":64,"_65":66,"_67":153,"_69":-5,"_70":71,"_72":71,"_73":74,"_75":74,"_76":74,"_77":71,"_78":71,"_79":154,"_81":155,"_83":156,"_85":25},"tree",[147],"files",[147],"counts",{"_136":60,"_137":138,"_139":60,"_140":141,"_142":143},"contents",[127],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles",true,"grants","orgs","customDomains",{},{"_43":128,"_32":28,"_30":31,"_129":-5,"_41":42,"_40":14,"_130":25,"_38":131,"_13":132,"_33":34,"_35":37,"_24":25,"_133":134,"_27":135},"ef6a90c2-39da-11f1-8af6-42b51c65c3df","parentId","latest",["D",1776374790737],23,"label","washingtonheightsflo",[28],"pulls","branches",1,"forks","envVars",{"_144":60,"_146":60},"connections",{"_144":60,"_145":60},"count","unfilledCount","emptyCount",{"_43":128,"_32":28,"_30":31,"_129":-5,"_41":42,"_40":14,"_130":25,"_38":148,"_13":132,"_33":34,"_35":37,"_24":25,"_133":134,"_149":150,"_27":151},["D",1776374790737],"children",[],[28],["D",1776265217555],["D",1789509672838],{"_97":96,"_104":100},{"_97":96,"_98":-5,"_99":100,"_18":54,"_101":102,"_103":25},{"_13":86,"_32":87,"_43":42,"_88":44,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":45,"_95":96},"ctx",{"_79":-5,"_124":190,"_191":192,"_193":194,"_195":25,"_196":25,"_197":25,"_198":122,"_199":-5,"_200":-7,"_201":-7,"_202":60,"_203":25,"_204":25,"_205":-5,"_206":25,"_207":25,"_208":25,"_209":-5},"ENV",{"_161":162,"_163":164,"_165":87,"_166":167,"_168":169,"_170":171,"_172":173,"_174":175,"_176":177,"_178":179,"_180":181,"_182":183,"_184":185,"_186":187,"_188":189},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","811aa22498c9b0b5a47e8d778de579cdb990f332","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 · v24