This page contains a description of a complete regression test. Because I currently use Firefox 4 to test new functionality during development, I recommend using IE for regression testing.

Preparations

  • Backup all database tables
  • Delete all database tables
  • Empty the log file

User management

 

Go to the login page Language of this page should be identical to the $firstthingsfirst_lang setting in localsettings.php (assume in further testing that this setting is set to English). This page should display a warning when you are using an outdated version of firefox, IE or Chrome.
Log in as user admin Log in succeeds and portal page is shown in English without any lists.
Click on user administration tab User management page is shown with only user admin.
Click on insert new user A new user entry form is shown.
Insert new user details and click on ok Use the following details:
  • name = tester
  • password = tester1
  • lang = English
  • date format = American
  • records = 12
  • can create = false
  • is admin = false

User management page is shown with user admin and user tester.
Insert new user details and click on ok Use the following details:
  • name = tester2
  • password = tester2
  • lang = Dutch
  • date format = European
  • records = 12
  • can create = true
  • is admin = false

User management page is shown with user admin, user tester and user tester2.
Click on row of user tester An entry form is shown for existing user tester with all previously entered details. The password field should be empty.
Change name of user and click on ok Change the name of the user to tester1. User management page is shown with user admin, user tester1 and user tester2.
Test column sorting by clicking several times on all the headers Users are sorted as expected and the blue arrow changes accordingly.
Return to the portal page by clicking on portal tab The portal page is shown without any lists.
Log out by clicking on logout The log in page is shown.
Log in as user tester1 and tell browser to remember password/username for this site Log in succeeds and portal page is shown without any lists and without the user administration tab.
Log out by clicking on logout The log in page is shown with user tester1 and password prefilled.
Log in with prefilled credentials Log in succeeds and portal page is shown in English (without any lists).

List record creation and modification

 

Click on the create a new list tab. An error message is shown (you do not have administrator permissions of this list)
Log out by clicking on logout The log in page is shown with user tester1 and password prefilled.
Log in as user tester2 Log in succeeds and portal page is shown (in Dutch) without any lists.
Insert list details and click on create this list Use the following details:
  • name = Todo list
  • description = This is a test Todo list

Create the following columns

  • auto number, id, show this column
  • automatic created, created, date and name
  • text line, description
  • selection box, status, open|closed

A yellow message appears which says that a new list was created.
Return to the portal page by clicking on portal link inside the yellow message The portal page is shown with the newly created list.
Click on the list The list is shown with four columns. The list contains no records. A new tab page user list permissions is visible.
Click on insert new list record A new list record entry form is shown. Only description and status are editable.
Insert record details and click on ok Enter a description and set status = open. The list is reloaded and now contains one record.
Repeat previous two steps twice to insert two additional records Make sure the second record has status = closed. The list is reloaded and now contains three records.
Test column sorting by clicking several times on all the headers List is sorted as expected and the blue arrow changes accordingly.
Click on the first record An entry form is shown for the first record with all previously entered details.
Change the description and click on ok The list is reloaded and contains three records. The new description of the first record is shown.
Click on the second record An entry form is shown for the second record with all previously entered details.
Click on cancel The list is reloaded and contains three records.
Click on archive of the third record The list is reloaded and contains two records.
Repeat earlier steps to insert a new record The list is reloaded and contains three records. The third record has id = 4.
Click on print this list A new browser tab has opened and the browser print screen is presented. Print the list and check if the list is printed correctly.
Return to the portal page by clicking on portal tab The portal page is shown with one list.

User list permissions

 

Log out by clicking on logout The log in page is shown with user tester1 and password prefilled.
Log in as user tester1 with prefilled credentials Log in succeeds and portal page is shown with no lists.
Log out by clicking on logout The log in page is shown with user tester1 and password prefilled.
Log in as user tester2 Log in succeeds and portal page is shown with one list.
Click on the list The list is shown and contains three records. A new tab page current list permissions is visible.
Click on current list permissions tab A list of three users is shown. User admin and user tester2 have all permissions. User tester1 has no permissions.
Click on tester1 The user list permissions of tester1 are shown.
Check the checkbox for can view this list and click on ok A list of three users is shown. User admin and user tester2 have all permissions. User tester1 has can view this list permission.
Log out by clicking on logout The log in page is shown with user tester1 and password prefilled.
Log in as user tester1 Log in succeeds and portal page is shown in English with one list.
Click on modify of the list An error message is shown (you do not have administrator permissions of this list)
Click on delete of the list An error message is shown (you do not have administrator permissions of this list)
Click on the list The list is shown and contains three records. A new tab page current list permissions is visible.
Test column sorting by clicking several times on all the headers. List is sorted as expected and the blue arrow changes accordingly.
Click on current list permissions tab An error is shown (you do not have administrator permissions of this list)
Click on insert new list record An error is shown (you do not have permission to create or delete records of this list)
Click on one of the list records An error is shown (you do not have permission to edit records of this list)
Click on archive of one of the list records An error is shown (you do not have permission to edit records of this list)
Click on import from file An error is shown (you do not have permission to create or delete records of this list)
Click on export to file A message is shown.
Click on cancel The list is reloaded and contains three records.
Log out by clicking on logout The log in page is shown in Dutch with user tester1 and password prefilled.
Log in as user tester2 Log in succeeds and portal page is shown with one list.
Click on the list The list is shown and contains three records. A new tab page current list permissions is visible.
Click on current list permissions tab A list of three users is shown. User admin and user tester2 have all permissions. User tester1 has can view this list permission.
Click on tester1 The user list permissions of tester1 are shown.
Check the checkbox for can edit this list and click on ok A list of three users is shown. User admin and user tester2 have all permissions. User tester1 has can view this list and can edit this list permissions.
Log out by clicking on logout The log in page is shown with user tester1 and password prefilled.
Log in as user tester1 Log in succeeds and portal page is shown in English with one list.
Click on modify of the list An error message is shown (you do not have administrator permissions of this list)
Click on delete of the list An error message is shown (you do not have administrator permissions of this list)
Click on the list The list is shown and contains three records. A new tab page current list permissions is visible.
Click on current list permissions tab An error is shown (you do not have administrator permissions of this list)
Click on insert new list record An error is shown (you do not have permission to create or delete records of this list)
Click on the first list record An entry form is shown for the first record with all previously entered details.
Change the description and click on ok The list is reloaded and contains three records. The new description of the first record is shown.
Click on archive of the first list record The list is reloaded and contains two records.
Click on import from file An error is shown (you do not have permission to create or delete records of this list)
Log out by clicking on logout The log in page is shown with user tester1 and password prefilled.
Log in as user tester2 Log in succeeds and portal page is shown in Dutch with one list.
Click on the list The list is shown and contains two records. A new tab page current list permissions is visible.
Click on current list permissions tab A list of three users is shown. User admin and user tester2 have all permissions. User tester1 has can view this list permission and can edit this list permission.
Click on tester1 The user list permissions of tester1 are shown.
Check the checkbox for and can add to this list permission and click on ok A list of three users is shown. User admin and user tester2 have all permissions. User tester1 has can view this list permission, can edit this list permission and can add to this list permission.
Log out by clicking on logout The log in page is shown with user tester1 and password prefilled.
Log in as user tester1 Log in succeeds and portal page is shown with one list.
Click on modify of the list An error message is shown (you do not have administrator permissions of this list)
Click on delete of the list An error message is shown (you do not have administrator permissions of this list)
Click on the list The list is shown and contains two records. A new tab page current list permissions is visible.
Click on current list permissions tab An error is shown (you do not have administrator permissions of this list)
Click on insert new list record A new list record entry form is shown.
Insert record details and click on ok Enter a description and set status = open. The list is reloaded and now contains four records.
Click on the last record An entry form is shown for the last record with all previously entered details.
Click on cancel The list is reloaded and contains three records.
Click on archive of the first list record The list is reloaded and contains two records.
Click on import from file An entry form is shown.
Click on cancel The panel disappears.
Click on export to file A yellow message is shown.
Click on cancel The list is reloaded and contains two records.
Log out by clicking on logout The log in page is shown with user tester1 and password prefilled.
Log in as user tester2 Log in succeeds and portal page is shown in Dutch with one list.
Click on the list The list is shown and contains three records. A new tab page current list permissions is visible.
Click on current list permissions tab A list of three users is shown. User admin and user tester2 have all permissions. User tester1 has can view this list permission, can edit this list permission and can add to this list permission.
Click on tester1 The user list permissions of tester1 are shown.
Check the checkbox for is administrator of this list and click on ok A list of three users is shown. All users have all permissions.
Log out by clicking on logout The log in page is shown with user tester1 and password prefilled.
Log in as user tester1 Log in succeeds and portal page is shown with one list.

List modification and list notes

 

Click on modify of the list The 'modify list' page is shown with all list details as expected.
Insert list details and click on modify this list Modify the name and description:
  • name = My todo list
  • description = This is my test Todo list

Modify the following column

  • id (do not show this column)

Add the following columns

  • date, due date (move up between description and status)
  • notes field, notes

A message box appears. Click on ok. A yellow message appears which says that list was modified.
Return to the portal page by clicking on the portal link in the yellow message. The portal page is shown with the modified list.
Click on the list The list is shown with five (no id column) columns. All records contain the same date in due date. The list contains two records.
Click on the second record An entry form is shown for the second record with all previously entered details.
Change the due date, add a note and click on ok The list is reloaded and contains two records. The second record has the expected due date and contains the new note. Note that the footer now says that last modification has been done by user tester1.
Click on the second record An entry form is shown for the second record with all previously entered details.
Add a second note by clicking on add note, enter a new note and click on modify The list is reloaded and contains two records. The second record now has two notes.
Insert three more notes by repeating the previous two steps. The list is reloaded and contains two records. The second record now has five notes.
Click on the first record An entry form is shown for the firstrecord with all previously entered details.
Insert a first note and click on modify The list is reloaded and contains two records. The first record has one note and the second record has five notes.
Click on the second record An entry form is shown for the second record with all previously entered details.
Remove the third note, then remove the last note and finally remove the first note and click on modify The list is reloaded and contains two records. The first record has one note and the second record has two notes left (the second and fourth).

List display and list filtering

 

Click on export to file A yellow message is shown
Click on ok A browser popup is shown
Choose to save the file and click on ok The list is reloaded and contains two records.
Click on import from file A new panel appears
Click on select file to upload A file select dialog appears. Select the file you have previously save (during the export). Now the file name appears in the panel and a new button import file appears.
Choose comma as field seperator and click on import file A message appears. Click on ok. The list is reloaded and contains four records and a new message appears which should say that the import was successful. Click on ok.
Set the display pull down to archived records The list is reloaded and contains the three previously archived records.
Click on active of the first record The list is reloaded and contains two records.
Click on delete of the first record The list is reloaded and contains one record.
Set the display pull down to normal records The list is reloaded and contains five records (including the previously archived record).
Enter a word in the filter field and click on filter Make sure you enter a word that is contained in one of the text fields of one of records. The list is reloaded and contains the expected record.
Click on clear filter (the red cross icon) The list is reloaded and contains five records.
Return to the portal page by clicking on portal tab. The portal page is shown with one list. Note that list was last modified by tester1. Make sure that the number of active and archived records is correct.
Click on user settings A new page is shown with a number of settings.
Change preferred language to Dutch, date format to European and rows per page to 2 and click on ok. A message appears which should say that user settings have been modified.
Log out by clicking on logout The log in page is shown with user tester1 and password prefilled.
Log in as user tester1 Log in succeeds and portal page is shown in Dutch (and with correct date format) with one list.
Click on the list The list is shown. The list contains two records and three pages.
Test page navigation by going to all seperate pages The page numbers should be clickable (except for the current page) and next and previous should be clickable.
Log out by clickin on logout The log in page is shown with user tester1 and password prefilled.
Log in as user admin Log in succeeds and portal page is shown in English with one list.
Create another list by clicking on create a new list Configure a new list page is shown.
Insert list details and click on create this list Use the following details:
  • name = Test list
  • description = This is a test list

Create the following columns

  • auto number, id, show this column
  • text field, description

A yellow message appears which says that a new list was created.
Return to the portal page by clicking on portal link of the message. The portal page is shown with two lists.
Test column sorting by clicking several times on all the headers. List is sorted as expected and the blue arrow changes accordingly.

Clean up

 

Click on delete of the first list A message box appears. Click on ok. The portal page is reloaded and contains only one list.
Click on delete of the list. A message box appears. Click on ok. The portal page is reloaded and contains no lists.
Click on user administration tab. User management page is shown with three users.
Click on delete of user tester1 User management page is reloaded with user admin and user tester2.
Click on delete of user tester2 User management page is reloaded with only user admin.
Return to the portal page by clicking on portal tab. The portal page is shown and contains no lists.

Restore

  • Restore all database tables
  • Check the log file for any unexpected messages
  • Empty the log file