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();
    }
}