⚡ 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 { and, eq, inArray } from "drizzle-orm";
import { HTTPException } from "hono/http-exception";
import db from "../../database";
import {
projectTable,
taskRelationTable,
taskTable,
} from "../../database/schema";
import { publishEvent } from "../../events";
import { projectAccessCondition } from "../../project-access/project-access-condition";
async function deleteTaskRelation(
id: string,
userId: string,
workspaceId: string,
) {
const workspaceTasks = db
.select({ id: taskTable.id })
.from(taskTable)
.innerJoin(projectTable, eq(taskTable.projectId, projectTable.id))
.where(
and(
eq(projectTable.workspaceId, workspaceId),
projectAccessCondition(userId, taskTable.projectId),
),
);
// Check both endpoints in the delete statement itself. Legacy cross-tenant
// rows must not bypass the same boundary enforced on creation and reads.
const [relation] = await db
.delete(taskRelationTable)
.where(
and(
eq(taskRelationTable.id, id),
inArray(taskRelationTable.sourceTaskId, workspaceTasks),
inArray(taskRelationTable.targetTaskId, workspaceTasks),
),
)
.returning();
if (!relation) {
throw new HTTPException(404, {
message: "Task relation not found",
});
}
const [task] = await db
.select({ projectId: taskTable.projectId })
.from(taskTable)
.innerJoin(projectTable, eq(taskTable.projectId, projectTable.id))
.where(
and(
eq(taskTable.id, relation.sourceTaskId),
eq(projectTable.workspaceId, workspaceId),
),
)
.limit(1);
if (task) {
await publishEvent("task-relation.deleted", {
...relation,
taskId: relation.sourceTaskId,
projectId: task.projectId,
userId,
});
}
return relation;
}
export default deleteTaskRelation;