[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_172":173,"_174":175},"routes/_app.x.$handle.$name",{"_96":95,"_32":44,"_104":86,"_27":105,"_13":14,"_106":-5,"_11":107,"_108":109,"_110":111,"_112":113,"_114":115,"_20":-5,"_116":-5,"_117":-5,"_118":48,"_119":120,"_121":48,"_122":-5,"_123":-5,"_124":125},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_42":43,"_32":44,"_37":45,"_46":-5,"_47":48,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":57,"_58":25,"_59":25,"_60":-5,"_61":62,"_63":64,"_65":-5,"_66":-5,"_67":-5,"_68":-5,"_69":70,"_71":70,"_72":73,"_74":73,"_75":73,"_76":70,"_77":70,"_78":79,"_80":81,"_82":83,"_84":48},"version",38,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":34,"_35":36,"_37":38,"_39":14,"_40":41,"_24":25},"previous",{"_30":31,"_32":28,"_33":34,"_35":36},"deleted",true,"deletedHere","path","webhook.tsx","latestPath","fileId","f65c80ac-583a-11f0-a23a-f69ea79377d9","name","fileType","script","content","import { sqlite } from \"https://esm.town/v/std/sqlite\";\nimport { discordWebhook } from \"https://esm.town/v/stevekrouse/discordWebhook\";\n\nconst webhookSecret = Deno.env.get(\"GITHUB_WEBHOOK_SECRET\");\n\n// Create tables if they don't exist\nawait sqlite.execute(`\nCREATE TABLE IF NOT EXISTS stargazers (\n user_id INTEGER PRIMARY KEY,\n login TEXT NOT NULL,\n avatar_url TEXT\n);\n`);\n\nawait sqlite.execute(`\nCREATE TABLE IF NOT EXISTS repo_gazers (\n user_id INTEGER,\n repo STRING,\n starred_at DATETIME,\n created_at DATETIME,\n FOREIGN KEY (user_id) REFERENCES stargazers(user_id),\n PRIMARY KEY (repo, user_id)\n);\n`);\n\nasync function verifyWebhookSignature(payload: string, signature: string): Promise {\n if (!webhookSecret) {\n console.warn(\"No webhook secret configured - skipping verification\");\n return true;\n }\n\n const encoder = new TextEncoder();\n const key = await crypto.subtle.importKey(\n \"raw\",\n encoder.encode(webhookSecret),\n { name: \"HMAC\", hash: \"SHA-256\" },\n false,\n [\"sign\"]\n );\n\n const expectedSignature = await crypto.subtle.sign(\"HMAC\", key, encoder.encode(payload));\n const expectedHex = \"sha256=\" + Array.from(new Uint8Array(expectedSignature))\n .map(b => b.toString(16).padStart(2, '0'))\n .join('');\n\n return expectedHex === signature;\n}\n\nasync function handleStarEvent(payload: any) {\n const { action, starred_at, repository, sender } = payload;\n\n if (action !== \"created\") {\n console.log(`Ignoring ${action} star event`);\n return;\n }\n\n const repo = repository.full_name;\n const user = sender;\n const now = new Date().toISOString();\n\n console.log(`New star: ${user.login} starred ${repo} at ${starred_at}`);\n\n // Store stargazer info\n await sqlite.execute({\n sql: `INSERT OR IGNORE INTO stargazers(user_id, login, avatar_url) VALUES(:user_id, :login, :avatar_url)`,\n args: {\n user_id: user.id,\n login: user.login,\n avatar_url: user.avatar_url,\n },\n });\n\n // Store starring event\n await sqlite.execute({\n sql: `INSERT OR IGNORE INTO repo_gazers(user_id, repo, starred_at, created_at) VALUES(:user_id, :repo, :starred_at, :created_at)`,\n args: {\n user_id: user.id,\n repo,\n starred_at,\n created_at: now,\n },\n });\n\n // Send Discord notification\n try {\n await discordWebhook({\n url: Deno.env.get(\"DISCORD_WEBHOOK\"),\n content: `**⭐ New stargazer! ⭐**\n\n[${user.login}](https://github.com/${user.login}) starred **${repo}**\nStarred at: ${new Date(starred_at).toLocaleString()}`,\n });\n console.log(\"Discord notification sent!\");\n } catch (error) {\n console.error(\"Error sending Discord notification:\", error);\n }\n}\n\nexport default async function(request: Request): Promise {\n if (request.method !== \"POST\") {\n return new Response(\"Method not allowed\", { status: 405 });\n }\n\n const signature = request.headers.get(\"x-hub-signature-256\");\n if (!signature) {\n return new Response(\"Missing signature\", { status: 401 });\n }\n\n const payload = await request.text();\n \n if (!await verifyWebhookSignature(payload, signature)) {\n return new Response(\"Invalid signature\", { status: 401 });\n }\n\n try {\n const data = JSON.parse(payload);\n const event = request.headers.get(\"x-github-event\");\n\n if (event === \"star\") {\n await handleStarEvent(data);\n return new Response(\"Star event processed\", { status: 200 });\n }\n\n console.log(`Ignoring ${event} event`);\n return new Response(\"Event ignored\", { status: 200 });\n } catch (error) {\n console.error(\"Error processing webhook:\", error);\n return new Response(\"Internal server error\", { status: 500 });\n }\n}","createdAt",["D",1751567100275],"branchVersion","branchId","67a1f35e-55df-11f0-8879-f69ea79377d9","id","67a18ff4-55df-11f0-8879-f69ea79377d9","github-stargazers",["D",1751307845317],"deletedAt","legacyEnvVars",false,"privacy","public","httpPrivacy","description","Track GitHub repo stargazers","imageUrl","c156eb0e-8b9d-4104-a055-502e9a0eb441","pinnedFileId","67a463b4-55df-11f0-8879-f69ea79377d9","pinPreview","pinMigrated","screenshotVersion","likeCount",3,"orgId","2019e55b-c541-4c51-bef0-008eef10ef88","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_96":95,"_103":99},"org",{"_96":95,"_97":-5,"_98":99,"_18":55,"_100":101,"_102":48},"branch",{"_13":85,"_32":86,"_42":41,"_87":43,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":44,"_94":95},"isOwned",85,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","charmaine","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvdXBsb2FkZWQvaW1nXzJ4cFpFME5pSXNZamJNd296dlZSYVJ0OVF1RSJ9","tier","pro","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_42":43,"_32":44,"_37":168,"_46":-5,"_47":48,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":57,"_58":25,"_59":25,"_60":-5,"_61":62,"_63":64,"_65":-5,"_66":-5,"_67":-5,"_68":-5,"_69":70,"_71":70,"_72":73,"_74":73,"_75":73,"_76":70,"_77":70,"_78":169,"_80":170,"_82":171,"_84":48},"tree",[159,160],"files",[159,160],"counts",{"_147":148,"_149":150,"_151":148,"_152":153,"_154":155},"contents",[126,127],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_42":139,"_32":140,"_30":141,"_130":-5,"_40":41,"_39":142,"_132":48,"_37":143,"_13":144,"_33":20,"_35":145,"_24":48,"_137":-5,"_27":146},{"_42":128,"_32":129,"_30":57,"_130":-5,"_40":41,"_39":131,"_132":48,"_37":133,"_13":134,"_33":135,"_35":136,"_24":48,"_137":-5,"_27":138},"f6571d7e-583a-11f0-8438-f69ea79377d9","main.tsx","parentId",36,"latest",["D",1751567071264],25,"interval","import { sqlite } from \"https://esm.town/v/std/sqlite\";\nimport { discordWebhook } from \"https://esm.town/v/stevekrouse/discordWebhook\";\n\nconst githubToken = Deno.env.get(\"GH_TOKEN\");\n\ntype Stargazer = {\n login: string;\n id: number;\n avatar_url: string;\n};\n\n// TODO: Change this depending on what repos you want to watch :)\nconst repos = [\n \"val-town/codemirror-ts\",\n \"val-town/vt\",\n];\nconsole.log(\"Repos to process:\", repos);\n\nawait sqlite.execute(`\n-- Stargazers Table\nCREATE TABLE IF NOT EXISTS stargazers (\n user_id INTEGER PRIMARY KEY,\n login TEXT NOT NULL,\n avatar_url TEXT\n);\n`);\nconsole.log(\"Created stargazers table\");\n\nawait sqlite.execute(`\n-- Stargazing Events Table\nCREATE TABLE IF NOT EXISTS repo_gazers (\n user_id INTEGER,\n repo STRING,\n created_at DATETIME,\n FOREIGN KEY (user_id) REFERENCES stargazers(user_id),\n PRIMARY KEY (repo, user_id)\n);\n`);\nconsole.log(\"Created repo_gazers table\");\n\nfunction rowObjects(data) {\n console.log(\"Processing row objects, row count:\", data.rows.length);\n return data.rows.map((row) => {\n return data.columns.reduce((obj, column, index) => {\n let value;\n if (data.columnTypes[index] === \"json\") {\n value = JSON.parse(row[index]);\n } else {\n value = row[index];\n }\n obj[column] = value;\n return obj;\n }, {});\n });\n}\n\nasync function fetchAllStargazers(repo: string, shouldExit: () => boolean): Promise {\n console.log(`Starting to fetch stargazers for ${repo}`);\n \n const lastCheck = await getLastCheckTimestamp(repo);\n console.log(`Last check timestamp for ${repo}: ${lastCheck}`);\n \n let stargazers: Stargazer[] = [];\n let page = 1;\n const perPage = 100;\n const maxPages = 10; // Limit pages per execution to prevent timeout\n\n while (page <= maxPages) {\n if (shouldExit()) {\n console.log(`Exiting pagination early due to time limit for ${repo} at page ${page}`);\n break;\n }\n\n console.log(`Fetching page ${page} for ${repo}`);\n\n try {\n let url = `https://api.github.com/repos/${repo}/stargazers?page=${page}&per_page=${perPage}`;\n if (lastCheck) {\n url += `&since=${lastCheck}`;\n }\n\n const response = await fetch(url, {\n headers: {\n \"Authorization\": `Bearer ${githubToken}`,\n \"Accept\": \"application/vnd.github.star+json\",\n },\n });\n\n if (!response.ok) {\n console.error(\n `API error for ${repo}:`,\n response.status,\n await response.text(),\n );\n throw new Error(\n `GitHub API responded with status code: ${response.status}`,\n );\n }\n\n const data: Array<{user: Stargazer, starred_at: string}> = await response.json();\n console.log(\n `Received ${data.length} stargazers for ${repo} on page ${page}`,\n );\n\n if (data.length === 0) {\n console.log(`No more stargazers for ${repo}, ending pagination`);\n break;\n }\n\n const mappedStargazers = data.map(item => ({\n ...item.user,\n starred_at: item.starred_at,\n }));\n\n stargazers = stargazers.concat(mappedStargazers);\n page++;\n\n // Add rate limiting to avoid hitting GitHub API limits\n if (page > 1) {\n await new Promise((resolve) => setTimeout(resolve, 100));\n }\n } catch (error) {\n console.error(`Error fetching page ${page} for ${repo}:`, error);\n throw error;\n }\n }\n\n if (page > maxPages) {\n console.log(`Reached max pages limit (${maxPages}) for ${repo}, will continue next run`);\n }\n\n return stargazers;\n}\n\nasync function getExistingStargazers(repo: string): Promise> {\n const existing = await sqlite.execute({\n sql: `SELECT user_id FROM repo_gazers WHERE repo = :repo`,\n args: { repo },\n });\n\n return new Set(existing.rows.map((row) => row[0] as number));\n}\n\nasync function addNewStargazers(\n repo: string,\n allGazers: Stargazer[],\n existingIds: Set,\n now: string,\n) {\n const newGazers = allGazers.filter((gazer) => !existingIds.has(gazer.id));\n\n if (newGazers.length === 0) {\n console.log(`No new stargazers for ${repo}`);\n return [];\n }\n\n console.log(`Adding ${newGazers.length} new stargazers for ${repo}`);\n\n const statements = newGazers.map((gazer) => {\n console.log(`Processing new gazer: ${gazer.login}`);\n return [{\n sql:\n `INSERT OR IGNORE INTO stargazers(user_id, login, avatar_url) values(:user_id, :login, :avatar_url)`,\n args: {\n user_id: gazer.id,\n login: gazer.login,\n avatar_url: gazer.avatar_url,\n },\n }, {\n sql:\n `INSERT OR IGNORE INTO repo_gazers(user_id, repo, created_at) values(:user_id, :repo, :created_at)`,\n args: { user_id: gazer.id, repo, created_at: now },\n }];\n });\n\n try {\n await sqlite.batch(statements.flat());\n console.log(\n `Successfully added ${newGazers.length} stargazers for ${repo}`,\n );\n return newGazers;\n } catch (error) {\n console.error(`Error adding stargazers for ${repo}:`, error);\n throw error;\n }\n}\n\nexport default async function (interval: Interval) {\n console.log(\"Starting interval execution\");\n const startTime = Date.now();\n const maxExecutionTime = 50000; // 50 seconds - leave buffer for Val Town timeout\n const now = (new Date()).toISOString();\n console.log(\"Current timestamp:\", now);\n\n let allNewGazers: Array<{ login: string; repo: string }> = [];\n\n function shouldExit(): boolean {\n const elapsed = Date.now() - startTime;\n const remaining = maxExecutionTime - elapsed;\n console.log(`Execution time: ${elapsed}ms, remaining: ${remaining}ms`);\n return remaining < 5000; // Exit if less than 5 seconds remaining\n }\n\n for (const repo of repos) {\n if (shouldExit()) {\n console.log(`Exiting early due to time limit before processing ${repo}`);\n break;\n }\n\n try {\n console.log(`Starting processing for repo: ${repo}`);\n\n // Get existing stargazers for this repo\n const existingIds = await getExistingStargazers(repo);\n console.log(`Found ${existingIds.size} existing stargazers for ${repo}`);\n\n if (shouldExit()) {\n console.log(`Exiting early due to time limit after loading existing data for ${repo}`);\n break;\n }\n\n // Fetch all current stargazers\n const allGazers = await fetchAllStargazers(repo, shouldExit);\n console.log(`Fetched ${allGazers.length} total stargazers for ${repo}`);\n\n if (shouldExit()) {\n console.log(`Exiting early due to time limit after fetching stargazers for ${repo}`);\n break;\n }\n\n // Add only new stargazers\n const newGazers = await addNewStargazers(\n repo,\n allGazers,\n existingIds,\n now,\n );\n\n // Track new gazers for Discord notification\n allNewGazers.push(...newGazers.map((g) => ({ login: g.login, repo })));\n\n // Update last check timestamp for this repo\n await updateLastCheckTimestamp(repo, now);\n\n console.log(\n `Completed processing for ${repo}. Added ${newGazers.length} new stargazers.`,\n );\n } catch (error) {\n console.error(`Error processing repo ${repo}:`, error);\n // Continue with other repos even if one fails\n }\n }\n\n console.log(`Total new gazers found: ${allNewGazers.length}`);\n\n if (allNewGazers.length === 0) {\n console.log(\"No new gazers found this time. Better luck next time.\");\n return;\n }\n\n console.log(\"Preparing Discord message\");\n\n try {\n await discordWebhook({\n url: Deno.env.get(\"DISCORD_WEBHOOK\"),\n content: `**⭐⭐ New stargazers! ⭐⭐** \n\n${\n allNewGazers.map((g) =>\n `[${g.login}](https://github.com/${g.login}) starred ${g.repo}`\n ).join(\"\\n\")\n }\n `,\n });\n console.log(\"Discord message sent!\");\n } catch (error) {\n console.error(\"Error sending Discord message:\", error);\n }\n}","label",[129],"27fc4a60-55ee-11f0-93a3-f69ea79377d9","README.md","645847d8-55e0-11f0-958a-f69ea79377d9",30,["D",1751314180977],6,"# GitHub Repo Stargazers Notification\n\nTracks new stargazers for your GitHub repositories and sends notifications to\nDiscord when someone stars your repos.\n\n## Features\n\n- Tracks stargazers across multiple GitHub repositories\n- Stores stargazer data in SQLite database with full history\n- Sends Discord notifications for new stars\n\n## Setup Instructions\n\n### 1. Create GitHub Personal Access Token\n\n1. Go to GitHub Settings > Developer settings > Personal access tokens\n2. Click \"Generate new token (classic)\"\n3. Give it a name like \"Val Town Stargazer Tracker\"\n4. Select the following scopes:\n - `public_repo` (to read public repository information)\n5. Copy the generated token\n\n### 2. Set Up Discord Webhook\n\n1. Go to your Discord server settings\n2. Navigate to \"Integrations\" > \"Webhooks\"\n3. Click \"Create Webhook\"\n4. Choose the channel where you want notifications\n5. Copy the webhook URL\n\n## Environment Variables\n\nSet the following on the left sidebar of your val:\n\n1. `GITHUB_TOKEN`: Your GitHub personal access token\n2. `DISCORD_WEBHOOK`: Your Discord webhook URL",[140],"pulls",0,"branches",1,"forks","envVars",{"_156":150,"_158":148},"connections",{"_156":148,"_157":148},"count","unfilledCount","emptyCount",{"_42":139,"_32":140,"_30":141,"_130":-5,"_40":41,"_39":142,"_132":48,"_37":165,"_13":144,"_33":20,"_35":145,"_24":48,"_137":-5,"_162":166,"_27":167},{"_42":128,"_32":129,"_30":57,"_130":-5,"_40":41,"_39":131,"_132":48,"_37":161,"_13":134,"_33":135,"_35":136,"_24":48,"_137":-5,"_162":163,"_27":164},["D",1751567071264],"children",[],[129],["D",1751314180977],[],[140],["D",1751307845317],{"_96":95,"_103":99},{"_96":95,"_97":-5,"_98":99,"_18":55,"_100":101,"_102":48},{"_13":85,"_32":86,"_42":41,"_87":43,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":44,"_94":95},"ctx",{"_78":-5,"_123":205,"_206":207,"_208":209,"_210":48,"_211":48,"_212":48,"_213":25,"_214":-5,"_215":-7,"_216":-7,"_217":148,"_218":48,"_219":48,"_220":-5,"_221":48,"_222":48,"_223":48,"_224":-5},"ENV",{"_176":177,"_178":179,"_180":86,"_181":182,"_183":184,"_185":186,"_187":188,"_189":190,"_191":192,"_193":194,"_195":196,"_197":198,"_199":200,"_201":202,"_203":204},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","811aa22498c9b0b5a47e8d778de579cdb990f332","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 · v38