Databases
StackOverflow2013
Postsdbo
POMany-to-Many, Doctrine's Entity Generator and Pluralization
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POMany-to-Many, Doctrine's Entity Generator and Pluralization
    primarykey
    data
    text
    <p>Doctrine's many-to-many logic is confusing me a bit. I have a pretty simple many-to-many relationship of recipes to categories. My base entity classes are equally simple.</p> <p>The Recipe entity class...</p> <pre class="lang-php prettyprint-override"><code>class Recipe { /** * @ORM\ManyToMany(targetEntity="Category", inversedBy="categories") * @ORM\JoinTable(name="recipe_category") **/ private $categories; /** * @var integer * * @ORM\Column(name="id", type="integer") * @ORM\Id * @ORM\GeneratedValue(strategy="AUTO") */ private $id; /** * @var string * * @ORM\Column(name="title", type="string", length=255) */ private $title; public function __construct() { $this-&gt;categories = new \Doctrine\Common\Collections\ArrayCollection(); } } </code></pre> <p>And the Category entity class...</p> <pre class="lang-php prettyprint-override"><code>class Category { /** * @ORM\ManyToMany(targetEntity="Recipe") **/ private $recipes; /** * @var integer * * @ORM\Column(name="id", type="integer") * @ORM\Id * @ORM\GeneratedValue(strategy="AUTO") */ private $id; /** * @var string * * @ORM\Column(name="name", type="string", length=255) */ private $name; public function __construct() { $this-&gt;recipes = new \Doctrine\Common\Collections\ArrayCollection(); } } </code></pre> <p>Seems pretty strait forward and matches Doctrine (and Symfony2's) documentation examples. The strange behavior comes when I try and generate the getters and setters for these classes via the Symfony console app.</p> <p>The relationship setters/getters are incorrect. Take, for instance, the Category setter in the Recipe class that's generated...</p> <pre class="lang-php prettyprint-override"><code>/** * Add categories * * @param \Namespace\CookbookBundle\Entity\Category $categories * @return Recipe */ public function addCategorie(\Namespace\CookbookBundle\Entity\Category $categories) { $this-&gt;categories[] = $categories; return $this; } </code></pre> <p>It looks like the auto-generation of the method name is off. It should be "addCategory" and should be passed a "category."</p> <p>While I can just correct this manually, if I re-run the entity generator, it will just add them again.</p> <p>Am I doing this incorrectly or is this just a quirk of the entity generator? Can I specify an over-ride via annotation?</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USwlvrn
    1. USwlvrn
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POMany-to-Many, Doctrine's Entity Generator and Pluralization
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POMany-to-Many, Doctrine's Entity Generator and Pluralization
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POMany-to-Many, Doctrine's Entity Generator and Pluralization
      1. This table or related slice is empty.
      1. VTUpMod
    1. COWell what looks weird is that it is neither `addCategories` or `addCategory` but `addCategorie`...
      singulars
      1. POMany-to-Many, Doctrine's Entity Generator and Pluralization
      1. UScheesemacfly
    2. COAgreed. I thought I might have screwed up some of the annotation but nothing seems to affect it which leads me to believe it's more of a core issue than an annotation/configuration problem.
      singulars
      1. POMany-to-Many, Doctrine's Entity Generator and Pluralization
      1. USwlvrn
    3. COI ran into the same issue myself. Just correct manually, then run doctrine:generate:entities whenever you want, it won't replace your existing methods, and the misspelled methods won't hurt anything.
      singulars
      1. POMany-to-Many, Doctrine's Entity Generator and Pluralization
      1. USkeyboardSmasher
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload