⚡ Project management that doesn't become the project. Boards, Gantt charts, and GitHub integration. Self-host it or use Kaneo Cloud.
TypeScript honoissue-managementissue-trackerjira-alternativekanbanlinear-alternativemcpproject-managementreactself-hostedtypescript
import { withIntegrationLink } from "../services/with-integration-link";
import { activityTable } from "../../../database/schema";
import { findExternalLink } from "../services/link-manager";
import { findAllIntegrationsByRepo } from "../services/task-service";
type IssueCommentCreatedPayload = {
action: string;
issue: {
number: number;
};
comment: {
id: number;
body: string;
html_url: string;
user: {
login: string;
avatar_url: string;
} | null;
created_at: string;
};
installation?: { id: number };
repository: {
id: number;
owner: { login: string };
name: string;
};
};
export async function handleIssueCommentCreated(
payload: IssueCommentCreatedPayload,
) {
const { issue, comment } = payload;
if (payload.action !== "created") {
return;
}
const username = comment.user?.login ?? "";
if (username.endsWith("[bot]")) {
return;
}
const integrations = await findAllIntegrationsByRepo(payload);
for (const integration of integrations) {
const existingLink = await findExternalLink(
integration.id,
"issue",
issue.number.toString(),
);
if (!existingLink) {
continue;
}
await withIntegrationLink(
existingLink,
integration,
async (db, _afterCommit, existingLink) => {
await db
.insert(activityTable)
.values({
taskId: existingLink.taskId,
type: "comment",
content: comment.body,
externalUserName: comment.user?.login ?? "Unknown",
externalUserAvatar: comment.user?.avatar_url ?? null,
externalSource: "github",
externalUrl: comment.html_url,
})
.onConflictDoNothing({
target: [
activityTable.taskId,
activityTable.externalSource,
activityTable.externalUrl,
],
});
return;
},
);
}
}