package org.itracker.persistence.dao;
   
   import java.util.List;
   
   import org.hibernate.HibernateException;
   import org.hibernate.Query;
   import org.itracker.model.Language;
   
   /**
   * 
   */
  public class LanguageDAOImpl extends BaseHibernateDAOImpl<Language> 
          implements LanguageDAO {
  
      public Language findById(Integer id) {
          Language language;
          
          try {
              language = (Language)getSession().get(Language.class, id);
          } catch (HibernateException ex) {
              throw convertHibernateAccessException(ex);
          }
          return language;
      }
      
      public Language findByKeyAndLocale(String key, String locale) {
          Language language;
          
          try {
              Query query = getSession().getNamedQuery(
                      "LanguagesByKeyAndLocaleQuery");
              query.setString("key", key);
              query.setString("locale", locale);
              language = (Language)query.uniqueResult();
          } catch (HibernateException ex) {
              throw convertHibernateAccessException(ex);
          }
          
          if (language == null) {
              throw new NoSuchEntityException("No language item for " 
                      + key + " " + locale);
          }
          return language;
      }
      
      @SuppressWarnings("unchecked") 
      public List<Language> findByKey(String key) {
          List<Language> languages;
          
          try {
              Query query = getSession().getNamedQuery("LanguagesByKeyQuery");
              query.setString("key", key);
              languages = query.list();
          } catch (HibernateException ex) {
              throw convertHibernateAccessException(ex);
          }
          return languages;
      }
      
      @SuppressWarnings("unchecked") 
      public List<Language> findByLocale(String locale) {
          List<Language> languages;
          
          try {
              Query query = getSession().getNamedQuery("LanguagesByLocaleQuery");
              query.setString("locale", locale);
              languages = query.list();
          } catch (HibernateException ex) {
              throw convertHibernateAccessException(ex);
          }
          return languages;
      }
      
  }