package ru.lisenochek.perks.sql;

import ru.lisenochek.perks.ConfigClass;
import ru.lisenochek.perks.Logger;
import ru.lisenochek.perks.Main;

import java.sql.*;

public class SQL {

    public static Connection connection;
    public static Statement statement;
    public static ResultSet resultSet;

    private static String url = "jdbc:mysql://" + ConfigClass.sqlConfig.get("ip") + ":" + ConfigClass.sqlConfig.get("port") + "/" + ConfigClass.sqlConfig.get("databaseName");
    private static String user = (String) ConfigClass.sqlConfig.get("user");
    private static String password = (String) ConfigClass.sqlConfig.get("password");

    public synchronized static void closeConnection() throws SQLException {
        if (connection == null) return;
        if (!connection.isClosed()) connection.close();
    }

    public synchronized static void openConnection() throws ClassNotFoundException, SQLException {

        if (ConfigClass.sqlConfig.get("SQLMode").equals("sqlite")) {
            if (!Main.plugin.getDataFolder().mkdirs()) Main.plugin.getDataFolder().mkdirs();
            Class.forName("org.sqlite.JDBC");
            connection = DriverManager.getConnection("jdbc:sqlite:plugins/" + Main.plugin.getName() + "/Database.db");
        }

        if (ConfigClass.sqlConfig.get("SQLMode").equals("mysql")) {
            Class.forName("com.mysql.jdbc.Driver");
            connection = DriverManager.getConnection(url, user, password);
        }

        statement = connection.createStatement();
    }

    public synchronized static boolean executeQuery(String query) {

        if (query == null || query.equals("")) {
            Logger.error("Невозможно выполнить запрос! Он равен null или пуст!");
            return false;
        }

        try {
            statement.execute(query);
            statement.close();
            closeConnection();
            openConnection();
            return true;
        } catch (SQLException e) {
            Logger.error("Что-то пошло не так и при запросе появилось исключение:");
            Logger.error(e.getMessage());
            return false;
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
            return false;
        }
    }
}