[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_204":205,"_206":207},"routes/_app.x.$handle.$name",{"_99":98,"_33":46,"_106":89,"_27":37,"_13":14,"_107":-5,"_11":108,"_109":110,"_111":112,"_113":114,"_115":116,"_20":-5,"_117":-5,"_118":-5,"_119":25,"_120":121,"_122":25,"_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",{"_44":45,"_33":46,"_39":47,"_48":-5,"_49":25,"_50":51,"_52":51,"_53":37,"_54":-5,"_18":55,"_56":32,"_57":58,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":66,"_67":68,"_69":70,"_71":-5,"_72":73,"_74":73,"_75":76,"_77":76,"_78":76,"_79":73,"_80":73,"_81":82,"_83":84,"_85":86,"_87":25},"version",14,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":30},"file",{"_31":32,"_33":28,"_34":35,"_36":38,"_39":40,"_41":14,"_42":43,"_24":25},"previous",{"_31":32,"_33":28,"_34":35,"_36":37},"deleted",false,"deletedHere","path","new-file-8839.ts","latestPath","viewer.ts","fileId","8219086a-64f9-11f1-b3ff-1607ee4eb77e","name","fileType","script","content","","import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { TABLE, upsertDraw } from \"./db.ts\";\nimport { fetchDraw } from \"./parse.ts\";\n\n// HTTP endpoint. Use it just like the Mega Millions URL — pass ?PlayDateTicks=\n//\n// /?PlayDateTicks=639150048000000000 -> fetch + parse + store that draw, return JSON\n// /?PlayDateTicks=...&raw=1 -> return the full raw payload instead\n// / -> latest 20 stored draws\nexport default async function (req: Request): Promise {\n const url = new URL(req.url);\n // Accept either ?PlayDateTicks= (same as the source API) or ?ticks=\n const ticks = url.searchParams.get(\"PlayDateTicks\") ??\n url.searchParams.get(\"ticks\");\n\n if (ticks) {\n if (!/^\\d+$/.test(ticks)) {\n return Response.json({ error: \"PlayDateTicks must be a number\" }, {\n status: 400,\n });\n }\n try {\n const draw = await fetchDraw(ticks);\n // Cache it so the scheduled list view picks it up too.\n await upsertDraw(draw);\n\n if (url.searchParams.get(\"raw\")) {\n return new Response(draw.raw, {\n headers: { \"content-type\": \"application/json\" },\n });\n }\n return Response.json(draw);\n } catch (err) {\n return Response.json({ error: (err as Error).message }, { status: 502 });\n }\n }\n\n const { columns, rows } = await sqlite.execute(`\n SELECT play_date_ticks, play_date, n1, n2, n3, n4, n5, mega_ball, megaplier,\n current_prize_pool, next_prize_pool, jackpot_winners, scraped_at\n FROM ${TABLE}\n ORDER BY play_date_ticks DESC\n LIMIT 20\n `);\n\n const draws = rows.map((r) =>\n Object.fromEntries(columns.map((c, i) => [c, r[i]]))\n );\n return Response.json({ count: draws.length, draws });\n}","createdAt",["D",1781115827319],"branchVersion","branchId","37790822-128c-44c5-8a02-e879023caf29","id","b04757d5-2790-41e1-93ff-1b5bf8373e20","danikaazure-go",["D",1781115744504],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","afc6b6b6-50b0-4981-bdfc-3bc06aa3c798","pinnedFileId","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","019eb2a9-32c8-758f-b0d5-319026801566","tursoName","b04757d5279041e193ff1b5bf8373e20","tursoHostname","b04757d5279041e193ff1b5bf8373e20-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789500119686],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_99":98,"_105":37},"org",{"_99":98,"_100":37,"_101":37,"_18":55,"_102":103,"_104":25},"branch",{"_13":88,"_33":89,"_44":43,"_90":45,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":46,"_97":98},"isOwned",20,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","danikaazure","handle","displayName","avatar","tier","free","canRestrictVals","profileImageUrl","branchName","adoptOrgId",{"_44":45,"_33":46,"_39":199,"_48":-5,"_49":25,"_50":51,"_52":51,"_53":37,"_54":-5,"_18":55,"_56":32,"_57":58,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":66,"_67":68,"_69":200,"_71":-5,"_72":73,"_74":73,"_75":76,"_77":76,"_78":76,"_79":73,"_80":73,"_81":201,"_83":202,"_85":203,"_87":25},"tree",[178,179,180,181,182],"files",[178,179,180,181,182],"counts",{"_168":62,"_169":159,"_170":62,"_171":172,"_173":174},"contents",[127,128,129,130,131],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_44":161,"_33":162,"_31":163,"_135":-5,"_42":43,"_41":164,"_137":58,"_39":165,"_13":139,"_34":35,"_36":166,"_24":25,"_141":-5,"_27":167},{"_44":157,"_33":28,"_31":32,"_135":-5,"_42":43,"_41":14,"_137":25,"_39":158,"_13":159,"_34":35,"_36":38,"_24":25,"_141":-5,"_27":160},{"_44":150,"_33":151,"_31":152,"_135":-5,"_42":43,"_41":153,"_137":58,"_39":154,"_13":139,"_34":35,"_36":155,"_24":25,"_141":-5,"_27":156},{"_44":143,"_33":144,"_31":145,"_135":-5,"_42":43,"_41":146,"_137":25,"_39":147,"_13":139,"_34":35,"_36":148,"_24":25,"_141":-5,"_27":149},{"_44":132,"_33":133,"_31":134,"_135":-5,"_42":43,"_41":136,"_137":58,"_39":138,"_13":139,"_34":35,"_36":140,"_24":25,"_141":-5,"_27":142},"8a9b57ad-35ec-41d4-bc3f-9df37be09d36","tick.ts","7ac1f8ba-64f9-11f1-9751-1607ee4eb77e","parentId",12,"latest",["D",1781115817576],2,"// .NET DateTime ticks: 100-nanosecond intervals since 0001-01-01 UTC.\n// Difference between .NET epoch and Unix epoch, in milliseconds.\nconst NET_EPOCH_OFFSET_MS = 62135596800000;\n\n// Returned as a string: ticks exceed JS's safe integer range, so we use\n// BigInt for the math and keep them as strings end-to-end.\nexport function dateToTicks(d: Date): string {\n // ticks = (unixMs + offset) * 10_000\n return (BigInt(d.getTime() + NET_EPOCH_OFFSET_MS) * 10000n).toString();\n}\n\nexport function ticksToDate(ticks: string): Date {\n return new Date(Number(BigInt(ticks) / 10000n) - NET_EPOCH_OFFSET_MS);\n}\n\n/**\n * Mega Millions draws are Tuesday & Friday. The API keys on the date at\n * midnight (PlayDate \"T00:00:00\"). Returns ticks for each of the most recent\n * `count` draw dates up to and including today (UTC date basis).\n */\nexport function recentDrawTicks(count = 4, from = new Date()): string[] {\n const ticks: string[] = [];\n // Walk backwards from today, collecting Tue(2)/Fri(5) midnight-UTC dates.\n const cursor = new Date(\n Date.UTC(from.getUTCFullYear(), from.getUTCMonth(), from.getUTCDate()),\n );\n while (ticks.length < count) {\n const dow = cursor.getUTCDay();\n if (dow === 2 || dow === 5) {\n ticks.push(dateToTicks(cursor));\n }\n cursor.setUTCDate(cursor.getUTCDate() - 1);\n }\n return ticks;\n}","label",[133],"35d9d91c-d2f1-426b-9369-009bc1f9ee6d","scraper.ts","72199d80-64f9-11f1-b939-1607ee4eb77e",9,["D",1781115804932],"import { setup, upsertDraw } from \"./db.ts\";\nimport { fetchDraw } from \"./parse.ts\";\nimport { recentDrawTicks } from \"./ticks.ts\";\n\n// Interval (cron) entrypoint. Scrapes the most recent draws each run.\nexport default async function (interval: Interval) {\n await setup();\n\n const ticksList = recentDrawTicks(4);\n const results: Record = {};\n\n for (const ticks of ticksList) {\n try {\n const draw = await fetchDraw(ticks);\n await upsertDraw(draw);\n results[ticks] = `ok: ${draw.playDate.slice(0, 10)} — ` +\n `${draw.n1}-${draw.n2}-${draw.n3}-${draw.n4}-${draw.n5} MB ${draw.megaBall}`;\n } catch (err) {\n results[ticks] = `error: ${(err as Error).message}`;\n }\n }\n\n console.log(\"Scrape complete\", results);\n return results;\n}",[144],"bae19ede-cb4a-4225-a50b-91119ac03661","parse.ts","6414a7f2-64f9-11f1-b2fb-1607ee4eb77e",6,["D",1781115790686],"import type { Draw } from \"./db.ts\";\n\nconst BASE =\n \"https://www.megamillions.com/cmspages/utilservice.asmx/GetDrawDataByTickWithMatrix\";\n\n/**\n * The API returns XML like:\n * { ...json... }\n * We pull the JSON payload out of the XML wrapper.\n */\nfunction extractJson(xml: string): any {\n // The inner text is HTML-entity-encoded inside the element.\n const inner = xml\n .replace(/^[\\s\\S]*?]*>/, \"\")\n .replace(/<\\/string>[\\s\\S]*$/, \"\")\n .replaceAll(\"<\", \"<\")\n .replaceAll(\">\", \">\")\n .replaceAll(\""\", '\"')\n .replaceAll(\"&\", \"&\")\n .trim();\n return JSON.parse(inner);\n}\n\nexport async function fetchDraw(playDateTicks: string): Promise {\n const res = await fetch(`${BASE}?PlayDateTicks=${playDateTicks}`, {\n headers: { \"User-Agent\": \"Mozilla/5.0 (val.town scraper)\" },\n });\n if (!res.ok) throw new Error(`Fetch failed: ${res.status} ${res.statusText}`);\n\n const xml = await res.text();\n const data = extractJson(xml);\n const dr = data.Drawing ?? {};\n const jp = data.Jackpot ?? {};\n\n return {\n playDateTicks: String(dr.PlayDateTicks ?? playDateTicks),\n playDate: dr.PlayDate ?? \"\",\n n1: dr.N1,\n n2: dr.N2,\n n3: dr.N3,\n n4: dr.N4,\n n5: dr.N5,\n megaBall: dr.MBall,\n megaplier: dr.Megaplier,\n currentPrizePool: jp.CurrentPrizePool ?? null,\n nextPrizePool: jp.NextPrizePool ?? null,\n currentCashValue: jp.CurrentCashValue ?? null,\n nextCashValue: jp.NextCashValue ?? null,\n jackpotWinners: jp.Winners ?? null,\n raw: JSON.stringify(data),\n scrapedAt: new Date().toISOString(),\n };\n}",[151],"5f2a137a-7047-429b-be88-bc887cd52e16",["D",1781115827319],1,[28],"8bbdadd0-223e-430c-a370-abd03af8bdf0","db.ts","5410d95c-64f9-11f1-a88a-1607ee4eb77e",3,["D",1781115770204],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\n// Bump the suffix if you change the schema.\nexport const TABLE = \"mm_draws_v2\";\n\nexport interface Draw {\n // Stored as TEXT — .NET ticks exceed JS's safe integer range.\n playDateTicks: string;\n playDate: string;\n n1: number;\n n2: number;\n n3: number;\n n4: number;\n n5: number;\n megaBall: number;\n megaplier: number;\n currentPrizePool: number | null;\n nextPrizePool: number | null;\n currentCashValue: number | null;\n nextCashValue: number | null;\n jackpotWinners: number | null;\n raw: string;\n scrapedAt: string;\n}\n\nexport async function setup() {\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${TABLE} (\n play_date_ticks TEXT PRIMARY KEY,\n play_date TEXT NOT NULL,\n n1 INTEGER, n2 INTEGER, n3 INTEGER, n4 INTEGER, n5 INTEGER,\n mega_ball INTEGER,\n megaplier INTEGER,\n current_prize_pool REAL,\n next_prize_pool REAL,\n current_cash_value REAL,\n next_cash_value REAL,\n jackpot_winners INTEGER,\n raw TEXT NOT NULL,\n scraped_at TEXT NOT NULL\n )\n `);\n}\n\n// Upsert keyed on the draw's ticks, so re-running the same draw just refreshes it.\nexport async function upsertDraw(d: Draw) {\n await sqlite.execute({\n sql: `\n INSERT INTO ${TABLE} (\n play_date_ticks, play_date, n1, n2, n3, n4, n5, mega_ball, megaplier,\n current_prize_pool, next_prize_pool, current_cash_value, next_cash_value,\n jackpot_winners, raw, scraped_at\n ) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)\n ON CONFLICT(play_date_ticks) DO UPDATE SET\n play_date=excluded.play_date, n1=excluded.n1, n2=excluded.n2, n3=excluded.n3,\n n4=excluded.n4, n5=excluded.n5, mega_ball=excluded.mega_ball,\n megaplier=excluded.megaplier, current_prize_pool=excluded.current_prize_pool,\n next_prize_pool=excluded.next_prize_pool, current_cash_value=excluded.current_cash_value,\n next_cash_value=excluded.next_cash_value, jackpot_winners=excluded.jackpot_winners,\n raw=excluded.raw, scraped_at=excluded.scraped_at\n `,\n args: [\n d.playDateTicks,\n d.playDate,\n d.n1,\n d.n2,\n d.n3,\n d.n4,\n d.n5,\n d.megaBall,\n d.megaplier,\n d.currentPrizePool,\n d.nextPrizePool,\n d.currentCashValue,\n d.nextCashValue,\n d.jackpotWinners,\n d.raw,\n d.scrapedAt,\n ],\n });\n}",[162],"pulls","branches","forks","envVars",{"_175":62,"_177":62},"connections",{"_175":62,"_176":62},"count","unfilledCount","emptyCount",{"_44":161,"_33":162,"_31":163,"_135":-5,"_42":43,"_41":164,"_137":58,"_39":196,"_13":139,"_34":35,"_36":166,"_24":25,"_141":-5,"_184":197,"_27":198},{"_44":157,"_33":28,"_31":32,"_135":-5,"_42":43,"_41":14,"_137":25,"_39":193,"_13":159,"_34":35,"_36":38,"_24":25,"_141":-5,"_184":194,"_27":195},{"_44":150,"_33":151,"_31":152,"_135":-5,"_42":43,"_41":153,"_137":58,"_39":190,"_13":139,"_34":35,"_36":155,"_24":25,"_141":-5,"_184":191,"_27":192},{"_44":143,"_33":144,"_31":145,"_135":-5,"_42":43,"_41":146,"_137":25,"_39":187,"_13":139,"_34":35,"_36":148,"_24":25,"_141":-5,"_184":188,"_27":189},{"_44":132,"_33":133,"_31":134,"_135":-5,"_42":43,"_41":136,"_137":58,"_39":183,"_13":139,"_34":35,"_36":140,"_24":25,"_141":-5,"_184":185,"_27":186},["D",1781115817576],"children",[],[133],["D",1781115804932],[],[144],["D",1781115790686],[],[151],["D",1781115827319],[],[28],["D",1781115770204],[],[162],["D",1781115744504],["D",1789500119686],{"_99":98,"_105":37},{"_99":98,"_100":37,"_101":37,"_18":55,"_102":103,"_104":25},{"_13":88,"_33":89,"_44":43,"_90":45,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":46,"_97":98},"ctx",{"_81":-5,"_124":237,"_238":239,"_240":241,"_242":25,"_243":25,"_244":25,"_245":58,"_246":-5,"_247":-7,"_248":-7,"_249":62,"_250":25,"_251":25,"_252":-5,"_253":25,"_254":25,"_255":25,"_256":-5},"ENV",{"_208":209,"_210":211,"_212":89,"_213":214,"_215":216,"_217":218,"_219":220,"_221":222,"_223":224,"_225":226,"_227":228,"_229":230,"_231":232,"_233":234,"_235":236},"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 · v14