1 | <?php |
||
2 | |||
3 | /** |
||
4 | * Copyright 2018 SURFnet bv |
||
5 | * |
||
6 | * Licensed under the Apache License, Version 2.0 (the "License"); |
||
7 | * you may not use this file except in compliance with the License. |
||
8 | * You may obtain a copy of the License at |
||
9 | * |
||
10 | * http://www.apache.org/licenses/LICENSE-2.0 |
||
11 | * |
||
12 | * Unless required by applicable law or agreed to in writing, software |
||
13 | * distributed under the License is distributed on an "AS IS" BASIS, |
||
14 | * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. |
||
15 | * See the License for the specific language governing permissions and |
||
16 | * limitations under the License. |
||
17 | */ |
||
0 ignored issues
–
show
Coding Style
introduced
by
![]() |
|||
18 | |||
19 | namespace Surfnet\Migrations; |
||
20 | |||
21 | use Doctrine\DBAL\Schema\Schema; |
||
22 | use Doctrine\Migrations\AbstractMigration; |
||
23 | |||
24 | /** |
||
25 | * Auto-generated Migration: Please modify to your needs! |
||
26 | */ |
||
0 ignored issues
–
show
|
|||
27 | class Version20181001082254 extends AbstractMigration |
||
28 | { |
||
29 | /** |
||
30 | * @param Schema $schema |
||
31 | */ |
||
0 ignored issues
–
show
|
|||
32 | public function up(Schema $schema): void |
||
33 | { |
||
34 | $authorizationRoles = [ |
||
35 | 'use_ra', |
||
36 | 'use_raa', |
||
37 | 'select_raa', |
||
38 | ]; |
||
39 | |||
40 | foreach ($authorizationRoles as $roleType) { |
||
41 | $this->addSql( |
||
42 | "INSERT IGNORE INTO institution_authorization(institution, institution_relation, institution_role) |
||
43 | SELECT institution, institution, '{$roleType}' FROM institution_configuration_options;", |
||
44 | ); |
||
45 | |||
46 | $this->addSql( |
||
47 | "INSERT IGNORE INTO institution_authorization(institution, institution_relation, institution_role) |
||
48 | SELECT institution, institution, '{$roleType}' FROM whitelist_entry;", |
||
49 | ); |
||
50 | } |
||
51 | } |
||
52 | |||
53 | /** |
||
54 | * @param Schema $schema |
||
55 | */ |
||
0 ignored issues
–
show
|
|||
56 | public function down(Schema $schema): void |
||
57 | { |
||
58 | // this down() migration is auto-generated, please modify it to your needs |
||
59 | } |
||
60 | } |
||
61 |