How to define relationships in Zend Framework

Question

I have two simple tables: Projects and SubProjects which I'd like to print every subproject with the respective project in a table.

So I wrote this:

class Admin_Model_Projects extends Zend_Db_Table_Abstract { protected $_name = 'main_projects'; protected $_primary = 'mai_id'; protected $_sequence = true; protected $_dependentTables = array('Admin_Model_SubProjects'); ....

And this:

class Admin_Model_SubProjects extends Zend_Db_Table_Abstract { protected $_name = 'sub_projects'; protected $_primary = 'sub_id'; protected $_sequence = true; protected $_referenceMap = array( 'columns' => 'mai_id', 'refTableClass' => 'Admin_Model_Projects', 'refColumns' => 'mai_id' ); .....

I'd like to know why do I get No reference from table Admin_Model_SubProjects to table Admin_Model_Projects when I type <?php echo $entry->findParentRow('Admin_Model_Projects'); ?>

Vika · Accepted Answer · 2010-09-20 20:00:08Z

Looks like you're missing name of the rule in your referenceMap definition.
It should be

protected $_referenceMap = array( 'Project' => array( 'columns' => 'mai_id', 'refTableClass' => 'Admin_Model_Projects', 'refColumns' => 'mai_id' ) );

chelmertz · Accepted Answer · 2010-09-20 19:45:19Z

You should define $_referenceMap and $_dependentTables in all of the related table-classes. It will look close-to mirrored when you're done.

Collectives™ on Stack Overflow

How to define relationships in Zend Framework

2 Answers 2

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Related