Umami is a privacy-first web and product analytics platform. Traffic, campaigns, behavior, conversions, and revenue in one place. No cookies, no surveillance, self-hosted or in the cloud.
TypeScript analyticsaudience-segmentationchartscohort-analysisgoogle-analyticsproduct-analyticsstatisticsuser-journeyweb-analytics
import type { Board, Prisma } from '@/generated/prisma/client';
import { BOARD_TYPES } from '@/lib/boards';
import prisma from '@/lib/prisma';
import { sanitizeSortFilters } from '@/lib/sort';
import type { PageResult, QueryFilters } from '@/lib/types';
const BOARD_SORT_FIELDS = ['name', 'description', 'type', 'createdAt'] as const;
export async function findBoard(criteria: Prisma.BoardFindUniqueArgs) {
return prisma.client.board.findUnique(criteria);
}
export async function getBoard(boardId: string) {
return findBoard({
where: {
id: boardId,
},
});
}
export async function getBoards(
criteria: Prisma.BoardFindManyArgs,
filters: QueryFilters = {},
): Promise<PageResult<Board[]>> {
const sortFilters = sanitizeSortFilters(filters, BOARD_SORT_FIELDS);
const { search } = sortFilters;
const { getSearchParameters, pagedQuery } = prisma;
const where: Prisma.BoardWhereInput = {
...criteria.where,
...getSearchParameters(search, [{ name: 'contains' }, { description: 'contains' }]),
};
return pagedQuery('board', { ...criteria, where }, sortFilters);
}
export async function getUserBoards(userId: string, filters?: QueryFilters) {
return getBoards(
{
where: {
userId,
type: {
not: BOARD_TYPES.dashboard,
},
},
},
filters,
);
}
export async function getTeamBoards(teamId: string, filters?: QueryFilters) {
return getBoards(
{
where: {
teamId,
type: {
not: BOARD_TYPES.dashboard,
},
},
},
filters,
);
}
export async function createBoard(data: Prisma.BoardUncheckedCreateInput) {
return prisma.client.board.create({ data });
}
export async function updateBoard(boardId: string, data: any) {
return prisma.client.board.update({ where: { id: boardId }, data });
}
export async function deleteBoard(boardId: string) {
return prisma.client.board.delete({ where: { id: boardId } });
}