Transcript Waitlist_Presentation

CSE Waitlist
•Made By: Peng Hu, Zhicheng Lin, Mark
Mosby, Robert Pittman, and Derek Robati
Process
•
•
•
•
Stepped Waterfall Model
Team Structure
Team Meetings
Participation
Requirements
• Meetings with the clients
• Briana Morrison
• Ray Walker
• Keep basic outlook
• XAMPP
• Authentication/Security
• Accounts
• Admin Functionality
• Page Flow
• Reports
Design
Frameworks
Symphony
• MVC, ORM, admin interface, terrible documentation
CodeIgnitor
• MVC, lightweight
CakePHP
• MVC
Wordpress
• CMS, Supportive Community
Drupal
• CMS, PAC (presentation abstraction control)
Drupal
•
•
•
•
•
An extensible CMS written in PHP
PAC architecture.
Offered a Admin interface.
Modules to extend Drupal's usability.
Provides security out of the box
o XSS
o SQL Injections
Users
• Authenticated Users:
o Faculty
 view submissions
o
Coordinators
 view/edit submissions
o
Admin
 view/edit/delete submissions
 activate/block/delete accounts
• Unauthenticated Users
o submit waitlist requests
Implementation
Installed Drupal 7.x
Setup a MySQL database through PHPMyAdmin.
Configured Drupal to use the database with proper
permissions.
Configured Drupal 'groups' and ‘permissions'.
Version Control
git, distributed version control
Set up a remote repository.
All members produced ssh keys and provided the repo with
their public key.
Members made commits and learned to push and pull (and
merge) them to a repo.
Coding
PHP:
– Modules: Webform, Captcha
CSS:
– Themes for each role (group)
JavaScript:
– Validation
– jQuery support
Testing
Test Schedule
• Functional Test
• Performance Test
• Security Test
• User Acceptance Test
Functional Test
• Requirement Specification
o Tested Functions:
 Submit waitlist request
 Access the waitlist system
 User Login
 View/edit/delete submissions
 Activate/block/delete accounts
 Request report downloading
 Error Message
• Documentation Test
o Check the accuracy
o No missing features
o Easy to understand
Test Cases
Performance Test
• Testing with ab (Appache Benchmark)
• Improve performance:
 Page Cache
 Simplify the page’s design
Security Test
• How secure the waitlist system is
o Unauthorized user access to confidential data is
prevented
o Block user account or IP after x number of logins
Test Case ID
Test Case
Title
Steps
014
Account blocked by failed attempts
•
•
•
•
•
•
•
•
Expected
Result
Actual Result
Go to the Internet and open the Waitlist Application web site:
http://cse.spsu.edu/waitlist
Click on Faculty Login
Type in admin as username
Type in try1 as password and then click log in
Type in try2 as password and then click log in
Type in try3 as password and then click log in
Type in try4 as password and then click log in
Type in try5 as password and then click log in
The account has been blocked.
The account has been blocked.
There is a message said that ”Sorry, there have been more than 5 failed
attempts for this account. It is temporarily blocked. Try again later or request
new password”
User Acceptance Test
•Ready for operational use.
•Test by Students, faculty, administrator
•Receive feedback
Lessons Learned
•
•
•
•
Version Control
Drupal
Testing
Project Management