Prisma, how to clear the database
While testing a site that used Prisma I had the need to clear the database from time to time, to clear the test data I entered.
You can clear items entered by using:
await prisma.user.deleteMany({})
If for some reason you want to iterate on the items to do some processing, you can iterate over them in this way:
const users = await prisma.user.findMany({})
const deleteUser = async (user) => {
return await prisma.user.delete({
where: { id: user.id }
})
}
const deleteUsers = async () => {
users.map((user) => deleteUser(user))
}
deleteUsers()
In this case I am not doing anything more than the previous example, which makes all this code redundant, but you could do anything you want inside deleteUser()
.
I had a problem though because I had a relation between 2 tables, tweets and users. A tweet was associated to a user. First I had to remove all tweets, then remove all users, so I wrote this function:
export const clearData = async (prisma) => {
const users = await prisma.user.findMany({})
const tweets = await prisma.tweet.findMany({})
const deleteUser = async (user) => {
return await prisma.user.delete({
where: { id: user.id }
})
}
const deleteTweet = async (tweet) => {
return await prisma.tweet.delete({
where: { id: tweet.id }
})
}
const deleteTweets = async () => {
return Promise.all(tweets.map((tweet) => deleteTweet(tweet)))
}
const deleteUsers = async () => {
return Promise.all(users.map((user) => deleteUser(user)))
}
await deleteTweets()
await deleteUsers()
}
Notice the use of Promise.all()
to wrap users.map()
so I could use await
on it, so all tweets are removed before I start deleting users.
I wrote 17 books to help you become a better developer, download them all at $0 cost by joining my newsletter
- C Handbook
- Command Line Handbook
- CSS Handbook
- Express Handbook
- Git Cheat Sheet
- Go Handbook
- HTML Handbook
- JS Handbook
- Laravel Handbook
- Next.js Handbook
- Node.js Handbook
- PHP Handbook
- Python Handbook
- React Handbook
- SQL Handbook
- Svelte Handbook
- Swift Handbook
JOIN MY CODING BOOTCAMP, an amazing cohort course that will be a huge step up in your coding career - covering React, Next.js - next edition February 2025