findMany returns zero entries

[i4lina]

Hi, I came across something strange. I have a database with a table called postBackup. If I look up the table using prisma studio I'm able to browse all the entries without problems. However, if I run await prisma.postBackup.findMany() I always get 0 results. I have run all the migrations and I generated the prisma client on the latest schema. How can I solve this?

I'm running the latest prisma version. Thanks for your help!

[gustavo-maurina]

Is the value returned from this piece code an actual empty array? Or is it something else? If you put that inside a try-catch block and throw the Error, is there nothing being thrown?

[i4lina]

I was trying with this script

const main = async () => {
  const postsToChange = await prisma.postBackup.findMany();
  console.log(postsToChange);
};

main();

And all I got was 0, as per the number. I tried again and now it seems to work. I don't know what was happening, I tried running the code several times, changing the query parameter but the results where always the same.

[gustavo-maurina]

Good that its working, just try wrap a try-catch block around that and throw errors, you might find useful errors that way