symfony2 外键 OneToMany

1.Entity：Category

use Doctrine\Common\Collections\ArrayCollection;

class Category

{

    // ...

    /**

     * @ORM\OneToMany(targetEntity="Product", mappedBy="category")

     */

    protected $products;

    public function __construct()

    {

        $this->products = new ArrayCollection();

    }

}

2.Entity：Product

class Product

{

    // ...

    /**

     * @ORM\ManyToOne(targetEntity="Category", inversedBy="products")

     * @ORM\JoinColumn(name="category_id", referencedColumnName="id")

     */

    protected $category;

}

这样 Category和Product就构成了1对多的映射。

php app/console doctrine:schema:update --force

3.、insert数据入库实例（保存相互关联的Entities ）

use AppBundle\Entity\Category;

use AppBundle\Entity\Product;

use Symfony\Component\HttpFoundation\Response;

class DefaultController extends Controller

{

    public function createProductAction()

    {

        $category = new Category();

        $category->setName('Main Products');

        $product = new Product();

        $product->setName('Foo');

        $product->setPrice(19.99);

        $product->setDescription('Lorem ipsum dolor');

        // relate this product to the category

        $product->setCategory($category);

        $em = $this->getDoctrine()->getManager();

        $em->persist($category);

        $em->persist($product);

        $em->flush();

        return new Response(

            'Created product id: '.$product->getId()

            .' and category id: '.$category->getId()

        );

    }

}

4.获取关联的对象

public function showAction($id)

{

    $product = $this->getDoctrine()

        ->getRepository('AppBundle:Product')

        ->find($id);

     $categoryName = $product->getCategory()->getName();

}

5.另外一种查询方法

public function showProductsAction($id)

{

    $category = $this->getDoctrine()

        ->getRepository('AppBundle:Category')

        ->find($id);

    $products = $category->getProducts();

}

6.还可以这么做

$product = $this->getDoctrine()

    ->getRepository('AppBundle:Product')

    ->find($id);

$category = $product->getCategory();

// prints "Proxies\AppBundleEntityCategoryProxy"

echo get_class($category);

7.关联记录（Repository的查询）

// src/AppBundle/Entity/ProductRepository.php

public function findOneByIdJoinedToCategory($id)

{

    $query = $this->getEntityManager()

        ->createQuery(

            'SELECT p, c FROM AppBundle:Product p

            JOIN p.category c

            WHERE p.id = :id'

        )->setParameter('id', $id);

    try {

        return $query->getSingleResult();

    } catch (\Doctrine\ORM\NoResultException $e) {

        return null;

    }

}

public function showAction($id)

{

    $product = $this->getDoctrine()

        ->getRepository('AppBundle:Product')

        ->findOneByIdJoinedToCategory($id);

    $category = $product->getCategory();

    // ...

}