Hey, if any of ya could give a quick hint on this ...
# orm-helpd
Dmitri Pisarev
07/15/2020, 3:06 PMHey, if any of ya could give a quick hint on this I'd greatly appreciate it! OR is driving me mad https://github.com/prisma/prisma/discussions/3030
n
nikolasburk
07/15/2020, 3:12 PM
Hmm, that looks strange indeed!
ORfindMany Copy code
const result = await prisma.post.findMany({
where: {
OR: [
{
title: { contains: 'Prisma' },
},
{
title: { contains: 'databases' },
},
],
},
})nikolasburk
07/15/2020, 3:13 PM
Can you share your schema (or the relevant parts therefore)? I'll try to reproduce the issue in an isolated environment 🙂
d
Dmitri Pisarev
07/15/2020, 3:14 PMHi @nikolasburk! Thanks a lot for getting in touch! The whole schema would be thousands of line long and under NDA, but I can try to cook up a minimal example
🙏 1
n
nikolasburk
07/15/2020, 3:15 PM
Ah I also just realized that you're using Prisma 1, the docs link I shared is for Prisma 2.
d
Dmitri Pisarev
07/15/2020, 3:17 PMv1 docs seem to also promise to support it https://v1.prisma.io/docs/1.34/prisma-client/basic-data-access/reading-data-JAVASCRIPT-rsc2/#basic-filters-for-lists
n
nikolasburk
07/15/2020, 3:18 PM
Yeah the API hasn't changed that much, I'd indeed expect it to be available in Prisma 1 as well 🤔
d
Dmitri Pisarev
07/15/2020, 3:24 PMOk that's actually interesting
Dmitri Pisarev
07/15/2020, 3:24 PM Copy code
type Thing @db(name: "myMongoCollection") {
_id: ID! @id
}Dmitri Pisarev
07/15/2020, 3:24 PMthis generates
Copy code
export interface ThingWhereInput {
_id?: string | null
_id_not?: string | null
_id_in?: string[]
_id_not_in?: string[]
_id_lt?: string | null
_id_lte?: string | null
_id_gt?: string | null
_id_gte?: string | null
_id_contains?: string | null
_id_not_contains?: string | null
_id_starts_with?: string | null
_id_not_starts_with?: string | null
_id_ends_with?: string | null
_id_not_ends_with?: string | null
AND?: ThingWhereInput[]
}Dmitri Pisarev
07/15/2020, 3:25 PMso my assumption about @relation doesn't seem to hold true
Dmitri Pisarev
07/15/2020, 3:26 PMbut for some types it generates
Copy code
export interface RoleScalarWhereInput {
_id?: string | null
_id_not?: string | null
_id_in?: string[]
_id_not_in?: string[]
_id_lt?: string | null
_id_lte?: string | null
_id_gt?: string | null
_id_gte?: string | null
_id_contains?: string | null
_id_not_contains?: string | null
_id_starts_with?: string | null
_id_not_starts_with?: string | null
_id_ends_with?: string | null
_id_not_ends_with?: string | null
name?: string | null
name_not?: string | null
name_in?: string[]
name_not_in?: string[]
name_lt?: string | null
name_lte?: string | null
name_gt?: string | null
name_gte?: string | null
name_contains?: string | null
name_not_contains?: string | null
name_starts_with?: string | null
name_not_starts_with?: string | null
name_ends_with?: string | null
name_not_ends_with?: string | null
AND?: RoleScalarWhereInput[]
OR?: RoleScalarWhereInput[]
NOT?: RoleScalarWhereInput[]
}Dmitri Pisarev
07/15/2020, 3:43 PMJust want to highlight the fact that I'm using Prisma 1 with Mongo. Maybe there are some issues with it?
Dmitri Pisarev
07/15/2020, 4:06 PMIt's been removed from the Mongo version of Prisma. And not a word in the docs! This is BAD! https://github.com/prisma/prisma1/issues/3897
2 Views