Symfony Profiler

<?php
declare(strict_types=1);
namespace DoctrineMigrations;
use Doctrine\DBAL\Schema\Schema;
use Doctrine\Migrations\AbstractMigration;
/**
* Auto-generated Migration: Please modify to your needs!
*/
final class Version20240411011507 extends AbstractMigration
{
public function getDescription(): string
{
return '';
}
public function up(Schema $schema): void
{
$count = $this->connection->fetchOne("SELECT COUNT(*) FROM dtb_page WHERE url = 'guide_submit'");
if ($count > 0) {
return;
}
$pageId = $this->connection->fetchOne('SELECT MAX(id) FROM dtb_page');
$sortNo = $this->connection->fetchOne('SELECT MAX(sort_no) FROM dtb_page_layout');
// 入稿データガイド
$pageId++;
$this->addSql("INSERT INTO dtb_page (
id, master_page_id, page_name, url, file_name, edit_type, create_date, update_date, meta_robots, discriminator_type
) VALUES(
$pageId, NULL, '入稿データガイド', 'guide_submit', 'Guide/submit', 2, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, NULL, 'page'
)");
$sortNo++;
$this->addSql("INSERT INTO dtb_page_layout (page_id, layout_id, sort_no, discriminator_type) VALUES ($pageId, 2, $sortNo, 'pagelayout')");
// ご注文の流れ
$pageId++;
$this->addSql("INSERT INTO dtb_page (
id, master_page_id, page_name, url, file_name, edit_type, create_date, update_date, meta_robots, discriminator_type
) VALUES(
$pageId, NULL, 'ご注文の流れ', 'guide_flow', 'Guide/flow', 2, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, NULL, 'page'
)");
$sortNo++;
$this->addSql("INSERT INTO dtb_page_layout (page_id, layout_id, sort_no, discriminator_type) VALUES ($pageId, 2, $sortNo, 'pagelayout')");
// 配送方法・送料
$pageId++;
$this->addSql("INSERT INTO dtb_page (
id, master_page_id, page_name, url, file_name, edit_type, create_date, update_date, meta_robots, discriminator_type
) VALUES(
$pageId, NULL, '配送方法・送料', 'guide_carriage', 'Guide/carriage', 2, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, NULL, 'page'
)");
$sortNo++;
$this->addSql("INSERT INTO dtb_page_layout (page_id, layout_id, sort_no, discriminator_type) VALUES ($pageId, 2, $sortNo, 'pagelayout')");
// お支払方法・手数料
$pageId++;
$this->addSql("INSERT INTO dtb_page (
id, master_page_id, page_name, url, file_name, edit_type, create_date, update_date, meta_robots, discriminator_type
) VALUES(
$pageId, NULL, 'お支払方法・手数料', 'guide_payment', 'Guide/payment', 2, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, NULL, 'page'
)");
$sortNo++;
$this->addSql("INSERT INTO dtb_page_layout (page_id, layout_id, sort_no, discriminator_type) VALUES ($pageId, 2, $sortNo, 'pagelayout')");
// Adobe Illustratorでデータご用意-カッティングステッカー
$pageId++;
$this->addSql("INSERT INTO dtb_page (
id, master_page_id, page_name, url, file_name, edit_type, create_date, update_date, meta_robots, discriminator_type
) VALUES(
$pageId, NULL, 'Adobe Illustratorでデータご用意-カッティングステッカー', 'guide_cutting_ai', 'Guide/cutting_ai', 2, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, NULL, 'page'
)");
$sortNo++;
$this->addSql("INSERT INTO dtb_page_layout (page_id, layout_id, sort_no, discriminator_type) VALUES ($pageId, 2, $sortNo, 'pagelayout')");
// Adobe Photoshopでデータご用意-カッティングステッカー
$pageId++;
$this->addSql("INSERT INTO dtb_page (
id, master_page_id, page_name, url, file_name, edit_type, create_date, update_date, meta_robots, discriminator_type
) VALUES(
$pageId, NULL, 'Adobe Photoshopでデータご用意-カッティングステッカー', 'guide_cutting_psd', 'Guide/cutting_psd', 2, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, NULL, 'page'
)");
$sortNo++;
$this->addSql("INSERT INTO dtb_page_layout (page_id, layout_id, sort_no, discriminator_type) VALUES ($pageId, 2, $sortNo, 'pagelayout')");
// Inkscapeでデータご用意-カッティングステッカー
$pageId++;
$this->addSql("INSERT INTO dtb_page (
id, master_page_id, page_name, url, file_name, edit_type, create_date, update_date, meta_robots, discriminator_type
) VALUES(
$pageId, NULL, 'Inkscapeでデータご用意-カッティングステッカー', 'guide_cutting_inkscape', 'Guide/cutting_inkscape', 2, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, NULL, 'page'
)");
$sortNo++;
$this->addSql("INSERT INTO dtb_page_layout (page_id, layout_id, sort_no, discriminator_type) VALUES ($pageId, 2, $sortNo, 'pagelayout')");
// いつも使っているアプリでデータ作成-カッティングステッカー
$pageId++;
$this->addSql("INSERT INTO dtb_page (
id, master_page_id, page_name, url, file_name, edit_type, create_date, update_date, meta_robots, discriminator_type
) VALUES(
$pageId, NULL, 'いつも使っているアプリでデータ作成-カッティングステッカー', 'guide_cutting_others', 'Guide/cutting_others', 2, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, NULL, 'page'
)");
$sortNo++;
$this->addSql("INSERT INTO dtb_page_layout (page_id, layout_id, sort_no, discriminator_type) VALUES ($pageId, 2, $sortNo, 'pagelayout')");
// テキストのみでオーダー
$pageId++;
$this->addSql("INSERT INTO dtb_page (
id, master_page_id, page_name, url, file_name, edit_type, create_date, update_date, meta_robots, discriminator_type
) VALUES(
$pageId, NULL, 'テキストのみでオーダー', 'guide_cutting_text', 'Guide/cutting_text', 2, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, NULL, 'page'
)");
$sortNo++;
$this->addSql("INSERT INTO dtb_page_layout (page_id, layout_id, sort_no, discriminator_type) VALUES ($pageId, 2, $sortNo, 'pagelayout')");
// デザイン上のご注意点など（カッティングステッカー）
$pageId++;
$this->addSql("INSERT INTO dtb_page (
id, master_page_id, page_name, url, file_name, edit_type, create_date, update_date, meta_robots, discriminator_type
) VALUES(
$pageId, NULL, 'デザイン上のご注意点など（カッティングステッカー）', 'guide_cutting_notice', 'Guide/cutting_notice', 2, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, NULL, 'page'
)");
$sortNo++;
$this->addSql("INSERT INTO dtb_page_layout (page_id, layout_id, sort_no, discriminator_type) VALUES ($pageId, 2, $sortNo, 'pagelayout')");
// 基本的な諸設定
$pageId++;
$this->addSql("INSERT INTO dtb_page (
id, master_page_id, page_name, url, file_name, edit_type, create_date, update_date, meta_robots, discriminator_type
) VALUES(
$pageId, NULL, '基本的な諸設定', 'guide_print_basicsetting', 'Guide/print_basicsetting', 2, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, NULL, 'page'
)");
$sortNo++;
$this->addSql("INSERT INTO dtb_page_layout (page_id, layout_id, sort_no, discriminator_type) VALUES ($pageId, 2, $sortNo, 'pagelayout')");
// Adobe Illustratorでデータご用意-プリントステッカー
$pageId++;
$this->addSql("INSERT INTO dtb_page (
id, master_page_id, page_name, url, file_name, edit_type, create_date, update_date, meta_robots, discriminator_type
) VALUES(
$pageId, NULL, 'Adobe Illustratorでデータご用意-プリントステッカー', 'guide_print_ai', 'Guide/print_ai', 2, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, NULL, 'page'
)");
$sortNo++;
$this->addSql("INSERT INTO dtb_page_layout (page_id, layout_id, sort_no, discriminator_type) VALUES ($pageId, 2, $sortNo, 'pagelayout')");
// いつも使っているアプリでデータ作成-プリントステッカー
$pageId++;
$this->addSql("INSERT INTO dtb_page (
id, master_page_id, page_name, url, file_name, edit_type, create_date, update_date, meta_robots, discriminator_type
) VALUES(
$pageId, NULL, 'いつも使っているアプリでデータ作成-プリントステッカー', 'guide_print_common', 'Guide/print_common', 2, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, NULL, 'page'
)");
$sortNo++;
$this->addSql("INSERT INTO dtb_page_layout (page_id, layout_id, sort_no, discriminator_type) VALUES ($pageId, 2, $sortNo, 'pagelayout')");
// デザイン上のご注意点など（プリントステッカー）
$pageId++;
$this->addSql("INSERT INTO dtb_page (
id, master_page_id, page_name, url, file_name, edit_type, create_date, update_date, meta_robots, discriminator_type
) VALUES(
$pageId, NULL, 'デザイン上のご注意点など（プリントステッカー）', 'guide_print_notice', 'Guide/print_notice', 2, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, NULL, 'page'
)");
$sortNo++;
$this->addSql("INSERT INTO dtb_page_layout (page_id, layout_id, sort_no, discriminator_type) VALUES ($pageId, 2, $sortNo, 'pagelayout')");
}
public function down(Schema $schema): void
{
// this down() migration is auto-generated, please modify it to your needs
}
}

app/DoctrineMigrations/Version20240411011507.php line 1