Symfony2学说创建查询

debugcn 发表于 Dev

用户名

我有3个实体：博客：

class Blog {

    /**
     * @ORM\Id
     * @ORM\Column(type="integer")
     * @ORM\GeneratedValue(strategy="AUTO")
     */
    protected $id;
//...

    /**
     * @ORM\ManyToMany(targetEntity="ProductTag", inversedBy="blogs", cascade={"persist"})
     * @ORM\JoinTable(name="blog_product_tag",
     * joinColumns={@ORM\JoinColumn(name="blog_id", referencedColumnName="id")},
     * inverseJoinColumns={@ORM\JoinColumn(name="product_tag_id", referencedColumnName="id")}
     * )
     */
    protected $product_tags;
//...
}

产品标签

class ProductTag {

    /**
     * @ORM\Id
     * @ORM\Column(type="integer")
     * @ORM\GeneratedValue(strategy="AUTO")
     */
    protected $id;
//...

    /**
     * @ORM\ManyToMany(targetEntity="Blog", mappedBy="blogs", cascade={"persist"})
     */
    private $blogs;
//...
}

产品

class Product {

    /**
     * @ORM\Id
     * @ORM\Column(type="integer")
     * @ORM\GeneratedValue(strategy="AUTO")
     */
    protected $id;
//...


    /**
     * @ORM\ManyToMany(targetEntity="ProductTag", inversedBy="products", cascade={"persist"})
     * @ORM\JoinTable(name="product_product_tag",
     * joinColumns={@ORM\JoinColumn(name="product_id", referencedColumnName="id")},
     * inverseJoinColumns={@ORM\JoinColumn(name="product_tag_id", referencedColumnName="id")}
     * )
     */
    protected $product_tags;
//...
}

我想进行查询，这将给我对应于与产品对应的product_tags的博客：

SELECT b . * 
FROM  `product` p
JOIN product_product_tag ppt ON ( p.id = ppt.product_id ) 
JOIN product_tag pt ON ( ppt.product_tag_id = pt.id ) 
JOIN blog_product_tag bpt ON ( pt.id = bpt.product_tag_id ) 
JOIN blog b ON ( bpt.blog_id = b.id ) 
WHERE p.id =5

怎么做？我需要使用它到knp_paginator :(

用户名

我找到了解决方案。问题是我在博客中创建了一个定向关系-product_tag和product-product_tag实体。根据此处的信息：http : //doctrine-orm.readthedocs.org/en/latest/reference/association-mapping.html我已将ProductTag实体的定义更改为休假：

//...
class ProductTag {
//...
/**
 * @ORM\ManyToMany(targetEntity="Blog", mappedBy="product_tags", cascade={"persist"})
 */
private $blogs;

/**
 * @ORM\ManyToMany(targetEntity="Product", mappedBy="product_tags", cascade={"persist"})
 */
private $products;
//...

它允许我在BlogRepository中创建以下方法：

public function getRelatedBlogsByProduct(Product $product) {
    return $this->createQueryBuilder('b')
            ->select('b')
            ->join('b.product_tags', 'pt')
            ->join('pt.products', 'p')
            ->where('p.id = :product_id')
            ->setParameter('product_id', $product->getId())
            ->getQuery()
            ->getResult();
}

它正在生成以下SQL：

SELECT b0_.id AS id0, b0_.title AS title1, b0_.author AS author2, b0_.blog AS blog3, b0_.image AS image4, b0_.created AS created5, b0_.updated AS updated6, b0_.published AS published7, b0_.is_homepage_slider AS is_homepage_slider8, b0_.is_category_slider AS is_category_slider9, b0_.is_breaking_news AS is_breaking_news10, b0_.category_id AS category_id11 FROM blog b0_ INNER JOIN blog_product_tag b2_ ON b0_.id = b2_.blog_id INNER JOIN product_tag p1_ ON p1_.id = b2_.product_tag_id INNER JOIN product_product_tag p4_ ON p1_.id = p4_.product_tag_id INNER JOIN Product p3_ ON p3_.id = p4_.product_id WHERE p3_.id = 2

SQL中的哪一种正在获取我想要的所有博客。

谢谢Ajeet的帮助，它对我帮助很大：)

本文收集自互联网，转载请注明来源。

如有侵权，请联系[email protected] 删除。