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}","deleted","label",[98],"permalink","https://www.val.town/x/kamilchm/GitHubCommunityActions/code/github-discussions-monitor.ts","extension","actionData","errors"]