CityDaoImpl.java

package fr.openwide.core.basicapp.core.business.referencedata.dao;

import org.springframework.stereotype.Repository;

import com.querydsl.jpa.impl.JPAQuery;

import fr.openwide.core.basicapp.core.business.common.model.PostalCode;
import fr.openwide.core.basicapp.core.business.referencedata.model.City;
import fr.openwide.core.basicapp.core.business.referencedata.model.QCity;
import fr.openwide.core.jpa.business.generic.dao.GenericEntityDaoImpl;

@Repository
public class CityDaoImpl extends GenericEntityDaoImpl<Long, City> implements ICityDao {

	@Override
	public City getByLabelAndPostalCode(String label, PostalCode postalCode) {
		return new JPAQuery<>(getEntityManager())
				.from(QCity.city)
				.where(QCity.city.label.eq(label))
				.where(QCity.city.postalCode.eq(postalCode))
				.select(QCity.city)
				.fetchOne();
	}

}