Data Driven Projects, Tests & Frameworks

Hi Mike,

The problem that I have is that each iteration must use the same row from every sheet and every application tab.

While Not Driver1.EOF

   ' Do Something

  Driver1.Next

  Driver2.Next

  ...

  Driver6.Next

WEnd

If you are using keyword tests and the Data-Driven Loop operation, you need to create and control Driver2..Driver6, as driver 1 will be controlled by the operation. To call the Next method, you can use the Call Object Method operation.

I'm also a little confused about the project layout and the framework of the tests themselves

1: Startup - A test that will perform initialization actions.

2: TestTabs - This is the test that will

                        * Read data from worksheets in a loop

                        * For each data row, it will

                              - simulate user actions on the tabs (fill the tabs 1..6);

                              - output data to a file;

                              - Compare - Performs the needed verifications. 

                              Each of these substeps can be a script routine or keyword test.

                        * Call Next to proceed to the next data row.

3: Teardown - A test that will perform finalization actions.

You can create test items for tests 1, 2 and 3 on the Test Items page of the project editor.

While Not Driver1.EOF    ' Do Something     Driver1.Next     Driver2.Next      ...   Driver6.Next Wend

Hi Mike,

Here's what I mean: while (!Driver1.EOF){   //Fill out parameters for tab1      while(!Driver2.EOF){     //Fill out parameters for tab2       while(!Driver3.EOF){       //Fill out parameters for tab3       ..........       ..........           while (!Driver6.EOF){           //Here is where the problem lies (I think).  When I get here, ALL rows for Driver 6 must be run.

As far as I understood, you have the same number of rows in each of the six datasheets, and you need to go through the sheets synchronously, right? In this case, you need only one while loop. If you want to control other drivers for EOF (just in case the test data is invalid), you can check them in the same "while" condition --

while(!Driver1.EOF() && !Driver2.EOF()... )

{

     // Your test goes here...

     Driver1.Next();

     Driver2.Next();

     ..

     Driver6.Next();

}

Does it work for you? Or am I missing something in your description?..

your solution looks like it will work if all of the test code (as far as manipulating the objects go) are in one script under the script tree.  What if I had one script for each tab?  How can I move back and forth there?  I haven't researched it yet, I just thought of that as I was typing this response.

// Define global variables

var Driver1, Driver2, ... Driver6;

// Initialize drivers

function InitDrivers()

{

  ...

}

// Simulate user actions on tabs

function TestTab1()

{

  ...

}

function TestTab2()

{

  ...

}

// Perform finalization actions

function Finalize()

{

}

function Main()

{

  InitDrivers();

  while (!Driver1.EOF() && !Driver2.EOF() ...)

  {

     TestTab1();

     TestTab2();

     ...

     Driver1.Next();

     Driver2.Next();

     ..

  }

 

  Finalize();

}

//USEUNIT commonlib

//USEUNIT applib

//USEUNIT ScriptUnit1

//USEUNIT ScriptUnit2

//USEUNIT ScriptUnit3

//USEUNIT ScriptUnit4

//USEUNIT ScriptUnit5     

//USEUNIT ScriptUnit6

//USEUNIT ScriptUnit7 

//USEUNIT ScriptUnit8

//USEUNIT ScriptUnit9

//USEUNIT ScriptUnit10

//USEUNIT ScriptUnit11



function Controller() {



//Get the test directory so we know where our datasheet is.

var testDir = Project.Path;

var testData = testDir + "\\Default.xls";



//Set up the data drivers, specific to the sheet we want to use.

var Sheet1 = DDT.ExcelDriver(testData, "ScriptUnit1");

var Sheet2 = DDT.ExcelDriver(testData, "ScriptUnit2");

var Sheet3 = DDT.ExcelDriver(testData, "ScriptUnit3");

var Sheet4 = DDT.ExcelDriver(testData, "ScriptUnit4");

var Sheet5 = DDT.ExcelDriver(testData, "ScriptUnit5");

var Sheet6 = DDT.ExcelDriver(testData, "ScriptUnit6");

var Sheet7 = DDT.ExcelDriver(testData, "ScriptUnit7");

var Sheet8 = DDT.ExcelDriver(testData, "ScriptUnit8");

var Sheet9 = DDT.ExcelDriver(testData, "ScriptUnit9");

var Sheet10 = DDT.ExcelDriver(testData, "ScriptUnit10");

var Sheet11 = DDT.ExcelDriver(testData, "ScriptUnit11");



//Since all sheets must have the same number of rows, we can use the 

//intial sheet as the EOF check.  If this sheet is EOF, all of them are.

while (!Sheet1.EOF()) {



  //First thing we need to do is get the Run Flag.  If it's 'N' we are not

  //running this iteration.

  var RUN_FLAG = Sheet1.Value("RunFlag");

  var myVar = Sheet1.Value("Val");

  if (RUN_FLAG == "N") {

    Log.Message("Skipping this iteration: " + Sheet1.Value("Val"));  

  }

  else { 

  

  //Write a log so that we know which row we are on.

  Log.Message("**************     Running test " + myVar  + " **************");

         

  //Set the ScriptUnit1 values.

  ScriptUnit1Tab(Sheet1);

  

  //Set the ScriptUnit2 values.

  ScriptUnit2Tab(Sheet2);

  

  //Set the ScriptUnit3 values.

  ScriptUnit3Tab(Sheet3);

  

  //Set the ScriptUnit4 values.

  ScriptUnit4Tab(Sheet4);

  

  //Set the ScriptUnit5 values.

  ScriptUnit5Tab(Sheet5);



  //Set the ScriptUnit6 values.

  ScriptUnit6Tab(Sheet6); 

   

  //Set the ScriptUnit7 values.

  ScriptUnit7Tab(Sheet7);

  

  //Set the ScriptUnit8 values.

  ScriptUnit8Tab(Sheet8);

  

  //Set the ScriptUnit9 values.

  ScriptUnit9Tab(Sheet9);

  

  //Set the ScriptUnit10 values.

  ScriptUnit10Tab(Sheet10);



  //Set the ScriptUnit9 values.

  ScriptUnit11Tab(Sheet11);

 

    }

    //Increment all rows for every sheet.

    Sheet1.Next();

    Sheet2.Next();

    Sheet3.Next();

    Sheet4.Next();

    Sheet5.Next();

    Sheet6.Next();

    Sheet7.Next();

    Sheet8.Next();

    Sheet9.Next();

    Sheet10.Next();

    Sheet11.Next();

}



}  // End of Controller

//USEUNIT commonlib

//USEUNIT applib



function ScriptUnit1Tab(Driver){



//Set up our local variables from the Sheet1 sheet.  

var var1 = Driver.Value("var1");

var var2 = Driver.Value("var2");

var var3 = Driver.Value("var3");



//Function calls to do things specific to the data in the sheet.



}//End of function

Mike,

Thank you for sharing your solution.

Nice to hear that everything works fine. :-)