package me.probablydiary.caveeconomy.database;

import me.probablydiary.caveeconomy.CaveEconomy;
import me.probablydiary.caveeconomy.util.DatabaseUtil;
import org.bukkit.ChatColor;

import java.sql.*;

public class Database {

    public static Connection getConnection(){
        try {
            Class.forName("org.h2.Driver");
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        }
        Connection connection = null;
        try {
            connection = DriverManager.getConnection(CaveEconomy.getConnectionURL());
        }catch (SQLException ex){
            System.out.println("" + ChatColor.RED + ChatColor.BOLD + "SQL Exception caught!");
        }

        return connection;
    }

    public static void initializeDatabase() {

        Connection connection = getConnection();
        PreparedStatement preparedStatement;
        try {
            preparedStatement = connection.prepareStatement("CREATE TABLE IF NOT EXISTS Accounts(PlayerUUID varchar, Balance double);");
            preparedStatement.execute();

            String defaultUUID = "systemMoney";
            if(!DatabaseUtil.accountExists(defaultUUID)){
                preparedStatement = connection.prepareStatement("INSERT INTO ACCOUNTS(PlayerUUID,Balance) VALUES(?,?)");
                preparedStatement.setDouble(2,55);
                preparedStatement.setString(1,defaultUUID);
                preparedStatement.execute();
            }
            connection.close();
        } catch (SQLException ex) {
            System.out.println("" + ChatColor.RED + ChatColor.BOLD + "Couldn't create table");
        }

    }
}