Forum Discussion

hazel_chua's avatar
hazel_chua
Contributor
5 years ago

Trying to retrieve a property based on the value of another property in the Properties test step

I have 2 Properties test steps set up in one of my test suites.  And right now I need to retrieve values from the 2nd Properties test step based on a serial number from the first Properties test step...
Data-Driven Testing
Scripting
SOAP
  • hazel_chua's avatar
    hazel_chua
    4 years ago

    eventually this is what I ended up doing : 

     

     

    	if(incCount == true)
	{
		//Count the number of times an account number is used for financial transactions on the day and 
		//updated the "Count" in the Settlements property step
		def propertySettlements = testRunner.testCase.getTestStepByName("Settlements")
		paddingNum = propertySettlements.getPropertyValue("DataRowCount").length()
	
		for(def testProperty in propertySettlements.getPropertyList())
		{
			if(accnum in testProperty.value)
			{
				def padFlag = testProperty.name.substring(testProperty.name.length()-paddingNum)
				int newVal = propertySettlements.getPropertyValue("Count " + padFlag).toInteger()
				newVal++
				propertySettlements.setPropertyValue("Count " + padFlag, newVal.toString())
			}
		}
	}

     

     

HimanshuTayal's avatar
HimanshuTayal
Community Hero
5 years ago

hazel_chua :

 

Hope below code will help you out in resolving your issue:

 

//For getting count from Properties step 1
def propertiesStep = testRunner.testCase.getTestStepByName("Properties")
HashMap<String,Integer> map = new HashMap<String,Integer>();
for(testProperty in propertiesStep.getPropertyList()){
	if(testProperty.name.contains("Serial")){
		if(map.containsKey(testProperty.getValue()) )
			map.put(testProperty.getValue(), map.get(testProperty.getValue())+1)
		else{
			map.put(testProperty.getValue(), 1)
		}
	}
}
//For setting count in Properties step 2
def propertiesStep1 = testRunner.testCase.getTestStepByName("Properties1")
for(testProperty in propertiesStep1.getPropertyList()){
	
	for(Map.Entry entry in map.entrySet()){
		if(entry.getKey() in testProperty.value){
			flag = testProperty.name.substring(testProperty.name.length()-1);
			propertiesStep1.setPropertyValue("Count "+flag.toString(),entry.getValue().toString())
		}
	}
}
  • hazel_chua's avatar
    hazel_chua
    Contributor
    5 years ago

    That isn't quite what I was after but it gives me something to try out.  Will update this when I get the chance to think through that and perhaps adapt the code to better suit what I need.

     

    Thanks

    • HimanshuTayal's avatar
      HimanshuTayal
      Community Hero
      5 years ago

      hazel_chua : What's your use case then could you please brief where have you stuck

      • hazel_chua's avatar
        hazel_chua
        Contributor
        5 years ago

        Apologies HimanshuTayal, been busy with other parts of work to get back to this.  What I am trying to do here is that while the script iterates through the properties of PropertyStep1, it updates the matching 'Count' property of the 'Serial Number' in PropertyStep2 with the new value based on the Serial Number that is encountered in PropertyStep1

         

        Edit again : I just thought of another interesting quandary.  What if the 'Count' property was added to PropertyStep2 after the property step was created, so that now PropertyStep2 looks like (as an example) :

        Row 1 : 1

        Serial Number 1 : 12345

        Row 2 : 2

        Serial Number 2 : 12346

        Row 3 : 3

        Serial Number 3 : 12347

        Count 1 : 0

        Count 2 : 0

        Count 3 : 0

  • hazel_chua's avatar
    hazel_chua
    Contributor
    4 years ago

    eventually this is what I ended up doing : 

     

     

    	if(incCount == true)
	{
		//Count the number of times an account number is used for financial transactions on the day and 
		//updated the "Count" in the Settlements property step
		def propertySettlements = testRunner.testCase.getTestStepByName("Settlements")
		paddingNum = propertySettlements.getPropertyValue("DataRowCount").length()
	
		for(def testProperty in propertySettlements.getPropertyList())
		{
			if(accnum in testProperty.value)
			{
				def padFlag = testProperty.name.substring(testProperty.name.length()-paddingNum)
				int newVal = propertySettlements.getPropertyValue("Count " + padFlag).toInteger()
				newVal++
				propertySettlements.setPropertyValue("Count " + padFlag, newVal.toString())
			}
		}
	}