package com.k_int.aggr2.mimsy.data.hdo;

import java.util.ArrayList;
import java.util.List;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.JoinColumn;
import javax.persistence.JoinTable;
import javax.persistence.Table;

import org.hibernate.HibernateException;
import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.annotations.Cascade;
import org.hibernate.annotations.CollectionOfElements;

import com.k_int.mimsy.ref.ElementDefinitionTypeEnum;
import com.k_int.mimsy.ref.MimsyDataTypeEnum;

@Entity
@Table(name="ELEMENT_DEFINITION")
public class ElementDefinitionHDO 
{
	private Long id;
	private String name;
	private String solr_identifier;
	private List<MimsyDataTypeEnum> applicable_mimsy_data_types = new ArrayList<MimsyDataTypeEnum>();
	private ElementDefinitionTypeEnum definition_type = ElementDefinitionTypeEnum.FLEXIBLE;
	
	protected ElementDefinitionHDO(){;}

	@Id
	@Column(name="ID")
	@GeneratedValue(strategy=GenerationType.AUTO)
	public Long getId() 
	{
		return id;
	}

	public void setId(Long id) 
	{
		this.id = id;
	}

	@Column(name="NAME")
	public String getName() 
	{
		return name;
	}

	public void setName(String name) 
	{
		this.name = name;
	}

	@Column(name="SOLR_IDENTIFIER")
	public String getSolrIdentifier()
	{
		return solr_identifier;
	}

	public void setSolrIdentifier(String solr_identifier) 
	{
		this.solr_identifier = solr_identifier;
	}

	@CollectionOfElements
	@JoinTable(name="ELEMENT_DEFINITION_DATA_TYPES_LINK")
	@JoinColumn(name="ELEMENT_DEFINITION_FK", referencedColumnName="ID")
	@Cascade(org.hibernate.annotations.CascadeType.DELETE_ORPHAN)
	@Column(name="MIMSY_DATA_TYPE")
	public List<MimsyDataTypeEnum> getApplicableMimsyDataTypes() 
	{
		return applicable_mimsy_data_types;
	}

	public void setApplicableMimsyDataTypes(List<MimsyDataTypeEnum> applicable_mimsy_data_types) 
	{
		this.applicable_mimsy_data_types = applicable_mimsy_data_types;
	}
	
	@Column(name="DEFINITION_TYPE")
	public ElementDefinitionTypeEnum getDefinitionType() 
	{
		return definition_type;
	}

	public void setDefinitionType(ElementDefinitionTypeEnum definition_type) 
	{
		this.definition_type = definition_type;
	}
	
	//LOOKUP BY ID
	public static ElementDefinitionHDO lookupOrCreate(Session session, Long id)
	{
		ElementDefinitionHDO retval = ElementDefinitionHDO.lookupById(session, id);
		
		if (retval == null) 
		{
			try
			{
				retval = new ElementDefinitionHDO(); 
				session.save(retval);
				session.flush();				 
			}
			catch(Exception e)
			{
		 
			}			 
		}
		return retval;
	}
	

	//LOOKUP BY NAME
	public static ElementDefinitionHDO lookupOrCreate(Session session, String name)
	{
		ElementDefinitionHDO retval = ElementDefinitionHDO.lookupByName(session, name);
		
		if (retval == null) 
		{
			try
			{
				retval = new ElementDefinitionHDO(); 
				retval.setName(name);
				session.save(retval);
				session.flush();				 
			}
			catch(Exception e)
			{
		 
			}			 
		}
		return retval;
	}
	
	public static ElementDefinitionHDO lookupById(Session session, Long id)
	{		
		if(id == null)
		{
			return null;
		}
			
		try 
		{
			Query q = session.createQuery("Select x from com.k_int.aggr2.mimsy.data.hdo.ElementDefinitionHDO x where x.id = ?");
			q.setLong(0, id);
			
			return (ElementDefinitionHDO) q.uniqueResult();
		}
		catch (HibernateException he) 
		{
			throw new HibernateException(he);
		}    
	}
	
	public static ElementDefinitionHDO lookupByName(Session session, String name)
	{		
		if(name == null)
		{
			return null;
		}
			
		try 
		{
			Query q = session.createQuery("Select x from com.k_int.aggr2.mimsy.data.hdo.ElementDefinitionHDO x where x.name = ?");
			q.setParameter(0, name);
			
			return (ElementDefinitionHDO) q.uniqueResult();
		}
		catch (HibernateException he) 
		{
			throw new HibernateException(he);
		}    
	}
}