Fetch entity without related objects doctrine

Question

I have the following classes:

class Category {

    /**
    * @ORM\OneToMany(targetEntity="Product", mappedBy="category")
    */
    private $products;

    ...
}

class Product {

    ...

    /**
    * @ORM\ManyToOne(targetEntity="Category", inversedBy="products")
    * @ORM\JoinColumn(name="category_id", referencedColumnName="id")
    */
    private $category;

    ...

}

when i try to fetch one product from my db like this:

    $query = $doctrineManager->createQuery(
        "
SELECT p FROM AppBundle:Product p
WHERE p.id = :id
        "
    )->setParameter('id', $id);

    $result = $query->getSingleResult();

i get not only my product, but also get category with all products (except the one i found). So, how can i fetch only model what i want without any related model?

why don't you use $this->getDoctrine()->getRepository('AppBundle:Product')->find($id)? — Denis Alimov
– Denis Alimov, Commented Jun 15, 2016 at 18:04
@DenisAlimov it doesn't matter. i get same result with what you post. — pacification
– pacification, Commented Jun 15, 2016 at 18:09
it called associations DQL SELECT statements are a very powerful way of retrieving parts of your domain model that are not accessible via associations. Additionally they allow to retrieve entities and their associations in one single SQL select statement which can make a huge difference in performance in contrast to using several queries. doctrine-orm.readthedocs.io/projects/doctrine-orm/en/latest/… — Denis Alimov
– Denis Alimov, Commented Jun 15, 2016 at 18:22
@DenisAlimov i know what it is. My question was So, how can i fetch only model what i want without any related model? — pacification
– pacification, Commented Jun 15, 2016 at 18:25

Community · Accepted Answer · 2017-05-23 12:09:32Z

7

They are just stubs, you don't actually fetch any related entity information unless you are using fetch=EAGER.

This answer explains it pretty well.

What is the difference between fetch="EAGER" and fetch="LAZY" in doctrine

In summary, you can't get rid of the associations, but they don't load the other entities until you call the data unless you specifically request otherwise. So don't worry about it.

edited May 23, 2017 at 12:09

CommunityBot

11 silver badge

answered Jun 15, 2016 at 19:32

Richard

4,1491 gold badge17 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Fetch entity without related objects doctrine

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related