As an administrator I want to purge the old data in the streamer UI database

[aardkronkel]

so I have the data of last week still available to me. Currently, the purge command wipes all tabular data, using the following SQL statement:

TRUNCATE TABLE uploadsession, uploadfile

Implement the following end points:

/api/purge/all   (wipe all table data, i.e. using the SQL statement above)
/api/purge        (wipe old data, i.e. using the SQL statement below)

The following SQL statement is proposed to remove the old data:

DELETE FROM uploadsession WHERE DATE_TRUNC('day', start_time) = CURRENT_DATE - interval '7 days'; 
DELETE FROM uploadfile WHERE upload_session_id NOT IN (SELECT id FROM uploadsession);

• [x] Add /api/purge and /api/purge/all
• [x] Implement /api/purge
• [x] Update scripts
• [x] Test and deploy

[aardkronkel]

Fixed in release 3.0.2