Extract relations of releases to notes from legacy db to new schema in RNA

legacy_release_note_map.py

import json

from django.db.models import Q
from rna.models import Release, Note

def dump_release_notes_map(filename='release-notes-map.json'):
    "used on the legacy side with the legacy models"
    with open(filename, 'w') as f:
        json.dump(
            [(release.id, list(
                Note.objects.filter(
                    (Q(first_version__lte=release.version) &
                     (Q(fixed_in_version__isnull=True) |
                      Q(fixed_in_version__gte=release.version))) |
                    Q(fixed_in_version=release.version),
                    Q(product__name='Firefox') |
                    Q(product__name__isnull=True)).values_list('id', flat=True)))
             for release in Release.objects.all()],
            f)


def load_release_notes_map(filename='release-notes-map.json'):
    with open(filename) as f:
        for release_id, note_ids in json.load(f):
            release = Release.objects.get(id=release_id)
            release.note_set.add(*list(Note.objects.filter(id__in=note_ids)))