Skip to content

armgit / kaneo

Public Imported from GitHub
0

⚡ Project management that doesn't become the project. Boards, Gantt charts, and GitHub integration. Self-host it or use Kaneo Cloud.

1.2 KB
Raw Blame
import { and, eq, isNull, sql } from "drizzle-orm";
import db from "../../database";
import {
  userTable,
  workspaceTable,
  workspaceUserTable,
} from "../../database/schema";
import { workspaceAccessColumns } from "../can-read-workspace";
import { filterReadableWorkspaces } from "../filter-readable-workspaces";
import {
  toWorkspaceResponse,
  workspaceColumns,
} from "../to-workspace-response";

async function listWorkspaces(userId: string) {
  const sortName = sql`lower(${workspaceTable.name})`;

  const rows = await db
    .selectDistinctOn([sortName, workspaceTable.id], {
      ...workspaceColumns,
      ...workspaceAccessColumns,
    })
    .from(workspaceTable)
    .innerJoin(
      workspaceUserTable,
      and(
        eq(workspaceUserTable.workspaceId, workspaceTable.id),
        eq(workspaceUserTable.userId, userId),
      ),
    )
    .innerJoin(userTable, eq(userTable.id, workspaceUserTable.userId))
    .where(isNull(workspaceTable.archivedAt))
    .orderBy(
      sortName,
      workspaceTable.id,
      workspaceUserTable.joinedAt,
      workspaceUserTable.id,
    );

  return (await filterReadableWorkspaces(rows)).map(toWorkspaceResponse);
}

export default listWorkspaces;