Complete drop procrastinate data

[ericsouza]

Is it possible to complete delete all data from procrastinate? While developing I often need to clean all jobs (hard delete) just so I don't need to deal if stalled or failed tasks in development.

[ewjoachim]

I don't know if there's a specifically official way of doing that but you can purge the jobs table. Given the cascade, it should be enough. I haven't done it often. Do you think there should be a function or something to facilitate that ?

[ericsouza]

Yes, sounds really useful for me and I think others might also be benefit from it 😄

[ewjoachim]

What could be an appropriate API for doing that in your opinion ? And how would we secure it to avoid erroneously doing it in production ?

[medihack]

Yes, I also sometimes miss a script in development to make this easier. Usually, I log in with pgsql and do it manually, but just a small script (with a confirmation, of course) would make things easier.