check_migrated.py

# check_migrated_block

import csv
import os

import django

os.environ["DJANGO_SETTINGS_MODULE"] = "cdhweb.settings"
django.setup()

from cdhweb.pages.models import ContentPage, LandingPage
from cdhweb.events.models import Event
from cdhweb.projects.models import Project
from cdhweb.people.models import Profile

output = "migrated_content.csv"
csvfile = open(output, "w")
print(f"saving report to {output}")
csvwriter = csv.writer(csvfile)
csvwriter.writerow(["page_type", "url", "title"])

pagetypes = {
    "event": Event,
    "contentpage": ContentPage,
    "landingpage": LandingPage,
    "project": Project,
    "profile": Profile,
}

for pagetype, cls in pagetypes.items():
    print(f"checking {pagetype}")
    for page in cls.objects.live():
        if "migrated" in [b.block_type for b in page.body]:
            csvwriter.writerow([pagetype, page.full_url, page.title])