To use reference in fixture, dont use the field name, but the relation
name
RobeetSection:
sec1:
name: Section1
sec2:
name: Section2
RobeetSection: sec1
On 26 mar, 14:54, comb <[email protected]> wrote:
> Hi, I was recommended from the forum.symfony-project.org to ask my
> question here.
>
> If I make a schema.yml that needs references to own objects and than
> load a fixture-file, where the first object should be referenced in
> the second, the data-load of the fixture fails.
>
> Example:
>
> #config/doctrine/schema.yml
> RobeetSection:
> actAs: { Timestampable: ~ }
> columns:
> name: { type: string(255), notnull: true, unique: true }
> parent_id: { type: integer }
> relations:
> RobeetSection: { onDelete: CASCADE, local: parent_id, foreign:
> id }
>
> #data/fixtures/sections.yml
> RobeetSection:
> sec1:
> name: Section1
> parent_id: null
> sec2:
> name: Section2
> parent_id: sec1
>
> $ php symfony doctrine:data-load
>
> fails with:
>
> SQLSTATE[HY000]: General error: 1452 Cannot add or update a child row:
> a foreign key constraint fails (`robeet`.`robeet_section`, CONSTRAINT
> `robeet_section_parent_id_robeet_section_id` FOREIGN KEY (`parent_id`)
> REFERENCES `robeet_section` (`id`) ON DELETE CASCADE)
>
> what can I do?
>
> (topic in
> symfony-forum:http://forum.symfony-project.org/index.php?t=rview&goto=96255#msg_96255
> )
--
If you want to report a vulnerability issue on symfony, please send it to
security at symfony-project.com
You received this message because you are subscribed to the Google
Groups "symfony users" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/symfony-users?hl=en
To unsubscribe, reply using "remove me" as the subject.
