Open-source and local-first Slack and Notion alternative that puts you in control of your data
TypeScript chatchat-applicationcrdteditorelectronknowledge-baselocal-firstnotionnotion-alternativerealtime-collaborationself-hostedslacksqliteteam-collaborationwikiyjs
import { FastifyPluginCallbackZod } from 'fastify-type-provider-zod';
import { z } from 'zod/v4';
import {
WorkspaceRole,
WorkspaceOutput,
ApiErrorCode,
UserStatus,
apiErrorOutputSchema,
workspaceOutputSchema,
} from '@colanode/core';
import { database } from '@colanode/server/data/database';
export const workspaceGetRoute: FastifyPluginCallbackZod = (
instance,
_,
done
) => {
instance.route({
method: 'GET',
url: '/',
schema: {
params: z.object({
workspaceId: z.string(),
}),
response: {
200: workspaceOutputSchema,
400: apiErrorOutputSchema,
403: apiErrorOutputSchema,
404: apiErrorOutputSchema,
},
},
handler: async (request, reply) => {
const workspaceId = request.params.workspaceId;
const workspace = await database
.selectFrom('workspaces')
.selectAll()
.where('id', '=', workspaceId)
.executeTakeFirst();
if (!workspace) {
return reply.code(400).send({
code: ApiErrorCode.WorkspaceNotFound,
message: 'Workspace not found.',
});
}
const user = await database
.selectFrom('users')
.selectAll()
.where('workspace_id', '=', workspaceId)
.where('account_id', '=', request.account.id)
.executeTakeFirst();
if (!user || user.status !== UserStatus.Active || user.role === 'none') {
return reply.code(403).send({
code: ApiErrorCode.WorkspaceNoAccess,
message: 'You do not have access to this workspace.',
});
}
const output: WorkspaceOutput = {
id: workspace.id,
name: workspace.name,
description: workspace.description,
avatar: workspace.avatar,
status: workspace.status,
user: {
id: user.id,
accountId: user.account_id,
role: user.role as WorkspaceRole,
},
};
return output;
},
});
done();
};