catalog->useTechnicalCatalog(); } protected function setUp(): void { parent::setUp(); $this->connection = $this->get('database_connection'); } public function test_it_updates_foreign_keys_of_oauth_code_table(): void { $this->dropForeignKeyIfExists('pim_api_auth_code', 'FK_AD5DC7C619EB6921'); $this->dropForeignKeyIfExists('pim_api_auth_code', 'FK_AD5DC7C6A76ED395'); $this->reExecuteMigration($this->getMigrationLabel()); Assert::assertTrue($this->foreignKeyHasDeleteCascade('pim_api_auth_code', 'FK_AD5DC7C619EB6921')); Assert::assertTrue($this->foreignKeyHasDeleteCascade('pim_api_auth_code', 'FK_AD5DC7C6A76ED395')); } private function dropForeignKeyIfExists(string $table, string $foreignKey): void { try { $this->connection->executeQuery(sprintf('ALTER TABLE %s DROP FOREIGN KEY %s', $table, $foreignKey)); } catch (Exception $e) { // ignore when the foreign did not exist } } private function foreignKeyHasDeleteCascade(string $table, string $foreignKey): bool { $database = $this->connection->getDatabase(); $query = <<connection->fetchOne($query, [ 'foreign_key' => $foreignKey, 'table' => $table, 'database' => $database, ]); return 'CASCADE' === $deleteRule; } private function getMigrationLabel(): string { $migration = (new \ReflectionClass($this))->getShortName(); $migration = str_replace('_Integration', '', $migration); $migration = str_replace('Version', '', $migration); return $migration; } }