migrations/Version20251126000000.php line 1

Open in your IDE?
  1. <?php
  3. declare(strict_types=1);
  5. namespace DoctrineMigrations;
  7. use Doctrine\DBAL\Schema\Schema;
  8. use Doctrine\Migrations\AbstractMigration;
  10. /**
  11. * Migration to update gemeinde psid values with Amtsblattportal UIDs
  12. */
  13. final class Version20251126000000 extends AbstractMigration
  14. {
  15. private array $gemeindePsids = [
  16. 'Alpthal' => 'e5995547-a5aa-11f0-95af-04505600900f',
  17. 'Altendorf' => '8bba1952-ca0d-11f0-a7a8-045056009022',
  18. 'Arth' => '5eb40870-a424-11f0-8b51-04505600904d',
  19. 'Einsiedeln' => '1cb8b3f7-a424-11f0-980a-04505600903b',
  20. 'Feusisberg' => '79f0c8a7-a42a-11f0-980a-04505600903b',
  21. 'Freienbach' => '94fd871e-a42a-11f0-980a-04505600903b',
  22. 'Galgenen' => 'c8815a31-a429-11f0-980a-04505600903b',
  23. 'Gersau' => 'ed08e8ad-a423-11f0-980a-04505600903b',
  24. 'Illgau' => '2c37e3ed-a429-11f0-980a-04505600903b',
  25. 'Ingenbohl' => '7b6fd5c1-a424-11f0-8b51-04505600904d',
  26. 'Innerthal' => 'f7dc009b-a429-11f0-980a-04505600903b',
  27. 'Küssnacht' => '3acb1154-a424-11f0-980a-04505600903b',
  28. 'Lachen' => '5dda580d-a429-11f0-980a-04505600903b',
  29. 'Lauerz' => '943ae464-a428-11f0-8b51-04505600904d',
  30. 'Morschach' => 'd015286f-a428-11f0-8b51-04505600904d',
  31. 'Muotathal' => '932d1b06-a424-11f0-980a-04505600903b',
  32. 'Oberiberg' => '547b5081-a428-11f0-980a-04505600903b',
  33. 'Reichenburg' => '62f1ca46-a42a-11f0-8b51-04505600904d',
  34. 'Riemenstalden' => '4ac230d8-a429-11f0-8b51-04505600904d',
  35. 'Rothenthurm' => '3787829f-a428-11f0-8b51-04505600904d',
  36. 'Sattel' => '200857b3-a428-11f0-980a-04505600903b',
  37. 'Schübelbach' => '121b5c82-a42a-11f0-8b51-04505600904d',
  38. 'Schwyz' => 'af23b976-a423-11f0-980a-04505600903b',
  39. 'Steinen' => '04d832d9-a428-11f0-980a-04505600903b',
  40. 'Steinerberg' => 'b5443b4e-a428-11f0-980a-04505600903b',
  41. 'Tuggen' => '2b4ddd1d-a42a-11f0-980a-04505600903b',
  42. 'Unteriberg' => '7c998c80-a428-11f0-980a-04505600903b',
  43. 'Vorderthal' => 'e5a14148-a429-11f0-8b51-04505600904d',
  44. 'Wangen' => '3b4f7493-a42a-11f0-8b51-04505600904d',
  45. 'Wollerau' => '79f0c8a7-a42a-11f0-980a-04505600903b',
  46. ];
  48. public function getDescription(): string
  49. {
  50. return 'Update gemeinde psid values with Amtsblattportal UIDs';
  51. }
  53. public function up(Schema $schema): void
  54. {
  55. // Update psid for each gemeinde
  56. foreach ($this->gemeindePsids as $gemeindeName => $psid) {
  57. $this->addSql(
  58. 'UPDATE gemeinde SET psid = ? WHERE name = ?',
  59. [$psid, $gemeindeName]
  60. );
  61. }
  62. }
  64. public function down(Schema $schema): void
  65. {
  66. // Set all psid values back to NULL
  67. foreach (array_keys($this->gemeindePsids) as $gemeindeName) {
  68. $this->addSql(
  69. 'UPDATE gemeinde SET psid = NULL WHERE name = ?',
  70. [$gemeindeName]
  71. );
  72. }
  73. }
  74. }