migrations/Version20250809135930.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. * Content Recommendation State Values Migration
  12. *
  13. * This migration updates the state field values in the content_recommendation table
  14. * to use the new standardized mapping:
  15. *
  16. * NEW MAPPING (after migration):
  17. * - 1 = NEW (default state for new recommendations)
  18. * - 2 = ACCEPTED (recommendation approved)
  19. * - 3 = REJECTED (recommendation declined)
  20. *
  21. * OLD MAPPING (before migration):
  22. * - 1 = ACCEPTED
  23. * - 2 = REJECTED
  24. * - 3 = NEW
  25. *
  26. * The migration preserves existing data by converting old values to new values.
  27. */
  28. final class Version20250809135930 extends AbstractMigration
  29. {
  30. public function getDescription(): string
  31. {
  32. return 'Update ContentRecommendation state values: 1=New, 2=Accepted, 3=Rejected';
  33. }
  35. public function up(Schema $schema): void
  36. {
  37. // Update existing state values to match new mapping:
  38. // Old: 1=Accepted, 2=Rejected, 3=New
  39. // New: 1=New, 2=Accepted, 3=Rejected
  41. // Create a temporary column to store the converted values
  42. $this->addSql('ALTER TABLE content_recommendation ADD COLUMN state_temp INT');
  44. // Convert the values:
  45. // Old 1 (Accepted) -> New 2 (Accepted)
  46. $this->addSql('UPDATE content_recommendation SET state_temp = 2 WHERE state = 1');
  47. // Old 2 (Rejected) -> New 3 (Rejected)
  48. $this->addSql('UPDATE content_recommendation SET state_temp = 3 WHERE state = 2');
  49. // Old 3 (New) -> New 1 (New)
  50. $this->addSql('UPDATE content_recommendation SET state_temp = 1 WHERE state = 3');
  52. // Copy converted values back to state column
  53. $this->addSql('UPDATE content_recommendation SET state = state_temp');
  55. // Drop temporary column
  56. $this->addSql('ALTER TABLE content_recommendation DROP COLUMN state_temp');
  57. }
  59. public function down(Schema $schema): void
  60. {
  61. // Revert state values to original mapping:
  62. // New: 1=New, 2=Accepted, 3=Rejected
  63. // Old: 1=Accepted, 2=Rejected, 3=New
  65. // Create a temporary column to store the converted values
  66. $this->addSql('ALTER TABLE content_recommendation ADD COLUMN state_temp INT');
  68. // Convert the values back:
  69. // New 1 (New) -> Old 3 (New)
  70. $this->addSql('UPDATE content_recommendation SET state_temp = 3 WHERE state = 1');
  71. // New 2 (Accepted) -> Old 1 (Accepted)
  72. $this->addSql('UPDATE content_recommendation SET state_temp = 1 WHERE state = 2');
  73. // New 3 (Rejected) -> Old 2 (Rejected)
  74. $this->addSql('UPDATE content_recommendation SET state_temp = 2 WHERE state = 3');
  76. // Copy converted values back to state column
  77. $this->addSql('UPDATE content_recommendation SET state = state_temp');
  79. // Drop temporary column
  80. $this->addSql('ALTER TABLE content_recommendation DROP COLUMN state_temp');
  81. }
  82. }