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

import java.io.Serializable;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.EnumType;
import javax.persistence.Enumerated;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Inheritance;
import javax.persistence.InheritanceType;
import javax.persistence.JoinColumn;
import javax.persistence.OneToOne;
import javax.persistence.Table;

import org.hibernate.HibernateException;
import org.hibernate.Query;
import org.hibernate.Session;

import com.k_int.mimsy.ref.DataException;
import com.k_int.mimsy.ref.MediaRecordTypeEnum;

@Entity
@Table(name="CIIM_MEDIA_DESCRIPTION")
@Inheritance(strategy=InheritanceType.JOINED)
public class CIIMMediaDescriptionHDO implements Serializable
{
	private static final long 		serialVersionUID = 1L;
	private Long id;
	private String name;
	private String location;
	private MediaRecordTypeEnum type;
	private MimsyMediaDataHDO mediaData;
	
	protected CIIMMediaDescriptionHDO()
	{;}
	
	/*protected CIIMMediaDescriptionHDO(String name, String location, MediaRecordTypeEnum type)
	{
		this.name=name;
		this.location=location;
		this.type=type;
	}*/
	@Id
	@Column(name="ID")
	@GeneratedValue(strategy=GenerationType.AUTO)
	public Long getId()
	{
		return this.id;
	}
	
	protected void setId(Long id)
	{
		this.id = id;
	}
	
	protected void setLocation(String location)
	{
		this.location=location;
	}
	
	@Column(name="MEDIA_LOCATION",length=255)
	public String getLocation()
	{
		return location;
	}
	
	protected void setName(String name)
	{
		this.name=name;
	}
	
	@Column(name="MEDIA_NAME",length=64)
	public String getName()
	{
		return name;
	}
	
	@Column(name="MEDIA_TYPE")
	@Enumerated(EnumType.ORDINAL)
	public MediaRecordTypeEnum getMediaType()
	{
		return type;
	}
	
	protected void setMediaType(MediaRecordTypeEnum type)
	{
		this.type=type;
	}
	
	@OneToOne
	@JoinColumn(name="MIMSY_MEDIA_DATA_FK")
	public MimsyMediaDataHDO getMediaData()
	{
		return mediaData;
	}
	
	public void setMediaData(MimsyMediaDataHDO mediaData) 
	{
		this.mediaData = mediaData;
	}
			
	public static CIIMMediaDescriptionHDO lookupByName(Session session, String name)throws DataException
	{		
		if(name == null)
		{
			return null;
		}
			
		try 
		{
			Query q = session.createQuery("Select x from com.k_int.aggr2.mimsy.data.hdo.CIIMMediaDescriptionHDO x where x.name = ?");
			q.setParameter(0, name);
			
			return (CIIMMediaDescriptionHDO) q.uniqueResult();
		}
		catch (HibernateException he) 
		{
			throw new DataException(he);
		}    
	}
	
	public static CIIMMediaDescriptionHDO lookupById(Session session, Long id)throws DataException
	{		
		if(id == null)
		{
			return null;
		}
			
		try 
		{
			Query q = session.createQuery("Select x from com.k_int.aggr2.mimsy.data.hdo.CIIMMediaDescriptionHDO x where x.id = ?");
			q.setLong(0, id);
			
			return (CIIMMediaDescriptionHDO) q.uniqueResult();
		}
		catch (HibernateException he) 
		{
			throw new DataException(he);
		}    
	}
	
}