app/DoctrineMigrations/Version20161024212538.php

   1 <?php
   2
   3 namespace Application\Migrations;
   4
   5 use Doctrine\DBAL\Schema\Schema;
   6 use Wallabag\CoreBundle\Doctrine\WallabagMigration;
   7
   8 /**
   9  * Added user_id column on oauth2_clients to prevent users to delete API clients from other users.
  10  */
  11 class Version20161024212538 extends WallabagMigration
  12 {
  13     private $constraintName = 'IDX_user_oauth_client';
  14
  15     /**
  16      * @param Schema $schema
  17      */
  18     public function up(Schema $schema)
  19     {
  20         $clientsTable = $schema->getTable($this->getTable('oauth2_clients'));
  21
  22         $this->skipIf($clientsTable->hasColumn('user_id'), 'It seems that you already played this migration.');
  23
  24         $clientsTable->addColumn('user_id', 'integer', ['notnull' => false]);
  25
  26         $clientsTable->addForeignKeyConstraint(
  27             $this->getTable('user'),
  28             ['user_id'],
  29             ['id'],
  30             ['onDelete' => 'CASCADE'],
  31             $this->constraintName
  32         );
  33     }
  34
  35     /**
  36      * @param Schema $schema
  37      */
  38     public function down(Schema $schema)
  39     {
  40         $clientsTable = $schema->getTable($this->getTable('oauth2_clients'));
  41
  42         $this->skipIf(!$clientsTable->hasColumn('user_id'), 'It seems that you already played this migration.');
  43
  44         $clientsTable->dropColumn('user_id', 'integer');
  45
  46         if ('sqlite' !== $this->connection->getDatabasePlatform()->getName()) {
  47             $clientsTable->removeForeignKey($this->constraintName);
  48         }
  49     }
  50 }