Function constructCommentPrismaQuery

src/lib/utils.ts:259–314

(
  searchParams: QueryParams,
  paginationInfo: PaginationInfo,
  contentId: number,
  userId: string,
)

  message: string;
};
export const constructCommentPrismaQuery = (
  searchParams: QueryParams,
  paginationInfo: PaginationInfo,
  contentId: number,
  userId: string,
): Prisma.CommentFindManyArgs => {
  const { pageSize, skip } = paginationInfo;
  const { tabtype, type } = searchParams;

  let orderBy: Prisma.Enumerable<Prisma.CommentOrderByWithRelationInput> = {};
  switch (tabtype) {
    case TabType.mu:
      orderBy = { upvotes: 'desc' };
      break;
    case TabType.md:
      orderBy = { downvotes: 'desc' };
      break;
    case TabType.mr:
      orderBy = { createdAt: 'desc' };
      break;
    default:
      orderBy = { upvotes: 'desc' };
  }

  const where: Prisma.CommentWhereInput = {};
  if (contentId) {
    where.contentId = contentId;
  }
  if (searchParams.parentId) {
    where.parentId = parseInt(searchParams.parentId.toString(), 10);
  } else {
    where.parent = null;
  }
  if (type === CommentType.INTRO) {
    where.commentType = type;
  }
  const query: Prisma.CommentFindManyArgs = {
    where,
    orderBy,
    skip,
    take: pageSize,
    include: {
      user: true,
      votes: {
        where: {
          userId,
        },
        select: {
          voteType: true, // Only fetch the voteType to determine if it's an upvote or downvote
        },
      },
    },
  };

  return query;
};

export const generateHandle = (title: string): string => {