Doctrine 2: Find an Entity Using Entity Relationships

Question

I have 3 objects:

Style

Colour

Article

The article has ManyToOne's relationship with both objects (the article is a unique combination of style and color). All objects have an automatic increase in surrogate integer indices.

I have a style element and a Color object, and I want to create a new article that links these two objects if they are not already. Given that there is no way to make an equivalent ("INSERT on DUPLICATE KEY UPDATE") using the doctrine, I need to find any articles that have a BOTH relationship with my Color styles and objects. If there are no matches, create a new object.

How can I find any article object in my system that is associated with style and color objects?

/** * @Entity */ class Style{ /** @Id @GeneratedValue @Column (type="integer") */ private $id; /** @Column (name="name", type="string") */ private $name; /** * @OneToMany(targetEntity="Article", mappedBy="style", cascade={"persist"}) */ private $articles; } class Colour{ /** @Id @GeneratedValue @Column (type="integer") */ private $id; /** @Column (name="name", type="string") */ private $name; } class Article{ /** @Id @GeneratedValue @Column (type="integer") */ private $id; /** * @ManyToOne(targetEntity="Style", inversedBy="articles", cascade={"persist"}) */ private $style; /** * @ManyToOne(targetEntity="Colour", cascade={"persist"}) */ private $colour; } 

The findBy methods described here http://www.doctrine-project.org/docs/orm/2.0/en/reference/working-with-objects.html seem to let you find objects using the string values ​​of the properties of the entity, and only one of them at a time.