⚡ 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 { eq } from "drizzle-orm";
import { HTTPException } from "hono/http-exception";
import db from "../../database";
import {
externalLinkTable,
projectTable,
taskTable,
} from "../../database/schema";
import { publishEvent } from "../../events";
import { pullRequestNumber } from "../pull-request-number";
type PullRequestMetadata = {
state: "open" | "closed";
merged: boolean;
draft: boolean;
};
async function createExternalLink({
taskId,
url,
title,
resourceType = "url",
metadata,
userId,
}: {
taskId: string;
url: string;
title?: string;
resourceType?: "url" | "pull_request";
metadata?: PullRequestMetadata;
userId: string;
}) {
if (metadata && resourceType !== "pull_request") {
throw new HTTPException(400, {
message: "Metadata is only accepted for pull request links",
});
}
const [link] = await db
.insert(externalLinkTable)
.values({
taskId,
integrationId: null,
resourceType,
externalId:
resourceType === "pull_request" ? (pullRequestNumber(url) ?? url) : url,
url,
title: title ?? null,
...(metadata ? { metadata: JSON.stringify(metadata) } : {}),
})
.returning();
if (!link) {
throw new HTTPException(500, {
message: "Failed to create external link",
});
}
const [task] = await db
.select({
projectId: taskTable.projectId,
title: taskTable.title,
status: taskTable.status,
})
.from(taskTable)
.innerJoin(projectTable, eq(taskTable.projectId, projectTable.id))
.where(eq(taskTable.id, taskId))
.limit(1);
if (!task) {
throw new HTTPException(404, {
message: "Task not found",
});
}
await publishEvent("task.updated", {
taskId,
projectId: task.projectId,
title: task.title,
status: task.status,
userId,
});
return link;
}
export default createExternalLink;