Forum Discussion

mgroen2's avatar
mgroen2
Super Contributor
9 years ago

Data driven Test Execution with TestExecute: is this possible implement?

I have created a Keyword Data Driven test in TestComplete. The test reads it's test data out of an Excel file, and perform a data driven loop. Works OK.   However, now I want another end user (not ...
  • m_essaid's avatar
    m_essaid
    9 years ago

    adapt and add this delphi-like script to your code :

     

    function ReadParams(Argument: string): Boolean;
    var
       i: integer;
    begin
       Result:= False;
       for i:= 0 to BuiltIn.ParamCount do
       begin
         log.Message(ParamStr(i));
         if (ParamStr(i) = Argument) then
         begin
           Result:= True;
           exit;
         end;
       end;
    end;

     

    use it like this :

     

    if (ReadParams('/User1')) then

      ... your code for the User1...

    else if ... etc

Marsha_R's avatar
Marsha_R
Moderator

If the end user has a separate copy of the project, then you could just replace the Excel file in that project with one using the same name as yours but different data.

 

If the end user is running out of your copy of the project, then is there a user name or something you can check first and then pass the Excel file name as a parameter?  

mgroen2's avatar
mgroen2
Super Contributor
9 years ago

Thanks for the tip. It's a good approach.

Could be a good 'workaround', in some situations, but in some situations it's not desired to change filenames (because of usage etc). Still think it's an improvement to implement more segregation between test scripts ('logic'), and test data. 

For end users this is necessary in particular because they do not run TestComplete.

  • m_essaid's avatar
    m_essaid
    Valued Contributor
    9 years ago

    Hi,

     

    I would :

     

      - create a function to read command line parameters of TextExecute (ask me if you need it) and then use a parameter like /User1, or /User2, etc...

      - Use this condition to create by scrip the variable that point on the excel file (for User1, use this excel, for User2, use this, etc...)

     

    That's all

     

    Mehdi

    • mgroen2's avatar
      mgroen2
      Super Contributor
      9 years ago

      Hi Mehdi,

       

      sounds like a good approach too. Can you explain me how to read command line parameters of TestExecute?

       

      Thanks.

      Mathijs

      • m_essaid's avatar
        m_essaid
        Valued Contributor
        9 years ago

        adapt and add this delphi-like script to your code :

         

        function ReadParams(Argument: string): Boolean;
        var
           i: integer;
        begin
           Result:= False;
           for i:= 0 to BuiltIn.ParamCount do
           begin
             log.Message(ParamStr(i));
             if (ParamStr(i) = Argument) then
             begin
               Result:= True;
               exit;
             end;
           end;
        end;

         

        use it like this :

         

        if (ReadParams('/User1')) then

          ... your code for the User1...

        else if ... etc