TEST PLAN DATE
Testing occurred, 9/5/06, 4:15pm-5:15pm.
TEST PLAN OVERVIEW
Scope of testing
This testing is designed to document the unit and integration test results of the programming team. For certain test cases, as described in the Test Cases section, the level of testing previously performed to handing off to QA will be documented. The level of involvement by system admins and programmers will be detailed for each test case.
...
Info | ||
---|---|---|
| ||
|
KNOWN ISSUES / PREVIOUS BUGS FIXED
...
- Hardware Setup
Server Type
Location
database
bricker.ucdavis.edu with banner-test (external db), and sakai dev (internal db)
application
isaac.ucdavis.edu, sakai-dev
web server
url,
http://sakai-dev.ucdavis.edu
- Note: The application does not need to be stopped for these tests to occur
- Software Setup
run test under https://mware.ucdavis.edu/svn/ucdsakai/branches/sakai-core-2.1.x branch, with mods from https://mware.ucdavis.edu/svn/ucdakai/sakai-core-2.1.x-scottsdev branch incorporated
...
- External-Banner Test Data to be Used As Representative Course Scenarios TODO|CRN with large enrollment number|2006-03-xxxxx|NA|NA|NA|x|Provider Id|
Scenario
Course
Roster Count
Instructor Kerb Name
Course Details (Catalog Root, Suffix, Section, Description)
Test Case Used In
Invalid CRNs
Invalid CRN (Number)
20061-06-111
NA
NA
NA
NA
White List, Provider Id
Invalid CRN (Number)
2006-06-12345
NA
NA
NA
NA
White List
Invalid CRN (Number)
2006-03-60024
NA
NA
NA
NA
White List
*additional* Invalid CRN (Number) available
1995-03-76288
NA
NA
NA
NA
White List
Invalid CRN (Bogus Text)
2006-sfs-sfsfdfsdfsfsfs
NA
NA
NA
NA
White List
No CRN (empty file)
null
NA
NA
NA
NA
White List,Black List, Provider Id
No CRN (null CRN value)
null
NA
NA
NA
NA
Provider Id
Valid CRNs
CRN with no enrollment
1995-01-76288
0
fzthorn, (Robert Thornton)
PLB, 092, 012, Internship
Winter Quarter 1995
White List
CRN with no enrollment
2004-03-60097
0
dlmiller (Douglas Miller)
ECN, 298 , 026, Group Study
Spring Quarter 2004
Provider Id
CRN with enrollment
2006-06-60005
11 (all valid knames)
acham (Christine Acham)
AAS, 198, S01, Directed Gp Study
Summer Special Session 2006
White List,Black List,Provider Id
CRN with enrollment
2006-01-40018
14 (all valid knames)
calymos (Calvin Lymos)
AAS, 154, 001, University Gospel Choir
Winter Quarter 2006
Black List
CRN with large enrollment number
2006-01-60001
84 (all valid knames)
ewlarsen (Eric Larsen)
LDA, 190 , 001, ProSeminar
Winter Quarter 2006
White List
TODO|CRN with large enrollment number, some student kerbs don't exist|2006-03-xxxxx|NA|NA|NA|x|Provider Id|Valid Term
Term with large number CRNs
2004-01
NA
NA
32573 sites
Winter Quarter 2004
Full Batch Run
DEPENDENCIES
- At least UserDirectoryProvider enabled to allow user accounts to be looked up automatically via kerberos name (Note:all Providers will be enabled)
- Distributed authentication using AFS (SAK-143)
- Sakai-dev will be used in its current state
- We will be referencing sakai-test external for populating course data
ROLES AND RESPONSIBILITIES
- Unit/Integration Testers (Programmers, Managers, etc)*
which would include any of the following persons that may be available:- Application admins (Programmers available, including Thomas, Lisa W., James, Brian, Jon G., Scott)
- Database mViews admin (Brian Donnelly)
COURSE SITE BATCHING DOCUMENTATION
- Requirements
The requirements for batching are documented at (see each test case)
- A few test course sites need to be created in advance so that the batch job can modify these sites with a respective provider Id. These sites are documented in the Provider Id Test Section.
DEPENDENCIES
- At least UserDirectoryProvider enabled to allow user accounts to be looked up automatically via kerberos name (Note:all Providers will be enabled)
- Distributed authentication using AFS (SAK-143)
- Sakai-dev will be used in its current state
- We will be referencing sakai-test external for populating course data
ROLES AND RESPONSIBILITIES
- Unit/Integration Testers (Programmers, Managers, etc)*
which would include any of the following persons that may be available:- Application admins (Programmers available, including Thomas, Lisa W., James, Brian, Jon G., Scott)
- Database mViews admin (Brian Donnelly)
Programmers/Managers available ??:
Sandra
Thomas
Brian
Jon G.
James
(Emily)
All of the above users will have access to the admin realm in Sakai, in addition to:
ssbatchadmin
COURSE SITE BATCHING DOCUMENTATION
- Requirements
The requirements for batching are documented at https://confluence.ucdavis.edu:8443/confluence/display/UCDSAKAI/Course+Batching+Strategy
JUNIT TEST RESULTS
The JUnit tests results are located on the server at:
/var/sakai/ucd-data/course-batch-unit-tests-082006
Also, the test results can be found here https://confluence.ucdavis.edu:8443/confluence/display/UCDSAKAI/Course+Batch+Creation+Unit+Test+Results
All unit tests passed!!
TEST PLAN PROCESS
This Course Batching Unit/Integration Test Plan will be coordinated by Scott Amerson, and will document the results of unit testing and integration testing for the batching process before handing off to QA. All tests must pass before handing off to QA.
Steps involved in the test process will be varied depending on the given test performed (as described below in the Test Cases section).
Info |
---|
*NOTE: The order of the test cases will be as follows.
|
TEST CASES
Info | ||
---|---|---|
| ||
Prerequisite Steps = actions needed before performing any of the given tests |
White List
Note | ||
---|---|---|
| ||
Description = Test the capability of the system to add "on-demand" course sites that are listed in a file. Courses are not required to have any enrollment in order to be created. Category of Testing = unit, integration Prerequisite Steps
Test Scenario
|
...
JUNIT TEST RESULTS
The JUnit tests results are located on the server at:
/var/sakai/ucd-data/xxxxx
...
|
...
...
All unit tests passed!!
TEST PLAN PROCESS
This Course Batching Unit/Integration Test Plan will be coordinated by Scott Amerson, and will document the results of unit testing and integration testing for the batching process before handing off to QA. All tests must pass before handing off to QA.
Steps involved in the test process will be varied depending on the given test performed (as described below in the Test Cases section).
Info |
---|
*NOTE: The order of the test cases will be as follows. White List Testing, Black List Testing, Provider Id Testing *
|
TEST CASES
Info | ||
---|---|---|
| ||
Prerequisite Steps = actions needed before performing any of the given tests |
White List
Note | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Description = Test the capability of the system to add "on-demand" course sites that are listed in a file. Courses are not required to have any enrollment in order to be created. Category of Testing = unit, integration Prerequisite Steps
Test Scenario
Test Cleanup
|
White List Test Results
Would yield an example Summary Test Result of:
Test | User Role | User Acting As | Result | Expected Result | Pass/Fail |
---|---|---|---|---|---|
Site xxxxx (created): Functionality Results | samerson | fzolupon | All tests pass | batching of course succeeded | P |
Site xxxxx (created): Course Management Test Results | samerson | QA Admin | All tests pass | course content correct | P |
Site xxxxx (created): Provider Id Test Results | samerson | QA Admin | All tests pass | provider id correct, roster number correct | P |
or..
Test | User | User Acting As | Result | Expected Result | Pass/Fail |
---|---|---|---|---|---|
Site xxxxy (not created):Test Results | samerson | QA Admin | All tests pass, not provisioned | course not created, correct | P |
results: https://confluence.ucdavis.edu:8443/confluence/display/UCDSAKAI/
...
...
...
...
...
...
Test Cleanup
- Scott will remove all sites created in this step when all test cases are completed.
White List Test Results
Would yield an example Summary Test Result of:
Test | User Role | User Acting As | Result | Expected Result | Pass/Fail |
---|---|---|---|---|---|
Site xxxxx (created): Functionality Results | samerson | fzolupon | All tests pass | batching of course succeeded | P |
Site xxxxx (created): Course Management Test Results | samerson | QA Admin | All tests pass | course content correct | P |
Site xxxxx (created): Provider Id Test Results | samerson | QA Admin | All tests pass | provider id correct, roster number correct | P |
or..
Test | User Role | User Acting As | Result | Expected Result | Pass/Fail |
---|---|---|---|---|---|
Site xxxxy (not created):Test Results | samerson | QA Admin | All tests pass, not provisioned | course not created, correct | P |
Info | ||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||||||||||||||||||||
|
Black List
...
title | Black List Testing |
---|
Description = Test the capability of the system to not add course sites that are listed in a file. Courses in this list will never be batch created.
Category of Testing = unit, integration
Prerequisite Steps
- Note: The application does not need to be stopped for this test to occur
- Scott will add a list of CRNs (valid or not) to the white-list.txt file in /var/sakai/ucd-data folder on the server, in the form of TERMYR-TERMCD-CRN for each entry. This list will be different than that used for the White List Test Scenario. Use this white list
- Scott will add a list of CRNs (valid or not) to the black-list.txt file in /var/sakai/ucd-data folder on the server, in the form of TERMYR-TERMCD-CRN for each entry. Use this black list file file to use here
- Scott will que the batch jobs to run, first Black List, then White List, (5 min time elapse needed)
- Scott will advise programmers that the batches have been run
- Thomas and Scott will monitor server activity while testers are using sakai-dev.
Test Scenario
...
Black List
Note | |||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| |||||||||||||||||||||||||||||||||||||||||||||||||
Description = Test the capability of the system to not add course sites that are listed in a file. Courses in this list will never be batch created. Category of Testing = unit, integration Prerequisite Steps
Prerequisite Steps needed for Scenario #2 only (in addition to Scenario #1 steps)
Test Scenarios
*Scenario #2 = Black list consulted when existing site already has provider id that matches black list entry*
Test Cleanup
|
Black List Test Results
Would yield an example Summary Test Result of:
Test | User Role | User Acting As | Result | Expected Result | Pass/Fail |
---|---|---|---|---|---|
Site xxxxy (not created):Test Results | samerson | QA Admin | All tests pass, not provisioned | course not created, correct | P |
Info | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||
Test | User Role | User Acting As | Result | Expected Result | Pass/Fail | |||||
Site xxxxx (not created):Test Results | ccjon | x | x | site not created in UI or db | x | |||||
Site yyyyy (not created):Test Results | ccjon | x | x | site not created in UI or db | x |
Scenario | Course | Site id | Roster Count | Instructor Kerb Name | Course Details (Catalog Root, Suffix, Section, Description) | Test Case Used In | File Associated | |
---|---|---|---|---|---|---|---|---|
Valid CRNs | ||||||||
CRN with enrollment | 2006-03-69857 | 10 | jrlund (Jay Lund) | ECI 299 019 Research | Spring Quarter 2006 | Black List | black-list.txt | |
CRN with enrollment (large) | 2006-03-65306 | 177 (all valid knames) | fzsegel (Leigh Segel) | BIS 103 002 Bioenergetics/Metabolism | Spring Quarter 2006 | Black List | white-list.txt,black-list.txt | |
CRN with no enrollment | 2006-06-60435 | 0 | fzblanch (Marc Blanchard) | COM 152 S01 Literature Of Americas | Summer Special Session 2006 | Black List | white-list.txt,black-list.txt |
Test Cleanup
- Scott will remove all sites created in this step when all test cases are completed.
Black List Test Results
Would yield an example Summary Test Result of:
Test | User | User Acting As | Result | Expected Result | Pass/Fail |
---|---|---|---|---|---|
Site xxxxy (not created):Test Results |
...
samerson |
...
x
...
x
...
site not created in UI or db
...
x
...
Site aaaaa (not created):Test Results
...
bdonnell
...
x
...
x
...
site not created in UI or db
...
x
*Note, pass/fail depends on db check also for this test! Jon and Brian will consult with Thomas and Scott about test case result.
Update Existing Site with Provider Id
...
QA Admin | All tests pass, not provisioned | course not created, correct | P |
Update Existing Site with Provider Id
Note | ||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||||||||||||||||||||||||||||||
Description = Test the capability of the system to update existing course sites with associated provider ids. This functionality can be done either in the UI or batch, however we want to Category of Testing = unit, integration Prerequisite Steps Test Scenario done either in the UI or batch, however we want to Category of Testing = unit, integration Prerequisite Steps
*Data To Be Used:
Test Scenario
Manual Process Check (update provider ids for sites manually):
Test Cleanup
|
Provider Id Update Test Results
Would yield an example Summary Test Result of (both batch and manual updates):
Test | User | User Acting As | Result | Expected Result | Pass/Fail |
---|---|---|---|---|---|
Site xxxxx: Provider Id Update Results | samerson | admin | provider id is ....., roster is same as CRN for provider id | provider id updated and seen in site tool under "provider id", roster reflects provider id roster | P |
Site Functionality
Note | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| |||||||||||||
Description = Test the capability of the system to add sites with the correct pages, tools, tabs, and look and feel. Category of Testing = unit, integration, functionality Prerequisite Steps
Test Cleanup
|
Course Management Data Presented in Admin Tools
Note | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| |||||||||||||
Description = Test the course management content displayed in admin tools. Category of Testing = unit, integration, functionality Prerequisite Steps
Test Cleanup
|
Provider Id Update Results
Action | Result | Expected Result | Pass/Fail |
---|---|---|---|
colB1 | colB2 | col3 | col4 |
...
|
Full Batch Run on Term
...
Note | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| |||||||||||||
Description = Test the capability of the system to add sites with the correct pages, tools, tabs, and look and feel.batch method for a whole term Category of Testing = unit, integration, functionality Prerequisite Steps Test Scenario
Test Cleanup
|
Panel | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||
|
Course Management Data Presented in Admin Tools
Note | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| |||||||||||||
Description = Test the course management content displayed in admin tools. Category of Testing = unit, integration, functionality Prerequisite Steps
Test Cleanup
|
Panel | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||
|
Recording Results
The test results will be recorded in the above summary tables by QA, and a summary report of both Regression and QA Tests will be created by Scott Amerson.
performance Prerequisite Steps
Test Cleanup
|
Recording Results
The test results will be recorded in the above summary tables by integration testers, and a summary of this data will be ready for QA and the Sakai Development team to review.
Feedback Mechanism
The above results will be analyzed by the SmartSite programming team, and management to determine the steps needed and whether or not to hand off to QA. Results of this test should be discussed as near to the Monday meetings as possible.