Forum Discussion

anand1's avatar
anand1
Contributor
5 years ago

Assertion of selective elements in a teststep

Hi, I am using readyapi version 3.1.0 and I am trying to do the database testing using it My test case looks like this Iteration 1- csvdata file-Datasource step step1 step2 step3 XPATH - [AC-1...
Assertions
Automation Environments
Editors
REST
Scripting
SOAP
  • anand1's avatar
    anand1
    5 years ago

    Thanks nmrao for your suggestion

    I have never used custom property earlier, however I am able to achieve it using script assertion and for now it seems that it running well with my huge data.

    Still if i run into any scenario..will surely try the custom property approach.

     

    Thanks for your help.

anand1's avatar
anand1
Contributor

Thanks nmrao HimanshuTayal 

Below is the screenshot for the call that I am executing, and in both the screenshot, call is made to the same table, however the expected value that I am trying to assert is changing.

 

Screen1:

 

Screen2:

 

Let me know if that helps.

 

Thanks,

Anand

nmrao's avatar
nmrao
Champion Level 3
5 years ago
Can't view the images, lost the quality on zooming.

Attach text of the response.
  • anand1's avatar
    anand1
    Contributor
    5 years ago

    Sure nmrao 

     

    Sc2:

     

    And the response output is 

    <Row rowNumber="1">
    <_>[STUDENTOBJECTIVEASSESSMENTSCORErESULTS]</_>
    <STUDENTOBJECTIVEASSESSMENTID>447023021</STUDENTOBJECTIVEASSESSMENTID>
    <ASSESSMENTREPORTINGMETHODTYPEID>24</ASSESSMENTREPORTINGMETHODTYPEID>
    <FORMATTEDRESULT>3611</FORMATTEDRESULT>
    <SHORTDESCRIPTION>Scale score</SHORTDESCRIPTION>
    <STUDENTOBJECTIVEASSESSMENTID>447023021</STUDENTOBJECTIVEASSESSMENTID>
    <ASSESSMENTREPORTINGMETHODTYPEID>24</ASSESSMENTREPORTINGMETHODTYPEID>
    <RESULT>3611</RESULT>
    <RESULTDATATYPETYPEID>1</RESULTDATATYPETYPEID>
    <EFFECTIVEFROMDATE>2020-03-11</EFFECTIVEFROMDATE>
    <EFFECTIVETODATE/>
    <CREATEDDATE>2020-03-11 09:05:58.353</CREATEDDATE>

     

    Assertion is 

    //Results[1]/ResultSet[1]/Row[1]/FORMATTEDRESULT[1]

    #Reading for Information Scaled Score

     

    Next Iteration 

    <Row rowNumber="1">
    <_>[STUDENTOBJECTIVEASSESSMENTSCORErESULTS]</_>
    <STUDENTOBJECTIVEASSESSMENTID>447023021</STUDENTOBJECTIVEASSESSMENTID>
    <ASSESSMENTREPORTINGMETHODTYPEID>24</ASSESSMENTREPORTINGMETHODTYPEID>
    <FORMATTEDRESULT>3611</FORMATTEDRESULT>
    <SHORTDESCRIPTION>Scale score</SHORTDESCRIPTION>
    <STUDENTOBJECTIVEASSESSMENTID>447023021</STUDENTOBJECTIVEASSESSMENTID>
    <ASSESSMENTREPORTINGMETHODTYPEID>24</ASSESSMENTREPORTINGMETHODTYPEID>
    <RESULT>3611</RESULT>
    <RESULTDATATYPETYPEID>1</RESULTDATATYPETYPEID>
    <EFFECTIVEFROMDATE>2020-03-11</EFFECTIVEFROMDATE>
    <EFFECTIVETODATE/>
    <CREATEDDATE>2020-03-11 09:05:58.353</CREATEDDATE>
    <LASTMODIFIEDDATE>2020-03-11 09:06:09.567</LASTMODIFIEDDATE>
    <STUDENTOBJECTIVEASSESSMENTSCORERESULTBK/>
    <ASSESSMENTREPORTINGMETHODTYPEID>24</ASSESSMENTREPORTINGMETHODTYPEID>
    <CODEVALUE>Scale score</CODEVALUE>
    <DESCRIPTION>Scale score</DESCRIPTION>
    <EFFECTIVEFROMDATE>2012-07-01</EFFECTIVEFROMDATE>
    <EFFECTIVETODATE/>
    <CREATEDDATE>2012-08-01 00:00:00.0</CREATEDDATE>

     

    Assertion is 

    //Results[1]/ResultSet[1]/Row[1]/FORMATTEDRESULT[1]

    #Functions (8, Alg I, Alg II) Scaled Score

     

    Let me know it that helps

    • nmrao's avatar
      nmrao
      Champion Level 3
      5 years ago
      Not sure if it is copy paste issue. Both iteration 1, 2 responses look similar.
      - "#Functions (8, Alg I, Alg II) Scaled Score" did not get what it is.

      Few other questions
      - how many rows in each iteration? fixed? varies?
      - how does a data source row appears for each iteration, assuming that this data is used to verify response.
      • anand1's avatar
        anand1
        Contributor
        5 years ago

        No it is not a copy paste issue, my expected data is changing, however my actual landing data is being saved in the same column of the database

         

        Few other questions
        - how many rows in each iteration? fixed? varies?

        [Anand] : If I understand it correctly, you are asking abt the response -if it is, then it is fixed
        - how does a data source row appears for each iteration, assuming that this data is used to verify response.

        [Anand] : Here is the caveat..the datasource row is changing based on type condition

        for eg row 1 : is having 10 column data --( col1, col2, col3, ........col10)

                  row2 : is having 10 columns data - but out of that 3 columns are different( col1, col2, col13,col14,col15 ..)

         

        hope this helps