package ch.myWinery.persistence;

import java.util.List;

import javax.persistence.EntityManager;
import javax.persistence.EntityManagerFactory;
import javax.persistence.Persistence;
import javax.persistence.Query;
import ch.myWinery.model.Wine;

public class WineryDB {
	private static WineryDB wineryDB;
	private static EntityManagerFactory emf;
	private static EntityManager em;

	private WineryDB() {
		emf = Persistence.createEntityManagerFactory("WineryDatabase");
		em = emf.createEntityManager();
	}

	@SuppressWarnings("unchecked")
	public List<Wine> getWines() {
		return em.createQuery("select w from Wine w").getResultList();
	}

	public Wine getWine(int id) {

		Query query = em.createNamedQuery(Wine.findByID);
		query.setParameter("id", id);

		Wine wine = (Wine) query.getSingleResult();

		return wine;
	}

	public static WineryDB getInstance() {
		if (wineryDB == null) {
			wineryDB = new WineryDB();
		}
		return wineryDB;
	}
}