PNI creepy ratings on non-English pages is in the wrong order

[Pomax]

How to Reproduce:

This was flagged on Twitter https://twitter.com/dtdan03/status/1441837328323031044 and was confirmed by staff

• Go to https://foundation.mozilla.org/fr/privacynotincluded/categories/video-call-apps/
• Notice apps like https://foundation.mozilla.org/fr/privacynotincluded/threema/ that have rated least creepy, are appearing towards the bottom of the page (it should be at the top of the page like it is on English version)

[Pomax]

Looking at the DOM, the code shows:

However, looking at Viber (the first item) in the database, it has 224 votes, with a spread of 22%, 21%, 36%, 10%, and 11% which means it cannot possibly have an average creepiness of 0,18834080717488788

[Pomax]

Looking at the stats for respective locales, it appears that voting is storing values "for localized products" independently of the original English product, So that's not great. Solving this one will require:

• updating the POST handling to make sure that given a product ID, we find the original product to update the votes for
• update the product model to find the original product on which to check the creepiness values
• write migrations that merge votes from all locales back to the original product.

[Pomax]

Current code in products.py:

    @property
    def total_vote_count(self):
        return sum(self.get_or_create_votes())

    @property
    def creepiness(self):
        try:
            average = self.creepiness_value / self.total_vote_count
        except ZeroDivisionError:
            average = 50
        return average

This needs those self replaced with product, based on finding the "real" product given a localized product.

Similarly, the POST code currently reads:

        if request.body and request.method == "POST":
            data = json.loads(request.body)
            if data.get("value"):
                ...
                try:
                    product = ProductPage.objects.get(pk=self.id)
                    ...

where this product, too, should be resolved to the original English product, not the localized product.

[Pomax]

Looking at the stage and prod db, I think we can get away with code-fixes only, there's a whole bunch of "zero vote" records in the database, but as far as I can they're not actually linked to any products (anymore?). So the PR for this will be code + tests without a cleanup management command. However, I will be filing a cleanup issue for "when we have time for cleanup" to see if we can safely remove those records from the database.

[Pomax]

Also, given that we're going to have to add a secondary locale as part of the test framework before can even write tests this works correctly in an automated fashion, I'm going to file that as separate issue, too, and we can land this first with manual testing, then figure out how to do secondary locales (in both unit tests and load_fake_data) separaterly.