⚡ 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, isNotNull, or } from "drizzle-orm";
import { HTTPException } from "hono/http-exception";
import db from "../../database";
import {
userTable,
workspaceTable,
workspaceUserTable,
} from "../../database/schema";
import { instanceAdminRoleSql } from "../../utils/instance-admin-role";
import { workspaceArchivedError } from "../archive/workspace-archived-error";
import { workspaceAccessColumns } from "../can-read-workspace";
import { filterReadableWorkspaces } from "../filter-readable-workspaces";
import {
toWorkspaceResponse,
workspaceColumns,
} from "../to-workspace-response";
async function getWorkspace(workspaceId: string, userId: string) {
const rows = await db
.select({
...workspaceColumns,
...workspaceAccessColumns,
archivedAt: workspaceTable.archivedAt,
})
.from(workspaceTable)
.innerJoin(userTable, eq(userTable.id, userId))
.leftJoin(
workspaceUserTable,
and(
eq(workspaceUserTable.workspaceId, workspaceTable.id),
eq(workspaceUserTable.userId, userTable.id),
),
)
.where(
and(
eq(workspaceTable.id, workspaceId),
or(
isNotNull(workspaceUserTable.id),
instanceAdminRoleSql(userTable.role),
),
),
)
.orderBy(workspaceUserTable.joinedAt, workspaceUserTable.id)
.limit(1);
const [row] = await filterReadableWorkspaces(rows);
if (!row) {
throw new HTTPException(404, { message: "Workspace not found" });
}
if (row.archivedAt) {
throw workspaceArchivedError();
}
return toWorkspaceResponse(row);
}
export default getWorkspace;