import java.sql.*;
import java.util.ArrayList;

public class ConnectBD {
    private Connection con;
    private Statement st;
    private ResultSet rs;


    public ConnectBD() {
        try {
            Class.forName("com.mysql.jdbc.Driver");
            con = DriverManager.getConnection("jdbc:mysql://localhost:3306/projectopdm", "root", "");
            st = con.createStatement();
        } catch (Exception e) {
            System.out.println("Error" + e);
        }
    }

    public boolean testPW(String email,String passe){
        String query="Select password from utilizador where IDUtilizador='"+email+"'";
        try{
            rs=st.executeQuery(query);
            if(rs.next()){
                String passeword=rs.getString(1);
                return passe.equals(passeword);
            }
        }catch(Exception e){
            System.out.println("ERROR: "+e);
        }
        return false;
    }

    public boolean inserirUser(String email,String nome,String passe,String dataNascimento){
        //
        return true;
    }

    public ArrayList<String> conversasDoUser(String email){
        String query="select name from chat c,utilizadorchat u where c.IDChat=u.idchat and u.idutilizador='"+email+"'";
        ArrayList<String> chats = new ArrayList<>();
        try {
            rs = st.executeQuery(query);
            while (rs.next()){
                String aux=new String(rs.getString(1));
                chats.add(aux);
            }
        }catch(Exception e){
            System.out.println("ERROR: "+e);
        }
        return chats;
    }

    public ArrayList<String> amigosDoUser(String email){
        //completar aqui
        String query="'"+email+"'";
        ArrayList<String> amigos = new ArrayList<>();
        try {
            rs = st.executeQuery(query);
            while (rs.next()){
                String aux=new String(rs.getString(1));
                amigos.add(aux);
            }
        }catch(Exception e){
            System.out.println("ERROR: "+e);
        }
        return amigos;
    }

}