[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_164":165,"_166":167},"routes/_app.x.$handle.$name",{"_93":92,"_32":45,"_101":83,"_27":102,"_13":14,"_103":-5,"_11":104,"_105":106,"_107":108,"_109":110,"_111":112,"_20":-5,"_113":-5,"_114":-5,"_115":25,"_116":117,"_118":25,"_119":-5,"_120":-5,"_121":122},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_43":44,"_32":45,"_38":46,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":-5,"_53":-5,"_18":54,"_55":-5,"_56":25,"_57":-5,"_58":-5,"_59":60,"_61":62,"_63":-5,"_64":-5,"_65":-5,"_66":-5,"_67":68,"_69":68,"_70":71,"_72":71,"_73":71,"_74":68,"_75":68,"_76":77,"_78":79,"_80":81,"_82":25},"version",6,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":34,"_35":37,"_38":39,"_40":14,"_41":42,"_24":25},"previous",{"_30":31,"_32":28,"_33":34,"_35":36},"deleted",false,"deletedHere","path","github-discussions-monitor.ts","latestPath","fileId","e128dfc2-354f-11f0-b75d-9e149126039e","name","fileType","interval","content","import { email } from \"https://esm.town/v/std/email\";\nimport { sqlite } from \"https://esm.town/v/std/sqlite\";\n\nawait sqlite.execute(`create table if not exists config(\n var text,\n value text,\n PRIMARY KEY (var) ON CONFLICT REPLACE\n)`);\n\n// Types for GitHub API responses\ninterface GitHubDiscussion {\n id: string;\n title: string;\n html_url: string;\n body: string;\n author: {\n login: string;\n avatar_url: string;\n };\n created_at: string;\n category: {\n name: string;\n };\n}\n\n// import { Interval } from \"https://esm.town/v/std/interval\";\n// FIXME: import doesn't work?\ntype Interval = {\n lastRunAt: Date;\n};\n\ninterface GitHubDiscussionsResponse {\n discussions: GitHubDiscussion[];\n}\n\n// Configuration (customize these values)\nconst REPO_OWNER = \"community\"; // Replace with the repository owner\nconst REPO_NAME = \"community\"; // Replace with the repository name\nconst CATEGORY = \"DIC_kwDOEfmk4M4CALJ4\"; // Actions Category ID\nconst STORAGE_KEY = \"github_discussions_last_checked\";\nconst EMAIL_NOTIFICATIONS = true; // Set to false to disable email notifications\n\n/**\n * Fetches discussions from a GitHub repository\n */\nasync function fetchGitHubDiscussions(): Promise {\n const token = Deno.env.get(\"GITHUB_TOKEN\");\n if (!token) {\n throw new Error(\"GITHUB_TOKEN environment variable is not set\");\n }\n\n const url = `https://api.github.com/graphql`;\n const query = `\n query {\n repository(owner: \"${REPO_OWNER}\", name: \"${REPO_NAME}\") {\n discussions(categoryId: \"${CATEGORY}\", first: 100, orderBy: {field: CREATED_AT, direction: DESC}) {\n nodes {\n id\n title\n url\n body\n createdAt\n author {\n login\n avatarUrl\n }\n category {\n name\n }\n }\n }\n }\n }\n `;\n\n const response = await fetch(url, {\n method: \"POST\",\n headers: {\n \"Authorization\": `Bearer ${token}`,\n \"Content-Type\": \"application/json\",\n },\n body: JSON.stringify({ query }),\n });\n\n if (!response.ok) {\n throw new Error(`GitHub API error: ${response.status} ${await response.text()}`);\n }\n\n const data = await response.json();\n\n // Transform the GraphQL response to match our interface\n return data.data.repository.discussions.nodes.map((node: any) => ({\n id: node.id,\n title: node.title,\n html_url: node.url,\n body: node.body,\n created_at: node.createdAt,\n author: {\n login: node.author?.login || \"unknown\",\n avatar_url: node.author?.avatarUrl || \"\",\n },\n category: {\n name: node.category?.name || \"General\",\n },\n }));\n}\n\n/**\n * Sends an email notification for a new discussion\n */\nasync function sendNotificationEmail(discussion: GitHubDiscussion): Promise {\n if (!EMAIL_NOTIFICATIONS) return;\n\n const bodyPreview = discussion.body.length > 200\n ? `${discussion.body.substring(0, 200)}...`\n : discussion.body;\n\n await email({\n subject: `New GitHub Discussion: ${discussion.title}`,\n text: `\nNew discussion in ${REPO_OWNER}/${REPO_NAME}\nTitle: ${discussion.title}\nCategory: ${discussion.category.name}\nAuthor: ${discussion.author.login}\nLink: ${discussion.html_url}\n\n${bodyPreview}\n `,\n html: `\n

New GitHub Discussion

Repository: ${REPO_OWNER}/${REPO_NAME}

Title: ${discussion.title}

Category: ${discussion.category.name}

Author: ${discussion.author.login}

Link: ${discussion.html_url}

${bodyPreview}

New GitHub Discussion

Repository: ${REPO_OWNER}/${REPO_NAME}

Title: ${discussion.title}

Category: ${discussion.category.name}

Author: ${discussion.author.login}

Link: ${discussion.html_url}

${bodyPreview}

\n `,\n });\n}\n\n/**\n * Main function that checks for new discussions and sends notifications\n */\nexport default async function checkGitHubDiscussions({ lastRunAt }: Interval) {\n try {\n console.log(`Checking for new discussions in ${REPO_OWNER}/${REPO_NAME}...`);\n\n let prevRunAt = new Date(Date.now() - 1000 * 60 * 60 * 24); // last day\n let prevRunAtRes = await sqlite.execute({ sql: `select value from config where var = ?`, args: [\"lastRunAt\"] });\n if (prevRunAtRes.rows.length > 0) {\n prevRunAt = new Date(parseInt(prevRunAtRes.rows[0][0]));\n }\n\n // Fetch discussions from GitHub\n const discussions = await fetchGitHubDiscussions();\n\n // Find new discussions\n const newDiscussions = discussions.filter(d => d.created_at > prevRunAt.toISOString());\n\n if (newDiscussions.length === 0) {\n console.log(\"No new discussions found\");\n return { status: \"success\", newDiscussions: 0 };\n }\n\n console.log(`Found ${newDiscussions.length} new discussions`);\n\n // Send notifications for new discussions\n for (const discussion of newDiscussions) {\n console.log(`New discussion: ${discussion.title}`);\n await sendNotificationEmail(discussion);\n }\n\n await sqlite.execute({ sql: `insert into config(var, value) values(?, ?)`, args: [\"lastRunAt\", +lastRunAt] });\n\n return {\n status: \"success\",\n newDiscussions: newDiscussions.length,\n discussions: newDiscussions.map(d => ({\n id: d.id,\n title: d.title,\n url: d.html_url,\n author: d.author.login,\n category: d.category.name,\n })),\n };\n } catch (error) {\n console.error(\"Error checking GitHub discussions:\", error);\n return {\n status: \"error\",\n message: error.message,\n };\n }\n}","createdAt",["D",1747731597967],"branchVersion","branchId","b6dd923a-354f-11f0-bf31-9e149126039e","id","b6dd4ed8-354f-11f0-bf31-9e149126039e","GitHubCommunityActions",["D",1747727693511],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","2b350469-79f3-4932-8f14-a3f1c49842b6","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","4bf43b81-7254-42b2-82d4-39908d80b395","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_93":92,"_100":96},"org",{"_93":92,"_94":-5,"_95":96,"_18":54,"_97":98,"_99":25},"branch",{"_13":14,"_32":83,"_43":42,"_84":44,"_85":-5,"_86":-5,"_87":-5,"_88":-5,"_89":-5,"_90":45,"_91":92},"isOwned","main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","kamilchm","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18yaFFrWkpoZndocDhJNnVLOGFqRGlGYTVqUlkifQ","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_43":44,"_32":45,"_38":160,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":-5,"_53":-5,"_18":54,"_55":-5,"_56":25,"_57":-5,"_58":-5,"_59":60,"_61":62,"_63":-5,"_64":-5,"_65":-5,"_66":-5,"_67":68,"_69":68,"_70":71,"_72":71,"_73":71,"_74":68,"_75":68,"_76":161,"_78":162,"_80":163,"_82":25},"tree",[151,152],"files",[151,152],"counts",{"_140":60,"_141":142,"_143":60,"_144":145,"_146":147},"contents",[123,124],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_43":133,"_32":134,"_30":135,"_126":-5,"_41":42,"_40":136,"_127":128,"_38":137,"_13":60,"_33":20,"_35":138,"_24":25,"_131":-5,"_27":139},{"_43":125,"_32":28,"_30":31,"_126":-5,"_41":42,"_40":14,"_127":128,"_38":129,"_13":130,"_33":34,"_35":37,"_24":25,"_131":-5,"_27":132},"ce1af628-3558-11f0-ab93-9e149126039e","parentId","latest",true,["D",1747731597967],4,"label",[28],"e988de4c-354f-11f0-b301-9e149126039e","README.md","e988dff0-354f-11f0-b301-9e149126039e",2,["D",1747727778517],"# GitHub Discussions Monitor\n\nThis Val Town application monitors a GitHub repository for new discussions and sends email notifications when new discussions are created.\n\n## Features\n\n- Monitors a GitHub repository for new discussions\n- Sends email notifications for new discussions\n- Keeps track of which discussions have already been processed\n- Can be scheduled to run at regular intervals\n\n## Setup Instructions\n\n1. **Set up environment variables**:\n - `GITHUB_TOKEN`: A GitHub personal access token with permissions to read discussions in the repository\n\n2. **Configure the monitor**:\n - Open the `github-discussions-monitor.ts` file\n - Update the `REPO_OWNER` and `REPO_NAME` variables with your target repository information\n - Optionally, set `EMAIL_NOTIFICATIONS` to `false` if you don't want email notifications\n\n3. **Set up a cron trigger**:\n - In the Val Town web UI, set up a cron trigger for this val to run at your desired frequency\n - Recommended: Every hour (`0 * * * *`)\n\n## How It Works\n\n1. The script fetches the most recent discussions from the specified GitHub repository using the GitHub GraphQL API\n2. It compares the fetched discussions with a list of previously processed discussions stored in Val Town's blob storage\n3. For each new discussion, it sends an email notification with details about the discussion\n4. It updates the list of processed discussions to include the new ones\n\n## Response Format\n\nWhen run, the function returns a JSON object with the following structure:\n\n```json\n{\n \"status\": \"success\",\n \"newDiscussions\": 2,\n \"discussions\": [\n {\n \"id\": \"D_kwDOG7...\",\n \"title\": \"New feature request\",\n \"url\": \"https://github.com/owner/repo/discussions/123\",\n \"author\": \"username\",\n \"category\": \"Ideas\"\n },\n ...\n ]\n}\n```\n\nOr in case of an error:\n\n```json\n{\n \"status\": \"error\",\n \"message\": \"Error message details\"\n}\n```\n\n## Customization\n\n- **Email Format**: You can customize the email format by modifying the `sendNotificationEmail` function\n- **Discussions Query**: You can adjust the GraphQL query in `fetchGitHubDiscussions` to change how discussions are fetched\n- **Storage Key**: You can change the `STORAGE_KEY` if you want to use a different key for blob storage\n\n## Troubleshooting\n\n- If you're not receiving notifications, check that your GitHub token has the correct permissions\n- Ensure the repository has discussions enabled\n- Check the Val Town logs for any error messages",[134],"pulls","branches",1,"forks","envVars",{"_148":142,"_150":60},"connections",{"_148":60,"_149":60},"count","unfilledCount","emptyCount",{"_43":133,"_32":134,"_30":135,"_126":-5,"_41":42,"_40":136,"_127":128,"_38":157,"_13":60,"_33":20,"_35":138,"_24":25,"_131":-5,"_154":158,"_27":159},{"_43":125,"_32":28,"_30":31,"_126":-5,"_41":42,"_40":14,"_127":128,"_38":153,"_13":130,"_33":34,"_35":37,"_24":25,"_131":-5,"_154":155,"_27":156},["D",1747731597967],"children",[],[28],["D",1747727778517],[],[134],["D",1747727693511],{"_93":92,"_100":96},{"_93":92,"_94":-5,"_95":96,"_18":54,"_97":98,"_99":25},{"_13":14,"_32":83,"_43":42,"_84":44,"_85":-5,"_86":-5,"_87":-5,"_88":-5,"_89":-5,"_90":45,"_91":92},"ctx",{"_76":-5,"_120":197,"_198":199,"_200":201,"_202":25,"_203":25,"_204":25,"_205":128,"_206":-5,"_207":-7,"_208":-7,"_209":60,"_210":25,"_211":25,"_212":-5,"_213":25,"_214":25,"_215":25,"_216":-5},"ENV",{"_168":169,"_170":171,"_172":83,"_173":174,"_175":176,"_177":178,"_179":180,"_181":182,"_183":184,"_185":186,"_187":188,"_189":190,"_191":192,"_193":194,"_195":196},"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 · v6