app/DoctrineMigrations/Version20240702100030.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 Version20240702100030 extends AbstractMigration
  14. {
  15.     const pages = [
  16.         [
  17.             'name' => 'ご利用ガイド詳細',
  18.             'url' => 'guide_detail',
  19.             'file' => 'guide_detail',
  20.         ],
  21.     ];
  23.     public function up(Schema $schema): void
  24.     {
  25.         foreach (self::pages as $page) {
  26.             $pageExists = $this->connection->fetchOne("SELECT COUNT(*) FROM dtb_page WHERE page_name = '$page[name]'");
  27.             if ($pageExists > 0) {
  28.                 continue;
  29.             }
  31.             $sql = "INSERT INTO dtb_page SELECT
  32.                 max(id)+1,
  33.                 null,
  34.                 '$page[name]',
  35.                 '$page[url]',
  36.                 '$page[file]',
  37.                 0,
  38.                 null,
  39.                 null,
  40.                 null,
  41.                 CURRENT_TIMESTAMP,
  42.                 CURRENT_TIMESTAMP,
  43.                 null,
  44.                 null,
  45.                 'page'
  46.             FROM dtb_page;";
  47.             $this->addSql($sql);
  49.             $sql = "INSERT INTO dtb_page_layout SELECT
  50.                 max(id),
  51.                 2,
  52.                 max(id),
  53.                 'pagelayout'
  54.             FROM dtb_page;";
  55.             $this->addSql($sql);
  56.         }
  57.     }
  59.     public function down(Schema $schema): void
  60.     {
  61.         foreach (self::pages as $page) {
  62.             $sql = "DELETE pl FROM dtb_page_layout pl
  63.             LEFT JOIN dtb_page p
  64.             ON pl.page_id = p.id
  65.             WHERE p.page_name = '$page[name]';
  66.             ";
  67.             $this->addSql($sql);
  69.             $sql = "DELETE FROM dtb_page
  70.             WHERE page_name = '$page[name]';
  71.             ";
  72.             $this->addSql($sql);
  73.         }
  74.     }
  75. }