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 {
extractNodeRole,
hasNodeRole,
NodeInteractionOpenedMutation,
NodeInteractionSeenMutation,
MutationStatus,
} from '@colanode/core';
import { database } from '@colanode/server/data/database';
import { eventBus } from '@colanode/server/lib/event-bus';
import { mapNode } from '@colanode/server/lib/nodes';
import { WorkspaceContext } from '@colanode/server/types/api';
export const markNodeAsSeen = async (
workspace: WorkspaceContext,
mutation: NodeInteractionSeenMutation
): Promise<MutationStatus> => {
const node = await database
.selectFrom('nodes')
.select(['id', 'root_id', 'workspace_id'])
.where('id', '=', mutation.data.nodeId)
.executeTakeFirst();
if (!node) {
return MutationStatus.NOT_FOUND;
}
const root = await database
.selectFrom('nodes')
.selectAll()
.where('id', '=', node.root_id)
.executeTakeFirst();
if (!root) {
return MutationStatus.NOT_FOUND;
}
const rootNode = mapNode(root);
const role = extractNodeRole(rootNode, workspace.user.id);
if (!role || !hasNodeRole(role, 'viewer')) {
return MutationStatus.FORBIDDEN;
}
const existingInteraction = await database
.selectFrom('node_interactions')
.selectAll()
.where('node_id', '=', mutation.data.nodeId)
.where('collaborator_id', '=', workspace.user.id)
.executeTakeFirst();
if (
existingInteraction &&
existingInteraction.last_seen_at !== null &&
existingInteraction.last_seen_at <= new Date(mutation.data.seenAt)
) {
return MutationStatus.OK;
}
const lastSeenAt = new Date(mutation.data.seenAt);
const firstSeenAt = existingInteraction?.first_seen_at ?? lastSeenAt;
const createdInteraction = await database
.insertInto('node_interactions')
.returningAll()
.values({
node_id: mutation.data.nodeId,
collaborator_id: workspace.user.id,
first_seen_at: firstSeenAt,
last_seen_at: lastSeenAt,
root_id: root.id,
workspace_id: root.workspace_id,
})
.onConflict((b) =>
b.columns(['node_id', 'collaborator_id']).doUpdateSet({
last_seen_at: lastSeenAt,
first_seen_at: firstSeenAt,
})
)
.executeTakeFirst();
if (!createdInteraction) {
return MutationStatus.INTERNAL_SERVER_ERROR;
}
eventBus.publish({
type: 'node.interaction.updated',
nodeId: createdInteraction.node_id,
collaboratorId: createdInteraction.collaborator_id,
rootId: createdInteraction.root_id,
workspaceId: createdInteraction.workspace_id,
});
return MutationStatus.OK;
};
export const markNodeAsOpened = async (
workspace: WorkspaceContext,
mutation: NodeInteractionOpenedMutation
): Promise<MutationStatus> => {
const node = await database
.selectFrom('nodes')
.select(['id', 'root_id', 'workspace_id'])
.where('id', '=', mutation.data.nodeId)
.executeTakeFirst();
if (!node) {
return MutationStatus.NOT_FOUND;
}
const root = await database
.selectFrom('nodes')
.selectAll()
.where('id', '=', node.root_id)
.executeTakeFirst();
if (!root) {
return MutationStatus.NOT_FOUND;
}
const rootNode = mapNode(root);
const role = extractNodeRole(rootNode, workspace.user.id);
if (!role || !hasNodeRole(role, 'viewer')) {
return MutationStatus.FORBIDDEN;
}
const existingInteraction = await database
.selectFrom('node_interactions')
.selectAll()
.where('node_id', '=', mutation.data.nodeId)
.where('collaborator_id', '=', workspace.user.id)
.executeTakeFirst();
if (
existingInteraction &&
existingInteraction.last_opened_at !== null &&
existingInteraction.last_opened_at <= new Date(mutation.data.openedAt)
) {
return MutationStatus.OK;
}
const lastOpenedAt = new Date(mutation.data.openedAt);
const firstOpenedAt = existingInteraction?.first_opened_at ?? lastOpenedAt;
const createdInteraction = await database
.insertInto('node_interactions')
.returningAll()
.values({
node_id: mutation.data.nodeId,
collaborator_id: workspace.user.id,
first_opened_at: firstOpenedAt,
last_opened_at: lastOpenedAt,
root_id: root.id,
workspace_id: root.workspace_id,
})
.onConflict((b) =>
b.columns(['node_id', 'collaborator_id']).doUpdateSet({
last_opened_at: lastOpenedAt,
first_opened_at: firstOpenedAt,
})
)
.executeTakeFirst();
if (!createdInteraction) {
return MutationStatus.INTERNAL_SERVER_ERROR;
}
eventBus.publish({
type: 'node.interaction.updated',
nodeId: createdInteraction.node_id,
collaboratorId: createdInteraction.collaborator_id,
rootId: createdInteraction.root_id,
workspaceId: createdInteraction.workspace_id,
});
return MutationStatus.OK;
};