package de.luckyapi.manager;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.time.Instant;
import java.time.LocalDateTime;
import java.time.ZoneId;
import java.util.Date;
import java.util.UUID;

public class MySQL {

    public static Connection con;

    public static void connect() throws SQLException {
        if(!(isConnected())){
            try {
                con = DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/db", "root", "");
                System.out.println("[KARTAWK] MySQL connected");
            } catch (SQLException e){
                e.printStackTrace();
            }
        }

    }

    public static void close(){
        if(isConnected()){
            try {
                con.close();
                System.out.println("Kartawk MYSQL closed");
            } catch (SQLException e) {
                e.printStackTrace();
            }

        }

    }

    public static boolean isConnected(){
        return con != null;
    }


    public static void createTable(){
        if(isConnected()){

            //UUID END REASON DATE BANNED COUNT
            try {
                con.createStatement().executeUpdate("CREATE TABLE IF NOT EXISTS kartawk_Bans (UUID VARCHAR(40), REASON VARCHAR(100), DATUM DATETIME, ANZAHL INT(10))");
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    }

    public static void update(String qry){
        if(isConnected()){
            try {
                con.createStatement().executeUpdate(qry);
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }

    }

    public static ResultSet getResult(String qry){
        if(isConnected()){
            try {
               return con.createStatement().executeQuery(qry);
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
        return null;
    }


    public static LocalDateTime convertToLocalDateTimeViaMilisecond(Date dateToConvert) {
        return Instant.ofEpochMilli(dateToConvert.getTime())
                .atZone(ZoneId.systemDefault())
                .toLocalDateTime();
    }
}