⚡ 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 { userTable, workspaceUserTable } from "../../database/schema";
import { clearMemberProjectAccess } from "../../project-access/clear-member-project-access";
import type { AdminAuditRequest } from "../audit/admin-audit-request";
import { recordWorkspaceMemberAction } from "../audit/record-workspace-member-action";
import { handleMemberAdded } from "../../workspace-members/handle-member-added";
import { isAssignableWorkspaceRole } from "../is-assignable-workspace-role";
import { lockWorkspace } from "../lock-workspace";
import listWorkspaceMembers from "./list-workspace-members";
async function addWorkspaceMember(
request: {
workspaceId: string;
userId: string;
role: string;
},
audit: AdminAuditRequest,
) {
const { workspaceId, userId, role } = request;
await db.transaction(async (tx) => {
const members = await lockWorkspace(tx, workspaceId);
const [user] = await tx
.select({ id: userTable.id })
.from(userTable)
.where(eq(userTable.id, userId))
.limit(1);
if (!user) {
throw new HTTPException(404, { message: "User not found" });
}
if (members.some((member) => member.userId === userId)) {
throw new HTTPException(409, {
message: "This user is already a member of the workspace",
});
}
if (!(await isAssignableWorkspaceRole(tx, workspaceId, role))) {
throw new HTTPException(400, {
message:
"Unknown role. To make someone the owner, add them and then transfer ownership",
});
}
await clearMemberProjectAccess(workspaceId, userId, tx);
await tx
.insert(workspaceUserTable)
.values({ workspaceId, userId, role, joinedAt: new Date() });
await recordWorkspaceMemberAction(tx, audit, {
action: "workspace.member_added",
workspaceId,
userId,
metadata: { role },
});
});
await handleMemberAdded(workspaceId, userId);
return listWorkspaceMembers(workspaceId);
}
export default addWorkspaceMember;