Return to TXT.rtf CVS log

Up to [NeXTSTEP 3.3 examples] / Examples / EnterpriseObjects / MasteringDetails / README.rtfd

Sample Programs from NeXSTEP 3.3

{\rtf0\ansi{\fonttbl\f0\fswiss Helvetica;\f1\fmodern Ohlfs;}
\paperw10800
\paperh10600
\margl60
\margr100
{\colortbl;\red0\green0\blue0;}
\pard\tx960\tx1920\tx2880\tx3840\tx4800\tx5760\tx6720\tx7680\tx8640\tx9600\f0\b\i0\ulnone\fs36\fc0\cf0 MasteringDetails
\b0\fs24 \
by Craig Federighi, EO Development Team\
\

\b\fs28 Overview
\b0\fs24 \
\
This example presents a generic scheme for assigning relationship keys automatically for insertions and deletions in detail controllers.  The implementation of this is fairly complex, but the result is a significant simplification in the code required to implement applications that allow editing master-detail relationships.\
\

\b\fs28 \
Demo Application Features\

\b0\fs24 \
The application allows the user to enter and edit employee information.  The employee data has several interesting relationships:\

\pard\tx980\tx1920\tx2880\tx3840\tx4800\tx5760\tx6720\tx7680\tx8640\tx9600\fi-220\li960\fc0\cf0 �	A to-one foreign key to primary key relationship for employee to department.\
�	A many-to-many relationship between employee and project.\

\pard\tx980\tx1920\tx2880\tx3840\tx4800\tx5760\tx6720\tx7680\tx8640\tx9600\fi-220\li960\fc0\cf0 �	Primary key to primary key relationship for Quote and Picture.\

\pard\tx960\tx1920\tx2880\tx3840\tx4800\tx5760\tx6720\tx7680\tx8640\tx9600\fc0\cf0 The primary purpose of this example is to show how key assignment can be handled in a general way when records are inserted in detail controllers with these sort of relationships.\
\

\b Additional Features:
\b0  \
\

\pard\tx980\tx1920\tx2880\tx3840\tx4800\tx5760\tx6720\tx7680\tx8640\tx9600\fi-220\li960\fc0\cf0 �	The Quote field demonstrates storing rich text in the database.  \
�	An image well allows storage and retrieval of images.\
�	Departments and Projects are selected by selecting from a list of available choices presented in a scrolling list (pick list).  This is done with a new association type.\
�	New objects are automatically assigned unique primary keys.\

\pard\tx960\tx1920\tx2880\tx3840\tx4800\tx5760\tx6720\tx7680\tx8640\tx9600\b\fs28\fc0\cf0 \
The Example Folder\

\b0\fs24 \
The example contains the following:\
\

\pard\tx1920\tx2880\tx3320\tx4800\tx5760\tx6720\tx7680\tx8640\tx9600\fi-3320\li3320\fc0\cf0 EOFExtensions.subproj	- 	A application-independent relationship management facility.\
    KeyGenerator		-	Much like the UniqueKey example, this provides a facility for assigning unique primary keys to objects.\
    ValueForKey		-	A category on NSObject to provide single key versions of takeValuesFromDictionary and valuesForKeys.\
    RelationshipKeySetter	-	The brains of this example.  Provides categories on EORelationship to perform key assignment on master or detail objects in order for the relationship between them to hold in the database.\
    SavvyControllerDel...	-	A generic EOController delegate that uses the RelationshipKeySetter to assign keys correctly when objects are inserted or deleted in detail controllers.\
    SelectionInsertionAs...	-	An EOAssociation subclass that inserts and deletes objects in its controller based on the selection in its destination controller.\

\pard\tx1920\tx2880\tx3320\tx4800\tx5760\tx6720\tx7680\tx8640\tx9600\fi-3320\li3320\fc0\cf0     ResetRelationships	-	Not actually used in this example.  Provides a category on EODatabaseChannel for updating the relationship pointers of an EO when its foreign key values have been modified.  This plays the opposite role to the RelationshipKeySetter.\

\pard\tx1920\tx2880\tx3320\tx4800\tx5760\tx6720\tx7680\tx8640\tx9600\fi-3320\li3320\fc0\cf0 EmpController		- 	The main controller in this application.  Sets up associations, performs initial fetches, and provides an insert operation to add new employees.  As a subclass of the generic SavvyControllerDelegate it acts as a delegate for detail controllers, performing key assignments for the insertion and deletion of objects.\
 Employee		- 	An example EO class.\

\pard\tx960\tx1920\tx2880\tx3840\tx4800\tx5760\tx6720\tx7680\tx8640\tx9600\fc0\cf0 \
\

\b\fs28\fc1\cf1 Running the Example
\b0\fs24\fc0\cf0 \
\
Select an employee from the table view; notice that the department and project lists at the bottom of the window select the department and projects for the selected employee.  You can edit the employee in several ways:\

\pard\tx980\tx1920\tx2880\tx3840\tx4800\tx5760\tx6720\tx7680\tx8640\tx9600\fi-220\li960\fc0\cf0 �	Re-assign an employee to a different department by clicking on the new department in the departments list. \
�	Assign the employee to additional projects by shift clicking on a new project in the projects list.  \
�	Add a picture for the employee by dragging an image into the image well.\
�	Type a new "quote" for the employee by typing in the Quote text view.  This is an RTFD field, so you can use rich text and even add images or files.\

\pard\tx960\tx1920\tx2880\tx3840\tx4800\tx5760\tx6720\tx7680\tx8640\tx9600\fc0\cf0 Save your changes by either clicking the save button or selecting a different employee.\
\
Add a new employee by clicking the Add button.  Enter the new data for this employee and select save to commit the new entry to the database.\

\b \
\

\pard\tx960\tx1920\tx2880\tx3840\tx4800\tx5760\tx6720\tx7680\tx8640\tx9600\fs28\fc1\cf1 Building For Sybase v.s. Oracle\

\pard\tx960\tx1920\tx2880\tx3840\tx4800\tx5760\tx6720\tx7680\tx8640\tx9600\b0\fs24\fc0\cf0 This example uses the "People" database.  Scripts to create this database on your server can be found in 
\b /NextDeveloper/Examples/EnterpriseObjects/PeopleDBScripts.
\b0   This example includes model files for both Sybase and Oracle.  To use Oracle, do the following in a shell:\

\f1\fs20 	cp people_Oracle.eomodel people_photo_quote.eomodel\

\f0\fs24 and then make the project.	\

\b \

\pard\tx960\tx1920\tx2880\tx3840\tx4800\tx5760\tx6720\tx7680\tx8640\tx9600\fc0\cf0 \

\fs28\fc1\cf1 Known Limitations\

\b0\fs24\fc0\cf0 \
The SavvyDelegate performs non-optimal database updates, sometimes updating an object twice or inserting an object and immediately updating it as part of a single save operation.
\pard\tx960\tx1920\tx2880\tx3840\tx4800\tx5760\tx6720\tx7680\tx8640\tx9600\fc0\cf0 \
\

\b\fs28\fc1\cf1 \
Possible Enhancements\

\pard\tx960\tx1920\tx2880\tx3840\tx4800\tx5760\tx6720\tx7680\tx8640\tx9600\b0\fs24\fc0\cf0 The SavvyDelegate does not handle propagating deletions from a master to its details.  It would be nice if we could just delete an employee from the master and have other associated data dropped automatically.
\pard\tx960\tx1920\tx2880\tx3840\tx4800\tx5760\tx6720\tx7680\tx8640\tx9600\b\fs28\fc1\cf1 \

\pard\tx980\tx1920\tx2880\tx3840\tx4800\tx5760\tx6720\tx7680\tx8640\tx9600\b0\fs24\fi-220\li960\fc0\cf0 \

\pard\tx1140\tx2300\tx3440\tx4600\tx5760\tx6900\tx8060\tx9200\tx10360\tx11520\fc1\cf1 This app performs no validation on employee data.  Combining the SavvyDelegate here and the ValidatingDelegate from the Validation example could improve that situation.\
\
\

\pard\tx960\tx1920\tx2880\tx3840\tx4800\tx5760\tx6720\tx7680\tx8640\tx9600\b\fs28\fc1\cf1 Philosophical Reflections\

\pard\tx1140\tx2300\tx3440\tx4600\tx5760\tx6900\tx8060\tx9200\tx10360\tx11520\b0\fs24\fc1\cf1 \

\pard\tx1140\tx2300\tx3440\tx4600\tx5760\tx6900\tx8060\tx9200\tx10360\tx11520\fc1\cf1 This example shows how to eliminate a lot of the drudgery associated with assigning keys in detail controllers.  One might ask why the assignment is being performed at the controller level at all.  For example, what if I create an employee object on a screen that does not display the department or employee picture (and therefore doesn't have detail controllers for these properties)?  I'd still like the employee to automatically be assigned a default department and (possibly empty) picture and quote objects.\
\
A better (and less UI-centric) way to handle the task of relationship management is to perform the work of the Savvy(Controller)Delegate in a delegate of the EODatabaseChannel, and/or in the EO itself.  This is left as an exercise for the reader!\

\pard\tx1140\tx2300\tx3440\tx4600\tx5760\tx6900\tx8060\tx9200\tx10360\tx11520\fc1\cf1 \
\

\b\fs28 Change History
\b0\fs24 \
\
17/Feb/95	Created for EOF 1.1 release (Craig Federighi)\

}

This archive runs on limited infrastructure. Preserving old code on modern bandwidth. Automated agents are requested to crawl responsibly.