package com.megatim.fdxconsultation.dao.impl.integration;
|
|
import com.megatim.fdxcommons.dao.ifaces.integration.ColumnDefinitionDAO;
|
import com.megatim.fdxcommons.model.integration.ColumnDefinition;
|
import java.util.List;
|
import javax.ejb.Stateless;
|
import javax.persistence.EntityManager;
|
import javax.persistence.PersistenceContext;
|
import javax.persistence.Tuple;
|
|
/**
|
*
|
* @author ASUS
|
*/
|
@Stateless
|
public class ColumnDefinitionDAOImpl implements ColumnDefinitionDAO {
|
|
@PersistenceContext(unitName = "fdxConsultationPersistenceUnit")
|
EntityManager em;
|
|
@Override
|
public EntityManager getEntityManager() {
|
return em;
|
}
|
|
@Override
|
public Class<ColumnDefinition> getManagedEntityClass() {
|
return (ColumnDefinition.class);
|
}
|
|
@Override
|
public List<ColumnDefinition> findByReferentielAndTypeFichier(String referentielVersion, String codeTypeFichier) {
|
return em
|
.createQuery("SELECT c FROM ColumnDefinition c"
|
+ " WHERE c.referentielVersion = :referentielVersion AND c.codeTypeFichier = :codeTypeFichier")
|
.setParameter("referentielVersion", referentielVersion)
|
.setParameter("codeTypeFichier", codeTypeFichier)
|
.getResultList();
|
|
}
|
|
@Override
|
public List<Tuple> byRefVersionAndByTypeFichier() {
|
String query = "SELECT codetypefichier, referentielversion"
|
+ " FROM columndefinition"
|
+ " GROUP BY referentielversion, codetypefichier"
|
+ " ORDER BY referentielversion";
|
return em.createNativeQuery(query, Tuple.class).getResultList();
|
}
|
}
|
