snippet to be run in django-admin shell `./manage.py shell` to bulk add certs from 'certs.txt' file in format [issuer: xx serial: yy].

bulkaddcerts.py

from olympia.blocklist.models import BlocklistDetail, BlocklistIssuerCert


def addCert(issuer, serial, name, bug):
    detail = BlocklistDetail(name=name, why='.', who='.', bug=bug)
    detail.save()
    cert = BlocklistIssuerCert(issuer=issuer, serial=serial, details=detail)
    cert.save()


def handle(*args, **options):
    fn = options['file']
    name = options['name']
    bug = options['bug']
    with open(fn, 'r') as input_file:
        for line in input_file:
            [_, issuer, _, serial] = line.strip().split(' ')
            if serial and issuer:
                addCert(issuer, serial, name, bug)

bug = 'https://bugzilla.mozilla.org/show_bug.cgi?id=1312150'
name = 'Revoked intermediates'
ffile = 'certs.txt'
handle(bug=bug, name=name, file=ffile)