Unit Testing RSF-Signup
Prerequisites
- DbVisualizer for reading/updating of Oracle Database tables.
- Access to the Oracle Database Tables for RSF
Creating Test Data
Setting up DbVisualizer to Access RSF-Signup Data
- Use the Driver Manager to set up the Oracle Thin driver. It can be found under ist-jxde/lib/ojdbc14.jar.
- Create a new Connection - call it rsf-dev
- Use the Oracle Thin driver for this connection
- Enter the Database Url string for test: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(HOST=jeeves3.berkeley.edu)(PROTOCOL=tcp)(PORT=1521))(CONNECT_DATA=(SID=SS1T)))
- Sign on as sisrsu - password can be obtained from members of the Java Team at SIS.
Find some CalSO Students
CalSO stands for Cal Student Orientation. CalSO students here for orientation
during the Summer term and will be new students in the subsequent Fall term.
CalSO students may purchase a Summer RSF membership at the standard price and may
pre-order for the following Fall term. Only CalSO students can pre-order for Fall.
Open the Object View tab and click Data tab, Set max rows to 10 and
select SISRSO | View | RSF_CALSO_STUDENT_VW from the database schemas under rsf-dev in the left-hand
column.
This should give you the first 10 stu_ids found who are CalSO students for the upcoming Fall term. Pick
a few of these stu_ids and write them down.
Find some students who are PE majors.
Use the same process as finding CalSO students, only you will apply the filters to rsf-dev | SISRSO | View | RSF_PHYS_ED_ENROLL_EXISTS_VW.
Create test records for the students found.
You will need to have Katherine Shaw (kathb@berkeley.edu) pull the student ids you found above and
create test records.
The test stu_ids are 99999990 through 999999999. Each test stu_id corresponds to a
test calnet-id.
Once she creates the test records you can use the test calnet-id to log on to rsf-signup and do your unit testing.
Validate and Reset
The test will create records in the following three database tables:
- SISRSO.RSF_EMAIL_PERM_TB
- SISRSO.RSF_STUTERM_FEE_TB
- SISRSO.RSF_STU_WAIVER_TB
Check the data created to make sure it's what you intended. You will need to delete the records created by this process (for stu_ids 99999990 through 99999999) each time you do a test.