Lock Scanner — Reserve California

[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_155":156,"_157":158},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":16,"_18":19,"_17":-7,"_117":-5,"_20":118,"_22":119,"_120":121,"_122":123,"_25":124,"_24":-5,"_125":-5,"_126":-5,"_127":53,"_128":129,"_130":44,"_131":-5,"_132":-5,"_133":134},"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","jr7250513","name","lockscanner","branchName","main","version","path","","project",{"_33":61,"_13":14,"_45":62,"_63":-5,"_64":53,"_65":66,"_67":66,"_68":-5,"_69":-5,"_70":71,"_72":-5,"_73":53,"_74":-5,"_75":-5,"_76":77,"_78":79,"_80":81,"_82":83,"_84":85,"_86":-5,"_87":88,"_89":88,"_90":91,"_92":91,"_93":91,"_94":88,"_95":88,"_96":97,"_98":99,"_100":101,"_102":53},"tree",[56],"file","contents",[32],"upstream","pull","ahead","behind","envVars",{"_33":34,"_13":35,"_36":37,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":46,"_17":47,"_48":49,"_50":51,"_52":53,"_54":14,"_18":55},"id","bd0de66e-353f-11f1-bcec-42b51c65c3df","main.ts","fileId","7925aef4-3464-11f1-b0d2-42b51c65c3df","parentId","branchId","79232260-3464-11f1-b0d2-42b51c65c3df","branchVersion",51,"latest",true,"createdAt",["D",1775868329609],50,"fileType","http","content","import { sqlite } from \"https://esm.town/v/std/sqlite\";\n\nexport default async function (req: Request): Promise {\n const url = new URL(req.url);\n\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS scans (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n username TEXT NOT NULL,\n park_id INTEGER NOT NULL,\n park_label TEXT NOT NULL,\n start_date TEXT NOT NULL,\n end_date TEXT NOT NULL,\n created_at TEXT DEFAULT (datetime('now'))\n )`);\n\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS users (\n username TEXT PRIMARY KEY,\n email TEXT NOT NULL DEFAULT ''\n )`);\n\n // GET /api/users\n if (url.pathname === \"/api/users\" && req.method === \"GET\") {\n const r = await sqlite.execute(\n \"SELECT DISTINCT username FROM scans ORDER BY username ASC\",\n );\n return Response.json(r.rows.map((r) => r[0]));\n }\n\n // GET /api/scans?user=...\n if (url.pathname === \"/api/scans\" && req.method === \"GET\") {\n const user = url.searchParams.get(\"user\") || \"\";\n const r = await sqlite.execute({\n sql:\n \"SELECT id, username, park_id, park_label, start_date, end_date FROM scans WHERE username = ? ORDER BY id DESC\",\n args: [user],\n });\n return Response.json(r.rows.map((r) => ({\n id: r[0],\n username: r[1],\n parkId: r[2],\n label: r[3],\n startDate: r[4],\n endDate: r[5],\n })));\n }\n\n // POST /api/scans\n if (url.pathname === \"/api/scans\" && req.method === \"POST\") {\n let body: any;\n try {\n body = await req.json();\n } catch {\n return Response.json({ error: \"Bad JSON\" }, { status: 400 });\n }\n const { user, parkId, label, startDate, endDate } = body;\n if (!user || !parkId || !label || !startDate || !endDate) {\n return Response.json({ error: \"Missing fields\" }, { status: 400 });\n }\n await sqlite.execute({\n sql:\n \"INSERT INTO scans (username, park_id, park_label, start_date, end_date) VALUES (?, ?, ?, ?, ?)\",\n args: [user, parkId, label, startDate, endDate],\n });\n return Response.json({ ok: true });\n }\n\n // DELETE /api/scans/:id\n if (url.pathname.startsWith(\"/api/scans/\") && req.method === \"DELETE\") {\n const id = url.pathname.split(\"/\").pop();\n await sqlite.execute({ sql: \"DELETE FROM scans WHERE id = ?\", args: [id] });\n return Response.json({ ok: true });\n }\n\n // GET /api/profile?user=...\n if (url.pathname === \"/api/profile\" && req.method === \"GET\") {\n const user = url.searchParams.get(\"user\") || \"\";\n const r = await sqlite.execute({\n sql: \"SELECT email FROM users WHERE username = ?\",\n args: [user],\n });\n return Response.json({ email: r.rows[0]?.[0] || \"\" });\n }\n\n // POST /api/profile\n if (url.pathname === \"/api/profile\" && req.method === \"POST\") {\n let body: any;\n try {\n body = await req.json();\n } catch {\n return Response.json({ error: \"Bad JSON\" }, { status: 400 });\n }\n const { user, email } = body;\n if (!user) return Response.json({ error: \"Missing user\" }, { status: 400 });\n await sqlite.execute({\n sql:\n \"INSERT INTO users (username, email) VALUES (?, ?) ON CONFLICT(username) DO UPDATE SET email = excluded.email\",\n args: [user, email || \"\"],\n });\n return Response.json({ ok: true });\n }\n\n // GET /api/parks\n if (url.pathname === \"/api/parks\" && req.method === \"GET\") {\n return Response.json([\n { id: 757, name: \"Crystal Cove - Beach Cottages\", r: \"SoCal Coast\" },\n { id: 447, name: \"Crystal Cove - Moro Campground\", r: \"SoCal Coast\" },\n { id: 582, name: \"Doheny SB - Lower (1-85)\", r: \"SoCal Coast\" },\n { id: 583, name: \"Doheny SB - Upper (86-140)\", r: \"SoCal Coast\" },\n { id: 661, name: \"San Clemente SB - RV (1-72)\", r: \"SoCal Coast\" },\n {\n id: 662,\n name: \"San Clemente SB - Tent East (100-160)\",\n r: \"SoCal Coast\",\n },\n {\n id: 664,\n name: \"San Clemente SB - Tent West (73-99)\",\n r: \"SoCal Coast\",\n },\n { id: 920, name: \"San Clemente SB - Vintage Trailers\", r: \"SoCal Coast\" },\n { id: 714, name: \"San Elijo SB\", r: \"SoCal Coast\" },\n { id: 716, name: \"South Carlsbad SB\", r: \"SoCal Coast\" },\n { id: 668, name: \"San Onofre - Bluffs Group Camp\", r: \"SoCal Coast\" },\n { id: 674, name: \"San Onofre - Bluff Camp (1-23)\", r: \"SoCal Coast\" },\n { id: 675, name: \"San Onofre - Bluff Camp (120-145)\", r: \"SoCal Coast\" },\n { id: 676, name: \"San Onofre - Bluff Camp (146-156)\", r: \"SoCal Coast\" },\n { id: 677, name: \"San Onofre - Bluff Camp (157-175)\", r: \"SoCal Coast\" },\n { id: 678, name: \"San Onofre - Bluff Camp (24-45)\", r: \"SoCal Coast\" },\n { id: 680, name: \"San Onofre - Bluff Camp (46-66)\", r: \"SoCal Coast\" },\n { id: 681, name: \"San Onofre - Bluff Camp (67-93)\", r: \"SoCal Coast\" },\n { id: 682, name: \"San Onofre - Bluff Camp (94-119)\", r: \"SoCal Coast\" },\n {\n id: 683,\n name: \"San Onofre - San Mateo Camp (101-140)\",\n r: \"SoCal Coast\",\n },\n {\n id: 684,\n name: \"San Onofre - San Mateo Camp (141-157)\",\n r: \"SoCal Coast\",\n },\n { id: 712, name: \"San Onofre - San Mateo Camp (1-67)\", r: \"SoCal Coast\" },\n {\n id: 686,\n name: \"San Onofre - San Mateo Camp (68-100)\",\n r: \"SoCal Coast\",\n },\n { id: 700, name: \"Huntington SB\", r: \"SoCal Coast\" },\n { id: 417, name: \"Bolsa Chica SB - Campground (1-31)\", r: \"SoCal Coast\" },\n {\n id: 418,\n name: \"Bolsa Chica SB - Campground (32-57)\",\n r: \"SoCal Coast\",\n },\n { id: 704, name: \"Leo Carrillo SP\", r: \"SoCal Coast\" },\n { id: 708, name: \"Point Mugu SP - Thornhill Broome\", r: \"SoCal Coast\" },\n { id: 709, name: \"Point Mugu SP - Sycamore Canyon\", r: \"SoCal Coast\" },\n { id: 695, name: \"Carpinteria SB\", r: \"SoCal Coast\" },\n { id: 699, name: \"El Capitan SB\", r: \"SoCal Coast\" },\n { id: 633, name: \"Refugio SB\", r: \"SoCal Coast\" },\n { id: 706, name: \"Malibu Creek SP\", r: \"SoCal Coast\" },\n {\n id: 611,\n name: \"Pfeiffer Big Sur - South Camp (1-78)\",\n r: \"Central Coast\",\n },\n {\n id: 612,\n name: \"Pfeiffer Big Sur - Weyland Camp (79-130)\",\n r: \"Central Coast\",\n },\n {\n id: 767,\n name: \"Pfeiffer Big Sur - Main Camp (131-188)\",\n r: \"Central Coast\",\n },\n { id: 577, name: \"Montana de Oro SP - Islay Creek\", r: \"Central Coast\" },\n { id: 672, name: \"Morro Bay SP - San Luis Creek\", r: \"Central Coast\" },\n { id: 787, name: \"San Simeon SP - Washburn\", r: \"Central Coast\" },\n { id: 711, name: \"San Simeon SP - San Simeon Creek\", r: \"Central Coast\" },\n { id: 694, name: \"Big Basin Redwoods SP\", r: \"Central Coast\" },\n { id: 717, name: \"Sunset SB\", r: \"Central Coast\" },\n { id: 701, name: \"Hearst San Simeon SP\", r: \"Central Coast\" },\n { id: 596, name: \"New Brighton SB - Campground (1)\", r: \"Central Coast\" },\n { id: 597, name: \"New Brighton SB - South (1-43)\", r: \"Central Coast\" },\n { id: 598, name: \"New Brighton SB - North (44-111)\", r: \"Central Coast\" },\n { id: 715, name: \"Seacliff SB\", r: \"Central Coast\" },\n { id: 498, name: \"Half Moon Bay SB - Francis Beach\", r: \"Central Coast\" },\n { id: 689, name: \"Samuel P. Taylor SP\", r: \"NorCal Coast\" },\n {\n id: 590,\n name: \"Mt Tamalpais SP - Steep Ravine Camps\",\n r: \"NorCal Coast\",\n },\n {\n id: 766,\n name: \"Mt Tamalpais SP - Steep Ravine Cabins\",\n r: \"NorCal Coast\",\n },\n { id: 687, name: \"Mt Tamalpais SP - Pantoll\", r: \"NorCal Coast\" },\n { id: 2061, name: \"Bodega Dunes Campground\", r: \"NorCal Coast\" },\n { id: 706, name: \"Sonoma Coast SP - Wright's Beach\", r: \"NorCal Coast\" },\n { id: 668, name: \"MacKerricher SP\", r: \"NorCal Coast\" },\n { id: 683, name: \"Jedediah Smith Redwoods SP\", r: \"NorCal Coast\" },\n { id: 682, name: \"Gold Bluffs Beach\", r: \"NorCal Coast\" },\n {\n id: 681,\n name: \"Prairie Creek Redwoods SP - Elk Prairie\",\n r: \"NorCal Coast\",\n },\n { id: 684, name: \"Patrick's Point SP\", r: \"NorCal Coast\" },\n { id: 686, name: \"Humboldt Redwoods SP - Burlington\", r: \"NorCal Coast\" },\n { id: 405, name: \"Angel Island SP - Ayala Cove\", r: \"Bay Area\" },\n { id: 406, name: \"Angel Island SP - East Bay\", r: \"Bay Area\" },\n { id: 407, name: \"Angel Island SP - West Garrison\", r: \"Bay Area\" },\n { id: 408, name: \"Angel Island SP - Ridge\", r: \"Bay Area\" },\n { id: 409, name: \"Angel Island SP - Sunrise\", r: \"Bay Area\" },\n { id: 411, name: \"Angel Island SP - Boat-In\", r: \"Bay Area\" },\n { id: 436, name: \"China Camp SP - Group Area\", r: \"Bay Area\" },\n { id: 437, name: \"China Camp SP - Campground\", r: \"Bay Area\" },\n { id: 656, name: \"Calaveras Big Trees SP\", r: \"Sierra\" },\n { id: 472, name: \"D.L. Bliss SP - Lower Eagle Point\", r: \"Sierra\" },\n { id: 786, name: \"D.L. Bliss SP - Upper Eagle Point\", r: \"Sierra\" },\n { id: 622, name: \"Plumas-Eureka SP - Jamison Creek\", r: \"Sierra\" },\n { id: 494, name: \"Grover Hot Springs SP (1-36)\", r: \"Sierra\" },\n { id: 495, name: \"Grover Hot Springs SP (37-76)\", r: \"Sierra\" },\n { id: 516, name: \"Indian Grinding Rock SHP\", r: \"Sierra\" },\n { id: 658, name: \"Columbia SHP\", r: \"Sierra\" },\n { id: 776, name: \"Anza-Borrego - Palm Canyon (1-52)\", r: \"Desert\" },\n { id: 777, name: \"Anza-Borrego - Palm Canyon (90-120)\", r: \"Desert\" },\n { id: 327, name: \"Anza-Borrego - Palm Canyon (53-89)\", r: \"Desert\" },\n { id: 329, name: \"Anza-Borrego - Tamarisk Grove\", r: \"Desert\" },\n { id: 602, name: \"Red Rock Canyon SP\", r: \"Desert\" },\n { id: 481, name: \"Folsom Lake SRA - Beals Point\", r: \"Central Valley\" },\n { id: 665, name: \"Auburn SRA\", r: \"Central Valley\" },\n { id: 666, name: \"McArthur-Burney Falls SP\", r: \"North State\" },\n { id: 431, name: \"Castle Crags SP\", r: \"North State\" },\n { id: 469, name: \"Ahjumawi Lava Springs SP\", r: \"North State\" },\n { id: 2031, name: \"Point Mugu SP - Thornhill Broome\", r: \"SoCal Coast\" },\n {\n id: 2158,\n name: \"Crystal Cove - Upper Moro Campground\",\n r: \"SoCal Coast\",\n },\n {\n id: 2159,\n name: \"Crystal Cove - Lower Moro Campground\",\n r: \"SoCal Coast\",\n },\n { id: 2038, name: \"Red Rock Canyon - Ricardo Campground\", r: \"Desert\" },\n { id: 2154, name: \"East Ridge Campground\", r: \"NorCal Coast\" },\n ]);\n }\n\n // Serve app\n const html = `\n\n\n\n\nLock Scanner — Reserve California\n\n\n\n\n

\n\n\n`;\n\n return new Response(html, {\n headers: { \"Content-Type\": \"text/html; charset=utf-8\" },\n });\n}","deleted",false,"label",[35],{"_33":34,"_13":35,"_36":37,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":57,"_17":47,"_48":49,"_50":51,"_52":53,"_54":14,"_58":59,"_18":60},["D",1775868329609],"children",[],[35],"79227a36-3464-11f1-b0d2-42b51c65c3df",["D",1775774155886],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","userId","8ba7e804-c257-4cfa-8e42-12d6d72199a8","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","019d738d-b90e-705f-acd4-242845609bf1","tursoName","79227a36346411f1b0d242b51c65c3df","tursoHostname","79227a36346411f1b0d242b51c65c3df-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789442454549],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_116":19},"org",{"_11":12,"_111":-5,"_112":19,"_70":71,"_113":114,"_115":53},"branch",{"_17":42,"_13":16,"_33":40,"_103":61,"_104":-5,"_105":-5,"_106":-5,"_107":-5,"_108":-5,"_109":14,"_110":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","avatar","tier","pro","canRestrictVals","profileImageUrl","adoptOrgId",{"_33":61,"_13":14,"_45":150,"_63":-5,"_64":53,"_65":66,"_67":66,"_68":-5,"_69":-5,"_70":71,"_72":-5,"_73":53,"_74":-5,"_75":-5,"_76":77,"_78":79,"_80":81,"_82":83,"_84":151,"_86":-5,"_87":88,"_89":88,"_90":91,"_92":91,"_93":91,"_94":88,"_95":88,"_96":152,"_98":153,"_100":154,"_102":53},[147],"files",[147],"counts",{"_137":77,"_138":139,"_140":77,"_31":141,"_142":143},[135],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_33":34,"_13":35,"_36":37,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":46,"_17":47,"_48":49,"_50":51,"_52":53,"_54":14,"_18":136},[35],"pulls","branches",1,"forks",{"_144":77,"_146":77},"connections",{"_144":77,"_145":77},"count","unfilledCount","emptyCount",{"_33":34,"_13":35,"_36":37,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":57,"_17":47,"_48":49,"_50":51,"_52":53,"_54":14,"_58":148,"_18":149},[],[35],["D",1775774155886],["D",1789442454549],{"_11":12,"_116":19},{"_11":12,"_111":-5,"_112":19,"_70":71,"_113":114,"_115":53},{"_17":42,"_13":16,"_33":40,"_103":61,"_104":-5,"_105":-5,"_106":-5,"_107":-5,"_108":-5,"_109":14,"_110":12},"ctx",{"_96":-5,"_132":188,"_189":190,"_191":192,"_193":53,"_194":53,"_195":53,"_196":44,"_197":-5,"_198":-7,"_199":-7,"_200":77,"_201":53,"_202":53,"_203":-5,"_204":53,"_205":53,"_206":53,"_207":-5},"ENV",{"_159":160,"_161":162,"_163":16,"_164":165,"_166":167,"_168":169,"_170":171,"_172":173,"_174":175,"_176":177,"_178":179,"_180":181,"_182":183,"_184":185,"_186":187},"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