[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_180":181,"_182":183},"routes/_app.x.$handle.$name",{"_98":97,"_31":43,"_107":88,"_26":108,"_13":14,"_109":-5,"_11":110,"_111":112,"_113":114,"_115":116,"_117":118,"_20":-5,"_119":-5,"_120":-5,"_121":24,"_122":123,"_124":24,"_125":-5,"_126":-5,"_127":128},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_41":42,"_31":43,"_36":44,"_45":-5,"_46":24,"_47":48,"_49":48,"_50":51,"_52":-5,"_18":53,"_54":55,"_56":57,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":65,"_66":67,"_68":69,"_70":-5,"_71":72,"_73":72,"_74":75,"_76":75,"_77":75,"_78":72,"_79":72,"_80":81,"_82":83,"_84":85,"_86":24},"version",3,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":-7,"_23":24,"_25":24,"_26":27,"_28":27},"file",{"_29":30,"_31":27,"_32":33,"_34":35,"_36":37,"_38":14,"_39":40,"_23":24},"previous","deleted",false,"deletedHere","path","store.ts","latestPath","fileId","95b7757a-87f2-11f1-b24f-1607ee4eb77e","name","fileType","script","content","// Watch list persistence (Val.town SQLite, val-scoped).\n//\n// A \"watch\" is: on this date, for this class, tell me when a spot opens.\n// Two flags control the lifecycle:\n// active — off means the checker ignores it entirely (the stop switch).\n// armed — on means \"currently full, waiting for it to open\". It flips off\n// when we notify and back on when the class fills up again, so a\n// standing watch pings on each full -> open transition instead of\n// every 15 minutes.\n\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { jstStamp, padTime } from \"./gym.ts\";\n\nexport const TABLE = \"gym_watch_v1\";\n\nexport type WatchState = \"full\" | \"open\" | \"missing\" | null;\n\nexport type Watch = {\n id: number;\n date: string;\n time: string | null;\n match: string;\n label: string;\n min_spots: number;\n active: number;\n once: number;\n armed: number;\n last_state: WatchState;\n last_checked_at: string | null;\n notified_at: string | null;\n created_at: string;\n};\n\nexport async function ensureSchema(): Promise {\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS ${TABLE} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n date TEXT NOT NULL,\n time TEXT,\n match TEXT NOT NULL DEFAULT '',\n label TEXT NOT NULL DEFAULT '',\n min_spots INTEGER NOT NULL DEFAULT 1,\n active INTEGER NOT NULL DEFAULT 1,\n once INTEGER NOT NULL DEFAULT 1,\n armed INTEGER NOT NULL DEFAULT 1,\n last_state TEXT,\n last_checked_at TEXT,\n notified_at TEXT,\n created_at TEXT NOT NULL\n )`);\n}\n\nfunction toWatch(row: Record): Watch {\n return {\n id: Number(row.id),\n date: String(row.date),\n time: row.time == null ? null : String(row.time),\n match: String(row.match ?? \"\"),\n label: String(row.label ?? \"\"),\n min_spots: Number(row.min_spots ?? 1),\n active: Number(row.active ?? 0),\n once: Number(row.once ?? 1),\n armed: Number(row.armed ?? 1),\n last_state: (row.last_state ?? null) as WatchState,\n last_checked_at: row.last_checked_at == null ? null : String(row.last_checked_at),\n notified_at: row.notified_at == null ? null : String(row.notified_at),\n created_at: String(row.created_at ?? \"\"),\n };\n}\n\nexport async function listWatches(): Promise {\n const res = await sqlite.execute(\n `SELECT * FROM ${TABLE} ORDER BY active DESC, date ASC, time ASC, id ASC`,\n );\n return res.rows.map((r) => toWatch(r as Record));\n}\n\nexport async function listActiveWatches(): Promise {\n const res = await sqlite.execute(\n `SELECT * FROM ${TABLE} WHERE active = 1 ORDER BY date ASC, time ASC, id ASC`,\n );\n return res.rows.map((r) => toWatch(r as Record));\n}\n\nexport type NewWatch = {\n date: string;\n time?: string | null;\n match?: string | null;\n label?: string | null;\n minSpots?: number;\n once?: boolean;\n};\n\nexport async function addWatch(w: NewWatch): Promise {\n if (!/^\\d{4}-\\d{2}-\\d{2}$/.test(w.date)) throw new Error(`bad date: ${w.date}`);\n const time = w.time ? padTime(w.time) : null;\n if (time && !/^\\d{2}:\\d{2}$/.test(time)) throw new Error(`bad time: ${w.time}`);\n const match = (w.match ?? \"\").trim();\n const label = (w.label ?? \"\").trim() || match || \"any class\";\n\n const res = await sqlite.execute({\n sql: `INSERT INTO ${TABLE}\n (date, time, match, label, min_spots, active, once, armed, created_at)\n VALUES (?, ?, ?, ?, ?, 1, ?, 1, ?)`,\n args: [\n w.date,\n time,\n match,\n label,\n Math.max(1, Number(w.minSpots ?? 1)),\n w.once === false ? 0 : 1,\n jstStamp(),\n ],\n });\n return Number(res.lastInsertRowid ?? 0);\n}\n\n/** Flip a watch on/off. Re-enabling re-arms it so it can fire again. */\nexport async function setActive(id: number, active: boolean): Promise {\n await sqlite.execute({\n sql: `UPDATE ${TABLE} SET active = ?, armed = CASE WHEN ? = 1 THEN 1 ELSE armed END\n WHERE id = ?`,\n args: [active ? 1 : 0, active ? 1 : 0, id],\n });\n}\n\nexport async function deleteWatch(id: number): Promise {\n await sqlite.execute({ sql: `DELETE FROM ${TABLE} WHERE id = ?`, args: [id] });\n}\n\n/** Turn off watches whose date has already passed in Japan time. */\nexport async function expirePastWatches(today: string): Promise {\n const res = await sqlite.execute({\n sql: `UPDATE ${TABLE} SET active = 0 WHERE active = 1 AND date < ?`,\n args: [today],\n });\n return Number(res.rowsAffected ?? 0);\n}\n\nexport async function recordCheck(\n id: number,\n state: Exclude,\n at: string,\n): Promise {\n await sqlite.execute({\n sql: `UPDATE ${TABLE} SET last_state = ?, last_checked_at = ?,\n armed = CASE WHEN ? = 'open' THEN armed ELSE 1 END\n WHERE id = ?`,\n args: [state, at, state, id],\n });\n}\n\n/** Called right after a successful push: disarm, and retire one-shot watches. */\nexport async function recordNotified(id: number, once: boolean, at: string): Promise {\n await sqlite.execute({\n sql: `UPDATE ${TABLE} SET armed = 0, notified_at = ?, last_state = 'open',\n last_checked_at = ?, active = ?\n WHERE id = ?`,\n args: [at, at, once ? 0 : 1, id],\n });\n}\n","createdAt",["D",1784961138871],"branchVersion","branchId","27b0c9da-a5eb-41fe-aaeb-77adf88507b4","id","5d4412c5-e8ea-4b0e-9c45-807ff466c2c8","gym-watch",["D",1784960531219],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Watch full gym classes and ntfy me when a spot opens","imageUrl","55bb51a5-3cba-4849-b93f-730c8256b11f","pinnedFileId","2cff4372-87f3-11f1-ae13-1607ee4eb77e","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","019e3895-8040-75ca-a642-70681ae8aa8b","tursoName","5d4412c5e8ea4b0e9c45807ff466c2c8","tursoHostname","5d4412c5e8ea4b0e9c45807ff466c2c8-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789476648181],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_98":97,"_106":102},"org",{"_98":97,"_99":100,"_101":102,"_18":53,"_103":104,"_105":24},"branch",{"_13":87,"_31":88,"_41":40,"_89":42,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":43,"_96":97},"isOwned",9,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","paul_firetruck","handle","displayName","Paul Brenner","avatar","https://lh3.googleusercontent.com/a/ACg8ocIp3wAlqlK0QrsWVa_cFuOroVJ9m_DHOSXQTtIZQQOtizdoQ9dI2g=s96-c","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_41":42,"_31":43,"_36":175,"_45":-5,"_46":24,"_47":48,"_49":48,"_50":51,"_52":-5,"_18":53,"_54":55,"_56":57,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":65,"_66":67,"_68":176,"_70":-5,"_71":72,"_73":72,"_74":75,"_76":75,"_77":75,"_78":72,"_79":72,"_80":177,"_82":178,"_84":179,"_86":24},"tree",[162,163,164],"files",[162,163,164],"counts",{"_152":61,"_153":148,"_154":61,"_155":156,"_157":158},"contents",[129,130,131],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_41":145,"_31":146,"_29":147,"_133":-5,"_39":40,"_38":148,"_134":57,"_36":149,"_13":61,"_32":20,"_34":150,"_23":24,"_136":-5,"_26":151},{"_41":138,"_31":139,"_29":140,"_133":-5,"_39":40,"_38":141,"_134":57,"_36":142,"_13":61,"_32":33,"_34":143,"_23":24,"_136":-5,"_26":144},{"_41":132,"_31":27,"_29":30,"_133":-5,"_39":40,"_38":14,"_134":57,"_36":135,"_13":61,"_32":33,"_34":35,"_23":24,"_136":-5,"_26":137},"b116d1e2-c91b-416d-b9ea-4d08c1ceaf2a","parentId","latest",["D",1784961138871],"label",[27],"c438ad7c-b88e-421d-b778-eaaa825f9706","gym.ts","dfb7045c-87f1-11f1-a052-1607ee4eb77e",2,["D",1784960833525],"// Client for the CrossFit Black Ships Yoyogi booking calendar.\n//\n// The public site (blackships.stores.jp, formerly coubic.com) is a Next.js app\n// behind Cloudflare; the calendar itself is client-rendered, so scraping the\n// HTML gets you an empty shell. The grid is populated from this JSON endpoint,\n// which needs no auth and no browser:\n//\n// GET /reserve/api/v2/merchants//booking_events\n// ?renderer=fullcalendar&start=&end=\n//\n// `start`/`end` are inclusive/exclusive instants; sending them with a +09:00\n// offset keeps day boundaries on Japan time. Times come back as local (JST)\n// \"YYYY-MM-DD HH:MM\" strings, already zero-padded — which is why plain string\n// comparison is safe for both matching and past-event filtering below.\n\nexport const MERCHANT = \"crossfityoyogi\";\nexport const SITE = \"https://blackships.stores.jp\";\nexport const CALENDAR_URL = `${SITE}/reserve/${MERCHANT}/services#pageContent`;\n\nconst API = `${SITE}/reserve/api/v2/merchants/${MERCHANT}/booking_events`;\n\nexport type GymEvent = {\n title: string;\n vacancy: number;\n capacity: number;\n full: boolean;\n waitingList: boolean;\n /** JST local time, \"YYYY-MM-DD HH:MM\". */\n start: string;\n end: string;\n /** Site-relative deep link straight to the booking slot. */\n url: string;\n};\n\n/** Absolute, tappable booking link for an event. */\nexport function bookingUrl(ev: GymEvent): string {\n return ev.url?.startsWith(\"http\") ? ev.url : `${SITE}${ev.url ?? \"\"}`;\n}\n\n/** \"YYYY-MM-DD\" for the given instant in Japan time. */\nexport function jstDate(at: Date = new Date()): string {\n return at.toLocaleDateString(\"en-CA\", { timeZone: \"Asia/Tokyo\" });\n}\n\n/** \"YYYY-MM-DD HH:MM\" for the given instant in Japan time. */\nexport function jstStamp(at: Date = new Date()): string {\n const parts = new Intl.DateTimeFormat(\"en-CA\", {\n timeZone: \"Asia/Tokyo\",\n year: \"numeric\",\n month: \"2-digit\",\n day: \"2-digit\",\n hour: \"2-digit\",\n minute: \"2-digit\",\n hourCycle: \"h23\",\n }).formatToParts(at);\n const get = (type: string) => parts.find((p) => p.type === type)?.value ?? \"00\";\n return `${get(\"year\")}-${get(\"month\")}-${get(\"day\")} ${get(\"hour\")}:${get(\"minute\")}`;\n}\n\n/** Shift a plain \"YYYY-MM-DD\" by whole days without tripping over timezones. */\nexport function addDays(date: string, days: number): string {\n const ms = Date.parse(`${date}T00:00:00Z`) + days * 86_400_000;\n return new Date(ms).toISOString().slice(0, 10);\n}\n\n/** Accepts \"9:15\" or \"09:15\"; returns \"09:15\". Empty input stays empty. */\nexport function padTime(time: string): string {\n const m = time.trim().match(/^(\\d{1,2}):(\\d{2})$/);\n return m ? `${m[1].padStart(2, \"0\")}:${m[2]}` : time.trim();\n}\n\n/** Class names carry a 【※予約制】-style suffix; strip it for display/matching. */\nexport function shortTitle(title: string): string {\n return title.split(/[【\\[]/)[0].replace(/\\s+/g, \" \").trim() || title.trim();\n}\n\nfunction normalize(s: string): string {\n return s.toLowerCase().replace(/\\s+/g, \" \").trim();\n}\n\n/**\n * Fetch every published class from `startDate` up to (not including) `endDate`,\n * both plain \"YYYY-MM-DD\" in Japan time. Dates the gym hasn't published yet\n * simply come back empty rather than erroring.\n */\nexport async function fetchEvents(startDate: string, endDate: string): Promise {\n const qs = new URLSearchParams({\n renderer: \"fullcalendar\",\n start: `${startDate}T00:00:00+09:00`,\n end: `${endDate}T00:00:00+09:00`,\n });\n const res = await fetch(`${API}?${qs}`, {\n headers: {\n Accept: \"application/json\",\n \"Accept-Language\": \"ja,en;q=0.9\",\n // The bare Deno UA gets challenged by Cloudflare on some paths.\n \"User-Agent\":\n \"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 \" +\n \"(KHTML, like Gecko) Chrome/131.0.0.0 Safari/537.36\",\n },\n });\n if (!res.ok) {\n throw new Error(`booking_events ${res.status} for ${startDate}..${endDate}`);\n }\n const body = await res.json();\n if (!Array.isArray(body)) throw new Error(\"booking_events did not return an array\");\n return body as GymEvent[];\n}\n\n/** All classes on a single JST date, in start order. */\nexport async function fetchDay(date: string): Promise {\n const events = await fetchEvents(date, addDays(date, 1));\n return events\n .filter((ev) => ev.start?.startsWith(date))\n .sort((a, b) => a.start.localeCompare(b.start));\n}\n\nexport type WatchCriteria = {\n date: string;\n /** \"HH:MM\" pins an exact class; empty matches any time that day. */\n time?: string | null;\n /** Case-insensitive substring of the class title; empty matches any class. */\n match?: string | null;\n};\n\n/** Classes on `criteria.date` matching the watch, regardless of availability. */\nexport function matchEvents(events: GymEvent[], criteria: WatchCriteria): GymEvent[] {\n const wantTime = criteria.time ? padTime(criteria.time) : \"\";\n const wantMatch = normalize(criteria.match ?? \"\");\n return events.filter((ev) => {\n const [date, time] = (ev.start ?? \"\").split(\" \");\n if (date !== criteria.date) return false;\n if (wantTime && time !== wantTime) return false;\n if (wantMatch && !normalize(ev.title ?? \"\").includes(wantMatch)) return false;\n return true;\n });\n}\n\n/**\n * Of the matched classes, the ones actually bookable right now: not full,\n * enough open spots, and not already under way (a spot freeing up ten minutes\n * into the class is not something to wake someone for).\n */\nexport function openEvents(events: GymEvent[], minSpots: number, now = jstStamp()): GymEvent[] {\n return events.filter(\n (ev) => !ev.full && (ev.vacancy ?? 0) >= Math.max(1, minSpots) && ev.start > now,\n );\n}\n",[139],"5f073c8b-0d77-4958-8b92-a8ef397c22e7","README.md","2b8956ce-87f1-11f1-9fc0-1607ee4eb77e",1,["D",1784960531236],"# gym-watch\n\nSource of truth: https://github.com/paul-brenner/toys `vals/gym-watch/`\n",[146],"pulls","branches","forks","envVars",{"_159":148,"_161":61},"connections",{"_159":61,"_160":61},"count","unfilledCount","emptyCount",{"_41":145,"_31":146,"_29":147,"_133":-5,"_39":40,"_38":148,"_134":57,"_36":172,"_13":61,"_32":20,"_34":150,"_23":24,"_136":-5,"_166":173,"_26":174},{"_41":138,"_31":139,"_29":140,"_133":-5,"_39":40,"_38":141,"_134":57,"_36":169,"_13":61,"_32":33,"_34":143,"_23":24,"_136":-5,"_166":170,"_26":171},{"_41":132,"_31":27,"_29":30,"_133":-5,"_39":40,"_38":14,"_134":57,"_36":165,"_13":61,"_32":33,"_34":35,"_23":24,"_136":-5,"_166":167,"_26":168},["D",1784961138871],"children",[],[27],["D",1784960833525],[],[139],["D",1784960531236],[],[146],["D",1784960531219],["D",1789476648181],{"_98":97,"_106":102},{"_98":97,"_99":100,"_101":102,"_18":53,"_103":104,"_105":24},{"_13":87,"_31":88,"_41":40,"_89":42,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":43,"_96":97},"ctx",{"_80":-5,"_126":213,"_214":215,"_216":217,"_218":24,"_219":24,"_220":24,"_221":57,"_222":-5,"_223":-7,"_224":-7,"_225":61,"_226":24,"_227":24,"_228":-5,"_229":24,"_230":24,"_231":24,"_232":-5},"ENV",{"_184":185,"_186":187,"_188":88,"_189":190,"_191":192,"_193":194,"_195":196,"_197":198,"_199":200,"_201":202,"_203":204,"_205":206,"_207":208,"_209":210,"_211":212},"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"]

Diff · v3