![[BACK]](/cvsweb/icons/back.gif){kind=icon}
Return to MasterDetail.m CVS log ![[TXT]](/cvsweb/icons/text.gif){kind=icon}
![[DIR]](/cvsweb/icons/dir.gif){kind=icon}
Up to [NeXTSTEP 3.3 examples] / Examples / EnterpriseObjects / UniqueKey / UniqueKey_sybase|
Return to MasterDetail.m CVS log | Up to [NeXTSTEP 3.3 examples] / Examples / EnterpriseObjects / UniqueKey / UniqueKey_sybase |
1.1 root 1: #import "UniqueKey.h"
2: #import "MasterDetail.h"
3:
4:
5: static BOOL _Debug = YES;
6:
7: @implementation MasterDetail
8:
9: /******************************************************************************
10: * Create an instance of the UniqueKey object to grab blocks of <count> keys for
11: * our use during insert. The count is set low so you can see the SQL reserve
12: * blocks of keys. Up the count to something larger for it to be of use.
13: *
14: * The login information (connection dictionary) has been blanked out, since
15: * you may elect to have the tables in some database other than PEOPLE, so we
16: * elect to run a login panel. Once the login is complete we can get the
17: * connection dictionary from the adaptor and use that information to allow
18: * UniqueKey to login and create its separate connection for key reservation.
19: *
20: * Many of the method calls in EOF return (id)<some protocol>, so you will notice
21: * several casts to (id) to avoid warnings for nested method calls supported by
22: * the returned object, but not by the protocol. Alternatively, you can cast to
23: * the exact class you know returned, such as (EODatabaseDataSource*) or
24: * (EODetailDatabaseSource*).
25: ******************************************************************************/
26: - appDidInit:sender
27: {
28: EOAdaptorChannel *eoAdaptorChannel = [[(id)[employeeController dataSource]
29: databaseChannel] adaptorChannel];
30: EOAdaptor *eoAdaptor = [[eoAdaptorChannel adaptorContext] adaptor];
31:
32: if(_Debug) [eoAdaptorChannel setDelegate:self];
33:
34: employeeEntity = [[(id)[employeeController dataSource] entity] retain];
35: equipmentOwnerEntity = [[(id)[equipmentOwnerController dataSource] entity] retain];
36:
37: if(![eoAdaptor runLoginPanelAndValidateConnectionDictionary]) [NXApp terminate:self];
38: [UniqueKey setConnectionDictionary:[eoAdaptor connectionDictionary]];
39:
40: employeeUniqueKey = [[[UniqueKey alloc] initWithEntity:employeeEntity count:5] retain];
41: if(!employeeUniqueKey) [NXApp terminate:self];
42:
43: [self setFetchOrderFor:employeeController with:@"LastName" order:EOAscendingOrder];
44: [self setFetchOrderFor:equipmentOwnerController with:@"Description" order:EOAscendingOrder];
45:
46: [employeeController fetch:self];
47: return self;
48: }
49:
50:
51: /******************************************************************************
52: * Set a controller's data source to fetch sorted by a given attribute name
53: * and order.
54: ******************************************************************************/
55: - setFetchOrderFor:(EOController*)controller with:(NSString*)attributeName order:(EOOrdering)order
56: {
57: id dataSource = [controller dataSource];
58: id attribute = [[dataSource entity] attributeNamed:attributeName];
59: NSArray *orderArray;
60:
61: orderArray = [NSArray arrayWithObject:
62: [EOAttributeOrdering attributeOrderingWithAttribute:attribute ordering:order]];
63: [dataSource setFetchOrder:orderArray];
64: return self;
65: }
66:
67:
68: /******************************************************************************
69: * Generate unique keys for the new object. Use the instance of UniqueKey
70: * to dole out a key from its internal buffer. The UniqueKey object has its
71: * own channel to the DB which it uses to allocate blocks of keys.
72: ******************************************************************************/
73: - (BOOL)controller:(EOController *)controller willInsertObject:object atIndex: (unsigned)newIndex
74: {
75: if(controller==employeeController)
76: {
77: NSNumber *uniqueKey = [NSNumber numberWithInt:[employeeUniqueKey nextKey]];
78: NSArray *emptyArray = [[[NSArray alloc] init] autorelease];
79:
80: [object setObject:uniqueKey forKey:@"EmpId"];
81: [object setObject:@"<LastName>" forKey:@"LastName"];
82: [object setObject:@"<FirstName>" forKey:@"FirstName"];
83: [object setObject:@"<Phone>" forKey:@"Phone"];
84: [object setObject:emptyArray forKey:@"toEmpEquipment"];
85: return YES;
86: }
87: return NO;
88: }
89:
90:
91: /******************************************************************************
92: * When an employee is deleted from the database, we need to remove that person's
93: * ownership of their equipment. We use the toEmpEquipment relationship to get
94: * an NSArray of equipment objects and null the EmpId for each.
95: ******************************************************************************/
96: - (BOOL)controller:controller willDeleteObject:object
97: {
98: NSArray *eeArray;
99: NSEnumerator *eeEnumerator;
100: EOGenericRecord *equipment;
101:
102: if(controller==employeeController) {
103: eeArray = [object objectForKey:@"toEmpEquipment"];
104: eeEnumerator = [eeArray objectEnumerator];
105:
106: while ((equipment = [eeEnumerator nextObject]) != nil) {
107: [equipment setObject:[EONull null] forKey:@"EmpId"];
108: [(id)[employeeController dataSource] updateObject:equipment];
109: }
110: }
111: return YES;
112: }
113:
114:
115: /******************************************************************************
116: * Bring up the assign equipment panel and start a modal session. Construct
117: * an 'otherEquipment' qualifier to select equipment not currently assigned to
118: * the selected employee.
119: ******************************************************************************/
120: - assignEquipmentToEmployee:sender
121: {
122: EOGenericRecord *employee;
123: NSNumber *empId;
124: EOQualifier *otherEquipment;
125: NSString *qualifierString;
126:
127: employee = [(id)[equipmentForEmployeeController dataSource] masterObject];
128: empId = [employee objectForKey:@"EmpId"];
129:
130: qualifierString = [NSString stringWithFormat:@"(EmpId != %@ or EmpId = NULL)",empId];
131:
132: otherEquipment = [[[EOQualifier alloc]
133: initWithEntity:equipmentOwnerEntity qualifierFormat:qualifierString] autorelease];
134:
135: [(id)[equipmentOwnerController dataSource] setQualifier:otherEquipment];
136: [equipmentOwnerController clearSelection];
137: [equipmentOwnerController fetch];
138: [[assignEquipmentPanel center] makeKeyAndOrderFront:nil];
139: [NXApp runModalFor:assignEquipmentPanel];
140: [assignEquipmentPanel orderOut:self];
141: [employeeController fetch];
142: return self;
143: }
144:
145: - assignEquipmentToEmployeeOK:sender
146: {
147: EOGenericRecord *employee;
148: NSNumber *empId;
149: NSArray *eoArray;
150: NSEnumerator *eoEnumerator;
151: EOGenericRecord *equipmentOwner;
152:
153: employee = [(id)[equipmentForEmployeeController dataSource] masterObject];
154: empId = [employee objectForKey:@"EmpId"];
155: eoArray = [equipmentOwnerController selectedObjects];
156: eoEnumerator = [eoArray objectEnumerator];
157:
158: while((equipmentOwner = [eoEnumerator nextObject]) != nil) {
159: [equipmentOwner setObject:empId forKey:@"EmpId"];
160: [(id)[equipmentOwnerController dataSource] updateObject:equipmentOwner];
161: }
162: [NXApp stopModal];
163: return self;
164: }
165:
166:
167: /******************************************************************************
168: * Release the equipment shown in the detail view. Null out the equipment owner's
169: * EmpId for each.
170: ******************************************************************************/
171: - releaseEquipmentForEmployee:sender
172: {
173: NSArray *efeArray;
174: NSEnumerator *efeEnumerator;
175: EOGenericRecord *equipment;
176:
177: efeArray = [equipmentForEmployeeController selectedObjects];
178: efeEnumerator = [efeArray objectEnumerator];
179:
180: while( (equipment = [efeEnumerator nextObject]) != nil) {
181: [equipment setObject:[EONull null] forKey:@"EmpId"];
182: [(id)[equipmentForEmployeeController dataSource] updateObject:equipment];
183: }
184: [employeeController fetch];
185: return self;
186: }
187:
188:
189: /******************************************************************************
190: * Echo SQL when debug is enabled.
191: ******************************************************************************/
192: - (EODelegateResponse)adaptorChannel:channel willEvaluateExpression:(NSMutableString *)expression
193: {
194: NSLog(expression);
195: return EODelegateApproves;
196: }
197:
198: - (void)dealloc
199: {
200: [employeeEntity release];
201: [equipmentOwnerEntity release];
202: [employeeUniqueKey release];
203: [super dealloc];
204:
205: }
206:
207: @end
This archive runs on limited infrastructure. Preserving old code on modern bandwidth. Automated agents are requested to crawl responsibly.