migrations/Version20251106090800.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. * Auto-generated Migration: Please modify to your needs!
  12. */
  13. final class Version20251106090800 extends AbstractMigration
  14. {
  15. public function getDescription(): string
  16. {
  17. return '';
  18. }
  20. public function up(Schema $schema): void
  21. {
  22. // this up() migration is auto-generated, please modify it to your needs
  23. $this->addSql('ALTER TABLE channel_positioning_test_blocks ADD mandatory_info TEXT DEFAULT NULL, ADD example_enabled TINYINT(1) DEFAULT 1 NOT NULL, ADD example_label VARCHAR(255) DEFAULT NULL, ADD example_description TEXT DEFAULT NULL, ADD example_answers JSON DEFAULT NULL COMMENT \'(DC2Type:json)\'');
  24. }
  26. public function down(Schema $schema): void
  27. {
  28. // this down() migration is auto-generated, please modify it to your needs
  29. $this->addSql('ALTER TABLE channel_positioning_test_blocks DROP mandatory_info, DROP example_enabled, DROP example_label, DROP example_description, DROP example_answers');
  30. }
  32. public function postUp(Schema $schema): void
  33. {
  34. $this->connection->executeStatement(
  35. 'UPDATE `channel_positioning_test_blocks` SET mandatory_info = :text WHERE mandatory_info IS NULL',
  36. ['text' => "Chaque question est obligatoire. Une fois validé, le formulaire n’est plus modifiable.\nVeuillez vérifier vos réponses avant toute validation."]
  37. );
  38. $this->connection->executeStatement(
  39. 'UPDATE `channel_positioning_test_blocks` SET example_label = :text WHERE example_label IS NULL',
  40. ['text' => 'Quel(s) élément(s) sont nécessaires pour faire pousser une plante ?']
  41. );
  42. $this->connection->executeStatement(
  43. 'UPDATE `channel_positioning_test_blocks` SET example_description = :text WHERE example_description IS NULL',
  44. ['text' => '(Plusieurs réponses possibles)']
  45. );
  46. $answers = [
  47. [
  48. 'label' => 'La lumière du soleil',
  49. 'valid' => true,
  50. ],
  51. [
  52. 'label' => 'Le Wi-Fi',
  53. 'valid' => false,
  54. ],
  55. [
  56. 'label' => 'De l\'eau',
  57. 'valid' => true,
  58. ],
  59. [
  60. 'label' => 'De la terre',
  61. 'valid' => true,
  62. ],
  63. ];
  64. $this->connection->executeStatement(
  65. 'UPDATE `channel_positioning_test_blocks` SET example_answers = :array WHERE example_answers IS NULL',
  66. ['array' => json_encode($answers)]
  67. );
  68. }
  69. }