所以我有一个包含许多 RNASeq 实体的实验实体。但是,当我尝试使用 RNASeq 条目(通过 newAction)保存实验时,仅保存实验部分。

我的 Controller 如下:

    <?php 
    // src/AppBundle/Controller/ExperimentController.php 
    namespace AppBundle\Controller; 
 
    use AppBundle\Entity\Experiment; 
    use AppBundle\Entity\RNASeq; 
    use AppBundle\Form\Type\ExperimentType; 
    use Symfony\Bundle\FrameworkBundle\Controller\Controller; 
    use Symfony\Component\HttpFoundation\Request; 
    use Sensio\Bundle\FrameworkExtraBundle\Configuration\Route; 
    use Symfony\Component\HttpFoundation\Response; 
 
    // 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 documentation .但是,它并没有专门讨论一对多的例子,我担心这可能是我搞砸的地方。

为了简洁起见,我的实体类和我的其余代码可以在 here 中找到.

编辑:

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

    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.

请您参考如下方法:

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

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

并将属性 cascade=all 添加到 Experiment::seqs 属性。然后你就不需要显式地持久化 seq 实体了。


评论关闭
IT序号网

微信公众号号:IT虾米 (左侧二维码扫一扫)欢迎添加!