package com.k_int.generic.schema.hdo;

import java.util.SortedSet;
import java.util.TreeSet;

import javax.persistence.CascadeType;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.FetchType;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.JoinColumn;
import javax.persistence.JoinTable;
import javax.persistence.OneToMany;

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.Sort;
import org.hibernate.annotations.SortType;

@Entity
@Table(name="SCHEMA_SECTION")
public class SchemaSectionHDO implements Comparable<SchemaSectionHDO>
{
	private Long id;
	private String name = null;
	private Integer position = Integer.MAX_VALUE; //always last by default
	private Boolean expanded = Boolean.TRUE;
	private SortedSet<SchemaElementHDO> ordered_fields = new TreeSet<SchemaElementHDO>();
	
	protected SchemaSectionHDO(){;}
	
	@Id
	@Column(name="ID")
	@GeneratedValue(strategy=GenerationType.AUTO)
	public Long getId()
	{ 
		return id;                          
	} 
	
	protected 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="POSITION")
	public Integer getPosition() 
	{
		return position;
	}

	public void setPosition(Integer position) 
	{
		this.position = position;
	}
	
	@Column(name="EXPANDED")
	public Boolean getExpanded() 
	{
		return expanded;
	}

	public void setExpanded(Boolean expanded) 
	{
		this.expanded = expanded;
	}
		
	@OneToMany(cascade=CascadeType.ALL, fetch=FetchType.EAGER)
	@JoinTable(name="SCHEMA_SECTION_ELEMENTS_LINK",
	         joinColumns=@JoinColumn(name="SCHEMA_SECTION_FK", referencedColumnName="ID"),
	         inverseJoinColumns= @JoinColumn(name="SCHEMA_ELEMENT_FK", referencedColumnName="ID"))  
	@Cascade({org.hibernate.annotations.CascadeType.SAVE_UPDATE})
	@Sort(type = SortType.NATURAL)
	public SortedSet<SchemaElementHDO> getOrderedFields()
	{
		return ordered_fields;
	}
	
	public void setOrderedFields(SortedSet<SchemaElementHDO> ordered_fields)
	{
		this.ordered_fields = ordered_fields;
	}
	
	public static SchemaSectionHDO lookupOrCreate(Session session, Long id)
	{
		SchemaSectionHDO retval = SchemaSectionHDO.lookupById(session, id);
		
		if (retval == null) 
		{
			try
			{
				retval = new SchemaSectionHDO(); 
				session.save(retval);
				session.flush();				 
			}
			catch (HibernateException he) 
			{
				throw new HibernateException(he);
			}    		 
		}
		return retval;
	}
	
	public static SchemaSectionHDO lookupById(Session session, Long id)
	{		
		if(id == null)
		{
			return null;
		}
			
		try 
		{
			Query q = session.createQuery("Select x from com.k_int.generic.schema.hdo.SchemaSectionHDO x where x.id = ?");
			q.setLong(0, id);
			
			return (SchemaSectionHDO) q.uniqueResult();
		}
		catch (HibernateException he) 
		{
			throw new HibernateException(he);
		}    
	}
	
	/* Comparator method used for sorting */
	public int compareTo(SchemaSectionHDO o) 
	{
        return this.position - o.position;
    }
}