kaneo (minimalist kanban) fork to experiment adding a tangled integration
github.com/usekaneo/kaneo
1import { eq } from "drizzle-orm";
2import db from "../../database";
3import { userTable, workspaceUserTable } from "../../database/schema";
4
5async function getWorkspaceMembers(workspaceId: string) {
6 const members = await db
7 .select({
8 id: userTable.id,
9 name: userTable.name,
10 email: userTable.email,
11 image: userTable.image,
12 role: workspaceUserTable.role,
13 })
14 .from(workspaceUserTable)
15 .innerJoin(userTable, eq(workspaceUserTable.userId, userTable.id))
16 .where(eq(workspaceUserTable.workspaceId, workspaceId));
17
18 return members;
19}
20
21export default getWorkspaceMembers;