Return to People_Sybase.eomodel CVS log

Up to [NeXTSTEP 3.3 examples] / Examples / EnterpriseObjects / DistributedEO

Sample Programs from NeXSTEP 3.3

{
    EOModelVersion = 1; 
    adaptorName = Sybase; 
    connectionDictionary = {databaseName = EOFTest; hostName = SYBASE; password = ""; userName = sa; }; 
    entities = (
	{
	    attributes = (
		{
		    columnName = DEPARTMENT_NAME; 
		    externalType = varchar; 
		    name = department_name; 
		    valueClassName = NSString; 
		}, 
		{
		    columnName = DEPT_ID; 
		    externalType = int; 
		    name = dept_id; 
		    valueClassName = NSNumber; 
		    valueType = i; 
		}, 
		{
		    columnName = LOCATION_ID; 
		    externalType = int; 
		    name = location_id; 
		    valueClassName = NSNumber; 
		    valueType = i; 
		}
	    ); 
	    attributesUsedForLocking = (department_name, dept_id, location_id); 
	    classProperties = (department_name, dept_id, location_id, toEmployee); 
	    externalName = DEPARTMENT; 
	    name = department; 
	    primaryKeyAttributes = (dept_id); 
	    relationships = (
		{
		    destination = employee; 
		    isToMany = Y; 
		    joins = (
			{
			    destinationAttribute = dept_id; 
			    joinOperator = EOJoinEqualTo; 
			    joinSemantic = EOInnerJoin; 
			    sourceAttribute = dept_id; 
			}
		    ); 
		    name = toEmployee; 
		}
	    ); 
	}, 
	{
	    attributes = (
		{
		    calendarFormat = "%b %d %Y %H:%M"; 
		    columnName = LOCK; 
		    externalType = varchar; 
		    name = lock; 
		    valueClassName = NSString; 
		}, 
		{
		    columnName = ADDRESS; 
		    externalType = varchar; 
		    name = address; 
		    valueClassName = NSString; 
		}, 
		{
		    columnName = CITY; 
		    externalType = varchar; 
		    name = city; 
		    valueClassName = NSString; 
		}, 
		{
		    columnName = DEPT_ID; 
		    externalType = int; 
		    name = dept_id; 
		    valueClassName = NSNumber; 
		    valueType = i; 
		}, 
		{
		    columnName = EMP_ID; 
		    externalType = int; 
		    name = emp_id; 
		    valueClassName = NSNumber; 
		    valueType = i; 
		}, 
		{
		    columnName = FIRST_NAME; 
		    externalType = varchar; 
		    name = first_name; 
		    valueClassName = NSString; 
		}, 
		{
		    calendarFormat = "%b %d %Y %H:%M"; 
		    columnName = HIRE_DATE; 
		    externalType = datetime; 
		    name = hire_date; 
		    valueClassName = NSCalendarDate; 
		}, 
		{
		    columnName = LAST_NAME; 
		    externalType = varchar; 
		    name = last_name; 
		    valueClassName = NSString; 
		}, 
		{
		    columnName = MANAGER; 
		    externalType = int; 
		    name = manager; 
		    valueClassName = NSNumber; 
		    valueType = i; 
		}, 
		{
		    columnName = PHONE; 
		    externalType = char; 
		    name = phone; 
		    valueClassName = NSString; 
		}, 
		{
		    definition = toEmp_Photo.photo; 
		    externalType = image; 
		    isReadOnly = Y; 
		    name = photo; 
		    valueClassName = NSData; 
		}, 
		{
		    columnName = SALARY; 
		    externalType = float; 
		    name = salary; 
		    valueClassName = NSNumber; 
		    valueType = d; 
		}, 
		{
		    columnName = STATE; 
		    externalType = char; 
		    name = state; 
		    valueClassName = NSString; 
		}, 
		{
		    columnName = TITLE_ID; 
		    externalType = int; 
		    name = title_id; 
		    valueClassName = NSNumber; 
		    valueType = i; 
		}, 
		{
		    definition = toEmp_Photo.photo; 
		    externalType = image; 
		    isReadOnly = Y; 
		    name = photo; 
		    valueClassName = NSData; 
		}, 
		{
		    columnName = ZIP; 
		    externalType = char; 
		    name = zip; 
		    valueClassName = NSString; 
		}
	    ); 
	    attributesUsedForLocking = (
		address, 
		city, 
		dept_id, 
		emp_id, 
		first_name, 
		hire_date, 
		last_name, 
		manager, 
		phone, 
		salary, 
		state, 
		title_id, 
		zip, 
		lock
	    ); 
	    className = Employee; 
	    classProperties = (
		address, 
		city, 
		dept_id, 
		emp_id, 
		first_name, 
		hire_date, 
		last_name, 
		manager, 
		phone, 
		salary, 
		state, 
		title_id, 
		zip, 
		toJob_Title, 
		toEmp_Photo, 
		photo, 
		lock
	    ); 
	    externalName = EMPLOYEE; 
	    name = employee; 
	    primaryKeyAttributes = (emp_id); 
	    relationships = (
		{
		    destination = emp_photo; 
		    isToMany = N; 
		    joins = (
			{
			    destinationAttribute = emp_id; 
			    joinOperator = EOJoinEqualTo; 
			    joinSemantic = EOInnerJoin; 
			    sourceAttribute = emp_id; 
			}
		    ); 
		    name = toEmp_Photo; 
		}, 
		{
		    destination = job_title; 
		    isToMany = N; 
		    joins = (
			{
			    destinationAttribute = title_id; 
			    joinOperator = EOJoinEqualTo; 
			    joinSemantic = EOInnerJoin; 
			    sourceAttribute = title_id; 
			}
		    ); 
		    name = toJob_Title; 
		}
	    ); 
	}, 
	{
	    attributes = (
		{
		    columnName = ASSET_TAG; 
		    externalType = int; 
		    name = asset_tag; 
		    valueClassName = NSNumber; 
		    valueType = i; 
		}, 
		{
		    columnName = DESCRIPTION; 
		    externalType = varchar; 
		    name = description; 
		    valueClassName = NSString; 
		}, 
		{
		    columnName = EMP_ID; 
		    externalType = int; 
		    name = emp_id; 
		    valueClassName = NSNumber; 
		    valueType = i; 
		}, 
		{
		    columnName = SERIAL_NUMBER; 
		    externalType = varchar; 
		    name = serial_number; 
		    valueClassName = NSString; 
		}
	    ); 
	    attributesUsedForLocking = (asset_tag, description, emp_id, serial_number); 
	    classProperties = (asset_tag, description, emp_id, serial_number); 
	    externalName = EMP_EQUIPMENT; 
	    name = emp_equipment; 
	    primaryKeyAttributes = (asset_tag); 
	}, 
	{
	    attributes = (
		{
		    columnName = EMP_ID; 
		    externalType = int; 
		    name = emp_id; 
		    valueClassName = NSNumber; 
		    valueType = i; 
		}, 
		{
		    columnName = PHOTO; 
		    externalType = image; 
		    name = photo; 
		    valueClassName = NSData; 
		}
	    ); 
	    attributesUsedForLocking = (emp_id, photo); 
	    classProperties = (emp_id, photo); 
	    externalName = EMP_PHOTO; 
	    name = emp_photo; 
	    primaryKeyAttributes = (emp_id); 
	}, 
	{
	    attributes = (
		{
		    columnName = EMP_ID; 
		    externalType = int; 
		    name = emp_id; 
		    valueClassName = NSNumber; 
		    valueType = i; 
		}, 
		{
		    columnName = PROJECT_ID; 
		    externalType = int; 
		    name = project_id; 
		    valueClassName = NSNumber; 
		    valueType = i; 
		}
	    ); 
	    attributesUsedForLocking = (emp_id, project_id); 
	    classProperties = (emp_id, project_id); 
	    externalName = EMP_PROJECT; 
	    name = emp_project; 
	    primaryKeyAttributes = (emp_id); 
	}, 
	{
	    attributes = (
		{
		    columnName = EMP_ID; 
		    externalType = int; 
		    name = emp_id; 
		    valueClassName = NSNumber; 
		    valueType = i; 
		}, 
		{
		    columnName = QUOTE; 
		    externalType = image; 
		    name = quote; 
		    valueClassName = NSData; 
		}
	    ); 
	    attributesUsedForLocking = (emp_id, quote); 
	    classProperties = (emp_id, quote); 
	    externalName = EMP_QUOTE; 
	    name = emp_quote; 
	    primaryKeyAttributes = (emp_id); 
	}, 
	{
	    attributes = (
		{
		    columnName = LOCATION; 
		    externalType = varchar; 
		    name = location; 
		    valueClassName = NSString; 
		}, 
		{
		    columnName = LOCATION_ID; 
		    externalType = int; 
		    name = location_id; 
		    valueClassName = NSNumber; 
		    valueType = i; 
		}, 
		{
		    calendarFormat = "%b %d %Y %H:%M"; 
		    columnName = PHOTO; 
		    externalType = image; 
		    name = photo; 
		    valueClassName = NSData; 
		}
	    ); 
	    attributesUsedForLocking = (location, location_id, photo); 
	    classProperties = (location, location_id, photo, toDepartment); 
	    externalName = FACILITY; 
	    name = facility; 
	    primaryKeyAttributes = (location_id); 
	    relationships = (
		{
		    destination = department; 
		    isToMany = Y; 
		    joins = (
			{
			    destinationAttribute = location_id; 
			    joinOperator = EOJoinEqualTo; 
			    joinSemantic = EOInnerJoin; 
			    sourceAttribute = location_id; 
			}
		    ); 
		    name = toDepartment; 
		}
	    ); 
	}, 
	{
	    attributes = (
		{
		    columnName = TITLE; 
		    externalType = varchar; 
		    name = title; 
		    valueClassName = NSString; 
		}, 
		{
		    columnName = TITLE_ID; 
		    externalType = int; 
		    name = title_id; 
		    valueClassName = NSNumber; 
		    valueType = i; 
		}, 
		{
		    columnName = TITLE_TYPE; 
		    externalType = varchar; 
		    name = title_type; 
		    valueClassName = NSString; 
		}
	    ); 
	    attributesUsedForLocking = (title, title_id, title_type); 
	    classProperties = (title, title_id, title_type); 
	    externalName = JOB_TITLE; 
	    name = job_title; 
	    primaryKeyAttributes = (title_id); 
	}, 
	{
	    attributes = (
		{
		    columnName = PROJECT_ID; 
		    externalType = int; 
		    name = project_id; 
		    valueClassName = NSNumber; 
		    valueType = i; 
		}, 
		{
		    columnName = PROJECT_NAME; 
		    externalType = varchar; 
		    name = project_name; 
		    valueClassName = NSString; 
		}, 
		{
		    columnName = SUMMARY_IMAGE; 
		    externalType = image; 
		    name = summary_image; 
		    valueClassName = NSData; 
		}
	    ); 
	    attributesUsedForLocking = (project_id, project_name, summary_image); 
	    classProperties = (project_id, project_name, summary_image); 
	    externalName = PROJECT; 
	    name = project; 
	    primaryKeyAttributes = (project_id); 
	}, 
	{
	    attributes = (
		{
		    columnName = ENTITY_NAME; 
		    externalType = varchar; 
		    name = entity_name; 
		    valueClassName = NSString; 
		}, 
		{
		    columnName = MAX_KEY; 
		    externalType = int; 
		    name = max_key; 
		    valueClassName = NSNumber; 
		    valueType = i; 
		}
	    ); 
	    attributesUsedForLocking = (entity_name, max_key); 
	    classProperties = (entity_name, max_key); 
	    externalName = UNIQUE_KEY; 
	    name = unique_key; 
	    primaryKeyAttributes = (entity_name); 
	}
    ); 
}

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