[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_212":213,"_214":215},"routes/_app.x.$handle.$name",{"_106":105,"_38":51,"_114":96,"_33":108,"_13":14,"_115":-5,"_11":116,"_117":118,"_119":120,"_121":122,"_123":124,"_26":-5,"_125":-5,"_126":-5,"_127":31,"_128":129,"_130":65,"_131":-5,"_132":-5,"_133":134},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":18,"_19":-5},"project",{"_49":50,"_38":51,"_44":52,"_53":-5,"_54":31,"_55":56,"_57":56,"_58":59,"_60":-5,"_19":61,"_62":63,"_64":65,"_66":-5,"_67":-5,"_68":69,"_70":71,"_72":73,"_74":75,"_76":77,"_78":-5,"_79":80,"_81":80,"_82":83,"_84":83,"_85":83,"_86":80,"_87":80,"_88":89,"_90":91,"_92":93,"_94":31},"version",8,"changes",[25],"aiChatInfo",{"_20":21,"_22":-5,"_23":-5,"_24":-5},"userId","aiChatMessageId","103fc5f9-6fd3-41bd-a839-506846744099","aiChatThreadId","aiChatThreadUserId","aiChatThreadTitle",{"_26":27,"_28":29,"_30":31,"_32":31,"_33":34,"_35":34},"file",{"_36":37,"_38":34,"_39":40,"_41":43,"_44":45,"_46":14,"_47":48,"_30":31},"previous",{"_36":37,"_38":34,"_39":40,"_41":42},"deleted",false,"deletedHere","path","db.ts","latestPath","fileId","fe78e06e-64f5-11f1-8f13-1607ee4eb77e","name","fileType","script","content","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 INTEGER 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, d.playDate, d.n1, d.n2, d.n3, d.n4, d.n5, d.megaBall, d.megaplier,\n d.currentPrizePool, d.nextPrizePool, d.currentCashValue, d.nextCashValue,\n d.jackpotWinners, d.raw, d.scrapedAt,\n ],\n });\n}\n","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, d.playDate, d.n1, d.n2, d.n3, d.n4, d.n5, d.megaBall, d.megaplier,\n d.currentPrizePool, d.nextPrizePool, d.currentCashValue, d.nextCashValue,\n d.jackpotWinners, d.raw, d.scrapedAt,\n ],\n });\n}\n","createdAt",["D",1781114372121],"branchVersion","branchId","63ea10ab-9496-4570-9acf-1b4c8d4438a6","id","d514cca1-3098-4c43-a729-bab3e539e71d","megamillions-scraper",["D",1781114312383],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Scrapes Mega Millions draw data on a schedule into SQLite","imageUrl","afc6b6b6-50b0-4981-bdfc-3bc06aa3c798","pinnedFileId","1ba1c7f0-64f6-11f1-bc85-1607ee4eb77e","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","019eb2a9-32c8-758f-b0d5-319026801566","tursoName","d514cca130984c43a729bab3e539e71d","tursoHostname","d514cca130984c43a729bab3e539e71d-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789499469860],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_106":105,"_113":108},"org",{"_106":105,"_107":108,"_109":108,"_19":61,"_110":111,"_112":31},"branch",{"_13":95,"_38":96,"_49":48,"_97":50,"_98":-5,"_99":-5,"_100":-5,"_101":-5,"_102":-5,"_103":51,"_104":105},"isOwned",15,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","danikaazure","handle","displayName","","avatar","tier","free","canRestrictVals","profileImageUrl","branchName","adoptOrgId",{"_49":50,"_38":51,"_44":207,"_53":-5,"_54":31,"_55":56,"_57":56,"_58":59,"_60":-5,"_19":61,"_62":63,"_64":65,"_66":-5,"_67":-5,"_68":69,"_70":71,"_72":73,"_74":75,"_76":208,"_78":-5,"_79":80,"_81":80,"_82":83,"_84":83,"_85":83,"_86":80,"_87":80,"_88":209,"_90":210,"_92":211,"_94":31},"tree",[186,187,188,189,190],"files",[186,187,188,189,190],"counts",{"_175":69,"_176":177,"_178":69,"_179":180,"_181":182},"contents",[135,136,137,138,139],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_49":172,"_38":34,"_36":37,"_142":-5,"_47":48,"_46":14,"_144":65,"_44":173,"_13":168,"_39":40,"_41":43,"_30":31,"_148":-5,"_33":174},{"_49":165,"_38":166,"_36":167,"_142":-5,"_47":48,"_46":168,"_144":31,"_44":169,"_13":69,"_39":40,"_41":170,"_30":31,"_148":-5,"_33":171},{"_49":157,"_38":158,"_36":159,"_142":-5,"_47":48,"_46":160,"_144":65,"_44":161,"_13":69,"_39":162,"_41":163,"_30":31,"_148":-5,"_33":164},{"_49":150,"_38":151,"_36":152,"_142":-5,"_47":48,"_46":153,"_144":31,"_44":154,"_13":69,"_39":40,"_41":155,"_30":31,"_148":-5,"_33":156},{"_49":140,"_38":141,"_36":63,"_142":-5,"_47":48,"_46":143,"_144":31,"_44":145,"_13":69,"_39":146,"_41":147,"_30":31,"_148":-5,"_33":149},"29a92152-04cd-4283-aabc-043cdbe5e785","viewer.ts","parentId",6,"latest",["D",1781114361335],"http","import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { TABLE } from \"./db.ts\";\n\n// HTTP endpoint: view stored draws as JSON.\n// / -> latest 20 draws (without the bulky raw payload)\n// /?ticks=... -> the full raw payload for one draw\nexport default async function (req: Request): Promise {\n const url = new URL(req.url);\n const ticks = url.searchParams.get(\"ticks\");\n\n if (ticks) {\n const { rows } = await sqlite.execute({\n sql: `SELECT raw FROM ${TABLE} WHERE play_date_ticks = ?`,\n args: [Number(ticks)],\n });\n if (!rows.length) return Response.json({ error: \"not found\" }, { status: 404 });\n return new Response(rows[0][0] as string, {\n headers: { \"content-type\": \"application/json\" },\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}\n","label",[141],"264863a8-13de-49e2-843c-17664c3176d1","ticks.ts","10fff132-64f6-11f1-b183-1607ee4eb77e",4,["D",1781114343502],"// .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\nexport function dateToTicks(d: Date): number {\n // ticks = (unixMs + offset) * 10_000\n return (d.getTime() + NET_EPOCH_OFFSET_MS) * 10000;\n}\n\nexport function ticksToDate(ticks: number): Date {\n return new Date(ticks / 10000 - 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()): number[] {\n const ticks: number[] = [];\n // Walk backwards from today, collecting Tue(2)/Fri(5) midnight-UTC dates.\n const cursor = new Date(Date.UTC(from.getUTCFullYear(), from.getUTCMonth(), from.getUTCDate()));\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}\n",[151],"19a7f899-ca31-45c2-bc10-b046cb5b3ec8","scraper.ts","13757586-64f6-11f1-b5bb-1607ee4eb77e",5,["D",1781114347627],"interval","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}\n",[158],"7e24c86d-fd73-4f1e-82d4-291b376d0cb3","parse.ts","0ac84b48-64f6-11f1-8b0f-1607ee4eb77e",3,["D",1781114333070],"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: number): 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: dr.PlayDateTicks ?? playDateTicks,\n playDate: dr.PlayDate ?? \"\",\n n1: dr.N1, n2: dr.N2, n3: dr.N3, n4: dr.N4, 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}\n",[166],"640291c0-ffc2-4a4f-b7ad-1f87cfe31dd4",["D",1781114372121],[34],"pulls","branches",1,"forks","envVars",{"_183":69,"_185":69},"connections",{"_183":69,"_184":69},"count","unfilledCount","emptyCount",{"_49":172,"_38":34,"_36":37,"_142":-5,"_47":48,"_46":14,"_144":65,"_44":204,"_13":168,"_39":40,"_41":43,"_30":31,"_148":-5,"_192":205,"_33":206},{"_49":165,"_38":166,"_36":167,"_142":-5,"_47":48,"_46":168,"_144":31,"_44":201,"_13":69,"_39":40,"_41":170,"_30":31,"_148":-5,"_192":202,"_33":203},{"_49":157,"_38":158,"_36":159,"_142":-5,"_47":48,"_46":160,"_144":65,"_44":198,"_13":69,"_39":162,"_41":163,"_30":31,"_148":-5,"_192":199,"_33":200},{"_49":150,"_38":151,"_36":152,"_142":-5,"_47":48,"_46":153,"_144":31,"_44":195,"_13":69,"_39":40,"_41":155,"_30":31,"_148":-5,"_192":196,"_33":197},{"_49":140,"_38":141,"_36":63,"_142":-5,"_47":48,"_46":143,"_144":31,"_44":191,"_13":69,"_39":146,"_41":147,"_30":31,"_148":-5,"_192":193,"_33":194},["D",1781114361335],"children",[],[141],["D",1781114343502],[],[151],["D",1781114347627],[],[158],["D",1781114333070],[],[166],["D",1781114372121],[],[34],["D",1781114312383],["D",1789499469860],{"_106":105,"_113":108},{"_106":105,"_107":108,"_109":108,"_19":61,"_110":111,"_112":31},{"_13":95,"_38":96,"_49":48,"_97":50,"_98":-5,"_99":-5,"_100":-5,"_101":-5,"_102":-5,"_103":51,"_104":105},"ctx",{"_88":-5,"_132":245,"_246":247,"_248":249,"_250":31,"_251":31,"_252":31,"_253":65,"_254":-5,"_255":-7,"_256":-7,"_257":69,"_258":31,"_259":31,"_260":-5,"_261":31,"_262":31,"_263":31,"_264":-5},"ENV",{"_216":217,"_218":219,"_220":96,"_221":222,"_223":224,"_225":226,"_227":228,"_229":230,"_231":232,"_233":234,"_235":236,"_237":238,"_239":240,"_241":242,"_243":244},"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 · v8