[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_337":338,"_339":340},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":16,"_242":78,"_47":-7,"_243":-5,"_17":244,"_245":246,"_247":248,"_249":250,"_251":252,"_61":-5,"_253":-5,"_254":-5,"_255":24,"_256":257,"_258":203,"_259":-5,"_260":-5,"_261":262},"routes/_app.x.$handle.$name.branch.$branch.history",{"_11":12,"_13":14,"_15":16,"_17":18,"_19":20,"_21":22,"_23":24,"_25":-5},"handle","danikaazure","name","megamillions-scraper","branchName","main","project",{"_41":191,"_13":14,"_45":192,"_193":-5,"_194":24,"_195":196,"_197":196,"_198":199,"_200":-5,"_25":76,"_201":122,"_202":203,"_204":-5,"_205":-5,"_206":20,"_49":50,"_207":208,"_209":210,"_211":212,"_213":-5,"_214":215,"_216":215,"_217":218,"_219":218,"_220":218,"_221":215,"_222":215,"_59":223,"_224":225,"_226":227,"_228":24},"page",0,"history",[26,27,28,29,30,31,32,33,34,35,36,37,38,39,40],"hasNext",false,"userId",{"_41":183,"_43":44,"_45":184,"_47":185,"_49":50,"_51":174,"_52":-5,"_53":186,"_54":-5,"_55":-5,"_56":-5,"_57":-5,"_58":-5,"_59":187,"_61":188,"_63":-5,"_64":-5,"_65":-5,"_66":-5,"_67":189},{"_41":174,"_43":44,"_45":175,"_47":176,"_49":50,"_51":167,"_52":-5,"_53":82,"_54":-5,"_55":-5,"_56":-5,"_57":-5,"_58":-5,"_59":177,"_61":178,"_63":-5,"_64":-5,"_65":-5,"_66":-5,"_67":179},{"_41":167,"_43":44,"_45":168,"_47":169,"_49":50,"_51":160,"_52":-5,"_53":82,"_54":-5,"_55":-5,"_56":-5,"_57":-5,"_58":-5,"_59":170,"_61":171,"_63":-5,"_64":-5,"_65":-5,"_66":-5,"_67":172},{"_41":160,"_43":44,"_45":161,"_47":162,"_49":50,"_51":153,"_52":-5,"_53":82,"_54":-5,"_55":-5,"_56":-5,"_57":-5,"_58":-5,"_59":163,"_61":164,"_63":-5,"_64":-5,"_65":-5,"_66":-5,"_67":165},{"_41":153,"_43":44,"_45":154,"_47":155,"_49":50,"_51":146,"_52":-5,"_53":82,"_54":-5,"_55":-5,"_56":-5,"_57":-5,"_58":-5,"_59":156,"_61":157,"_63":-5,"_64":-5,"_65":-5,"_66":-5,"_67":158},{"_41":146,"_43":44,"_45":147,"_47":148,"_49":50,"_51":139,"_52":-5,"_53":82,"_54":-5,"_55":-5,"_56":-5,"_57":-5,"_58":-5,"_59":149,"_61":150,"_63":-5,"_64":-5,"_65":-5,"_66":-5,"_67":151},{"_41":139,"_43":44,"_45":140,"_47":141,"_49":50,"_51":132,"_52":-5,"_53":82,"_54":-5,"_55":-5,"_56":-5,"_57":-5,"_58":-5,"_59":142,"_61":143,"_63":-5,"_64":-5,"_65":-5,"_66":-5,"_67":144},{"_41":132,"_43":44,"_45":133,"_47":134,"_49":50,"_51":125,"_52":-5,"_53":82,"_54":-5,"_55":-5,"_56":-5,"_57":-5,"_58":-5,"_59":135,"_61":136,"_63":-5,"_64":-5,"_65":-5,"_66":-5,"_67":137},{"_41":125,"_43":44,"_45":126,"_47":127,"_49":50,"_51":115,"_52":-5,"_53":82,"_54":-5,"_55":-5,"_56":-5,"_57":-5,"_58":-5,"_59":128,"_61":129,"_63":-5,"_64":-5,"_65":-5,"_66":-5,"_67":130},{"_41":115,"_43":44,"_45":116,"_47":117,"_49":50,"_51":105,"_52":-5,"_53":82,"_54":-5,"_55":-5,"_56":-5,"_57":-5,"_58":-5,"_59":118,"_61":119,"_63":-5,"_64":-5,"_65":-5,"_66":-5,"_67":120},{"_41":105,"_43":44,"_45":106,"_47":107,"_49":50,"_51":96,"_52":-5,"_53":82,"_54":-5,"_55":-5,"_56":-5,"_57":-5,"_58":-5,"_59":108,"_61":109,"_63":-5,"_64":-5,"_65":-5,"_66":-5,"_67":110},{"_41":96,"_43":44,"_45":97,"_47":98,"_49":50,"_51":87,"_52":-5,"_53":82,"_54":-5,"_55":-5,"_56":-5,"_57":-5,"_58":-5,"_59":99,"_61":100,"_63":-5,"_64":-5,"_65":-5,"_66":-5,"_67":101},{"_41":87,"_43":44,"_45":88,"_47":89,"_49":50,"_51":79,"_52":-5,"_53":82,"_54":-5,"_55":-5,"_56":-5,"_57":-5,"_58":-5,"_59":90,"_61":91,"_63":-5,"_64":-5,"_65":-5,"_66":-5,"_67":92},{"_41":79,"_43":44,"_45":80,"_47":81,"_49":50,"_51":42,"_52":-5,"_53":82,"_54":-5,"_55":-5,"_56":-5,"_57":-5,"_58":-5,"_59":83,"_61":84,"_63":-5,"_64":-5,"_65":-5,"_66":-5,"_67":85},{"_41":42,"_43":44,"_45":46,"_47":48,"_49":50,"_51":-5,"_52":-5,"_53":-5,"_54":-5,"_55":-5,"_56":-5,"_57":-5,"_58":-5,"_59":60,"_61":62,"_63":-5,"_64":-5,"_65":-5,"_66":-5,"_67":68},"id","2d571548-3ff3-4af1-b27b-11d1ac19f716","branchId","63ea10ab-9496-4570-9acf-1b4c8d4438a6","createdAt",["D",1781114312416],"version",1,"orgId","019eb2a9-32c8-758f-b0d5-319026801566","parentId","incomingCommitId","aiChatMessageId","aiChatThreadId","aiChatThreadUserId","aiChatThreadTitle","source","clientLabel","user",{"_41":76,"_49":50,"_11":12,"_77":78},"file",{"_70":71,"_13":72,"_73":74,"_75":24},"pull","merge","revert","multiple","commits",[69],{"_41":42,"_43":44,"_45":46,"_47":48,"_49":50,"_51":-5,"_52":-5,"_53":-5,"_54":-5,"_55":-5,"_56":-5,"_57":-5,"_58":-5,"_59":60,"_61":62,"_63":-5,"_64":-5,"_65":-5},"fileId","fe78e06e-64f5-11f1-8f13-1607ee4eb77e","db.ts","fileType","script","deleted","afc6b6b6-50b0-4981-bdfc-3bc06aa3c798","avatar","","7224e5c6-dc56-4386-baee-54d1673ffcac",["D",1781114324803],2,"103fc5f9-6fd3-41bd-a839-506846744099",{"_41":76,"_49":50,"_11":12,"_77":78},{"_70":71,"_13":72,"_73":74,"_75":24},[86],{"_41":79,"_43":44,"_45":80,"_47":81,"_49":50,"_51":42,"_52":-5,"_53":82,"_54":-5,"_55":-5,"_56":-5,"_57":-5,"_58":-5,"_59":83,"_61":84,"_63":-5,"_64":-5,"_65":-5},"798654c6-ddc2-4920-8b29-55b162390e21",["D",1781114333070],3,{"_41":76,"_49":50,"_11":12,"_77":78},{"_70":94,"_13":95,"_73":74,"_75":24},[93],{"_41":87,"_43":44,"_45":88,"_47":89,"_49":50,"_51":79,"_52":-5,"_53":82,"_54":-5,"_55":-5,"_56":-5,"_57":-5,"_58":-5,"_59":90,"_61":91,"_63":-5,"_64":-5,"_65":-5},"0ac84b48-64f6-11f1-8b0f-1607ee4eb77e","parse.ts","f30840cf-f5e4-4749-975b-b1fa578e1a58",["D",1781114343502],4,{"_41":76,"_49":50,"_11":12,"_77":78},{"_70":103,"_13":104,"_73":74,"_75":24},[102],{"_41":96,"_43":44,"_45":97,"_47":98,"_49":50,"_51":87,"_52":-5,"_53":82,"_54":-5,"_55":-5,"_56":-5,"_57":-5,"_58":-5,"_59":99,"_61":100,"_63":-5,"_64":-5,"_65":-5},"10fff132-64f6-11f1-b183-1607ee4eb77e","ticks.ts","f3024c0c-61de-4878-9959-6632904c81b2",["D",1781114347627],5,{"_41":76,"_49":50,"_11":12,"_77":78},{"_70":112,"_13":113,"_73":114,"_75":24},[111],{"_41":105,"_43":44,"_45":106,"_47":107,"_49":50,"_51":96,"_52":-5,"_53":82,"_54":-5,"_55":-5,"_56":-5,"_57":-5,"_58":-5,"_59":108,"_61":109,"_63":-5,"_64":-5,"_65":-5},"13757586-64f6-11f1-b5bb-1607ee4eb77e","scraper.ts","interval","8f292482-fe9e-45a8-8765-78f6a2c40179",["D",1781114361335],6,{"_41":76,"_49":50,"_11":12,"_77":78},{"_70":122,"_13":123,"_73":124,"_75":24},[121],{"_41":115,"_43":44,"_45":116,"_47":117,"_49":50,"_51":105,"_52":-5,"_53":82,"_54":-5,"_55":-5,"_56":-5,"_57":-5,"_58":-5,"_59":118,"_61":119,"_63":-5,"_64":-5,"_65":-5},"1ba1c7f0-64f6-11f1-bc85-1607ee4eb77e","viewer.ts","http","93a733e4-22fc-44bf-b7e2-4d856069ac45",["D",1781114370805],7,{"_41":76,"_49":50,"_11":12,"_77":78},{"_70":71,"_13":72,"_73":74,"_75":24},[131],{"_41":125,"_43":44,"_45":126,"_47":127,"_49":50,"_51":115,"_52":-5,"_53":82,"_54":-5,"_55":-5,"_56":-5,"_57":-5,"_58":-5,"_59":128,"_61":129,"_63":-5,"_64":-5,"_65":-5},"29bc023f-73bc-401d-8e13-3701ddb7259c",["D",1781114372121],8,{"_41":76,"_49":50,"_11":12,"_77":78},{"_70":71,"_13":72,"_73":74,"_75":24},[138],{"_41":132,"_43":44,"_45":133,"_47":134,"_49":50,"_51":125,"_52":-5,"_53":82,"_54":-5,"_55":-5,"_56":-5,"_57":-5,"_58":-5,"_59":135,"_61":136,"_63":-5,"_64":-5,"_65":-5},"a576c5f2-c0f2-44f3-bc65-77b3bad17d3d",["D",1781114379367],9,{"_41":76,"_49":50,"_11":12,"_77":78},{"_70":103,"_13":104,"_73":74,"_75":24},[145],{"_41":139,"_43":44,"_45":140,"_47":141,"_49":50,"_51":132,"_52":-5,"_53":82,"_54":-5,"_55":-5,"_56":-5,"_57":-5,"_58":-5,"_59":142,"_61":143,"_63":-5,"_64":-5,"_65":-5},"4aa0fe4a-2df3-4789-ac3e-5b791071e0f6",["D",1781114381293],10,{"_41":76,"_49":50,"_11":12,"_77":78},{"_70":103,"_13":104,"_73":74,"_75":24},[152],{"_41":146,"_43":44,"_45":147,"_47":148,"_49":50,"_51":139,"_52":-5,"_53":82,"_54":-5,"_55":-5,"_56":-5,"_57":-5,"_58":-5,"_59":149,"_61":150,"_63":-5,"_64":-5,"_65":-5},"3cb35b9e-6d43-4745-ad57-d5df5e603727",["D",1781114382667],11,{"_41":76,"_49":50,"_11":12,"_77":78},{"_70":94,"_13":95,"_73":74,"_75":24},[159],{"_41":153,"_43":44,"_45":154,"_47":155,"_49":50,"_51":146,"_52":-5,"_53":82,"_54":-5,"_55":-5,"_56":-5,"_57":-5,"_58":-5,"_59":156,"_61":157,"_63":-5,"_64":-5,"_65":-5},"5b39c299-f568-42ac-8ba7-8be995b818ea",["D",1781114384554],12,{"_41":76,"_49":50,"_11":12,"_77":78},{"_70":94,"_13":95,"_73":74,"_75":24},[166],{"_41":160,"_43":44,"_45":161,"_47":162,"_49":50,"_51":153,"_52":-5,"_53":82,"_54":-5,"_55":-5,"_56":-5,"_57":-5,"_58":-5,"_59":163,"_61":164,"_63":-5,"_64":-5,"_65":-5},"6428a473-841b-41ba-a4ae-29b6bc7084f7",["D",1781114385338],13,{"_41":76,"_49":50,"_11":12,"_77":78},{"_70":122,"_13":123,"_73":124,"_75":24},[173],{"_41":167,"_43":44,"_45":168,"_47":169,"_49":50,"_51":160,"_52":-5,"_53":82,"_54":-5,"_55":-5,"_56":-5,"_57":-5,"_58":-5,"_59":170,"_61":171,"_63":-5,"_64":-5,"_65":-5},"72f3db78-ea1f-4438-82b7-e52d05adf491",["D",1781114405362],14,{"_41":76,"_49":50,"_11":12,"_77":78},{"_70":181,"_13":182,"_73":61,"_75":24},[180],{"_41":174,"_43":44,"_45":175,"_47":176,"_49":50,"_51":167,"_52":-5,"_53":82,"_54":-5,"_55":-5,"_56":-5,"_57":-5,"_58":-5,"_59":177,"_61":178,"_63":-5,"_64":-5,"_65":-5},"35def250-64f6-11f1-b183-1607ee4eb77e","README.md","35ea6375-b003-4429-ab99-fbb3d3a33209",["D",1781114824843],15,"7b579a9a-47ad-44ff-b490-63c148608e6d",{"_41":76,"_49":50,"_11":12,"_77":78},{"_70":122,"_13":123,"_73":124,"_75":24},[190],{"_41":183,"_43":44,"_45":184,"_47":185,"_49":50,"_51":174,"_52":-5,"_53":186,"_54":-5,"_55":-5,"_56":-5,"_57":-5,"_58":-5,"_59":187,"_61":188,"_63":-5,"_64":-5,"_65":-5},"d514cca1-3098-4c43-a729-bab3e539e71d",["D",1781114312383],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Scrapes Mega Millions draw data on a schedule into SQLite","imageUrl","pinnedFileId","pinPreview",true,"pinMigrated","screenshotVersion","likeCount","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",{"_11":12,"_241":78},"org",{"_11":12,"_237":78,"_77":78,"_25":76,"_238":239,"_240":24},"branch",{"_47":185,"_13":16,"_41":44,"_229":191,"_230":-5,"_231":-5,"_232":-5,"_233":-5,"_234":-5,"_235":14,"_236":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","tier","free","canRestrictVals","profileImageUrl","path","adoptOrgId",{"_41":191,"_13":14,"_45":332,"_193":-5,"_194":24,"_195":196,"_197":196,"_198":199,"_200":-5,"_25":76,"_201":122,"_202":203,"_204":-5,"_205":-5,"_206":20,"_49":50,"_207":208,"_209":210,"_211":333,"_213":-5,"_214":215,"_216":215,"_217":218,"_219":218,"_220":218,"_221":215,"_222":215,"_59":334,"_224":335,"_226":336,"_228":24},"tree",[307,308,309,310,311,312],"files",[307,308,309,310,311,312],"counts",{"_297":20,"_298":48,"_299":20,"_300":301,"_302":303},"contents",[263,264,265,266,267,268],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_41":293,"_13":182,"_70":181,"_51":-5,"_43":44,"_270":176,"_271":203,"_45":294,"_47":20,"_73":61,"_273":295,"_75":24,"_275":-5,"_242":296},{"_41":289,"_13":72,"_70":71,"_51":-5,"_43":44,"_270":134,"_271":203,"_45":290,"_47":89,"_73":74,"_273":291,"_75":24,"_275":-5,"_242":292},{"_41":285,"_13":95,"_70":94,"_51":-5,"_43":44,"_270":162,"_271":203,"_45":286,"_47":81,"_73":74,"_273":287,"_75":24,"_275":-5,"_242":288},{"_41":281,"_13":113,"_70":112,"_51":-5,"_43":44,"_270":107,"_271":203,"_45":282,"_47":20,"_73":114,"_273":283,"_75":24,"_275":-5,"_242":284},{"_41":277,"_13":104,"_70":103,"_51":-5,"_43":44,"_270":148,"_271":203,"_45":278,"_47":81,"_73":74,"_273":279,"_75":24,"_275":-5,"_242":280},{"_41":269,"_13":123,"_70":122,"_51":-5,"_43":44,"_270":185,"_271":203,"_45":272,"_47":81,"_73":124,"_273":274,"_75":24,"_275":-5,"_242":276},"95fa0bad-b559-4544-b3b8-8f5bc52245f0","branchVersion","latest",["D",1781114824843],"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\") ?? url.searchParams.get(\"ticks\");\n\n if (ticks) {\n if (!/^\\d+$/.test(ticks)) {\n return Response.json({ error: \"PlayDateTicks must be a number\" }, { status: 400 });\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}\n","label",[123],"ee992ffd-0b46-4c48-bcd1-3a9a84a054b8",["D",1781114381293],"// .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(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",[104],"19a7f899-ca31-45c2-bc10-b046cb5b3ec8",["D",1781114347627],"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",[113],"aaef0c93-8db5-4959-8680-acee64409b7a",["D",1781114384554],"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, 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",[95],"640291c0-ffc2-4a4f-b7ad-1f87cfe31dd4",["D",1781114372121],"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",[72],"961658c9-4b62-4702-a00b-588791d7e6b1",["D",1781114405362],"# Mega Millions Scraper\n\nScrapes the Mega Millions draw-data API on a schedule and stores each draw in SQLite.\n\n## How it works\n\n```mermaid\nflowchart LR\n cron[\"scraper.ts (interval, every 15 min)\"] --> ticks[\"ticks.ts
compute recent draw dates\"]\n ticks --> parse[\"parse.ts
fetch + unwrap XML→JSON\"]\n parse --> db[\"db.ts
upsert into SQLite\"]\n db --> view[\"viewer.ts (HTTP)
read stored draws\"]\n```\n\n## Files\n\n| File | Type | Purpose |\n|--------------|----------|---------|\n| `scraper.ts` | interval | Cron entrypoint. Runs every 15 min, scrapes the most recent 4 draws. |\n| `ticks.ts` | script | Converts dates ⇄ .NET \"ticks\" and figures out recent Tue/Fri draw dates. |\n| `parse.ts` | script | Fetches the API and unwraps the XML-wrapped JSON payload. |\n| `db.ts` | script | SQLite schema + upsert (keyed on `play_date_ticks`). |\n| `viewer.ts` | http | `GET /` → latest 20 draws as JSON. `GET /?ticks=` → full raw payload. |\n\n## Notes\n\n- **The API returns XML-wrapped JSON.** `parse.ts` strips the `…`\n wrapper and decodes HTML entities before `JSON.parse`.\n- **`.NET` ticks exceed JS's safe integer range,** so they're handled with `BigInt`\n and stored/queried as TEXT. Storing them as INTEGER causes a libSQL\n \"integer too large\" error.\n- **Cron runs in UTC.** Draw dates are computed on a UTC date basis.\n- The scraper re-scrapes the latest few draws each run (upsert), so jackpot\n amounts and winner counts stay fresh as they're finalized after each draw.\n\n## Changing the schedule\n\nEdit the interval on `scraper.ts`. Current: `*/15 * * * *` (every 15 min).\nFor hourly use `0 * * * *`.\n",[182],"pulls","branches","forks","envVars",{"_304":20,"_306":20},"connections",{"_304":20,"_305":20},"count","unfilledCount","emptyCount",{"_41":293,"_13":182,"_70":181,"_51":-5,"_43":44,"_270":176,"_271":203,"_45":329,"_47":20,"_73":61,"_273":295,"_75":24,"_275":-5,"_314":330,"_242":331},{"_41":289,"_13":72,"_70":71,"_51":-5,"_43":44,"_270":134,"_271":203,"_45":326,"_47":89,"_73":74,"_273":291,"_75":24,"_275":-5,"_314":327,"_242":328},{"_41":285,"_13":95,"_70":94,"_51":-5,"_43":44,"_270":162,"_271":203,"_45":323,"_47":81,"_73":74,"_273":287,"_75":24,"_275":-5,"_314":324,"_242":325},{"_41":281,"_13":113,"_70":112,"_51":-5,"_43":44,"_270":107,"_271":203,"_45":320,"_47":20,"_73":114,"_273":283,"_75":24,"_275":-5,"_314":321,"_242":322},{"_41":277,"_13":104,"_70":103,"_51":-5,"_43":44,"_270":148,"_271":203,"_45":317,"_47":81,"_73":74,"_273":279,"_75":24,"_275":-5,"_314":318,"_242":319},{"_41":269,"_13":123,"_70":122,"_51":-5,"_43":44,"_270":185,"_271":203,"_45":313,"_47":81,"_73":124,"_273":274,"_75":24,"_275":-5,"_314":315,"_242":316},["D",1781114824843],"children",[],[123],["D",1781114381293],[],[104],["D",1781114347627],[],[113],["D",1781114384554],[],[95],["D",1781114372121],[],[72],["D",1781114405362],[],[182],["D",1781114312383],["D",1789499469860],{"_11":12,"_241":78},{"_11":12,"_237":78,"_77":78,"_25":76,"_238":239,"_240":24},{"_47":185,"_13":16,"_41":44,"_229":191,"_230":-5,"_231":-5,"_232":-5,"_233":-5,"_234":-5,"_235":14,"_236":12},"ctx",{"_59":-5,"_260":370,"_371":372,"_373":374,"_375":24,"_376":24,"_377":24,"_378":203,"_379":-5,"_380":-7,"_381":-7,"_382":20,"_383":24,"_384":24,"_385":-5,"_386":24,"_387":24,"_388":24,"_389":-5},"ENV",{"_341":342,"_343":344,"_345":16,"_346":347,"_348":349,"_350":351,"_352":353,"_354":355,"_356":357,"_358":359,"_360":361,"_362":363,"_364":365,"_366":367,"_368":369},"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"]

History