utils/eclipselink.utils.workbench.test/mappingsplugin/source/org/eclipse/persistence/tools/workbench/test/models/complexmapping/Employee.java

/*******************************************************************************
 * Copyright (c) 1998, 2013 Oracle and/or its affiliates. All rights reserved.
 * This program and the accompanying materials are made available under the 
 * terms of the Eclipse Public License v1.0 and Eclipse Distribution License v. 1.0 
 * which accompanies this distribution. 
 * The Eclipse Public License is available at http://www.eclipse.org/legal/epl-v10.html
 * and the Eclipse Distribution License is available at 
 * http://www.eclipse.org/org/documents/edl-v10.php.
 *
 * Contributors:
 *     Oracle - initial API and implementation from Oracle TopLink
******************************************************************************/
package org.eclipse.persistence.tools.workbench.test.models.complexmapping;

import java.io.Serializable;
import java.util.Calendar;
import java.util.Vector;

import org.eclipse.persistence.descriptors.ClassDescriptor;
import org.eclipse.persistence.expressions.Expression;
import org.eclipse.persistence.expressions.ExpressionBuilder;
import org.eclipse.persistence.indirection.ValueHolder;
import org.eclipse.persistence.indirection.ValueHolderInterface;
import org.eclipse.persistence.internal.helper.ConversionManager;
import org.eclipse.persistence.internal.helper.DatabaseField;
import org.eclipse.persistence.mappings.DirectToFieldMapping;
import org.eclipse.persistence.mappings.ManyToManyMapping;
import org.eclipse.persistence.mappings.OneToOneMapping;
import org.eclipse.persistence.mappings.converters.ObjectTypeConverter;
import org.eclipse.persistence.sessions.Record;
import org.eclipse.persistence.sessions.Session;
import org.eclipse.persistence.tools.schemaframework.TableDefinition;
 
public class Employee implements Serializable {
	public String firstName;
	public String lastName;
	public String sex;
	public java.util.Date dateAndTimeOfBirth;
	public java.util.Date joiningDate;
	public ValueHolderInterface policies;
	private ValueHolderInterface designation;
	public JobDescription jobDescription;
	public Hardware computer;

	public Vector shipments;
	public Vector managedEmployees;
	public Employee manager;
	public ValueHolderInterface phoneNumbers;
	public Gender gender;
	public Cubicle cubicle;
public Employee() {
	policies = new ValueHolder(new Vector());
	designation = new ValueHolder();
	shipments = new Vector();
	managedEmployees = new Vector();
	phoneNumbers = new ValueHolder(new Vector());
}	
public void addManagedEmployee(Employee employee) {
	this.managedEmployees.addElement(employee);
}
public void addPhoneNumber(Phone phoneNumber)
{
	 this.getPhoneNumbers().addElement(phoneNumber);
}
public static void addToDescriptor(ClassDescriptor des) {
	ExpressionBuilder computer = new ExpressionBuilder();
	OneToOneMapping computerMapping = (OneToOneMapping) des.getMappingForAttributeName("computer");
	computerMapping.setSelectionCriteria((computer.getField("MAP_HRW.EMP_FNAME").equal(computer.getParameter(new DatabaseField("MAP_EMP.FNAME")))).and(computer.getField("MAP_HRW.EMP_LNAME").equal(computer.getParameter(new DatabaseField("MAP_EMP.LNAME")))));
	
	ExpressionBuilder shipment = new ExpressionBuilder();
	Expression linkTable = shipment.getTable("MAP_EMSP");
	ManyToManyMapping shipmentMapping = (ManyToManyMapping) des.getMappingForAttributeName("shipments");
	shipmentMapping.setSelectionCriteria(((((linkTable.getField("MAP_EMSP.EMP_FNAME").equal(shipment.getParameter(new DatabaseField("MAP_EMP.FNAME")))).and(linkTable.getField("MAP_EMSP.EMP_LNAME").equal(shipment.getParameter(new DatabaseField("MAP_EMP.LNAME"))))).and(linkTable.getField("MAP_EMSP.SP_TS").equal(shipment.getField("MAP_SHIP.SP_TS")))).and(linkTable.getField("MAP_EMSP.SP_TSMIL").equal(shipment.getField("MAP_SHIP.SP_TSMIL")))).and(linkTable.getField("MAP_EMSP.STATUS").equal(null)));

	ObjectTypeConverter genderTypeConverter = new ObjectTypeConverter();
	genderTypeConverter.addConversionValue("M",Male.male);
	genderTypeConverter.addConversionValue("F",Female.female);
	genderTypeConverter.setDefaultAttributeValue(Female.female);
	DirectToFieldMapping genderType = new DirectToFieldMapping();
	genderType.setFieldName("GENDER");
	genderType.setAttributeName("gender");
	genderType.setConverter(genderTypeConverter);
	des.addMapping(genderType);
	
	}
/**
 * Return a platform independant definition of the database table.
 */

public static TableDefinition employeePhoneJoinTableDefinition()
{
	TableDefinition definition = new TableDefinition();

	definition.setName("MAP_EMPH");

	definition.addPrimaryKeyField("FNAME", String.class, 20);
	definition.addPrimaryKeyField("LNAME", String.class, 20);
	definition.addPrimaryKeyField("P_ID", java.math.BigDecimal.class, 15);
	
	return definition;
}
public static Employee errorExample1()
{
	Employee example = new Employee();
	Vector empPolicies = new Vector();
	
	example.firstName = "Dave";
	example.lastName = "Vadis";
	example.sex = "unknown";
	Calendar c = Calendar.getInstance();
	c.set(1974, 2, 14, 1, 1, 1);
	c.set(Calendar.MILLISECOND, 0); 
	example.dateAndTimeOfBirth = c.getTime();
	c = Calendar.getInstance();
	c.set(1994, 2, 14);
	example.joiningDate = c.getTime();
	example.designation.setValue("Executive");
	example.setJobDescription(JobDescription.example1());
	example.computer = Computer.example1(example);

	empPolicies.addElement("Health");
	empPolicies.addElement("Tenant");
	example.setPolicies(empPolicies);
	
	Shipment s1 = Shipment.example1();
	Shipment s2 = Shipment.example2();
	example.shipments.addElement(s1);
	example.shipments.addElement(s2);
	s1.employees.addElement(example);
	s2.employees.addElement(example);
	
 	example.addPhoneNumber(Phone.example1());
	example.addPhoneNumber(Phone.example2());

	return example;
}
public static Employee example1()
{
	Employee example = new Employee();
	Vector empPolicies = new Vector();
	
	example.firstName = "Dave";
	example.lastName = "Vadis";
	example.sex = "male";
	example.gender = Male.male;
	example.cubicle = Cubicle.example1();
	
	Calendar c = Calendar.getInstance();
	c.set(1974,2,14,1,1,1); //new java.util.Date(74, 2, 14, 1, 1, 1);
	c.set(Calendar.MILLISECOND, 0); 
    example.dateAndTimeOfBirth = c.getTime();
	c.clear(); // re-set calendar
	c.set(1994,2,14,1,1,1); //new java.util.Date(94, 2, 14);
	example.joiningDate = c.getTime();
	
	example.designation.setValue("Executive");
	example.setJobDescription(JobDescription.example1());
	example.computer = Computer.example1(example);

	empPolicies.addElement("Health");
	empPolicies.addElement("Tenant");
	example.setPolicies(empPolicies);
	
	Shipment s1 = Shipment.example1();
	Shipment s2 = Shipment.example2();
	example.shipments.addElement(s1);
	example.shipments.addElement(s2);
	s1.employees.addElement(example);
	s2.employees.addElement(example);
	
 	example.addPhoneNumber(Phone.example1());
	example.addPhoneNumber(Phone.example2());

	return example;
}
public static Employee example2()
{
	Employee example = new Employee();
	Vector empPolicies = new Vector();
	
	example.firstName = "Tracy";
	example.lastName = "Chapman";
	example.sex = "female";
	example.gender = Female.female;
	example.cubicle = Cubicle.example2();
		
	Calendar c = Calendar.getInstance();
	c.set(1975,1,19,2,2,2); // new java.util.Date(75, 1, 19, 2, 2, 2);
	c.set(Calendar.MILLISECOND, 0); 
	example.dateAndTimeOfBirth = c.getTime();
	c.clear();
	c.set(1995,3,14); // new java.util.Date(95, 3, 14);
	example.joiningDate = c.getTime();

	example.designation.setValue("Non-Executive");
	example.setJobDescription(JobDescription.example2());
	example.computer = Computer.example2(example);

	empPolicies.addElement("Vehicle");
	empPolicies.addElement("Tenant");
	example.setPolicies(empPolicies);
	
	Shipment s1 = Shipment.example3();
	Shipment s2 = Shipment.example4();
	example.shipments.addElement(s1);
	example.shipments.addElement(s2);
	s1.employees.addElement(example);
	s1.employees.addElement(example);
	
 	example.addPhoneNumber(Phone.example3()); 
		
	return example;
}
public static Employee example3()
{
	Employee example = new Employee();
	Vector empPolicies = new Vector();

	example.firstName = "Edward";
	example.lastName = "White";
	example.sex = "male";
	example.gender = Male.male;
	example.cubicle = Cubicle.example1();

			
	Calendar c = Calendar.getInstance();
	c.set(1971,11,24,3,3,3); // new java.util.Date(71, 11, 24, 3, 3, 3);
	c.set(Calendar.MILLISECOND, 0); 
	example.dateAndTimeOfBirth = c.getTime();
	c.clear();
	c.set(1995,3,14); // new java.util.Date(95, 3, 14);
	example.joiningDate = c.getTime();

	example.designation.setValue("Non-Executive");
	example.setJobDescription(JobDescription.example3());
	example.computer = Computer.example3(example);

	empPolicies.addElement("Vehicle");
	empPolicies.addElement("House");
	example.setPolicies(empPolicies);	
			
	example.addPhoneNumber(Phone.example4());
	example.addPhoneNumber(Phone.example5());
	return example;
}
public static Employee example4()
{
	Employee example = new Employee();
	Vector empPolicies = new Vector();

	example.firstName = "Graham";
	example.lastName = "Gooch";
	example.sex = "male";
	example.gender = Male.male;
	example.cubicle = Cubicle.example2();
				
	Calendar c = Calendar.getInstance();
	c.set(1973,2,14,1,1,1); // new java.util.Date(73, 2, 14, 1, 1, 1);
	c.set(Calendar.MILLISECOND, 0); 
	example.dateAndTimeOfBirth = c.getTime();
	c.clear();
	c.set(1992,2,14); // new java.util.Date(92, 2, 14);
	example.joiningDate = c.getTime();

	example.designation.setValue("Executive");
	example.setJobDescription(JobDescription.example1());
	example.computer = Computer.example4(example);

	empPolicies.addElement("House");
	empPolicies.addElement("Land");
	example.setPolicies(empPolicies);

	Shipment s1 = Shipment.example3();
	Shipment s2 = Shipment.example4();
	example.shipments.addElement(s1);
	example.shipments.addElement(s2);
	s1.employees.addElement(example);
	s2.employees.addElement(example);
	
	example.addPhoneNumber(Phone.example7());
	example.addPhoneNumber(Phone.example8());
	
	return example;
}
public static Employee example5()
{
	Employee example = new Employee();
	Vector empPolicies = new Vector();

	example.firstName = "Tracy";
	example.lastName = "Rue";
	example.sex = "female";
	example.gender = Female.female;
					
	Calendar c = Calendar.getInstance();
	c.set(1975,1,19,2,2,2); // new java.util.Date(75, 1, 19, 2, 2, 2);
	c.set(Calendar.MILLISECOND, 0); 
	example.dateAndTimeOfBirth = c.getTime();
	c.clear();
	c.set(1992,2,14); // new java.util.Date(92, 2, 14);
	example.joiningDate = c.getTime();

	example.designation.setValue("Non-Executive");
	example.setJobDescription(JobDescription.example2());
	example.computer = Computer.example5(example);

	empPolicies.addElement("Vehicle");
	empPolicies.addElement("Tenant");
	example.setPolicies(empPolicies);

	Shipment s1 = Shipment.example5();
	Shipment s2 = Shipment.example6();
	example.shipments.addElement(s1);
	example.shipments.addElement(s2);
	s1.employees.addElement(example);
	s2.employees.addElement(example);
	
 	example.addPhoneNumber(Phone.example9());
			
	return example;
}
public static Employee example6()
{
	Employee example = new Employee();
	Vector empPolicies = new Vector();

	example.firstName = "Norman";
	example.lastName = "Louis";
	example.sex = "male";
	example.gender = Male.male;
						
	Calendar c = Calendar.getInstance();
	c.set(1971,11,24,3,3,3); // new java.util.Date(71, 11, 24, 3, 3, 3);
	c.set(Calendar.MILLISECOND, 0); 
	example.dateAndTimeOfBirth = c.getTime();
	c.clear();
	c.set(1992,2,14); // new java.util.Date(92, 2, 14);
	example.joiningDate = c.getTime();

	example.designation.setValue("Non-Executive");
	example.setJobDescription(JobDescription.example3());
	example.computer = Computer.example6(example);

	empPolicies.addElement("Vehicle");
	empPolicies.addElement("House");
	example.setPolicies(empPolicies);	
	
 	example.addPhoneNumber(Phone.example10());
	example.addPhoneNumber(Phone.example11());
	return example;
}
public static Employee example7()
{
	Employee example = new Employee();
	Vector empPolicies = new Vector();

	example.firstName = "Imran";
	example.lastName = "Khan";
	example.sex = "male";
	example.gender = Male.male;
	
	Calendar c = Calendar.getInstance();
	c.set(1971,11,24,3,3,3); // new java.util.Date(71, 11, 24, 3, 3, 3);
	c.set(Calendar.MILLISECOND, 0); 
	example.dateAndTimeOfBirth = c.getTime();
	c.clear();
	c.set(1970,2,19); // new java.util.Date(70, 2, 19);
	example.joiningDate = c.getTime();

	example.designation.setValue("Executive");
	example.setJobDescription(JobDescription.example3());
	example.computer = Computer.example7(example);

	empPolicies.addElement("Arms");
	empPolicies.addElement("Legs");
	example.setPolicies(empPolicies);	
	
 	example.addPhoneNumber(Phone.example13());
	example.addPhoneNumber(Phone.example14());
	return example;
}
public static Employee example8()
{
	Employee example = new Employee();
	Vector empPolicies = new Vector();

	example.firstName = "Margaret";
	example.lastName = "Thatcher";
	example.sex = "female";
	example.gender = Female.female;
		
	Calendar c = Calendar.getInstance();
	c.set(1971,11,24,3,3,3); // new java.util.Date(71, 11, 24, 3, 3, 3);
	c.set(Calendar.MILLISECOND, 0); 
	example.dateAndTimeOfBirth = c.getTime();
	c.clear();
	c.set(1901,1,1); // new java.util.Date(01,01,01);
	example.joiningDate = c.getTime();

	example.designation.setValue("Non-Executive");
	example.setJobDescription(JobDescription.example4());
	example.computer = Computer.example8(example);

	empPolicies.addElement("House");
	empPolicies.addElement("Vehicle");
	example.setPolicies(empPolicies);	
	
 	example.addPhoneNumber(Phone.example15());
	example.addPhoneNumber(Phone.example16());
	return example;
}
public static Employee example9()
{
	Employee example = new Employee();
	Vector empPolicies = new Vector();

	example.firstName = "Ace";
	example.lastName = "Ventura";
	example.sex = "male";
	example.gender = Male.male;
			
	Calendar c = Calendar.getInstance();
	c.set(1971,11,24,3,3,3); // new java.util.Date(71, 11, 24, 3, 3, 3);
	c.set(Calendar.MILLISECOND, 0); 
	example.dateAndTimeOfBirth = c.getTime();
	c.clear();
	c.set(1901,1,1); // new java.util.Date(01,01,01);
	example.joiningDate = c.getTime();

	example.designation.setValue("Executive");
	example.setJobDescription(JobDescription.example5());
	example.computer = Computer.example9(example);

	empPolicies.addElement("Pet");
	empPolicies.addElement("Vehicle");
	example.setPolicies(empPolicies);	
	
 	example.addPhoneNumber(Phone.example17());
	example.addPhoneNumber(Phone.example18());
	return example;
}
public Hardware getComputer() {
	return computer;
}
public java.sql.Date getDate()
{
	if (this.dateAndTimeOfBirth == null) {
		return null;
	} else {		
		Calendar c = Calendar.getInstance();
		c.setTime(this.dateAndTimeOfBirth);
		return new java.sql.Date(	
			c.get(Calendar.YEAR)-1900,
			c.get(Calendar.MONTH),
			c.get(Calendar.DAY_OF_MONTH));
	}
}
public String getDesignation()
{
	return (String) designation.getValue();
}
private ValueHolderInterface getDesignationHolder()
{
	return designation;
}
public JobDescription getJobDescription()
{
	return jobDescription;
}
public Vector getManagedEmployees() {
	return managedEmployees;
}
public Vector getManagedEmployeesForTOPLink()
{
	// test method mutating
	return (Vector) managedEmployees.clone();
}
public Employee getManager() {
	return manager;
}
public Vector getPhoneNumbers()
{
	 return (Vector)phoneNumbers.getValue();
}	
public Vector getPolicies()
{
	return (Vector)policies.getValue();
}
public Integer getRankFromObject()
{
	Integer rank = null;
	if (getDesignation() == null) {
		return null;
	}	
	
	if (getDesignation().equals("Executive"))
		rank = new Integer(1);
	if (getDesignation().equals("Non-Executive"))
		rank = new Integer(2);
	return rank;
}
public String getRankFromRow(Record row, Session aSession)
{
	Integer value = new Integer(((Number)row.get("RANK")).intValue());
	String rank = null;
	Employee employee = new Employee();
	
	//(Employee) aSession.readObject(Employee.class);
	if (value.intValue() == 1)
		rank = new String("Executive");
	if (value.intValue() == 2)
		rank = new String("Non-Executive");
	return rank;
}
public Vector getShipments() {
	return shipments;
}
public java.sql.Time getTime()
{
	if (dateAndTimeOfBirth == null) {
		return null;
	}			
	Calendar c = Calendar.getInstance();
	c.setTime(this.dateAndTimeOfBirth);
		return new java.sql.Time(
			c.get(Calendar.HOUR_OF_DAY),
			c.get(Calendar.MINUTE),
			c.get(Calendar.SECOND));
}
/**
 * Return a platform independant definition of the database table.
 */

public static TableDefinition joinTableDefinition()
{
	TableDefinition definition = new TableDefinition();

	definition.setName("MAP_EMSP");

	definition.addPrimaryKeyField("EMP_FNAME", String.class, 20);
	definition.addPrimaryKeyField("EMP_LNAME", String.class, 20);
	definition.addPrimaryKeyField("SP_TS", java.sql.Timestamp.class);
	definition.addPrimaryKeyField("SP_TSMIL", Integer.class);
	definition.addField("STATUS", Character.class);
	
	return definition;
}
/**
 * This method was created in VisualAge.
 */
void newMethod() {
}
public void removeManagedEmployee(Employee employee)
{
	managedEmployees.removeElement(employee);
}
public void setComputer(Computer computer) {
	this.computer = computer;
}
public void setComputer(Hardware computer) {
	this.computer = computer;
}
public java.util.Date setDateAndTime(Record row)
{
	java.sql.Date sqlDateOfBirth = (java.sql.Date) ConversionManager.getDefaultManager().convertObject(
		row.get("BDAY"), java.sql.Date.class);
	java.sql.Time timeOfBirth = (java.sql.Time) ConversionManager.getDefaultManager().convertObject(
		row.get("BTIME"), java.sql.Time.class);	
	/**
	 * Deprecated API is used here because calendars do not work properly in JVIEW.
	 */
	java.util.Date utilDateOfBirth = 
		new java.util.Date(
				sqlDateOfBirth.getYear(),
				sqlDateOfBirth.getMonth(),
				sqlDateOfBirth.getDate(),
				timeOfBirth.getHours(),
				timeOfBirth.getMinutes(),
				timeOfBirth.getSeconds());
	
	return utilDateOfBirth;
}
public void setDesignation(String designation)
{
	this.designation.setValue(designation);
}
private void setDesignationHolder(ValueHolderInterface value)
{
	designation = value;
}
public void setJobDescription(JobDescription newJobDescription)
{
	jobDescription = newJobDescription;
}
public void setManagedEmployees(Vector emps)
{
	// test method mutating
	managedEmployees = emps;
}
public void setManagedEmployeesFromTOPLink(Vector emps)
{
	// test method mutating
	managedEmployees = (Vector) emps.clone();
}
public void setManager(Employee manager) {
	this.manager = manager;
}
public void setPhoneNumbers(Vector v)
{
	 phoneNumbers.setValue(v);
}	
public void setPolicies(Vector theVector)
{
	policies.setValue(theVector);
}
/**
 * Return a platform independant definition of the database table.
 */

public static TableDefinition tableDefinition() {
	TableDefinition definition = new TableDefinition();
	definition.setName("MAP_EMP");
	definition.addField("FNAME", String.class, 20);
	definition.addField("LNAME", String.class, 20);
	definition.addField("SEX", String.class, 10);
	definition.addField("BDAY", java.sql.Date.class);
	definition.addField("BTIME", java.sql.Time.class);
	definition.addField("JDAY", java.sql.Date.class);
	definition.addField("RANK", Integer.class);
	definition.addField("GENDER", String.class, 10);

	// The JDESC field will be added after a plaftorm check in 
	// MappingSystem.createTables()

	definition.addField("M_FNAME", String.class, 20);
	definition.addField("M_LNAME", String.class, 20);
	definition.addField("C_ID", String.class, 15);
	definition.addField("A_ID", java.math.BigDecimal.class,15);
	return definition;
}
@Override
public String toString()
{
	return "Employee(" + firstName + " " + lastName + ")";
}
}