package me.trent;

import me.trent.verify.User;
import net.dv8tion.jda.core.entities.Member;
import net.dv8tion.jda.core.entities.Role;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.UUID;

public class databaseThread extends Thread {

    @Override
    public void run() {
        while(true){

            try{

                Thread.sleep(500);

                try {
                    if (DB.connection == null || DB.connection.isClosed()) {
                        DB.start();
                    }


                    if (DB.connection != null && !DB.connection.isClosed()) {
                        if (!Main.getManager().isLoaded) {
                            Main.getManager().isLoaded = true;
                            Main.getManager().loadUsers();
                        }
                    }

                    if (DB.connection != null) {
                        Statement statement = DB.connection.createStatement();
                        ResultSet resultSet = statement.executeQuery("SELECT * FROM verify_queue");
                        while (resultSet.next()) {
                            //1 - uuid
                            //2 - code
                            //3 -
                            UUID playerUUID = UUID.fromString(resultSet.getString(1));
                            int code = resultSet.getInt(2);

                            Main.getManager().userCode.put(code, playerUUID);

                            //remove from database
                            DB.removeRow("verify_queue", "uuid", playerUUID.toString());

                            System.out.print("\n User (code) loaded: " + code + "\n");
                        }

                        statement = DB.connection.createStatement();
                        resultSet = statement.executeQuery("SELECT * FROM player_data");
                        while (resultSet.next()) {
                            //1 - uuid
                            //2 - name
                            //3 - rank
                            UUID playerUUID = UUID.fromString(resultSet.getString(1));
                            String name = resultSet.getString(2);
                            String rank = resultSet.getString(3);

                            if (Main.getUtils().getUserFromUUID(playerUUID) != null){
                                User minecraftUser = Main.getUtils().getUserFromUUID(playerUUID);
                                if (Main.getUtils().getMemberFromID(minecraftUser.getDiscordTag()) != null){
                                    Member member = Main.getUtils().getMemberFromID(minecraftUser.getDiscordTag());
                                    Role role = Main.getUtils().getRoleByName(rank);

                                    try {
                                        if (member.getNickname() == null || (!member.getNickname().equalsIgnoreCase(member.getUser().getName()+" ("+name+")"))) {
                                            //not the same name
                                            Main.getUtils().setNickName(member, name);
                                            System.out.print("\n\n Added Nick: " + name + "\n\n");
                                        }
                                    }catch(net.dv8tion.jda.core.exceptions.HierarchyException e){ }

                                    if (role != null){
                                        if (!Main.getUtils().hasRole(member, role)){
                                            Main.getUtils().addRole(member, role);
                                            System.out.print("\n\n Added role: "+role.getName()+"\n\n");
                                        }
                                    }
                                }
                            }
                        }
                    }
                }catch(SQLException e){
                    e.printStackTrace();
                }
            }catch(InterruptedException e){
                break;
            }
        }
    }
}