1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
|
import type { Prisma } from '@/generated/prisma/client';
import prisma from '@/lib/prisma';
import type { QueryFilters } from '@/lib/types';
export async function findPixel(criteria: Prisma.PixelFindUniqueArgs) {
return prisma.client.pixel.findUnique(criteria);
}
export async function getPixel(pixelId: string) {
return findPixel({
where: {
id: pixelId,
},
});
}
export async function getPixels(criteria: Prisma.PixelFindManyArgs, filters: QueryFilters = {}) {
const { search } = filters;
const where: Prisma.PixelWhereInput = {
...criteria.where,
...prisma.getSearchParameters(search, [{ name: 'contains' }, { slug: 'contains' }]),
};
return prisma.pagedQuery('pixel', { ...criteria, where }, filters);
}
export async function getUserPixels(userId: string, filters?: QueryFilters) {
return getPixels(
{
where: {
userId,
},
},
filters,
);
}
export async function getTeamPixels(teamId: string, filters?: QueryFilters) {
return getPixels(
{
where: {
teamId,
},
},
filters,
);
}
export async function createPixel(data: Prisma.PixelUncheckedCreateInput) {
return prisma.client.pixel.create({ data });
}
export async function updatePixel(pixelId: string, data: any) {
return prisma.client.pixel.update({ where: { id: pixelId }, data });
}
export async function deletePixel(pixelId: string) {
return prisma.client.pixel.delete({ where: { id: pixelId } });
}
|