package sk.tuke.gamestudio.server.service;

import org.springframework.transaction.annotation.Transactional;
import sk.tuke.gamestudio.server.entity.Rating;

import javax.persistence.EntityManager;
import javax.persistence.PersistenceContext;

/**
 * Created by martinsenitka on 30/03/17.
 */

@Transactional
public class RatingServiceJPA implements RatingService {


    @PersistenceContext
    private EntityManager entityManager;


    @Override
    public void setRating(Rating rating) throws RatingException {
        entityManager.persist(rating);
    }

    @Override
    public int getAverageRating(String game) throws RatingException {
        return ((Double) entityManager.createNamedQuery("Rating.getAverageRating")
                .setParameter("game", game).setMaxResults(10).getSingleResult()).intValue();
    }


    @Override
    public int getRating(String game, String player) throws RatingException {
        return ((Double) entityManager.createNamedQuery("Rating.getRating")
                .setParameter("game", game).setParameter("player",player).setMaxResults(10).getSingleResult()).intValue();
    }
}