import events.Queue;
import net.dv8tion.jda.core.JDA;
import net.dv8tion.jda.core.JDABuilder;
import net.dv8tion.jda.core.entities.Channel;
import net.dv8tion.jda.core.entities.User;
import net.dv8tion.jda.core.events.guild.GenericGuildEvent;
import net.dv8tion.jda.core.events.message.guild.GuildMessageReceivedEvent;
import net.dv8tion.jda.core.hooks.ListenerAdapter;

import javax.security.auth.login.LoginException;
import java.sql.*;
import java.util.TimerTask;

public class FindMatch extends TimerTask {
    @Override
    public void run() {

        //System.out.println("run");
        try{
            //JDA jda = new JDABuilder("NTI4NzI4OTU1MjQ3Nzg4MDQz.DwmhPA.YvrhvvIDO3_sLQrZLMXZviV8jlg").build();
            Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/matchmaking", "kanedu", "kanedu");
            //Queue channel = new Queue();
            //System.out.println(channel.getChannelID());
            PreparedStatement user1 = con.prepareStatement("SELECT discorduser, inqueue, elo FROM " + "c533518528108560394" +
                    " WHERE inqueue = 1 ORDER BY RAND() LIMIT 1");
            ResultSet user1RS = user1.executeQuery();
            String u1 = null;
            int u1Elo = -1;
            if(user1RS.next()){
                u1 = user1RS.getString("discorduser");
                u1Elo = user1RS.getInt("elo");
            }

            //Make sure users are not matched with themselves
            PreparedStatement user2 = con.prepareStatement("SELECT discorduser, inqueue, elo" +
                    " FROM " + "c533518528108560394" +
                    " WHERE inqueue = 1 AND discorduser <> "+u1+" ORDER BY RAND() LIMIT 1");
            ResultSet user2RS = user2.executeQuery();
            String u2 = null;
            int u2Elo = -1;
            if(user2RS.next()){
                u2 = user2RS.getString("discorduser");
                u2Elo = user2RS.getInt("elo");
            }

            User u1User = MatchmakingMain.jda.retrieveUserById(u1).complete();
            User u2User = MatchmakingMain.jda.retrieveUserById(u2).complete();


            if(Math.abs(u1Elo-u2Elo)<150){
                System.out.println(u1);
                System.out.println(u2);
                System.out.println(u1User.isFake());
                System.out.println(u2User.isFake());
                u1User.openPrivateChannel().complete().sendMessage("Matched").queue();
                u2User.openPrivateChannel().complete().sendMessage("Matched").queue();
            }
            else{

            }

        } catch (SQLException e) {
            e.printStackTrace();
        }

    }