package TopKills;

import java.io.File;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import org.bukkit.plugin.Plugin;

import com.gmail.filoghost.holographicdisplays.api.Hologram;

public class Database {
    private String url;
    private Plugin p;
    public Database(Plugin p) throws Exception {
        this.p = p;
        url = "jdbc:sqlite:"+p.getDataFolder()+File.separator+"database.db";
        Class.forName("org.sqlite.JDBC").newInstance();
        Connection c = getConnection();
        Statement s = c.createStatement();
        s.executeUpdate("CREATE TABLE IF NOT EXISTS top (`nickname` TEXT, `kills` INTEGER);");
        s.close();
        c.close();
    }

    private Connection getConnection() throws SQLException {
        return DriverManager.getConnection(url);
    }

    public void updateData(String nick) {
        try {
            Connection c = getConnection();
            Statement s = c.createStatement();
            ResultSet r = s.executeQuery("SELECT * FROM top");
            int kills=0;
            while(r.next()) {
                String str = r.getString(1);
                if(str.equalsIgnoreCase(nick)) {
                    kills = r.getInt(2);
                    break;
                }
            }
            s.executeUpdate(String.format("UPDATE top SET `kills`='%d' WHERE `nickname`='%s';", kills+1, nick));
            r.close();
            s.close();
            c.close();
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }

    public void addData(String nick) {
        try {
            Connection c = getConnection();
            Statement s = c.createStatement();
            ResultSet r = s.executeQuery("SELECT * FROM top");
            Boolean contains = false;
            while(r.next()) {
                String str = r.getString(1);
                if(str.equalsIgnoreCase(nick)) {
                    contains = true;
                    break;
                }
            }
            if(!contains) {
                s.executeUpdate(String.format("INSERT INTO top VALUES ('%s','%d')", nick, 0));
                r.close();
                s.close();
                c.close();
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }

    public void getData(Hologram h){
        try {
            Connection c = getConnection();
            Statement s = c.createStatement();

            h.clearLines();

            ResultSet r = s.executeQuery("SELECT * FROM top ORDER BY kills DESC, nickname ASC;");
            int i=1;
            while(r.next()) {

                h.insertTextLine(i-1,
                        replaceHolo(p.getConfig().getString("Messages.Hologram"),
                                Integer.toString(i),
                                r.getString(1),
                                Integer.toString(r.getInt(2)
                )));
                i++;
            }

            r.close();
            s.close();
            c.close();
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }

    private String replaceHolo (String str, String first, String second, String third) {
        str = str
        .replace("&", "§")
        .replace("%i%", first)
        .replace("%nickname%", second)
        .replace("%kills%", third);
        return str;
    }
}