Items that have been uploaded more than 6 months before should be automatically deleted 🧹

[camelPhonso]

Expected Behaviour

If an item has been added to the database more than 6 months ago it should be deleted to avoid us overloading our storage and to promote new items moving through the app.

This issue will require spiking the following questions:

• what happens if an item has been available for more than 6 months but there are active conversations relating to this issue?
• should the donor receive a notification that their item will be deleted if it is not given away soon ?
  • how would we notify them of this?

Current Behaviour

Items are available on kindly until the donor removes them.

Steps to Reproduce

1. In your seed.js file manually add an entry for an item with the created_at value set to more than 6 months before
2. Log in and visit your profile
3. The item is still visible in your list
4. Run npx supabase status on your terminal
5. Visit the Studio Url link and navigate to Table Editor > Items
6. Your Item entry is visible in the Items table

[github-actions]

🤖 meep morp!

Thank you for your contribution @idellien - this Issue is assigned to you as requested ✨

🔎 Please keep in mind that in order to give everyone a chance to contribute Issues may be unassigned if they go stale.
You will be warned if the Issue is marked as stale at any point.

🔎 Please review our documentation for guidance on:

• common Patterns we follow in the code base
• conventions set for commit messages and naming of functions, classes or files

💡 The core team is available for any help and will try to respond to any comments in this Issue or questions on discord as quickly as possible.

Happy coding ! 🦆

[idelinz]

!request

[github-actions]

🤖 meep morp!

Thank you for your contribution @idellien - this Issue is assigned to you as requested ✨

🔎 Please keep in mind that in order to give everyone a chance to contribute Issues may be unassigned if they go stale.
You will be warned if the Issue is marked as stale at any point.

🔎 Please review our documentation for guidance on:

• common Patterns we follow in the code base
• conventions set for commit messages and naming of functions, classes or files

💡 The core team is available for any help and will try to respond to any comments in this Issue or questions on discord as quickly as possible.

Happy coding ! 🦆

[AnyaVeselova]

Hi! Can I take on this issue?

!request