⚡ 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 { labelTable, projectTable, taskTable } from "../../database/schema";
import { publishEvent } from "../../events";
import { removeLabelFromGitea } from "../../plugins/gitea/utils/sync-label-to-gitea";
import { removeLabelFromGitlab } from "../../plugins/gitlab/utils/sync-label-to-gitlab";
import { removeLabelFromGitHub } from "../../plugins/github/utils/sync-label-to-github";
async function unassignLabelFromTask(id: string, userId: string) {
const label = await db.query.labelTable.findFirst({
where: (label, { eq }) => eq(label.id, id),
});
if (!label) {
throw new HTTPException(404, {
message: "Label not found",
});
}
if (!label.taskId) {
throw new HTTPException(400, {
message: "Label is not assigned to a task",
});
}
const [task] = await db
.select({
id: taskTable.id,
projectId: taskTable.projectId,
workspaceId: projectTable.workspaceId,
})
.from(taskTable)
.innerJoin(projectTable, eq(taskTable.projectId, projectTable.id))
.where(eq(taskTable.id, label.taskId))
.limit(1);
if (!task || task.workspaceId !== label.workspaceId) {
throw new HTTPException(404, {
message: "Task not found",
});
}
const [deletedLabel] = await db
.delete(labelTable)
.where(eq(labelTable.id, id))
.returning();
if (!deletedLabel) {
throw new HTTPException(500, {
message: "Failed to detach label from task",
});
}
if (deletedLabel.taskId) {
removeLabelFromGitea(deletedLabel.taskId, deletedLabel.name).catch(
(error) => console.error("Failed to remove label from Gitea:", error),
);
removeLabelFromGitlab(deletedLabel.taskId, deletedLabel.name).catch(
(error) => console.error("Failed to remove label from GitLab:", error),
);
removeLabelFromGitHub(deletedLabel.taskId, deletedLabel.name).catch(
(error) => {
console.error("Failed to remove label from GitHub:", error);
},
);
}
await publishEvent("task.label_unassigned", {
label: deletedLabel,
task,
projectId: task.projectId,
taskId: deletedLabel.taskId,
userId,
type: "label_unassigned",
});
return deletedLabel;
}
export default unassignLabelFromTask;