package com.andu033.restapi.basiccrud.DAO.Impl;

import com.andu033.restapi.basiccrud.DAO.spotDAO;
import com.andu033.restapi.basiccrud.models.spot;
import com.andu033.restapi.basiccrud.models.user;
import org.hibernate.Criteria;
import org.hibernate.HibernateException;
import org.hibernate.SessionFactory;
import org.hibernate.criterion.Restrictions;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Component;
import org.springframework.stereotype.Controller;

import java.util.List;
@Component
public class HibernateSpotDAO implements spotDAO {

	@Autowired
	public SessionFactory sessionFactory;

	@Override
	public List<spot> getSpots(String country, double windProbability) {
		sessionFactory.getCurrentSession().beginTransaction();
		try {


			Criteria criteria = sessionFactory.getCurrentSession().createCriteria(spot.class);
			if (country != null)
				criteria.add(Restrictions.eq("country", country));
			criteria.add(Restrictions.eq("windProbability", windProbability));

			List<spot> spotList = criteria.list();

			if (spotList != null) {
				return spotList;
			}

			sessionFactory.getCurrentSession().getTransaction().commit();
		} catch (HibernateException e) {
			e.printStackTrace();
			sessionFactory.getCurrentSession().getTransaction().rollback();
		}
		return null;
	}

	@Override
	public void saveFavoriteSpot(int spotId) {

	}

	@Override
	public void deleteFavoriteSpot(int spotId) {

	}
}