-
Notifications
You must be signed in to change notification settings - Fork 1.5k
/
optional.ts
119 lines (105 loc) · 2.49 KB
/
optional.ts
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
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
import { getTestClient } from '../../../../../utils/getTestClient'
import { commentOptionalPropDataA } from '../__helpers__/build-data/commentOptionalPropDataA'
const describeIf = (condition: boolean) => (condition ? describe : describe.skip)
let PrismaClient, prisma
const id = '7aaaaaaaaaaaaaaaaaaaaaaa'
/**
* Test findFirst operations on optional composite fields
*/
describeIf(!process.env.TEST_SKIP_MONGODB)('findFirst > optional', () => {
beforeAll(async () => {
PrismaClient = await getTestClient('../')
prisma = new PrismaClient()
})
beforeEach(async () => {
await prisma.commentOptionalProp.deleteMany({ where: { id } })
await prisma.commentOptionalProp.create({ data: commentOptionalPropDataA(id) })
})
afterEach(async () => {
await prisma.$disconnect()
})
/**
* Simple find
*/
test('simple', async () => {
const comment = await prisma.commentOptionalProp.findFirst({
where: { id },
})
expect(comment).toMatchInlineSnapshot(`
Object {
content: Object {
text: Hello World,
upvotes: Array [
Object {
userId: 10,
vote: true,
},
],
},
country: null,
id: 7aaaaaaaaaaaaaaaaaaaaaaa,
}
`)
})
/**
* Select
*/
test('select', async () => {
const comment = await prisma.commentOptionalProp.findFirst({
where: { id },
select: {
content: {
select: {
text: true,
},
},
},
})
expect(comment).toMatchInlineSnapshot(`
Object {
content: Object {
text: Hello World,
},
}
`)
})
/**
* Order by
*/
test('orderBy', async () => {
const comment = await prisma.commentOptionalProp.findFirst({
where: { id },
orderBy: {
content: {
upvotes: {
_count: 'desc',
},
},
},
})
expect(comment).toMatchInlineSnapshot(`
Object {
content: Object {
text: Hello World,
upvotes: Array [
Object {
userId: 10,
vote: true,
},
],
},
country: null,
id: 7aaaaaaaaaaaaaaaaaaaaaaa,
}
`)
})
/**
* Filter isSet
*/
test('filter isSet', async () => {
const comment = await prisma.commentOptionalProp.findFirst({
where: { id, country: { isSet: true } },
})
expect(comment).toMatchInlineSnapshot(`null`)
})
})