package gamestudio.service;

import gamestudio.entity.Rating;

import java.sql.*;
import java.util.ArrayList;
import java.util.List;

/**
 * Created by HP on 18.4.2016.
 */

public class RatingServiceImpl implements RatingService {

    private static final String URL = "jdbc:oracle:thin:@oracle.kpi.fei.tuke.sk:1521:db11g";;
    private static final String LOGIN = "marcelhvozdik";
    private static final String PASSWORD = "marcelhvozdik";


    private static final String INSERT_STMT =
            "INSERT INTO hodnotenie (player, game, rating) VALUES (?, ?, ?)";

    private static final String SELECT_STMT =
            "SELECT player, game, rating FROM hodnotenie WHERE player=? ORDER BY rating DESC";




    @Override
    public void addRating(Rating rating) throws RatingException {

        try(Connection connection = DriverManager.getConnection(URL, LOGIN, PASSWORD);
            PreparedStatement ps = connection.prepareStatement(INSERT_STMT)) {
            ps.setString(1, rating.getPlayer());
            ps.setString(2, rating.getGame());
            ps.setInt(3, rating.getRating());
            ps.executeUpdate();
        } catch (SQLException e) {
            throw new RatingException("Error saving rating", e);
        }
    }




    @Override
    public List<Rating> getBestRating(String game) throws RatingException {
        List<Rating> ratings = new ArrayList<>();

        try(Connection connection = DriverManager.getConnection(URL, LOGIN, PASSWORD);
            PreparedStatement ps = connection.prepareStatement(SELECT_STMT)) {

            ps.setString(1,game);
            try(ResultSet rs = ps.executeQuery()){
                while (rs.next()){
                    Rating rating = new Rating(rs.getString(1), rs.getString(2),rs.getInt(3));
                    ratings.add(rating);
                }
            }

        }catch (SQLException e){
            throw new RatingException("Error loading rating",e);
        }

    return ratings;


    }


    public static void main(String[] args) throws RatingException {

        RatingService ratingService = new RatingServiceImpl();

        System.out.println(ratingService.getBestRating("TiltMazes"));



    }

}