Acceptance Tests

Table of Contents

1. Installation
2. Registration
3. User Administration
4. Bboard System
5. News
6. General Comments

Installation

You should ensure the database has been properly configured and that your AOLServer installation will actually start.
Suggested method:

• Open up a sqlplus session as the Oracle user your AOLServer will connect as. We want to ensure we've completed the installation step of adding NLS_DATE_FORMAT = "YYYY-MM-DD" to the Oracle instance init file. Make sure the date format is set correctly.

  
           SQL> select to_date('1-1-2000', 'MM-DD-YYYY') as y2k from dual ;
  
           Y2K
           ----------
           2000-01-01
  

  If the date did not read "2000-01-01" that installation step failed.
• Next, make sure that the step of feeding Oracle the data model works. In the same sqlplus session, make sure the country_codes, counties, and states tables were loaded:

  
           SQL> select table_name from user_tables where lower(table_name) in ('country_codes', 'states', 'counties') ;
  
           TABLE_NAME
           ------------------------------
           COUNTIES 
           COUNTRY_CODES
           STATES
  

  If these three tables do not show up, we failed to properly feed Oracle the data model. Spot-check that database objects created in /web/yourservername/www/doc/sql exist.
• If you installed site-wide-search make sure the im_convert PL/SQL proc is there. This procedure converts a search string into a form interMedia understands to perform the search.

  
           SQL> select im_convert('foo bar') from dual ;
  
           IM_CONVERT('FOOBAR')
           --------------------------------------------------------------------------------
           ( { foo } NEAR { bar })*2.0,about(   foo     bar  )
  

  If this is not what you see, then you likely failed to properly feed Oracle the data model.
• Unless you have specified port numbers for both the ns_sock and ns_ssl (if applicable) modules that are greater than 1024, you will need sudo permissions or root access for the following command. As root make sure your server will start

  
           /webroot/aol30/bin/nsd -fc /webroot/aol30/.ini -r /webroot
  

  The -f option runs the server in the foreground, so you can easily see any errors that may have occurred when the server was run. If you see any errors indicating the failure of a virtual server to start, this step failed.
  

Registration

You should test basic registration and the login process.
Suggested method:

• Go to /pvt/home.tcl
• Walk through registering as a new user
• Go back to /pvt/home.tcl and "Log out"
• Go back to /pvt/home.tcl again and log in as the same user

User Administration

You should test adding a user, searching for users, modifying user data, banning or deleting a user, and spamming a class of users.
Suggested method:

• Go to /admin/users
• Admin email/password = system/changeme
• Create a test user
• Search for a class of users (which includes the test user)
• View the list of matching users and edit the user data for the new test user
• Spam a (small) group of users.
• Delete the test user
• Ban the test user
• Nuke the test user

Bboard System

You should test setting up a bboard, posting a message, alerts, and searching.
Suggested method:

• Create a test bboard
• Sign up for an instantaneous alert
• Post a message
• Respond to your message
• Search for your message (Note that you must wait for the index to be rebuilt before you'll actually see your new posting. Or you can do it manually by going to SQL*Plus and typing alter index sws_ctx_index rebuild parameters('sync').)
• Deactivate the test bboard (you can leave it for later testing)

News

You should test story posting, story approval, and story editing (for both site-wide and group scope). You can also test the interface into the general comments module.
Suggested Method:

• Add a story
• Approve the story in the admin pages (depends on policy)
• Add a comment to the story
• Approve the comment in the admin pages (depends on policy)
• Revoke approval for the story in the admin pages. The story should not appear the user pages.

General Comments

Test tcl procedures used for adding comments to pages and test general comments admin pages

• adding a comment using ad_general_comment_add
• updating a comment using ad_general_comment_update
• displaying general comments using ad_general_comments_summary and ad_general_comments_summary_sorted
• approving/disapproving a comment through admin pages
• editing a comment through admin pages
• deleting a comment through admin pages
• using dimensions on admin pages (sections, approving/disapproving, number of days)