所以我有一个包含许多 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 实体了。