Allow multiple test execution runs

[omar-selo]

Description

Includes the following changes:

• Drop unneeded review columns from Test Execution (now that the previous migration seems to have been safe)
• Remove uniqueness constraint on Test Executions to allow multiple to exist in case of reruns
• Remove automatic approvals (needs a separate revisit)
• Show multiple test execution runs on the frontend
• Replace test execution status filter with last test execution status filter (required a small refactor)
• Group previous test results by artefact version
• Reverse order of previous results and add the current result as large icon https://warthogs.atlassian.net/browse/RTW-398
• Fix issues and improve performance of previous results query https://warthogs.atlassian.net/browse/RTW-408

Notes:

• Test result history now shows history including previous runs
• Environment expandable has a test execution status icon next to it for the last run
• Among the changes to the query that fetches previous results, it now doesn't only consider latest builds. This is because we've learned during the sprint that newer builds should be considered as reruns. There are more changes that need to be done to get there, but this is a first step

Resolved issues

Resolves https://warthogs.atlassian.net/browse/RTW-387 Resolves https://warthogs.atlassian.net/browse/RTW-398 Resolves https://warthogs.atlassian.net/browse/RTW-408

Documentation

Web service API changes

Nothing.

Tests

Added some automated tests. And manually tested the frontend.

Screencast from 2024-11-22 17-31-50.webm

[omar-selo]

Converted PR to draft as I still need to group historic test results by artefact version.

[omar-selo]

I know we are introducing some limitations with this change, such as the the summary of test executions (artefact environments) that we used to have will now be gone, but I think this is all known in the implementation plan and we will provide the equivalent after we complete all phases.

Good catch. I actually missed this. I've added it back using the latest test execution result for each environment.