How can I re-write not commented code in one reque...
# orm-helpg
Gorodov Maksim
06/28/2018, 2:51 PMHow can I re-write not commented code in one request? I tried to do like in commented code, but I got error
Field "OR" is not defined by type UserWhereUniqueInput.j
Jenkins
06/28/2018, 3:05 PMAs far as I can see what you've done is correct... Looking at my own schema, OR is a valid member of UserWhereInput and expects an array of UserWhereInput. Hopefully someone comes around who's able to help you!
g
Gorodov Maksim
06/28/2018, 3:07 PMyea, i hope that somebody will help me too because i took this concept from tutorial in docs and i was surprised when I got such error
j
Jenkins
06/28/2018, 3:14 PMAaaah, I see why.
Jenkins
06/28/2018, 3:15 PMEither email or nick is unique. You can't do OR'ing on unique keys. In mine I have two unique fields, id and email, and this
Copy code
type UserWhereUniqueInput {
id: ID
email: String
}g
Gorodov Maksim
06/28/2018, 3:19 PMyea, i have been thinking about it but i think it is okay to do OR if u have same value for both unique fields
j
Jenkins
06/28/2018, 3:23 PMIt's not part of the schema, so I don't know. I can only use what I can see.
Jenkins
06/28/2018, 3:25 PMUse context.prisma.query.users instead. OR doesn't exists on the "query.user" schema.
Jenkins
06/28/2018, 3:26 PMYou just have to assert that you only have one. Can be done with
const [user, ...rest] = context.prisma.query.users({your stuff}); if (rest) {shit}g
Gorodov Maksim
06/28/2018, 3:26 PMu think it is a good idea to use users for searching one user?
j
Jenkins
06/28/2018, 3:27 PMIt's the only user query path that has an OR operator.
Jenkins
06/28/2018, 3:27 PMJust assert that there was only one with similar code to what I wrote above.
g
Gorodov Maksim
06/28/2018, 3:33 PMhow do u think it will be better than do 2 requests or not?
j
Jenkins
06/28/2018, 3:36 PMI'd probably do the OR query as it's a single query to the database and not two, as in your circumstance.
g
Gorodov Maksim
06/28/2018, 3:52 PMthanks, i did like u said and it works 🙂 but i have one strange thing...
here i get an array with one object
const user = await context.prisma.query.users(
{
where: {
OR: [
{ email: args.login, },
{ nickname: args.login },
],
},
},
);
so, then i should use it like user[0]
but if I do this, i get undefined, wtf?))
const user = await context.prisma.query.users(
{
where: {
OR: [
{ email: args.login, },
{ nickname: args.login },
],
},
},
)[0];
Gorodov Maksim
06/28/2018, 3:52 PMis it because it is await function or what?
j
Jenkins
06/28/2018, 6:02 PMYes, sorry for the late reply. I'd recommend to do arraay deconstruction. const [user, ...rest] = db.query...
user will have your user if it exists and if rest is not undefined then you have a problem... 😛
❤️ 1
g
Gorodov Maksim
06/29/2018, 5:37 AM@Jenkins yep, that works, thank u so much :))