Where clause with multiple values

[danielweil]

Hey,

Is there any way to use IN and NOT IN for normal kind of columns in the where clause?

Ex: Get the objects from the db from a list of IDs.

Sorry for opening an issue, I searched the docs but couldn't find it.

[RobertCraigie]

What do you mean by normal kind of columns?

[danielweil]

Integers and strings.

[RobertCraigie]

I need to improve the structure of the documentation.

You can find the documentation for these operations here:
https://prisma-client-py.readthedocs.io/en/stable/reference/operations/#string-fields

[RobertCraigie]

May I ask where you were looking in the documentation before?

I find it difficult to know whether or not the documentation I've written is well structured so any feedback would be greatly appreciated :)

[danielweil]

Guess it is my fault.

I passed it through the page but thought that "desc" could be ordering descenent. My Bad!

Thanks!

[RobertCraigie]

Don't worry about it, the documentation does need some work.

[RobertCraigie]

Ah I see, I should use a different field name to showcase that API.

[danielweil]

Can I ask you another doubt?

I am trying to update a foreign key in my object, and I saw previously that I had to use "connect" keywork.

I was able to make it work in create clauses, but not in update. Can you help me out?

[RobertCraigie]

@danielweil I think this is actually a bug, let me look into it further.

[RobertCraigie]

@danielweil You can't update a relation in an update_many query.

[RobertCraigie]

prisma/prisma#3143

[danielweil]

How should go on for now?

[RobertCraigie]

You could try using query batching and switch to making multiple update calls instead of one update_many: https://prisma-client-py.readthedocs.io/en/stable/reference/batching/

However, I don't know if this will work for your use case

[danielweil]

Should raw queries work? I tried using it for the update and it gave me this error:

[RobertCraigie]

That looks like it could be a bug, Clcan you share the debug logs please?

https://prisma-client-py.readthedocs.io/en/stable/reference/logging/#debugging-the-client

[danielweil]

Thanks! I could fix the problem with the message!. Thanks