Symfony 3.0 嵌套实体不保存

2022-01-03 00:00:00 php symfony doctrine-orm

所以我有一个实验实体，它有许多 RNASeq 实体.但是，当我尝试使用 RNASeq 条目(通过 newAction)保存实验时，只有实验部分会保存.

So I have an Experiment Entity which has many RNASeq entities. However, when I try to save an Experiment with an RNASeq entry (via the newAction), only the Experiment portion saves.

我的控制器如下:

    <?php
    // src/AppBundle/Controller/ExperimentController.php
    namespace AppBundleController;

    use AppBundleEntityExperiment;
    use AppBundleEntityRNASeq;
    use AppBundleFormTypeExperimentType;
    use SymfonyBundleFrameworkBundleControllerController;
    use SymfonyComponentHttpFoundationRequest;
    use SensioBundleFrameworkExtraBundleConfigurationRoute;
    use SymfonyComponentHttpFoundationResponse;

    // TODO: deleteAction should be implemented. 

    class ExperimentController extends Controller {
        /**
         * @Route("/experiment/index", name="experiment_index")
         */
        public function indexAction() {
            // Grab all experiments from database and hand them to template. 
            $repository = $this->getDoctrine()->getRepository('AppBundle:Experiment');
            $experiments = $repository->findAll();
            return $this->render('experiment/index.html.twig',['experiments' => $experiments]);
        }

        /**
         * @Route("/experiment/new", name="experiment_new")
         */
        public function newAction(Request $request) {
            $experiment = new Experiment();

            $form = $this->createForm(ExperimentType::class, $experiment);

            $form->handleRequest($request);

            // On submission.
            if ($form->isValid()) {
                $em = $this->getDoctrine()->getManager();
                $em->persist($experiment);
                // For each nested object. 
                foreach($experiment->getRNASeqs() as $rnaseq) {
                    $em->persist($rnaseq);
                }
                $em->flush();
                return $this->redirectToRoute('experiment_index');
            }

            return $this->render('experiment/form.html.twig', array('form' => $form->createView()));
        }

        /**
         * @Route("/experiment/show/{id}", name="experiment_show")
         * TODO: Not sure if nessesary (wasn't in last system).
         */
        public function showAction($id) {
            return $this->render('experiment/show.html.twig');
        }

        /**
         * @Route("/experiment/edit/{id}", name="experiment_edit")
         */
        public function editAction(Request $request, $id) {
            $repository = $this->getDoctrine()->getRepository('AppBundle:Experiment');
            $experiment = $repository->find($id);

            $form = $this->createForm(ExperimentType::class, $experiment);

            $form->handleRequest($request);

            return $this->render('experiment/form.html.twig', array('form' => $form->createView()));
        }

}
  ?>

我试图遵循 Symfony 文档.然而，它并没有专门讨论一对多的例子，我担心这可能是我搞砸的地方.

I've attempted to follow the Symfony documentation. However, it doesn't specifically go over a One-to-Many example, and I fear this is possibly where I've messed up.

为了简洁起见，可以找到我的实体类和我的其余代码 此处.

For the sake of brevity my Entity classes and the rest of my code can be found here.

我注意到在创建事件期间，insert into 事件似乎没有正确的关系属性:

I've noticed that during a creation event, the insert into events don't seem to have the correct relationship attributes:

    INSERT INTO experiment (title, exp_type, sample_nums) VALUES (?, ?, ?)
Parameters: { 1: fe, 2: RNASeq, 3: 'a:1:{i:0;i:68767;}' }

    INSERT INTO rnaseq (quality, ribodepleted, final_quality, sample_num, protocol_used, step1, step1result, service_provider, platform, data_files, pipeline, pipeline_parameters, result_files, experiment_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: { 1: fds, 2: 0, 3: fes, 4: 7876, 5: esf, 6: 0, 7: fsd, 8: fs, 9: fs, 10: fsd, 11: sdf, 12: fds, 13: fsd, 14: null }

Experiment 似乎缺少对其 rnaSeqs 属性的更新，并且 RNASeq 有一个 null 参数用于experiment_id.

Experiment appears to be missing an update to its rnaSeqs attribute, and RNASeq has a null parameter for experiment_id.

推荐答案

这是一个非常常见的问题.您需要注意交叉引用您的对象.尽管许多人最初似乎认为它会自动执行，但学说不会自动执行此操作.

This is a very common issue. You need to take care of cross referencing your objects. Doctrine does not do this automatically though many people initially seem to think it will.

class Experiment {
  public function addRNASeq($seq) {
    $this->seqs[] = $seq;
    $seq->setExperiment($this);  // This is what you are missing

并将属性 cascade=all 添加到您的 Experiment::seqs 属性中.那么你就不需要显式地持久化 seq 实体.

And add the attribute cascade=all to your Experiment::seqs property. Then you won't need to explicitly persist the seq entities.

相关文章