1593917 - Add management script for cascade deleting old perf frameworks

Status: RESOLVED FIXED

(Tree Management :: Perfherder, task, P1)

Description

[Ionuț Goldan [:igoldan]]

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.

Comment 1

[GitHub Bugzilla PR Linker]

Attachment: Link to GitHub pull-request: https://github.com/mozilla/treeherder/pull/5594

Comment 2

[Armen [:armenzg]]

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})