Delete website Data for a Specified Period and Implement Import/Export Functionality

[LahlouMohamed]

Describe the feature or enhancement

Objective
Add the ability to delete data for a specified period for Umami users.

Context
This feature aims to improve performance management by allowing the deletion of data within specific date ranges. This helps to maintain a lighter and more performant database. Additionally, an import/export feature will be ideal for archiving complete periods before deletion.

Implementation Details

Database
Addition of cascading delete functionality to ensure that all data related to a specific period is correctly removed.
Update of database schemas and necessary migration scripts.

API
Create a new API endpoint that takes two parameters: startDate and endDate.
Implement the logic for deleting data (event_data) within this date range.

Frontend
Add a user interface to select a date range and initiate the deletion of the corresponding data.
Display appropriate confirmations and alerts to prevent accidental deletions.

Import/Export
Set up API endpoints for exporting and importing data for a specified period.
Create user interfaces to facilitate data export and import before deletion.

Screenshot

[franciscao633]

Import / Export date ranges definitely needs to be done. I think if the main purpose to delete data is performance, I would rather focus on pure performance changes.