Zend 2-学说如何为三个实体插入一对多？

Question

我有一个有三张桌子的场景（有它自己的id）

Concurso (id 130)
    Country Canada (id 1)
         Languages French (id 20) 
                   English (id 40)                   
    Country USA (id 2)
         Language English (id 40) 
                  Spanish (id 33)
    Country Italy (id 5)
         Language Italian (id 99)

目标是在concursoCountry表中有这些字段

130 1 20
130 1 40
130 2 40
130 2 33
130 5 99

这是我的代码，感谢您的任何建议

public function create($params) { 
        //echo "<pre>";
        //print_r($params);
        
        $stringCountry = "cou_id";
        $arrayIdLanguage = array();
        
        $concurso = new $this->entity;
        $concursoCountry =  new $this->entityConcursoCountry;
        
        $host = new \Application\Model\DB\Host($this->em);
        $concurso->setHos($host->find(1));

        $image = new \Application\Model\DB\Image($this->em);
        $concurso->setConIma($image->find(1));
        
        $concurso->setConName($params['con_name']);
        $concurso->setConDescription($params['con_description']);
        $concurso->setConTitle($params['con_name']);

        ... other information fields...

        $this->em->persist($concurso);
        $this->em->flush();

        $concursoCountry->setCon($concurso);
 
        foreach ($params as $keyCounty=>$valueCountry) {
            $posCounntry = strpos($keyCounty, $stringCountry);
            
            if($posCounntry === false){
                //
            }else{
                $country = new \Application\Model\DB\Country($this->em);
                $concursoCountry->setCou($country->find($params[$keyCounty]));
                
                $piecesCountry = explode("_", $keyCounty);
                $indexCountry = $piecesCountry[2];
                
                $stringLanguage = "lan_id_".$indexCountry;
                
                foreach ($params as $keyLan=>$valueLan) {
                    $posLang = strpos($keyLan, $stringLanguage);
                    
                    if($posLang === false){
                        //
                    }else{
                        
                        $language = new \Application\Model\DB\Language($this->em);
                        $concursoCountry->setLan($language->find($params[$keyLan]));
                        $this->em->persist($concursoCountry);
                        $this->em->flush();
                    }
                }
            }
        }

        return true;
    }  
}

这是entity/concurso.php（有几个信息字段不是必需的

Answer 1

首先创建父级，然后创建子级，然后在子级中设置父级(FK)。在创建的每一个对象之后持久化，最后只进行一次刷新。