⚡ 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 {
customFieldDefinitionTable,
projectTable,
} from "../../database/schema";
async function deleteCustomField(id: string) {
const [field] = await db
.select({
projectId: customFieldDefinitionTable.projectId,
workspaceId: projectTable.workspaceId,
})
.from(customFieldDefinitionTable)
.innerJoin(
projectTable,
eq(projectTable.id, customFieldDefinitionTable.projectId),
)
.where(eq(customFieldDefinitionTable.id, id))
.limit(1);
if (!field) {
throw new HTTPException(404, {
message: "Custom field or project not found",
});
}
if (!field.workspaceId) {
throw new HTTPException(400, {
message: "The project is not associated with a workspace",
});
}
const [deleted] = await db
.delete(customFieldDefinitionTable)
.where(eq(customFieldDefinitionTable.id, id))
.returning();
if (!deleted) {
throw new HTTPException(404, {
message: "Custom field not found",
});
}
return {
...deleted,
workspaceId: field.workspaceId,
};
}
export default deleteCustomField;