<ac:macro ac:name="info"><ac:parameter ac:name="title">Zend_Db_Table_Rowset_Recursive_Abstract - Adrian Hope-Bailie</ac:parameter></ac:macro>

<ac:macro ac:name="unmigrated-inline-wiki-markup"><ac:plain-text-body><![CDATA[

<ac:macro ac:name="unmigrated-inline-wiki-markup"><ac:plain-text-body><![CDATA[

Zend Framework: Zend_Db_Table_Recursive_Abstract Component Proposal

Table of Contents

1. Overview

Zend_Db_Table_Rowset_Recursive_Abstract extends Zend_Db_Table_Rowset_Abstract and implements RecursiveIterator.
This allows rowsets that extend this class to specify an id column and a cloumn that references a parent row.
This in turn will allow the rowset to be iterated using regular foreach loops and return information such as the depth of iteration etc.

2. References

• PHP 5 Recursive Iterator

3. Component Requirements, Constraints, and Acceptance Criteria

• This component will extend the existing Zend_Db_Table_Rowset_Abstract class.
• This component will implement the RecursiveIterator interface.
• This component will implement the RecursiveIterator interface.
• This component will support the standard Zend_Db_Table_Rowset_Abstract constructor argument (array $config)

4. Dependencies on Other Framework Components

• Zend_Db_Table_Rowset_Abstract

5. Theory of Operation

The component extended in the same way as it's parent class. The user may then specify that Zend_Db_Table_Abstract child objects use the child of Zend_Db_Table_Rowset_Recursive_Abstract as their rowset class. Following this rowsets returned by functions on Zend_Db_Table_Abstract (find, fetchAll) can be iterated recursively returning child rows too.

6. Milestones / Tasks

• Milestone 1:[DONE] Design notes will be published on this page
• Milestone 2: Working prototype checked into the incubator supporting use case #1
• Milestone 4: Unit tests exist, work, and are checked into SVN.
• Milestone 5: Initial documentation exists.

If a milestone is already done, begin the description with "[DONE]", like this:

• Milestone #: [DONE] Unit tests ...

7. Class Index

• http://framework.zend.com/wiki/pages/editpage.action?pageId=37341

8. Use Cases

DB table containing comments that can be threaded.
EG:

TABLE: Comments
COLUMNS:
id int (11) not null
parent_id int (11) allow null
user_id int (11) not null
comment text

Here comments that are children of a parent contain the id of the parent comment in the parent_id column, otherwise they contain null.

Model:

Implementation of component:

Comments controller:

Comments view:

9. Class Skeletons