package destinymod.MySQL;



import org.bukkit.entity.Player;

import java.sql.*;

public class MySql {

    private String urlbase,host,database,username,password;

    public MySql(String urlbase, String host, String database, String username, String password) {
        this.urlbase = urlbase;
        this.host = host;
        this.database = database;
        this.username = username;
        this.password = password;

    }


    public Connection con;


    //connection
    public void connect(){
        if(!isConnected()){
            try{
                con = DriverManager.getConnection(urlbase + host + "/" + database, username, password);
                System.out.println("Connection etablie !");
            }catch (SQLException e) {
                e.printStackTrace();
                System.out.println("Accès Refusé");
            }

        }
    }

    //public void disconnect(){
        //if(isConnected()){
            //try{
                //con.close();
                //System.out.print("Connection Fermée !");
            //}catch (SQLException e){
               // e.printStackTrace();
           // }
       // }
    //}

    private boolean isConnected() {
        return (con != null);
    }
    public Connection getConnection(){
        return con;
    }


    public boolean getReport(Player player){
        try{
            PreparedStatement q = (PreparedStatement) con.prepareStatement("SELECT * FROM report WHERE uuid = ?");
            q.setString(1, player.getUniqueId().toString());
            ResultSet resultat =  q.executeQuery();
            boolean getReport = resultat.next();
            q.close();
            return getReport;
        }catch (SQLException e){
            e.printStackTrace();
        }
        return false;
    }


    public void postReport(Player player, String arg){


        try{
            PreparedStatement q = (PreparedStatement) con.prepareStatement("INSERT INTO report (uuid, reason) VALUES (?,?)");
            q.setString(1, player.getUniqueId().toString());
            q.setString(2, arg);
            q.execute();
        }catch (SQLException e){
            e.printStackTrace();
        }
    }

    public int getHowManyReport(Player player){
        return 0;
    }







}