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]))

     

     

     

     

baxatob's avatar
baxatob
Community Hero
8 years ago
What did you mean saying "print"?
If you want to output the resulting value e.g. to the log, use:

Log.Message(str(get_test_suite(your_excel_file_driver)))

tests_to_run is a local variable inside get_test_suite() function.
  • Rajesh2's avatar
    Rajesh2
    Contributor
    8 years ago

    Hi baxatob. I was asking like how to print only the first value?

     

    Like from ['TC1138', 'TC996', 'TC1135', 'TC1138', 'TC1140'] i need to print only 'TC1138'.

     

    Can you help with this problem?

    • baxatob's avatar
      baxatob
      Community Hero
      8 years ago

      Rajesh2,

       

      my_list = [1, 2, 3, 4, 5]

my_list[0] == 1

my_list[-1] == 5

      etc...

      You ask very fundamental questions. I believe you need to open Python's Tutorial where you will find all answers and more.

      It's impossible to code something without that knowledge.

      • Rajesh2's avatar
        Rajesh2
        Contributor
        8 years ago

        baxatob I know to print the values from the list. 

         

        my_list = [1, 2, 3, 4, 5]

my_list[0] == 1

my_list[-1] == 5

         

         But i am not able to print using the script which you have sent

         

        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 

         

        When i call this method inside a script i will get the result as ['TC1138', 'TC996', 'TC1135', 'TC1138', 'TC1140']. 

        Now i need to fetch the first value from the list.

         

        I have tried with this code:

         

        test_case_container = DDT.ExcelDriver("C:\\Users\\TESTPC\\Desktop\\TestDoc.xlsx", "Sheet1", True)

         

        def get_test_suite():
        tests_to_run = [] # creating an empty list
        while not test_case_container.EOF():
        if(test_case_container.Value["Execute-Flag(Y/N)"] == "Y"):
        test=tests_to_run.append(test_case_container.Value["TCID"])
        test_case_container.Next()
        return tests_to_run

        def test():
        Log.Message(str(get_test_suite()))
        A=[get_test_suite()]
        Log.Message(str(A[1]))

         

        But i am not able to fetch the values. Can you please help with this problem?