Topic: WinRunner Questions and Answers Part-8

How do you convert a database file to a text file?
You can use Data Junction to create a conversion file which converts a database to a target text file.

How do you parameterize database check points?
When you create a standard database checkpoint using ODBC (Microsoft Query), you can add parameters to an SQL statement to parameterize the checkpoint. This is useful if you want to create a database checkpoint with a query in which the SQL statement defining your query changes

How do you create parameterize SQL commands?

• A parameterized query is a query in which at least one of the fields of the WHERE clause is parameterized, i.e., the value of the field is specified by a question mark symbol ( ? ). For example, the following SQL statement is based on a query on the database in the sample Flight Reservation application:

SELECT Flights.Departure, Flights.Flight_Number, Flights.Day_Of_Week FROM Flights Flights WHERE (Flights.Departure=?) AND (Flights.Day_Of_Week=?)

     SELECT defines the columns to include in the query.
     FROM specifies the path of the database.
WHERE (optional) specifies the conditions, or filters to use in the query.
Departure is the parameter that represents the departure point of a flight.
Day_Of_Week is the parameter that represents the day of the week of a flight.

• When creating a database checkpoint, you insert a db_check statement into your test script. When you parameterize the SQL statement in your checkpoint, the db_check function has a fourth, optional, argument: the parameter_array argument. A statement similar to the following is inserted into your test script:

db_check("list1.cdl", "dbvf1", NO_LIMIT, dbvf1_params);

The parameter_array argument will contain the values to substitute for the parameters in the parameterized checkpoint.

Explain the following commands

• db_connect - to connect to a database

db_connect(<session_name>, <connection_string>)

• db_execute_query - to execute a query

db_execute_query ( session_name, SQL, record_number );
[record_number  is the out value]

• db_get_field_value - returns the value of a single field in the specified row_index and column in the session_name database session.

db_get_field_value ( session_name, row_index, column );

• db_get_headers - returns the number of column headers in a query and the content of the column headers, concatenated and delimited by tabs.

db_get_headers ( session_name, header_count, header_content );

• db_get_row - returns the content of the row, concatenated and delimited by tabs.

db_get_row ( session_name, row_index, row_content );

• db_write_records - writes the record set into a text file delimited by tabs.

db_write_records ( session_name, output_file [ , headers [ , record_limit ] ] );

• db_get_last_error - returns the last error message of the last ODBC or Data Junction operation in the session_name database session.

db_get_last_error ( session_name, error );

• db_disconnect - disconnects from the database and ends the database session.

db_disconnect ( session_name );

• db_dj_convert - runs the djs_file Data Junction export file. When you run this file, the Data Junction Engine converts data from one spoke (source) to another (target). The optional parameters enable you to override the settings in the Data Junction export file.

db_dj_convert ( djs_file [ , output_file [ , headers [ , record_limit ] ] ] );

What check points you will use to read and check text on the GUI and explain its syntax?
You can use text checkpoints in your test scripts to read and check text in GUI objects and in areas of the screen. While creating a test you point to an object or a window containing text. WinRunner reads the text and writes a TSL statement to the test script. You may then add simple programming elements to your test scripts to verify the contents of the text.

You can use a text checkpoint to:
 

1. Read text from a GUI object or window in your application, using obj_get_text and win_get_text
    
2. Search for text in an object or window, using win_find_text and obj_find_text
    
3. Move the mouse pointer to text in an object or window, using obj_move_locator_text and win_move_locator_text
    
4. Click on text in an object or window, using obj_click_on_text and win_click_on_text

Winrunner Question 76: Explain Get Text checkpoint from object/window with syntax?

Winrunner Question 77: Explain Get Text checkpoint from screen area with syntax?

Winrunner Question 78: Explain Get Text checkpoint from selection (web only) with syntax?