Alternative fix for duplicate results race condition

Our current fix for the duplicate results race condition [1] has the adverse effect of disabling further database updates for each pipeline result after it's written once to the database. Since our fix results in a single update the database ever per pipeline, it also works around the database lock exceptions we were seeing with the in-memory sqlite DB during testing.

This commit provides an alternative way to fix the race condition, along with a test to ensure that the database is properly updated when we get updated CI data. Sadly, we now get the database lock issue during testing again, hence we also need to disable the test.

[1] Commit edd5d4a5

Signed-off-by: Alexandros Frantzis alexandros.frantzis@collabora.com