How do we do soft delete with prisma? busy migrati...
# orm-helpp
Pieter
11/04/2020, 7:32 PMHow do we do soft delete with prisma? busy migrating from sequelize and we got deletedAt fields and it doesnt seem like prisma is respecting those when fetching.
j
Jonathan Romano
11/04/2020, 7:50 PMThis is not currently built in - a proposal for this is at https://github.com/prisma/prisma/issues/3398
Jonathan Romano
11/04/2020, 7:50 PMThis comment specifically suggests a middleware to implement this so that you don't need to manually include it in all queries: https://github.com/prisma/prisma/issues/3398#issuecomment-688320927
p
Pieter
11/04/2020, 7:51 PMThanks that helps
Pieter
11/04/2020, 7:52 PMOh wow, I had no idea prisma.$use existed!
Pieter
11/04/2020, 7:52 PMI can do all sorts of things with that!
prisma rainbow 2
Pieter
11/04/2020, 7:55 PMSo I could essentially do
Copy code
prisma.$use((params, next) => {
if(params.action === 'findMany')
params.args['where'] = { ...params.args['where'], deletedAt: null }
next(params)
})4 Views