Skip to content
This repository has been archived by the owner on Dec 20, 2022. It is now read-only.

Auto DB cleanup #140

Open
dldnhf opened this issue Mar 12, 2021 · 0 comments
Open

Auto DB cleanup #140

dldnhf opened this issue Mar 12, 2021 · 0 comments
Labels
Prio: Triage Triage Priority Status: Pending Issue or PR awaits response Type: Feature Issue or PR is a new feature

Comments

@dldnhf
Copy link

dldnhf commented Mar 12, 2021

Feature request

Expected Behavior - What where you expecting to happen?

LicenseScout should delete data which is older than a configurable retention period from the results database.

Possible Solution

DELETE FROM Builds WHERE Datetime < NOW() - INTERVAL 'n days'
(n being a configurable parameter for the retention period in days)
@dldnhf dldnhf added Prio: Triage Triage Priority Status: Pending Issue or PR awaits response Type: Feature Issue or PR is a new feature labels Mar 12, 2021
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Assignees
No one assigned
Labels
Prio: Triage Triage Priority Status: Pending Issue or PR awaits response Type: Feature Issue or PR is a new feature
Milestone
No milestone
Development

No branches or pull requests
1 participant
@dldnhf