Write script to query Code Ocean for stale runs and runs that can be removed

[jtyoung84]

User story

As an admin, I would like to know which Runs we could potentially delete so as to save space/cost.

Code Ocean Capsules and Pipelines have many Runs that store output files. In many cases these runs are part of the normal testing cycle and can be removed.

Acceptance criteria

• A script we can run regularly that produces a CSV with columns: capsule name, run datetime, size

Sprint Ready Checklist

• 1. Acceptance criteria defined
• 2. Team understands acceptance criteria
• 3. Team has defined solution / steps to satisfy acceptance criteria
• 4. Acceptance criteria is verifiable / testable
• 5. External / 3rd Party dependencies identified
• 6. Ticket is prioritized and sized

Notes

This script should not actually delete data - that will be a separate task.

*Original issue:

Code Ocean Capsules and Pipelines have many Runs that store output files. In many cases these runs are part of the normal testing cycle and can be removed.

Write a script uses the Code Ocean API to identify Runs that we could potentially delete. The script should output a CSV with the following columns:
1. Capsule name
2. Run date / time
3. Whether the Run was captured as a Data Asset
4. Total size of files

We should be able to generate this report whenever we like. Actually deleting data will be a separate task.

[dyf]

blocked because capsule API is missing

[jtyoung84]

Still blocked. Will follow up with Code Ocean.