Dans le cadre d'un test technique, je dois développer un petit site d'e-commerce le plus simple possible avec Symfony. Du coup, je fais mes grands débuts avec ce framework après avor passé pas mal de temps sous Zend
mais, dans ma qualité de n00b, je suis confronté à un soucis concernant l'insertion de données via Doctrine 2 (autant s'amuser avec ça, je n'avait pas utiliser encore ^^).J'ai deux tables, créés avec Doctrine : Products et CategoriesProducts. J'ai créé les Entities via Doctrine et elles donnent ça :
namespace Bdc\BoutiqueBundle\Entity;
use Doctrine\ORM\Mapping as ORM;
/**
* CategoriesProducts
*
* @ORM\Table()
* @ORM\Entity(repositoryClass="Bdc\BoutiqueBundle\Entity\CategoriesProductsRepository")
*/
class CategoriesProducts
{
/**
* @var integer
*
* @ORM\Column(name="id", type="integer")
* @ORM\Id
* @ORM\GeneratedValue(strategy="AUTO")
*/
private $id;
/**
* @var string
*
* @ORM\Column(name="categorie_name", type="string", length=255)
*/
private $categorieName;
/**
* Get id
*
* @return integer
*/
public function getId()
{
return $this->id;
}
/**
* Set categorieName
*
* @param string $categorieName
* @return CategoriesProducts
*/
public function setCategorieName($categorieName)
{
$this->categorieName = $categorieName;
return $this;
}
/**
* Get categorieName
*
* @return string
*/
public function getCategorieName()
{
return $this->categorieName;
}
}
namespace Bdc\BoutiqueBundle\Entity;
use Doctrine\ORM\Mapping as ORM;
/**
* Products
*
* @ORM\Table()
* @ORM\Entity(repositoryClass="Bdc\BoutiqueBundle\Entity\ProductsRepository")
*/
class Products
{
/**
* @ORM\ManyToOne(targetEntity="Bdc\BoutiqueBundle\Entity\CategoriesProducts")
* @ORM\JoinColumn(nullable=false)
*/
private $categorieProduct;
/**
* @var integer
*
* @ORM\Column(name="id", type="integer")
* @ORM\Id
* @ORM\GeneratedValue(strategy="AUTO")
*/
private $id;
/**
* @var string
*
* @ORM\Column(name="name_product", type="string", length=255)
*/
private $nameProduct;
/**
* @var string
*
* @ORM\Column(name="description_product", type="string", length=255)
*/
private $description;
/**
* @var string
*
* @ORM\Column(name="image_product", type="string", length=255)
*/
private $image;
/**
* Get id
*
* @return integer
*/
public function getId()
{
return $this->id;
}
/**
* Set nameProduct
*
* @param string $nameProduct
* @return Products
*/
public function setNameProduct($nameProduct)
{
$this->nameProduct = $nameProduct;
return $this;
}
/**
* Get nameProduct
*
* @return string
*/
public function getNameProduct()
{
return $this->nameProduct;
}
/**
* Set description
*
* @param string $description
* @return Products
*/
public function setDescription($description)
{
$this->description = $description;
return $this;
}
/**
* Get description
*
* @return string
*/
public function getDescription()
{
return $this->description;
}
/**
* Set categorieProduct
*
* @param \Bdc\BoutiqueBundle\Entity\CategoriesProducts $categorieProduct
* @return Products
*/
public function setCategorieProduct(\Bdc\BoutiqueBundle\Entity\CategoriesProducts $categorieProduct)
{
$this->categorieProduct = $categorieProduct;
return $this;
}
/**
* Get categorieProduct
*
* @return \Bdc\BoutiqueBundle\Entity\CategoriesProducts
*/
public function getCategorieProduct()
{
return $this->categorieProduct;
}
/**
* Set image
*
* @param string $image
* @return Products
*/
public function setImage($image)
{
$this->image = $image;
return $this;
}
/**
* Get image
*
* @return string
*/
public function getImage()
{
return $this->image;
}
}
/**
* @ORM\ManyToOne(targetEntity="Bdc\BoutiqueBundle\Entity\CategoriesProducts")
* @ORM\JoinColumn(nullable=false)
*/
private $categorieProduct;
Maintenant, pour insérer des données automatiquement, j ai vu que je pouvais utiliser DoctrineFixturesBundle.
Pour remplir ma table CategoriesProducts, j'ai créé cette classe :
/**
* Insertion de données dans la table CategoriesProducts
*/
namespace Bdc\BoutiqueBundle\DataFixtures\ORM;
use Doctrine\Common\DataFixtures\FixtureInterface;
use Doctrine\Common\Persistence\ObjectManager;
use Bdc\BoutiqueBundle\Entity\CategoriesProducts;
class LoadCategoriesProductsData implements FixtureInterface
{
public function load (ObjectManager $manager)
{
$datas = array("Film", "Musique", "Livre");
foreach($datas as $i => $nom)
{
// On crée la compétence
$liste_competences[$i] = new CategoriesProducts();
$liste_competences[$i]->setCategorieName($nom);
// On la persiste
$manager->persist($liste_competences[$i]);
}
// On déclenche l'enregistrement
$manager->flush();
}
}
namespace Bdc\BoutiqueBundle\DataFixtures\ORM;
use Doctrine\Common\DataFixtures\FixtureInterface;
use Doctrine\Common\Persistence\ObjectManager;
use Bdc\BoutiqueBundle\Entity\Products;
use Bdc\BoutiqueBundle\Entity\CategoriesProducts;
class LoadProductsData implements FixtureInterface
{
public function load (ObjectManager $manager)
{
$datas = array(
array(
"name_product" => "Le Seigneur des Anneaux",
"categorieProduct_id" => "Film",
"description_product" => "",
"image_product" => "http://www.collecttolkien.com/images/Media/Movies%20LOTR%20Trilogy%20DVD%20Box%20Set%20May252004%20$69.jpg"
),
array(
"name_product" => "Star Wars",
"categorieProduct_id" => "Film",
"description_product" => "",
"image_product" => "http://pmcdn.priceminister.com/photo/893150047.jpg"
),
// etc etc... avec plein d'autres données
);
foreach($datas as $i => $tabProducts) {
// On crée la compétence
$liste_competences[$i] = new Products();
$liste_competences[$i]->setNameProduct($tabProducts["name_product"]);
$liste_competences[$i]->setDescription($tabProducts["description_product"]);
$liste_competences[$i]->setImage($tabProducts["image_product"]);
// Gestion CategoriesProducts
$oCategorieProduct = new CategoriesProducts();
$oCategorieProduct->setCategorieName($tabProducts["categorieProduct_id"]);
$liste_competences[$i]->setCategorieProduct($oCategorieProduct);
// On la persiste
$manager->persist($liste_competences[$i]);
}
// On déclenche l'enregistrement
$manager->flush();
}
}
Code : Tout sélectionner
stephane@balistik-pc:~/workspace/bedycasa$ php app/console doctrine:fixtures:load
Careful, database will be purged. Do you want to continue Y/N ?y
> purging database
> loading Bdc\BoutiqueBundle\DataFixtures\ORM\LoadCategoriesProductsData
> loading Bdc\BoutiqueBundle\DataFixtures\ORM\LoadProductsData
[Doctrine\ORM\ORMInvalidArgumentException]
A new entity was found through the relationship 'Bdc\BoutiqueBundle\Entity\Products#categorieProduct'
that was not configured to cascade persist operations for entity: Bdc\BoutiqueBundle\Entity\Categories
Products@00000000332c9adf000000006224c514. To solve this issue: Either explicitly call EntityManager#p
ersist() on this unknown entity or configure cascade persist this association in the mapping for exam
ple @ManyToOne(..,cascade={"persist"}). If you cannot find out which entity causes the problem impleme
nt 'Bdc\BoutiqueBundle\Entity\CategoriesProducts#__toString()' to get a clue.
doctrine:fixtures:load [--fixtures[="..."]] [--append] [--em="..."] [--purge-with-truncate]
Merci d'avance ^^
