]>
Commit | Line | Data |
---|---|---|
23406ca3 NL |
1 | <?php |
2 | ||
3 | namespace Application\Migrations; | |
4 | ||
5 | use Doctrine\DBAL\Migrations\AbstractMigration; | |
6 | use Doctrine\DBAL\Schema\Schema; | |
7 | use Symfony\Component\DependencyInjection\ContainerAwareInterface; | |
8 | use Symfony\Component\DependencyInjection\ContainerInterface; | |
9 | ||
b87f1712 | 10 | /** |
01736b5a | 11 | * Added user_id column on oauth2_clients to prevent users to delete API clients from other users. |
b87f1712 | 12 | */ |
23406ca3 NL |
13 | class Version20161024212538 extends AbstractMigration implements ContainerAwareInterface |
14 | { | |
15 | /** | |
16 | * @var ContainerInterface | |
17 | */ | |
18 | private $container; | |
19 | ||
4acbeb93 NL |
20 | private $constraintName = 'IDX_user_oauth_client'; |
21 | ||
23406ca3 NL |
22 | public function setContainer(ContainerInterface $container = null) |
23 | { | |
24 | $this->container = $container; | |
25 | } | |
26 | ||
23406ca3 NL |
27 | /** |
28 | * @param Schema $schema | |
29 | */ | |
30 | public function up(Schema $schema) | |
31 | { | |
84c6a48d | 32 | $clientsTable = $schema->getTable($this->getTable('oauth2_clients')); |
23406ca3 | 33 | |
84c6a48d | 34 | $this->skipIf($clientsTable->hasColumn('user_id'), 'It seems that you already played this migration.'); |
18d7bc3a | 35 | |
4acbeb93 | 36 | $clientsTable->addColumn('user_id', 'integer', ['notnull' => false]); |
84c6a48d NL |
37 | |
38 | $clientsTable->addForeignKeyConstraint( | |
39 | $this->getTable('user'), | |
65a8c6e1 NL |
40 | ['user_id'], |
41 | ['id'], | |
4acbeb93 NL |
42 | ['onDelete' => 'CASCADE'], |
43 | $this->constraintName | |
84c6a48d | 44 | ); |
23406ca3 NL |
45 | } |
46 | ||
47 | /** | |
48 | * @param Schema $schema | |
49 | */ | |
50 | public function down(Schema $schema) | |
51 | { | |
4acbeb93 NL |
52 | $clientsTable = $schema->getTable($this->getTable('oauth2_clients')); |
53 | ||
54 | $this->skipIf(!$clientsTable->hasColumn('user_id'), 'It seems that you already played this migration.'); | |
55 | ||
56 | $clientsTable->dropColumn('user_id', 'integer'); | |
57 | ||
3ef055ce | 58 | if ('sqlite' !== $this->connection->getDatabasePlatform()->getName()) { |
4acbeb93 NL |
59 | $clientsTable->removeForeignKey($this->constraintName); |
60 | } | |
23406ca3 | 61 | } |
f808b016 JB |
62 | |
63 | private function getTable($tableName) | |
64 | { | |
65 | return $this->container->getParameter('database_table_prefix') . $tableName; | |
66 | } | |
23406ca3 | 67 | } |