Developer Testing
Confirmation of Standards Adherence
Activity | Date Tested | Notes |
NA |
| |
NA |
| |
NA |
|
Developer Tests and Outcomes
Genereate the NEW state from Grouper
| Test | Outcome |
| new_state: init_stud_enr | mdlfeeds_stud_enr_new is empty |
| new_state: init_co_enr | mdlfeeds.mdlfeeds_co_enr_new is empty |
| new_state: init_stud | mdlfeeds.mdlfeeds_stu_new is empty |
| new_state: init_co | mdlfeeds.mdlfeeds_co_new is empty |
| new_state: set_co_new known UUN | user info added to mdlfeeds.mdlfeeds_co_new |
| new_state: set_co_new unknown UUN | No user info added to mdlfeeds.mdlfeeds_co_new, log table updated |
| new_state: set_co_new duplicate of existing UUN | No change in mdlfeeds.mdlfeeds_co_new |
| new_state: set_stu_new known UUN | user info added to mdlfeeds.mdlfeeds_stu_new |
| new_state: set_stu_new unknown UUN | No user info added to mdlfeeds.mdlfeeds_stu_new, log table updated |
| new_state: set_stu_new duplicate of existing UUN | No change in mdlfeeds.mdlfeeds_stu_new |
| new_state: set_stud_enr_new | row added to mdlfeeds.mdlfeeds_stud_enr_new |
| new_state: get_stud_enr_new | member values (if any) are correctly inserted into mdlfeeds.mdlfeeds_stud_enr_new and mdlfeeds.mdlfeeds_stu_new |
| new_state: load_eugex_data | mdlfeeds.mdlfeeds_eugx contains the correct numer of rows with the csv fields mapped to the correct columns in the table |
| new_state: lookup_eugex_data normal course code | returns correct coursetitle and schoolid |
| new_state: lookup_eugex_data course code with escaped '+' | returns correct coursetitle and schoolid |
| new_state: lookup_eugex_data course code not in EUGEX feed | returns empty coursetitle and schoolid |
| new_state: set_co_enr_new | row added to mdlfeeds.mdlfeeds_co_enr_new |
| new_state: get_co_uun_from_staff_no known staff no | returns UUN |
| new_state: get_co_uun_from_staff_no unknown staff no | returns empty UUN |
| new_state: get_co_enr_new | organiser/secretary values (if any) are correctly inserted into mdlfeeds.mdlfeeds_co_enr_new and mdlfeeds.mdlfeeds_co_new |
| new_state: init_courses_new | mdlfeeds.mdlfeeds_crs_new is empty |
| new_state: set_courses_new | row added to mdlfeeds.mdlfeeds_crs_new |
| new_state: get_courses_new | all courses (if any) in the correct LDAP cn inserted into mdlfeeds.mdlfeeds_crs_new |
| new_state: process_new_state_for_all_years() | call all the above successfully |
Generate the current state from Moodle
| Test | Outcome |
| current_state: current_courses | `mdlfeeds_crs_curr` contains the courses found under 'uoe_top' |
| current_state: current_course_organisers | `mdlfeeds_co_curr` is populated wit the course owners enrolled in the courses in `mdlfeeds_crs_curr` |
| current_state: current_course_organiser_enrolments | `mdlfeeds_co_enr_curr` is populated with the active enrollments in the courses in `mdlfeeds_crs_curr` |
| current_state:current_students | `mdlfeeds_stu_curr` is populated wit the course owners enrolled in the courses in `mdlfeeds_crs_curr` |
| current_state:current_student_enrolments | `mdlfeeds_stud_enr_curr` is populated with the active enrollments in the courses in `mdlfeeds_crs_curr` |
| current_state:process_current_state | call all the above successfully |
Generate actions
| Test | Outcome |
| action: courses_actions Add | Courses that exists in New but not in Current are inserted into `mdlfeeds_crs_action` as an 'A' record |
| action: courses_actions Delete | Courses that exists in Current but not in New are inserted into `mdlfeeds_crs_action` as an 'D' record |
| action: courses_actions Update | Courses that exists in Current and in New with different values are inserted into `mdlfeeds_crs_action` as an 'U' record |
| action:user_actions Add | People that exists in New but not in Current are inserted into `mdlfeeds_usr_action` as an 'A' record |
| action:user_actions Add | People that exists in Current and in New with different values are inserted into `mdlfeeds_usr_action` as an 'U' record |
| action:course_organiser_enrolments_actions Add | Enrolments that exists in New but not in Current are inserted into `mdlfeeds_co_enr_action` as an 'A' record |
| action:course_organiser_enrolments_actions Delete | Enrolments that exists in Current but not in New are inserted into `mdlfeeds_co_enr_action` as an 'D' record |
| action:student_enrolments_actions Add | Enrolments that exists in New but not in Current are inserted into `mdlfeeds_stud_enr_action` as an 'A' record |
| action:student_enrolments_actions Delete | Enrolments that exists in Current but not in New are inserted into `mdlfeeds_stud_enr_action` as an 'D' record |
| action: process_actions | call all the above successfully |
Validate Actions
| Test | Outcome |
| validate: user_validations no username in mdlfeeds_usr_action | validated=0 |
| validate: user_validations username in mdlfeeds_usr_action exists in Moodle | validated=0 |
| validate: user_validations idnumber in mdlfeeds_usr_action exists in Moodle | validated=0 |
| validate:course_validations 'A'dd course action that is soft deleted course | Action='U' |
| validate: validate_actions | call all the above successfully |
Webservice calls
| Test | Outcome |
| web-service:add_course_categories | 'AYXXXX/ZZZZ EUCLID courses' category created under uoe_top node if it doesn't exist |
| web-service:add_course_categories | 'SU123-XXXX/ZZZZ' school category created under AY node if it doesn't exist |
| web-service:add_courses | course created with the right names and in the right category |
| web-service:add_users | user created with the right username, firstname,surname., email with 'shibboleth' authentication. |
| web-service:add_co_enrolments | 'courseowner role assigned to the identified user in the identfied course |
| web-service:remove_courses | 'visible' flag of the identfied course set to 0 |
| web-service:suspend_student_enrolments | state of the enrolment in the role of the user in the course is set to 'suspended' |
| web-service:modify_courses | changes in names or visibility state of the course are applied |
| web-service:modify_users | changes in username, firstname,surname, email are applied |
| web-service:web_services_all | if the number of course deletions found > configured max course deletions: exit |
| web-service:web_services_all | if the number of course un-enrolments found > configured max un-enrolments: exit |
| web-service:web_services_all | call all the above successfully |
Logger
| Test | Outcome |
| logger:logger | only message with $status >= $global_log are logged |
| logger:is_db | return 1 if a databse query succeeds 0 otherwise |
| logger:is_ldap | return 1 if ldap could be connected to 0 otherwise |
| logger:generate_db_message | The counts corresponds with the values in the database action tables |
| logger: send_email error | Send email to users configured with error=1 |
| logger: send_email !error | Send email to users configured with success=1 |
| logger:get_isprocessing | return the value of isprocessing in mdlfeeds.mdlfeeds_system |
| logger:set_isprocessing $status | sets isprocessing in mdlfeeds.mdlfeeds_system to the value of $status |
| logger:is_maxdel_courses | 1 if the number of courses to be deleted >= mdlfeeds.mdlfeeds_system.maxdelcourses 0 therwise |
| logger:is_maxdel_enrolments | 1 if the number of STUDENT unenrolments to be processed >= mdlfeeds.mdlfeeds_system.maxdelenrolments 0 otherwise |
DB stored procedures
| Test | Outcome |
| `populate_co_curr` | course owner enrolled in courses in an academic year for which we are processing courses and enrolments are added to mdlfeeds_co_curr |
| `populate_co_enr_action` | Enrolments that exists in New but not in Current are inserted into `mdlfeeds_co_enr_action` as an 'A' record Enrolments that exists in Current but not in New are inserted into `mdlfeeds_co_enr_action` as an 'D' record |
| `populate_co_enr_curr` | course owners enrolments in courses in an academic year for which we are processing courses and enrolments are added to mdlfeeds_co_enr_curr |
| `populate_crs_action` | Courses that exists in New but not in Current are inserted into `mdlfeeds_crs_action` as an 'A' record Courses that exists in Current but not in New are inserted into `mdlfeeds_crs_action` as an 'D' record Courses that exists in Current and in New with different values are inserted into `mdlfeeds_crs_action` as an 'U' record |
| `populate_crs_curr` | courses under uoe_top in acadmic years for which process courses = 1 are added to mdlfeeds.mdlfeeds_crs_curr |
| `populate_stu_curr` | students enrolled in courses in an academic year for which we are processing courses and enrolments are added to mdlfeeds_stu_curr |
| `populate_stud_enr_action` | Enrolments that exists in New but not in Current are inserted into `mdlfeeds_stud_enr_action` as an 'A' record Enrolments that exists in Current but not in New are inserted into `mdlfeeds_stud_enr_action` as an 'D' record |
| `populate_stud_enr_curr` | student enrolments in courses in an academic year for which we are processing courses and enrolments are added to mdlfeeds_stud_enr_curr |
| `populate_usr_action` | People that exists in New but not in Current are inserted into `mdlfeeds_usr_action` as an 'A' record People that exists in Current and in New with different values are inserted into `mdlfeeds_usr_action` as an 'U' record |
| `validate_crs_action` | 'A'dd course action that is soft deleted course action='U' |
| `validate_usr_action` | no username in mdlfeeds_usr_action validated=0 username in mdlfeeds_usr_action exists in Moodle validated=0 idnumber in mdlfeeds_usr_action exists in Moodle validated=0 |
CRON job
| Test | Outcome |
| the cron job runs successfully at the configured time | success |