# Generated by Django 4.0.6 on 2022-09-05 09:44

from django.db import migrations


class Migration(migrations.Migration):

    dependencies = [
        ('question_bank', '0021_questionbank__subscribers'),
    ]

    def modify(apps, schema_editor):

        QuestionBankAccessibility = apps.get_model(
            "question_bank", "QuestionBankAccessibility")
        QuestionBank = apps.get_model("question_bank", "QuestionBank")

        db_alias = schema_editor.connection.alias
        qb_queryset = QuestionBank.objects.using(db_alias).all()

        for qb in qb_queryset:
            accessibilities = QuestionBankAccessibility.objects.using(
                db_alias).filter(question_bank=qb)

            qb._subscribers = [
                accessibility.institute.pk for accessibility in accessibilities]

            if qb.institute.pk not in qb._subscribers:
                qb._subscribers.append(qb.institute.pk)

            qb.save()

    operations = [
        migrations.RunPython(modify),
    ]