Prisma

Is there a way to iterate over all tables in a schema with the prisma client itself? So without using raw queries?

Do you just want the table names or the data?

Basically I want to call a function on each table

<@UESADRKMY> Sorry, don't know if I should tag you in these treads or if that's aggressive. I often overlook them myself though :sweat_smile:

One option is to use `dmmf`  to get table names:
```const prisma = new PrismaClient();

console.log(prisma._dmmf);```


In this object, you would get all the table names.

Thanks for your answer. I actually tried that, as well as iterating over the prisma object and then filtering the attributes that begin with an underscore. But how would I use thes strings then? Because `prisma[tableNam]`  doesn't seem to work?

It will work as long as the tableName matches the model name

You won't get TypeScript autocomplete but it will work

```export async function deleteAllTables(
  prismaClient: PrismaClient
): Promise&lt;void&gt; {
  for (const key of prismaClient._dmmf) {
    prismaClient[key].deleteMany({})
  }
}```

This doesn't work. Especially since _dmmf doesn't seem to be iterable

It’s inside a specific key in `_dmmf`. You need to log this entire object to get where the models are exactly located.

Yeah, sorry, should've added: that is `enumMap` as far as I can tell and it doesn't seem to be iterable as well

```   TypeError: prismaClient._dmmf.enumMap is not iterable

      107 |   prismaClient: PrismaClient
      108 | ): Promise&lt;void&gt; {
    &gt; 109 |   for (const key of prismaClient._dmmf.enumMap) {
          |                                        ^
      110 |     prismaClient[key].deleteMany({})
      111 |   }
      112 | }```

It would be an object, so you would need to use `Object.entries` to make it iterable.

Ah, makes sense. I will try that, thanks!