Symfony Profiler

<?php
declare(strict_types=1);
namespace DoctrineMigrations;
use Doctrine\DBAL\Schema\Schema;
use Doctrine\Migrations\AbstractMigration;
/**
* 注文ごとの販売者ステータス管理テーブルのマイグレーション
* dtb_order_seller_statusテーブルの作成・更新
*/
final class Version20251111000000 extends AbstractMigration
{
public function getDescription(): string
{
return 'dtb_order_seller_statusテーブルの作成または更新';
}
public function up(Schema $schema): void
{
$platform = $this->connection->getDatabasePlatform();
$schemaManager = $this->connection->createSchemaManager();
// テーブルが存在しない場合は作成
if (!$schemaManager->tablesExist(['dtb_order_seller_status'])) {
$this->addSql('CREATE TABLE dtb_order_seller_status (
id INT UNSIGNED NOT NULL,
order_id INT UNSIGNED DEFAULT NULL,
seller_id INT UNSIGNED DEFAULT NULL,
order_status_id SMALLINT UNSIGNED DEFAULT NULL,
discriminator_type VARCHAR(255) NOT NULL,
PRIMARY KEY(id),
INDEX IDX_5503C9F78D9F6D38 (order_id),
INDEX IDX_5503C9F78DE820D9 (seller_id),
INDEX IDX_5503C9F7D7707B45 (order_status_id)
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_bin ENGINE = InnoDB');
return;
}
// テーブルが存在する場合、カラムをチェックして必要に応じて追加・変更
$columns = $schemaManager->listTableColumns('dtb_order_seller_status');
$columnNames = array_map(function($column) {
return $column->getName();
}, $columns);
// 各カラムの存在確認と追加
if (!in_array('id', $columnNames)) {
$this->addSql('ALTER TABLE dtb_order_seller_status ADD id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST');
}
if (!in_array('order_id', $columnNames)) {
$this->addSql('ALTER TABLE dtb_order_seller_status ADD order_id INT UNSIGNED DEFAULT NULL');
} else {
// 型チェックと変更
$column = $columns[array_search('order_id', $columnNames)];
if ($column->getType()->getName() !== 'integer' || !$column->getUnsigned()) {
$this->addSql('ALTER TABLE dtb_order_seller_status MODIFY order_id INT UNSIGNED DEFAULT NULL');
}
}
if (!in_array('seller_id', $columnNames)) {
$this->addSql('ALTER TABLE dtb_order_seller_status ADD seller_id INT UNSIGNED DEFAULT NULL');
} else {
// 型チェックと変更
$column = $columns[array_search('seller_id', $columnNames)];
if ($column->getType()->getName() !== 'integer' || !$column->getUnsigned()) {
$this->addSql('ALTER TABLE dtb_order_seller_status MODIFY seller_id INT UNSIGNED DEFAULT NULL');
}
}
if (!in_array('order_status_id', $columnNames)) {
$this->addSql('ALTER TABLE dtb_order_seller_status ADD order_status_id SMALLINT UNSIGNED DEFAULT NULL');
} else {
// 型チェックと変更
$column = $columns[array_search('order_status_id', $columnNames)];
if ($column->getType()->getName() !== 'smallint' || !$column->getUnsigned()) {
$this->addSql('ALTER TABLE dtb_order_seller_status MODIFY order_status_id SMALLINT UNSIGNED DEFAULT NULL');
}
}
if (!in_array('discriminator_type', $columnNames)) {
$this->addSql('ALTER TABLE dtb_order_seller_status ADD discriminator_type VARCHAR(255) NOT NULL');
} else {
// 型チェックと変更
$column = $columns[array_search('discriminator_type', $columnNames)];
if ($column->getType()->getName() !== 'string' || $column->getLength() !== 255 || $column->getNotnull() !== true) {
$this->addSql('ALTER TABLE dtb_order_seller_status MODIFY discriminator_type VARCHAR(255) NOT NULL');
}
}
// インデックスの確認と追加
$indexes = $schemaManager->listTableIndexes('dtb_order_seller_status');
$indexNames = array_keys($indexes);
if (!in_array('idx_5503c9f78d9f6d38', array_map('strtolower', $indexNames))) {
$this->addSql('CREATE INDEX IDX_5503C9F78D9F6D38 ON dtb_order_seller_status (order_id)');
}
if (!in_array('idx_5503c9f78de820d9', array_map('strtolower', $indexNames))) {
$this->addSql('CREATE INDEX IDX_5503C9F78DE820D9 ON dtb_order_seller_status (seller_id)');
}
if (!in_array('idx_5503c9f7d7707b45', array_map('strtolower', $indexNames))) {
$this->addSql('CREATE INDEX IDX_5503C9F7D7707B45 ON dtb_order_seller_status (order_status_id)');
}
}
public function down(Schema $schema): void
{
// ダウングレード時はテーブルを削除
$this->addSql('DROP TABLE IF EXISTS dtb_order_seller_status');
}
}

app/DoctrineMigrations/Version20251111000000.php line 1