Provide easy way to reset all data in database

[schickling]

No description provided.

[schickling]

Here's an initial design proposal. It's not clear to me yet where the best location for this feature would be but this should get the ball rolling and unblock users. As part of #265 we should rethink this further.

Important: When clicking the button, the user should be prompted with a confirmation pop up.

[schickling]

@madebysid can you implement the functionality for this yourself or does this depend on some (missing) SDK functionality?

[sdnts]

It is possible, I'll run a deleteMany on all models.

[janpio]

Please make sure that the need to put this somewhere more safe and hidden is tracked. Super scary, even if it needs 5 confirmations.

[matthewmueller]

Personally, I'd prefer if we handle this in the CLI today with a workflow like prisma truncate <models...>

Then when we go for it, we have the following UI:

Something to improve Soren's workflow is exporting the models from @prisma/client:

import { PrismaClient, models } from "@prisma/client"
const prisma = new PrismaClient()

for (let model of models) {
  await prisma[model].deleteMany()
}

I also think with Migrate will cover this use case better.

---

I'd very much prefer to leave this until post-Beta given that we have so many other fish to fry related to the databrowser.

[anasouardini]

This still open!!! We need a clearAllTables method.