Symfony 怎么把数据迁移转为数组

up()

down()

$manager->persist($entity)

Version20230101000000.php

<?php

declare(strict_types=1);

namespace DoctrineMigrations;

use Doctrine\DBAL\Schema\Schema;
use Doctrine\Migrations\AbstractMigration;

final class Version20230101000000 extends AbstractMigration
{
    public function getDescription(): string
    {
        return 'Adds initial user roles.';
    }

    public function up(Schema $schema): void
    {
        $this->addSql("INSERT INTO user_role (id, name, description) VALUES (1, 'ROLE_ADMIN', 'Administrator role');");
        $this->addSql("INSERT INTO user_role (id, name, description) VALUES (2, 'ROLE_USER', 'Standard user role');");
    }

    public function down(Schema $schema): void
    {
        $this->addSql("DELETE FROM user_role WHERE id IN (1, 2);");
    }
}

$initialRoles = [
    ['id' => 1, 'name' => 'ROLE_ADMIN', 'description' => 'Administrator role'],
    ['id' => 2, 'name' => 'ROLE_USER', 'description' => 'Standard user role'],
];
// 这样你就得到了一个数组

user_role

// 假设你在一个Symfony命令或服务中
namespace App\Command;

use App\Entity\UserRole; // 假设你有对应的UserRole实体
use Doctrine\ORM\EntityManagerInterface;
use Symfony\Component\Console\Command\Command;
use Symfony\Component\Console\Input\InputInterface;
use Symfony\Component\Console\Output\OutputInterface;

class ExportUserRolesCommand extends Command
{
    protected static $defaultName = 'app:export-user-roles';
    private EntityManagerInterface $entityManager;

    public function __construct(EntityManagerInterface $entityManager)
    {
        parent::__construct();
        $this->entityManager = $entityManager;
    }

    protected function execute(InputInterface $input, OutputInterface $output): int
    {
        $userRoles = $this->entityManager->getRepository(UserRole::class)->findAll();

        $rolesAsArray = [];
        foreach ($userRoles as $role) {
            $rolesAsArray[] = [
                'id' => $role->getId(),
                'name' => $role->getName(),
                'description' => $role->getDescription(),
                // 确保这里包含了你所有需要的字段
            ];
        }

        // 现在 $rolesAsArray 就是你想要的数据数组了
        // 你可以将其输出、保存到文件或进行其他操作
        $output->writeln(json_encode($rolesAsArray, JSON_PRETTY_PRINT | JSON_UNESCAPED_UNICODE));

        return Command::SUCCESS;
    }
}

up()

down()

up()

// 迁移示例：将JSON字段拆分为新列
public function up(Schema $schema): void
{
    // 1. 添加新列
    $this->addSql('ALTER TABLE product ADD COLUMN settings_enabled BOOLEAN DEFAULT FALSE NOT NULL');
    $this->addSql('ALTER TABLE product ADD COLUMN settings_theme VARCHAR(255) DEFAULT NULL');

    // 2. 迁移数据 (这部分通常需要通过DBAL来处理，因为ORM在迁移中不太方便)
    $products = $this->connection->fetchAllAssociative('SELECT id, settings FROM product WHERE settings IS NOT NULL');

    foreach ($products as $product) {
        $settings = json_decode($product['settings'], true);
        if ($settings) {
            $enabled = $settings['enabled'] ?? false;
            $theme = $settings['theme'] ?? null;
            $this->addSql(
                'UPDATE product SET settings_enabled = :enabled, settings_theme = :theme WHERE id = :id',
                ['enabled' => $enabled, 'theme' => $theme, 'id' => $product['id']]
            );
        }
    }

    // 3. (可选) 移除旧列
    // $this->addSql('ALTER TABLE product DROP COLUMN settings');
}

JsonType

SerializedType

json_encode

json_decode

serialize

unserialize

TEXT

JSON

up()

php bin/console doctrine:migrations:migrate

doctrine:migrations:migrate --no-interaction --allow-no-migration

--no-interaction

--allow-no-migration

app:deploy

doctrine:migrations:migrate