package nl.kingcrafting.ultrapoints.mangers;

import com.zaxxer.hikari.HikariDataSource;
import nl.kingcrafting.ultrapoints.UltraPoints;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.sql.Statement;

/**
 * Created by Jasper on 14-4-2017.
 */
public class DBManager {

    private UltraPoints plugin;
    private HikariDataSource hikari;
    private Connection connection;


    private String user,database,ip,password;
    private int port;


    public void init() {
        plugin = UltraPoints.getPlugin(UltraPoints.class);
        setup();
        setupHikari();
        setupTables();

    }


    private void setupHikari() {

        hikari = new HikariDataSource();
        hikari.setDataSourceClassName("com.mysql.jdbc.jdbc2.optional.MysqlDataSource");
        hikari.addDataSourceProperty("serverName",  "127.0.0.1");
        hikari.addDataSourceProperty("port", "3306");
        hikari.addDataSourceProperty("databaseName", "plugin");
        hikari.addDataSourceProperty("user", "root");
        hikari.addDataSourceProperty("password", "mijnpassword");
        try {
            connection = hikari.getConnection();
        } catch (SQLException e) {
            e.printStackTrace();
        }


    }
    private void setupTables(){

        try {

            Statement statement = connection.createStatement();
            statement.executeUpdate("CREATE TABLE IF NOT EXISTS Points(UUID varchar(36), COINS int)");

            PreparedStatement pre = connection.prepareStatement("INSERT INTO Points VALUES(?,?) ON DUPLICATE KEY UPDATE COINS=?");
            pre.setString(1, "567f12bb4e284adbb36f177b296223a4");
            pre.setInt(2, 20);
            pre.execute();


        } catch (SQLException e){
            e.printStackTrace();
        }

    }


    private void setup() {
        port = plugin.getConfig().getInt("port");
        ip = plugin.getConfig().getString("host");
        user = plugin.getConfig().getString("user");
        password = plugin.getConfig().getString("password");
        database = plugin.getConfig().getString("database");

    }

    private void initTables() {
    }


}