Database Admin dialog box

This dialog box allows you run various scripts on the Image database as well as the UKCTOCS System database. It also allows you to  run a series of automated User Acceptance Tests and validate the operation of the stored procedures you have installed on the UKCTOCS System database. The Database Admin dialog box is opened from the main menu (Tools | Database Admin), but it is only available to URA-Admin and SysAdmin users.

 

Click on the controls in the picture to access links to appropriate information

Normal Use: Validating the UKCTOCS System database connection

  1. Open this Database Admin dialog box (Tools | Database Admin)

  2. Enter the Surname, First names and Volunteer Reference for someone in the UKCTOCS System database

  3. Press the TestPatientDb button and wait for the results to appear in the Results box

Normal Use: Running the User Acceptance Tests (UAT)

  1. Open this Database Admin dialog box (Tools | Database Admin)

  2. Press the Create UAT Files button and wait for the results to appear in the Results box

  3. Press the Run UAT button and wait for your Browser to open displaying the result UAT document

  4. Check the result UAT document contains no unexpected errors, i.e. read or yellow tables

Normal Use: Running a Database Script

  1. Open this Database Admin dialog box (Tools | Database Admin)

  2. Select the script named 'TestImageDb' in the Database Scripts list (script a) and press the Run button

  3. Confirm that you want to run the script

  4. Check the itemd that appear in the Results box to confirm that your connection to the Image database is good.

  5. Repeat steps 2, 3 and 4, but for the script named 'TestPatientDb' to confirm that your connection to the UKCTOCS System database is good.

Note: The scripts are held in the application's DbScripts directory and are run from this dialog box according to the corresponding settings in your configuration file.

Controls

Surname text box

Enter the Volunteer's Surname in this textbox

First Names text box

Enter the Volunteer's First Names in this textbox

Volunteer Ref text box

Enter the Volunteer Ref number in this textbox

TestPatientDb button

Executes the test. The results are shown in the Results box


Create UAT Files button

Creates the files needed for the UAT in the FIT directory. The progression of this file creation operation is shown in the Results box

Edit UAT Doc button

Opens the UAT document in Word so that you can edit your User Acceptance Tests. After changing these tests save the document as a 'Web filtered (html) document with the same name and in the same location as the original. That is to say save it as the filename defined in your configuration file in your Install directory.

Run UAT button

Executes the automated User Acceptance Tests by passing the UAT document to the FIT test runner. The progression of the testing is shown in the Results box and the resultant document is displayed in your browser. The name and location of this result document is given to the right of the button.


Database Scripts List

Scripts configurated to be run from this dialog box.

Note: The scripts are held in the application's DbScripts directory and are run from this dialog box according to the corresponding settings in your configuration file.

Run button

Runs the script selected in the Database Scripts List.


Results box

Displays the output generated by running a script, executing the UAT or testing the UKCTOCS database connection

Close button

Closes the dialog box