Modifying a Standard Database Checkpoint - WinRunner

You can make the following changes to an existing standard database checkpoint:

  • make a checklist available to other users by saving it in a shared folder
  • change which database properties to check in an existing checklist
  • modify a query in an existing checklist

Saving a Database Checklist in a Shared Folder

By default, checklists for database checkpoints are stored in the folder of the current test. You can specify that a checklist be placed in a shared folder to enable wider access, so that you can use the same checklist in multiple tests.

The default folder in which WinRunner stores your shared checklists is WinRunner installation folder/chklist. To choose a different folder, you can use the Shared checklists box in the Folders category of the General Options dialog box. For more information, see “Setting Global Testing Options.”

To save a database checklist in a shared folder:

  1. Choose Insert > Edit Database Checklist.
  2. The Open Checklist dialog box opens.
    To save a database checklist in a shared folder

  3. Select a database checklist and click OK. Note that database checklists have the .cdl extension, while GUI checklists have the .ckl extension. For information on GUI checklists, see “Modifying GUI Checklists,”
  4. The Open Checklist dialog box closes. The Edit Database Checklist dialog box displays the selected database checklist.

  5. Save the checklist by clicking Save As.
  6. The Save Checklist dialog box opens.
    To save a database checklist in a shared folder
  7. Under Scope, click Shared. Type in a name for the shared checklist. Click OK to save the checklist and close the dialog box.
  8. Click OK to close the Edit Database Checklist dialog box.

Editing Database Checklists

You can edit an existing database checklist. Note that a database checklist includes only a reference to the msqr*.sql query file or the *.djs conversion file of the database and the properties to be checked. It does not include the expected results for the values of those properties.

You may want to edit a database checklist to change which properties in a database to check.

To edit an existing database checklist:

  1. Choose Insert > Edit Database Checklist. The Open Checklist dialog box opens.
  2. A list of checklists for the current test is displayed. If you want to see checklists in a shared folder, click Shared.
  3. For more information on sharing database checklists, see “Saving a Database Checklist in a Shared Folder”

    To edit an existing database checklist

  4. Select a database checklist.
  5. Click OK
  6. The Open Checklist dialog box closes. The Edit Database Checklist dialog box opens and displays the selected checklist.

    The Objects pane contains “Database check” and the name of the *.sql query file or *.djs conversion file that will be included in the database checkpoint.

    The Properties pane lists the different types of checks that can be performed on databases. A check mark indicates that the item is selected and is included in the checkpoint.

    To edit an existing database checklist
    You can use the Modify button to modify the database checkpoint, as described in “Modifying a Query in an Existing Database Checklist”

    In the Properties pane, you can edit your database checklist to include or exclude the following types of checks:

    ColumnsCount: Counts the number of columns in the result set.

    Content: Checks the content of the result set, as described in “Creating a Default Check on a Database”

    RowsCount: Counts the number of rows in the result set.

  7. Save the checklist in one of the following ways:
  • To save the checklist under its existing name, click OK to close the Edit Database Checklist dialog box. A WinRunner message prompts you to overwrite the existing checklist. Click OK.
  • To save the checklist under a different name, click the Save As button.

The Save Checklist dialog box opens. Type a new name or use the default name. Click OK. Note that if you do not click the Save As button, WinRunner automatically saves the checklist under its current name when you click OK to close the Edit Database Checklist dialog box.

A new database checkpoint statement is not inserted in your test script.

Modifying a Query in an Existing Database Checklist

You can modify a query in an existing database checklist from the Edit Database Checklist dialog box. You may want to do this if, for example, you move the database to a new location on the network. You must use the same tool to modify the query that you used to create it.

Modifying a Query Created with ODBC/Microsoft Query

You can modify a query created with ODBC/Microsoft Query from the Edit Database Checklist dialog box.

To modify a database checkpoint created with ODBC/Microsoft Query:

  1. Choose Insert > Edit Database Checklist. The Open Checklist dialog box opens.
  2. A list of checklists for the current test is displayed. If you want to see checklists in a shared folder, click Shared.
  3. For more information on sharing database checklists, see “Saving a Database Checklist in a Shared Folder”

    modify a database checkpoint created with ODBC/Microsoft Query

  4. Select a database checklist.
  5. Click OK.
  6. The Open Checklist dialog box closes. The Edit Database Checklist dialog box opens and displays the selected checklist.

    The Objects pane contains “Database check” and the name of the *.sql query file that will be included in the database checkpoint.

    The Properties pane lists the different types of checks that can be performed on databases. A check mark indicates that the item is selected and is included in the checkpoint.

    To modify the properties to check, see “Editing Database Checklists”

    modify the properties to check, see “Editing Database Checklists

  7. In the Objects column, highlight the name of the query file or the conversion file, and click Modify.
  8. The Modify ODBC Query dialog box opens.
    Modify ODBC Query dialog box

  9. Modify the ODBC query by changing the connection string and/or the SQL statement. You can click Database to open the ODBC Select Data Source dialog box, in which you can select a *.dsn file, which inserts the connection string in the box. You can click Microsoft Query to open Microsoft Query.
  10. Click OK to return to the Edit Checklist dialog box.
  11. Click OK to close the Edit Checklist dialog box.

Modifying a Query Created with Data Junction

You can modify a Data Junction conversion file used in a database checkpoint directly in Data Junction. To see the pathname of the conversion file, follow the instructions below.

To see the pathname of a Data Junction conversion file in a database checkpoint:

  1. Choose Insert > Edit Database Checklist. The Open Checklist dialog box opens.
  2. A list of checklists for the current test is displayed. If you want to see checklists in a shared folder, click Shared.
  3. For more information on sharing database checklists, see “Saving a Database Checklist in a Shared Folder”

    To see the pathname of a Data Junction conversion file in a database checkpoint

  4. Select a database checklist.
  5. Click OK.
  6. The Open Checklist dialog box closes. The Edit Database Checklist dialog box opens and displays the selected checklist.

    The Objects pane contains “Database check” and the name of the *.djs conversion file that will be included in the database checkpoint.

    The Properties pane lists the different types of checks that can be performed on databases. A check mark indicates that the item is selected and is included in the checkpoint.

    To modify the properties to check, see “Editing Database Checklists”

    Editing Database Checklists”

  7. In the Objects column, highlight the name of the conversion file, and click Modify.
  8. WinRunner displays a message to use Data Junction to modify the conversion file and the pathname of the conversion file.

  9. Click OK to close the message and return to the Edit Checklist dialog box.
  10. Click OK to close the Edit Checklist dialog box.
  11. Modify the conversion file directly in Data Junction.

All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd DMCA.com Protection Status

WinRunner Topics