Trophy Manager - Canadian Players Scan

\n \n

\n ✓ Scan completed successfully!\n

\n\n

Canadian Players Found

${playerCount}

CSV File Size

${(csvSize / 1024 / 1024).toFixed(2)} MB

\n\n

Scan Log

\n ${\n scanLog.map((entry) => `

${entry}

`).join(\"\")\n }\n

\n\n Download CSV\n

\n\n\n `;\n}\n\n// HTTP Handlers\nexport default async function (req) {\n const url = new URL(req.url);\n\n if (url.pathname === \"/canadian-players\") {\n return await handleCanadianPlayers();\n } else if (url.pathname === \"/us-players\") {\n return await handleUSPlayers();\n } else if (url.pathname.startsWith(\"/download/\")) {\n return await handleDownload(url.pathname.split(\"/download/\")[1]);\n }\n\n return new Response(\"Endpoints: /canadian-players, /us-players\", {\n status: 200,\n headers: { \"Content-Type\": \"text/plain\" },\n });\n}\n\nasync function handleCanadianPlayers() {\n try {\n scanLog = [];\n log(\"Starting Canadian players scan\");\n\n const players = await scanCountries([\"ca\"]);\n const csv = generateCSV(players);\n\n const timestamp = new Date().toISOString().split(\"T\")[0];\n const time = new Date().toTimeString().split(\" \")[0].replace(/:/g, \"-\");\n const blobKey = `canadian_players_${timestamp}_${time}.csv`;\n\n await blob.set(blobKey, csv);\n await cleanupOldBlobs(\"canadian_players_\", 5);\n\n const html = generateHtmlPage(blobKey, csv.length, players.length);\n return new Response(html, {\n status: 200,\n headers: { \"Content-Type\": \"text/html;charset=utf-8\" },\n });\n } catch (error) {\n log(`ERROR: ${error.message}`);\n return new Response(\n `

Scan Error

${\n        scanLog.join(\"\\n\")\n      }\\n\\nError: ${error.message}

`,\n {\n status: 500,\n headers: { \"Content-Type\": \"text/html\" },\n },\n );\n }\n}\n\nasync function handleUSPlayers() {\n try {\n scanLog = [];\n log(\"Starting US players scan\");\n\n const players = await scanCountries([\"us\"]);\n const csv = generateCSV(players);\n\n const timestamp = new Date().toISOString().split(\"T\")[0];\n const time = new Date().toTimeString().split(\" \")[0].replace(/:/g, \"-\");\n const blobKey = `us_players_${timestamp}_${time}.csv`;\n\n await blob.set(blobKey, csv);\n await cleanupOldBlobs(\"us_players_\", 5);\n\n const html = generateHtmlPage(blobKey, csv.length, players.length);\n return new Response(html, {\n status: 200,\n headers: { \"Content-Type\": \"text/html;charset=utf-8\" },\n });\n } catch (error) {\n log(`ERROR: ${error.message}`);\n return new Response(\n `

Scan Error

${\n        scanLog.join(\"\\n\")\n      }\\n\\nError: ${error.message}

`,\n {\n status: 500,\n headers: { \"Content-Type\": \"text/html\" },\n },\n );\n }\n}\n\nasync function handleDownload(filename) {\n try {\n const blobResponse = await blob.get(filename);\n if (!blobResponse) {\n return new Response(\"File not found\", { status: 404 });\n }\n\n const csv = await blobResponse.text();\n\n return new Response(csv, {\n status: 200,\n headers: {\n \"Content-Type\": \"text/csv;charset=utf-8\",\n \"Content-Disposition\": `attachment; filename=\"${filename}\"`,\n },\n });\n } catch (error) {\n return new Response(`Error downloading file: ${error.message}`, {\n status: 500,\n });\n }\n}","deleted","label",[99],"permalink","https://www.val.town/x/prevosb/CanadianPlayersScrapper/code/CanadiansDB.ts","extension","actionData","errors"]