Skip to content

Open-source and local-first Slack and Notion alternative that puts you in control of your data

4.7 KB
Raw Blame
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;
};