Surfnet\StepupMiddleware\Migrations\Version20181001082254::up()

Complexity

Conditions	2
Paths	2

Size

Total Lines

20

Duplication

Lines	0
Ratio	0 %

Importance

Changes

0

<?php
    public function up(Schema $schema)
    {
        $authorizationRoles = [
            'use_ra',
            'use_raa',
            'select_raa',
        ];

        foreach ($authorizationRoles as $roleType) {
            $this->addSql(
                "INSERT IGNORE INTO institution_authorization(institution, institution_relation, institution_role)
                SELECT institution, institution, '{$roleType}' FROM institution_configuration_options;"
            );

            $this->addSql(
                "INSERT IGNORE INTO institution_authorization(institution, institution_relation, institution_role)
                SELECT institution, institution, '{$roleType}' FROM whitelist_entry;"
            );
        }
    }