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 ms from 'ms';
import { WorkspaceMutationHandlerBase } from '@colanode/client/handlers/mutations/workspace-mutation-handler-base';
import { eventBus } from '@colanode/client/lib/event-bus';
import { mapNodeInteraction } from '@colanode/client/lib/mappers';
import { MutationHandler } from '@colanode/client/lib/types';
import { fetchNode } from '@colanode/client/lib/utils';
import {
NodeInteractionOpenedMutationInput,
NodeInteractionOpenedMutationOutput,
} from '@colanode/client/mutations/nodes/node-interaction-opened';
import {
NodeInteractionOpenedMutation,
generateId,
IdType,
} from '@colanode/core';
export class NodeInteractionOpenedMutationHandler
extends WorkspaceMutationHandlerBase
implements MutationHandler<NodeInteractionOpenedMutationInput>
{
async handleMutation(
input: NodeInteractionOpenedMutationInput
): Promise<NodeInteractionOpenedMutationOutput> {
const workspace = this.getWorkspace(input.userId);
const node = await fetchNode(workspace.database, input.nodeId);
if (!node) {
return {
success: false,
};
}
const existingInteraction = await workspace.database
.selectFrom('node_interactions')
.selectAll()
.where('node_id', '=', input.nodeId)
.where('collaborator_id', '=', workspace.userId)
.executeTakeFirst();
if (existingInteraction) {
const lastOpenedAt = existingInteraction.last_opened_at;
if (
lastOpenedAt &&
lastOpenedAt > new Date(Date.now() - ms('5 minutes')).toISOString()
) {
return {
success: true,
};
}
}
const lastOpenedAt = new Date().toISOString();
const firstOpenedAt = existingInteraction
? existingInteraction.first_opened_at
: lastOpenedAt;
const { createdInteraction, createdMutation } = await workspace.database
.transaction()
.execute(async (trx) => {
const createdInteraction = await trx
.insertInto('node_interactions')
.returningAll()
.values({
node_id: input.nodeId,
collaborator_id: workspace.userId,
last_opened_at: lastOpenedAt,
first_opened_at: firstOpenedAt,
revision: '0',
root_id: node.rootId,
})
.onConflict((b) =>
b.columns(['node_id', 'collaborator_id']).doUpdateSet({
last_opened_at: lastOpenedAt,
first_opened_at: firstOpenedAt,
})
)
.executeTakeFirst();
if (!createdInteraction) {
throw new Error('Failed to create node interaction');
}
const mutation: NodeInteractionOpenedMutation = {
id: generateId(IdType.Mutation),
createdAt: new Date().toISOString(),
type: 'node.interaction.opened',
data: {
nodeId: input.nodeId,
collaboratorId: workspace.userId,
openedAt: new Date().toISOString(),
},
};
const createdMutation = await trx
.insertInto('mutations')
.returningAll()
.values({
id: mutation.id,
type: mutation.type,
data: JSON.stringify(mutation.data),
created_at: mutation.createdAt,
retries: 0,
})
.executeTakeFirst();
return {
createdInteraction,
createdMutation,
};
});
if (!createdInteraction || !createdMutation) {
throw new Error('Failed to create node interaction');
}
await workspace.nodeCounters.checkCountersForUpdatedNodeInteraction(
createdInteraction,
existingInteraction
);
workspace.mutations.scheduleSync();
eventBus.publish({
type: 'node.interaction.updated',
workspace: {
workspaceId: workspace.workspaceId,
userId: workspace.userId,
accountId: workspace.accountId,
},
nodeInteraction: mapNodeInteraction(createdInteraction),
});
return {
success: true,
};
}
}