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 { Link, Prisma } from '@/generated/prisma/client';
import prisma from '@/lib/prisma';
import { sanitizeSortFilters } from '@/lib/sort';
import type { PageResult, QueryFilters } from '@/lib/types';
const LINK_SORT_FIELDS = ['name', 'slug', 'url', 'createdAt'] as const;
export async function findLink(criteria: Prisma.LinkFindUniqueArgs) {
return prisma.client.link.findUnique(criteria);
}
export async function getLink(linkId: string) {
return findLink({
where: {
id: linkId,
},
});
}
export async function getLinks(
criteria: Prisma.LinkFindManyArgs,
filters: QueryFilters = {},
): Promise<PageResult<Link[]>> {
const sortFilters = sanitizeSortFilters(filters, LINK_SORT_FIELDS);
const { search } = sortFilters;
const { getSearchParameters, pagedQuery } = prisma;
const where: Prisma.LinkWhereInput = {
...criteria.where,
...getSearchParameters(search, [
{ name: 'contains' },
{ url: 'contains' },
{ slug: 'contains' },
]),
};
return pagedQuery('link', { ...criteria, where }, sortFilters);
}
export async function getUserLinks(userId: string, filters?: QueryFilters) {
return getLinks(
{
where: {
userId,
deletedAt: null,
},
},
filters,
);
}
export async function getTeamLinks(teamId: string, filters?: QueryFilters) {
return getLinks(
{
where: {
teamId,
},
},
filters,
);
}
export async function createLink(data: Prisma.LinkUncheckedCreateInput) {
return prisma.client.link.create({ data });
}
export async function updateLink(linkId: string, data: any) {
return prisma.client.link.update({ where: { id: linkId }, data });
}
export async function deleteLink(linkId: string) {
return prisma.client.link.delete({ where: { id: linkId } });
}