Forum Discussion

Rajesh2's avatar
Rajesh2
Contributor
8 years ago

Can anyone please help me with using Tuples in TestComplete with Python

Hi,   I need to fetch the testcases based on the ExecutionFlag(Y/N) from Excel   I need to store the testcases which have ExecutionFlag="Y" and store it in Array.   Now i need to create a loop ...
  • baxatob's avatar
    baxatob
    8 years ago

    This should work:

     

    A = get_test_suite(test_case_container)
Log.Message(str(A[0]))

    as well as this:

     

    A = [get_test_suite(test_case_container)]
Log.Message(str(A[0][0]))

     

     

     

     

Rajesh2's avatar
Rajesh2
Contributor

baxatob Can you please help me with this?

baxatob's avatar
baxatob
Community Hero
8 years ago

Ok.

 

 

test_case_container = DDT.ExcelDriver("C:\\TestCases.xls", "Sheet1")

def get_test_suite(test_case_container):

    tests_to_run = [] # creating an empty list

    while not test_case_container.EOF():
        if test_case_container.Value["ExecutionFlag(Y/N)"] == "Y":
            tests_to_run.append(test_case_container.Value["TCID"])

        test_case_container.Next()

    return tests_to_run

 

 

get_test_suite() will return a list of strings, where each string is a name of your test case marked with "Y" flag.

  • Rajesh2's avatar
    Rajesh2
    Contributor
    8 years ago

    Thank you so much baxatob.. But i am unable to print tests_to_run which has appended all test cases with Execution Flag = "Y". 

     

    Like if i need to print all the testcases with Execution Flag="Y" using that array tests_to_run.