app/DoctrineMigrations/Version20240708164000.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 Version20240708164000 extends AbstractMigration
  14. {
  15.     const pages = [
  16.         [
  17.             'name' => '祈りに親しむ',
  18.             'url' => 'special_posts',
  19.             'file' => 'Special/index',
  20.         ],
  21.         [
  22.             'name' => '祈りに親しむ詳細',
  23.             'url' => 'special_post',
  24.             'file' => 'Special/detail',
  25.         ],
  26.     ];
  28.     public function up(Schema $schema): void
  29.     {
  30.         foreach (self::pages as $page) {
  31.             $pageExists = $this->connection->fetchOne("SELECT COUNT(*) FROM dtb_page WHERE page_name = '$page[name]'");
  32.             if ($pageExists > 0) {
  33.                 continue;
  34.             }
  36.             $sql = "INSERT INTO dtb_page SELECT
  37.                 max(id)+1,
  38.                 null,
  39.                 '$page[name]',
  40.                 '$page[url]',
  41.                 '$page[file]',
  42.                 0,
  43.                 null,
  44.                 null,
  45.                 null,
  46.                 CURRENT_TIMESTAMP,
  47.                 CURRENT_TIMESTAMP,
  48.                 null,
  49.                 null,
  50.                 'page'
  51.             FROM dtb_page;";
  52.             $this->addSql($sql);
  54.             $sql = "INSERT INTO dtb_page_layout SELECT
  55.                 max(id),
  56.                 2,
  57.                 max(id),
  58.                 'pagelayout'
  59.             FROM dtb_page;";
  60.             $this->addSql($sql);
  61.         }
  62.     }
  64.     public function down(Schema $schema): void
  65.     {
  66.         foreach (self::pages as $page) {
  67.             $sql = "DELETE pl FROM dtb_page_layout pl
  68.             LEFT JOIN dtb_page p
  69.             ON pl.page_id = p.id
  70.             WHERE p.page_name = '$page[name]';
  71.             ";
  72.             $this->addSql($sql);
  74.             $sql = "DELETE FROM dtb_page
  75.             WHERE page_name = '$page[name]';
  76.             ";
  77.             $this->addSql($sql);
  78.         }
  79.     }
  80. }