public ArrayList<Models.DatabaseModel.Patient> listAllPatients() {
        String query = "SELECT  `patients`.`ID`" 
                             +",`patients`.`name`" 
                      + "FROM  	`patients`" 
                      + "LEFT JOIN `deletedPatient` ON `patients`.`ID` = `deletedPatient`.`patientId` "
                      + "WHERE `deletedPatient`.`patientId` IS NULL;" ;
        
        ArrayList<Models.DatabaseModel.Patient> allPatients = new ArrayList<>();
        Utils.DBA dba = Helper.getDBA();
        ResultSet rs;
        try {
            rs = Helper.getDBA().executeQuery(query);

            while (rs.next()) {
                Patient newPatient = new Patient();
                newPatient.setID(rs.getInt("id"));
                newPatient.setName(rs.getString("name"));

                allPatients.add(newPatient);
            }

        } catch (SQLException sqlEx) {
            Helper.logException(sqlEx);

        }

        return allPatients;
    }