Closed Bug 1593917 Opened 6 years ago Closed 6 years ago

Add management script for cascade deleting old perf frameworks

Categories

(Tree Management :: Perfherder, task, P1)

Tracking

(Not tracked)

RESOLVED FIXED

People

(Reporter: igoldan, Assigned: igoldan)

References

Details

(Keywords: leave-open)

Attachments

(1 file)

This is a follow up for bug 1516630.

Django only provides cascade deletes on ORM level, not on database level. Basically, we won't be able to cascade delete using raw SQL queries. At least, it's not something trivial.

Once this ticket is merged & executed on all our environments (including production), this script must be deleted from source code.

Keywords: leave-open
armenzg@Armens-MacBook-Pro treeherder % heroku run --app treeherder-prod bash
Running bash on ⬢ treeherder-prod... up, run.5787 (Standard-1X)
~ $ ./manage.py shell
Python 3.7.2 (default, Jan 29 2019, 19:41:29)
[GCC 7.3.0] on linux
Type "help", "copyright", "credits" or "license" for more information.
(InteractiveConsole)
>>> from treeherder.perf.models import PerformanceFramework
>>> PerformanceFramework.objects.filter(name__in=['talos-aws', 'hasal', 'servo-perf', 'autophone']).delete()
(474, {'perf.PerformanceAlert': 0, 'perf.PerformanceBugTemplate': 1, 'perf.PerformanceAlertSummary': 469, 'perf.PerformanceFramework': 4})
Status: NEW → RESOLVED
Closed: 6 years ago
Resolution: --- → FIXED
You need to log in before you can comment on or make changes to this bug.

Attachment

General

Created:
Updated:
Size: