Issues (4057)

Branch: main

src/Surfnet/Migrations/Version20141125173004.php (8 issues)

1
<?php
2
3
/**
4
 * Copyright 2014 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
Missing @link tag in file comment
Loading history...
18
19
namespace Surfnet\Migrations;
20
21
use Doctrine\DBAL\Schema\Schema;
22
use Doctrine\Migrations\AbstractMigration;
23
use Surfnet\Stepup\MigrationsFactory\ConfigurationAwareMigrationInterface;
24
use Surfnet\Stepup\MigrationsFactory\ConfigurationAwareMigrationTrait;
25
26
/**
27
 * Auto-generated Migration: Please modify to your needs!
28
 */
0 ignored issues
show
Missing @category tag in class comment
Loading history...
Missing @package tag in class comment
Loading history...
Missing @author tag in class comment
Loading history...
Missing @license tag in class comment
Loading history...
Missing @link tag in class comment
Loading history...
29
class Version20141125173004 extends AbstractMigration implements ConfigurationAwareMigrationInterface
30
{
31
    use ConfigurationAwareMigrationTrait;
32
33
    public function up(Schema $schema): void
34
    {
35
        $gatewaySchema = $this->getGatewaySchema();
36
        $middlewareUser = $this->getMiddlewareUser();
37
38
        // this up() migration is auto-generated, please modify it to your needs
39
        $this->abortIf(
40
            $this->connection->getDatabasePlatform()->getName() != 'mysql',
0 ignored issues
show
Deprecated Code introduced by
The function Doctrine\DBAL\Platforms\...ractPlatform::getName() has been deprecated: Identify platforms by their class. ( Ignorable by Annotation )

If this is a false-positive, you can also ignore this issue in your code via the ignore-deprecated  annotation

40
            /** @scrutinizer ignore-deprecated */ $this->connection->getDatabasePlatform()->getName() != 'mysql',

This function has been deprecated. The supplier of the function has supplied an explanatory message.

The explanatory message should give you some clue as to whether and when the function will be removed and what other function to use instead.

Loading history...
41
            'Migration can only be executed safely on \'mysql\'.',
42
        );
43
44
        $this->addSql(
45
            sprintf(
46
                'CREATE TABLE %s.saml_entity (entity_id VARCHAR(255) NOT NULL, type VARCHAR(255) NOT NULL, configuration LONGTEXT NOT NULL, PRIMARY KEY(entity_id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB',
47
                $gatewaySchema,
48
            ),
49
        );
50
        $this->addSql(
51
            sprintf("GRANT DELETE,INSERT,SELECT,UPDATE ON %s.saml_entity TO %s", $gatewaySchema, $middlewareUser),
52
        );
53
    }
54
55
    public function down(Schema $schema): void
56
    {
57
        $gatewaySchema = $this->getGatewaySchema();
58
        $middlewareUser = $this->getMiddlewareUser();
59
60
        // this down() migration is auto-generated, please modify it to your needs
61
        $this->abortIf(
62
            $this->connection->getDatabasePlatform()->getName() != 'mysql',
0 ignored issues
show
Deprecated Code introduced by
The function Doctrine\DBAL\Platforms\...ractPlatform::getName() has been deprecated: Identify platforms by their class. ( Ignorable by Annotation )

If this is a false-positive, you can also ignore this issue in your code via the ignore-deprecated  annotation

62
            /** @scrutinizer ignore-deprecated */ $this->connection->getDatabasePlatform()->getName() != 'mysql',

This function has been deprecated. The supplier of the function has supplied an explanatory message.

The explanatory message should give you some clue as to whether and when the function will be removed and what other function to use instead.

Loading history...
63
            'Migration can only be executed safely on \'mysql\'.',
64
        );
65
66
        $this->addSql(
67
            sprintf("REVOKE DELETE,INSERT,SELECT,UPDATE ON %s.saml_entity FROM %s", $gatewaySchema, $middlewareUser),
68
        );
69
        $this->addSql(sprintf('DROP TABLE %s.saml_entity', $gatewaySchema));
70
    }
71
}
72