package net.krentox.cloudapi.manager.mysql;

import org.bukkit.configuration.file.FileConfiguration;
import org.bukkit.configuration.file.YamlConfiguration;

import java.io.File;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

public class MySQL {

    public Connection connection;


    private File file = new File("plugins/CloudAPI/", "mysql.yml");
    private FileConfiguration configuration = YamlConfiguration.loadConfiguration(file);

    public void loadConfig() {

        configuration.options().copyDefaults(true);

        configuration.addDefault("host", "localhost");
        configuration.addDefault("user", "root");
        configuration.addDefault("port", "3306");
        configuration.addDefault("password", "password");
        configuration.addDefault("database", "BungeeSystem");

        try {
            configuration.save(file);
        } catch (IOException e) {
            e.printStackTrace();
        }
    }

    public void startConnection() {

        loadConfig();

        String host = configuration.getString("host");
        String user = configuration.getString("user");
        String port = configuration.getString("port");
        String password = configuration.getString("password");
        String database = configuration.getString("database");

        if (!isConnected()) {


            try {
                connection = DriverManager.getConnection("jdbc:mysql://" + host + ":" + port + "/" + database + "?autoReconnect=true", user, password);
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    }

    public void closeConnection() {

        if (isConnected()) {
            try {
                connection.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }

    }

    private boolean isConnected() {

        return connection != null;

    }

}