Skip to content

armgit / papra

Public Imported from GitHub
0

The minimalistic document archiving platform.

2.9 KB
Raw Blame
import type { Database } from '../../app/database/database.types';
import type { DocumentActivityEvent } from './document-activity.types';
import { injectArguments } from '@corentinth/chisels';
import { and, desc, eq, getTableColumns } from 'drizzle-orm';
import { withPagination } from '../../shared/db/pagination';
import { tagsTable } from '../../tags/tags.table';
import { usersTable } from '../../users/users.table';
import { documentsTable } from '../documents.table';
import { documentActivityLogTable } from './document-activity.table';

export type DocumentActivityRepository = ReturnType<typeof createDocumentActivityRepository>;

export type DocumentActivityInput = {
  documentId: string;
  event: DocumentActivityEvent;
  eventData?: Record<string, unknown>;
  userId?: string | null;
  tagId?: string;
};

export function createDocumentActivityRepository({ db }: { db: Database }) {
  return injectArguments(
    {
      saveDocumentActivity,
      saveDocumentActivities,
      getOrganizationDocumentActivities,
    },
    { db },
  );
}

async function saveDocumentActivity({
  documentId,
  event,
  eventData,
  userId,
  tagId,
  db,
}: DocumentActivityInput & { db: Database }) {
  const [activity] = await db
    .insert(documentActivityLogTable)
    .values({
      documentId,
      event,
      eventData,
      userId,
      tagId,
    })
    .returning();

  return { activity };
}

async function saveDocumentActivities({
  activities,
  db,
}: {
  activities: DocumentActivityInput[];
  db: Database;
}) {
  if (activities.length === 0) {
    return { activities: [] };
  }

  const inserted = await db.insert(documentActivityLogTable).values(activities).returning();

  return { activities: inserted };
}

async function getOrganizationDocumentActivities({
  organizationId,
  documentId,
  pageIndex,
  pageSize,
  db,
}: {
  organizationId: string;
  documentId: string;
  pageIndex: number;
  pageSize: number;
  db: Database;
}) {
  const query = db
    .select({
      ...getTableColumns(documentActivityLogTable),
      user: {
        id: usersTable.id,
        name: usersTable.name,
      },
      tag: {
        id: tagsTable.id,
        name: tagsTable.name,
        color: tagsTable.color,
        description: tagsTable.description,
      },
    })
    .from(documentActivityLogTable)
    // Join with documents table to ensure the document exists in the organization
    .innerJoin(documentsTable, eq(documentActivityLogTable.documentId, documentsTable.id))
    .leftJoin(usersTable, eq(documentActivityLogTable.userId, usersTable.id))
    .leftJoin(tagsTable, eq(documentActivityLogTable.tagId, tagsTable.id))
    .where(
      and(
        eq(documentsTable.organizationId, organizationId),
        eq(documentActivityLogTable.documentId, documentId),
      ),
    );

  const activities = await withPagination(query.$dynamic(), {
    orderByColumn: desc(documentActivityLogTable.createdAt),
    pageIndex,
    pageSize,
  });

  return { activities };
}