Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>I think you have incorrect relations between your models. I guess it will be enough with:</p> <pre><code>// Node Model public $hasAdBelongsToMany = array( 'AssociatedNode' =&gt; array( 'className' =&gt; 'Node', 'foreignKey' =&gt; 'node_id' 'associationForeignKey' =&gt; 'associated_node_id', 'joinTable' =&gt; 'nodes_nodes' ) ); </code></pre> <p>// Tables</p> <p><strong>nodes</strong></p> <ul> <li>id</li> <li>name</li> <li>node_type_id</li> </ul> <p><strong>nodes_nodes</strong></p> <ul> <li>id</li> <li>node_id</li> <li>associated_node_id</li> </ul> <p><strong>node_types</strong></p> <ul> <li>id</li> <li>name</li> </ul> <p>Then you can try using <a href="http://book.cakephp.org/2.0/en/core-libraries/behaviors/containable.html" rel="nofollow">ContainableBehavior</a> to fetch your data. For Example, to find all TVShows belonging to a TVStation:</p> <pre><code>$options = array( 'contain' =&gt; array( 'AssociatedNode' =&gt; array( 'conditions' =&gt; array( 'AssociatedNode.node_type_id' =&gt; $id_of_tvshows_type ) ) ), conditions =&gt; array( 'node_type_id' =&gt; $id_of_tvstations_type ) ); $nodes = $this-&gt;Node-&gt;find('all', $options); </code></pre> <p><strong>EDIT :</strong></p> <p>You can even have second level conditions (see last example on <a href="http://book.cakephp.org/2.0/en/core-libraries/behaviors/containable.html#containing-deeper-associations" rel="nofollow">this section</a>, look at the 'Tag' model conditions). Try this:</p> <pre><code>$options = array( 'contain' =&gt; array( 'AssociatedNode' =&gt; array( 'conditions' =&gt; array( 'AssociatedNode.node_type_id' =&gt; $id_of_tvshows_type ), 'AssociatedNode' =&gt; array( 'conditions' =&gt; array( 'AssociatedNode.type_id' =&gt; $id_of_actors_type) ) ) ), conditions =&gt; array( 'node_type_id' =&gt; $id_of_tvstations_type ) ); $nodes = $this-&gt;Node-&gt;find('all', $options); </code></pre>
    singulars
    1. This table or related slice is empty.
    1. POSelf "HABTM" or "HasMany Through" concept confusion
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USChoma
    1. USChoma
    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. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COI don't believe that works - 1) how do I know that it's the associated_node_id I'm looking for as opposed to the node_id, and 2) Per my example question, I want to be able to contain another level down. I've been able to get it to work with one level of contain - but never further... which seems very restricting.
      singulars
      1. PO
      1. USDave
    2. CO1) I think you don't completely understand the HABTM relation, that is why your models are so messy. You should read more hasAndBelongsToMany. 2) It was just an example, see the edit.
      singulars
      1. PO
      1. USChoma
    3. CO1) I was using HasMany Through, not HABTM. "read more hasAndBelongsToMany" - where? Any/all examples I find are for two different tables, not HABTM with self. And when trying on itself, it doesn't return correct/all data. 2) I understand Contain, and that you can contain more than one level - but when I try this way with . Also - how would I know that I'm looking for 'AssociatedNode.type_id' - my current table has a 'node_type_id' field, but which node is of that type?
      singulars
      1. PO
      1. USDave
 

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