使用ZenstruckFoundryBundle加载Symfony7 Fixtures时外键未设置

错误信息 #

SQLSTATE[23502]: Not null violation: 7 ERROR:  null value in column "organization_id" of relation "project" violates not-null constraint
DETAIL:  Failing row contains (c2a33118-c009-37e2-9c62-6a1017ae12b0, null, Howe-Kling, Non et non explicabo option sunt at. Ut quia doloribus distinctio..., null).

DataFixtures代码 #

namespace App\DataFixtures;

use App\Application\Service\UuidGeneratorInterface;
use App\Factory\Projects\ProjectFactory;
use App\Factory\Users\OrganizationFactory;
use App\Factory\Users\ProfileFactory;
use App\Factory\Users\UserFactory;
use Doctrine\Bundle\FixturesBundle\Fixture;
use Doctrine\Persistence\ObjectManager;

class AppFixtures extends Fixture
{
    public function __construct(
        private UuidGeneratorInterface $uuidGenerator,
    ) {
    }

    public function load(ObjectManager $manager): void
    {
        $user = UserFactory::createOne([
            'email' => 'test@user.com',
            'password' => 'Password1234!',
            'profile' => ProfileFactory::createOne([
                'firstName' => 'John',
                'lastName' => 'Doe'
            ]),
            'organization' => OrganizationFactory::createOne([
                'name' => 'ACME',
                'companySize' => '100-499',
                'industry' => 'Software'
            ]),
        ]);

        $projects = ProjectFactory::createOne([
            'organizationId' => $user->getOrganization()->getId(),
            'ownerId' => $user->getId()
        ]);
    }
}

Project实体代码 #

namespace App\Capabilities\Projects\Domain;

use App\Capabilities\Projects\Infrastructure\Persistence\ProjectsRepository;
use Doctrine\ORM\Mapping as ORM;

#[ORM\Entity(
    repositoryClass: ProjectsRepository::class
)]
class Project
{
    #[ORM\Id]
    #[ORM\GeneratedValue(strategy: 'NONE')]
    #[ORM\Column(type: 'uuid')]
    private string $id;

    #[ORM\Column(type: 'string', length: 128)]
    private string $name;

    #[ORM\Column(type: 'text')]
    private string $description;

    #[ORM\Column( type: 'uuid')]
    private string $organizationId;

    #[ORM\Column(type: 'uuid')]
    private string $ownerId;

    #[ORM\OneToOne(targetEntity: Organization::class)]
    private Organization $organization;

    #[ORM\OneToOne(targetEntity: Owner::class)]
    private Owner $owner;

    // No more fields, just methods after this
}

问题根源与修复方案 #

1. 实体映射错误（核心问题） #

你的Project实体同时定义了独立的organizationId字段和organization关联关系，但两者没有正确绑定：

• 关联关系缺少#[ORM\JoinColumn]注解，Doctrine无法识别organization关联对应数据库的organization_id列
• 独立的organizationId字段和关联关系脱节，导致插入数据时Doctrine无法自动同步ID值，最终出现空值

2. Fixtures赋值方式不当 #

直接给organizationId赋值ID字符串，不符合Foundry Factory的设计逻辑——Factory更适合直接处理对象关联，而非手动传递ID。

修复步骤 #

方案一：移除冗余ID字段，用关联管理外键（推荐）

删除独立的organizationId和ownerId字段，通过Doctrine关联自动生成并管理外键列：

namespace App\Capabilities\Projects\Domain;

use App\Capabilities\Users\Domain\Organization;
use App\Capabilities\Users\Domain\User; // 替换为实际的Owner实体类
use App\Capabilities\Projects\Infrastructure\Persistence\ProjectsRepository;
use Doctrine\ORM\Mapping as ORM;

#[ORM\Entity(repositoryClass: ProjectsRepository::class)]
class Project
{
    #[ORM\Id]
    #[ORM\GeneratedValue(strategy: 'NONE')]
    #[ORM\Column(type: 'uuid')]
    private string $id;

    #[ORM\Column(type: 'string', length: 128)]
    private string $name;

    #[ORM\Column(type: 'text')]
    private string $description;

    #[ORM\OneToOne(targetEntity: Organization::class)]
    #[ORM\JoinColumn(name: 'organization_id', referencedColumnName: 'id', nullable: false)]
    private Organization $organization;

    #[ORM\OneToOne(targetEntity: User::class)]
    #[ORM\JoinColumn(name: 'owner_id', referencedColumnName: 'id', nullable: false)]
    private User $owner;

    // 构造函数确保必填字段初始化
    public function __construct(string $id, string $name, string $description, Organization $organization, User $owner)
    {
        $this->id = $id;
        $this->name = $name;
        $this->description = $description;
        $this->organization = $organization;
        $this->owner = $owner;
    }

    // 其他getter/setter方法
}

方案二：同步ID字段与关联关系（不推荐，冗余易出错）

如果必须保留独立ID字段，需要在实体中同步关联对象与ID值，并修改映射：

// 仅修改关联和字段映射部分
#[ORM\Column(type: 'uuid')]
private string $organizationId;

#[ORM\OneToOne(targetEntity: Organization::class)]
#[ORM\JoinColumn(name: 'organization_id', referencedColumnName: 'id', nullable: false, insertable: false, updatable: false)]
private Organization $organization;

#[ORM\Column(type: 'uuid')]
private string $ownerId;

#[ORM\OneToOne(targetEntity: Owner::class)]
#[ORM\JoinColumn(name: 'owner_id', referencedColumnName: 'id', nullable: false, insertable: false, updatable: false)]
private Owner $owner;

// 在构造函数或setter中同步ID
public function setOrganization(Organization $organization): void
{
    $this->organization = $organization;
    $this->organizationId = $organization->getId();
}

修复Fixtures代码

改为直接传递关联对象，而非ID字符串：

public function load(ObjectManager $manager): void
{
    $user = UserFactory::createOne([
        'email' => 'test@user.com',
        'password' => 'Password1234!',
        'profile' => ProfileFactory::createOne([
            'firstName' => 'John',
            'lastName' => 'Doe'
        ]),
        'organization' => OrganizationFactory::createOne([
            'name' => 'ACME',
            'companySize' => '100-499',
            'industry' => 'Software'
        ]),
    ]);

    // 直接传入关联对象
    ProjectFactory::createOne([
        'organization' => $user->getOrganization(),
        'owner' => $user
    ]);
}

内容的提问来源于stack exchange，提问作者floriank