Pro Zend Framework Techniques Build a Full CMS Project phần 5

SQL phụ thuộc vào các bộ chuyển đổi cơ sở dữ liệu bạn đang sử dụng, mà làm cho mã di giờ bạn có một phương pháp để lấy tất cả các lỗi từ cơ sở dữ liệu, bạn đã sẵn sàng để bắt đầu làm việc với họ. Vì vậy, tạo ra một danh sách hành động trong bộ điều khiển lỗi. | CHAPTER 5 WORKING WITH CMS DATA The page-to-page relationship is handled by the parent_id and id fields. You define this using the same technique as you did with the ContentNode model. Add the dependentTables and referenceMap properties in Listing 5-10 to the top of your Page model directly below the _name property. Listing 5-10. The content_nodes to page and Page-to-Page References in application models protected _dependentTables protected _referenceMap Page array columns refTableClass refColumns onDelete onUpdate . array Model_ContentNode array array parent_id Model_Page array id self CASCADE self RESTRICT Working with Related Items Zend_Db_Table_Row has a number of methods for fetching related records using the references you just set up. These include standard methods such as findDependentRowset as well as a set of magic methods these are methods that are created on the fly. The following code samples are examples only you will create the actual methods in the Content Items section which follows. To fetch all the content nodes for a given page you first need to find the page row. Once you have that row you use the findDependentRowset method to which you pass the class name of the table you want it to search as in the example in Listing 5-11. Listing 5-11. Fetching Dependent Rows mdlPage new Model_Page page mdlPage- find 1 - current contentNodes page- findDependentRowset Model_ContentNode To go the other direction and find a parent row for a given row you use the findParentRow method. You pass this method the class name for the parent table as well as in Listing 5-12. Listing 5-12. Fetching Parent Rows mdlContentNode new Model_ContentNode node mdlContentNode- find 1 - current parentPage node- findParentRow Model_Page 86 Download at CHAPTER 5 WORKING WITH CMS DATA Cascading Updates and Deletes Zend_Db_Table supports cascading write operations but this is intended only for database systems that do not support referential integrity such as .