Forum Discussion

IBaxter's avatar
IBaxter
Occasional Contributor
9 years ago

Is this still true that you can only run a single statement per JDBC step?

REST API I create users via API and have to drop them after that so that this scenario can be automated. POST user makes entiries into four different tables. So I have to create four JDBC steps? O...
nmrao's avatar
nmrao
Champion Level 3
Are you surprised with that?
If there are multiple queries allowed, how do you assert result?
IBaxter's avatar
IBaxter
Occasional Contributor
9 years ago

I don't care about assertion of this step. This is not a testing step. This is a maintanance step.

  • nmrao's avatar
    nmrao
    Champion Level 3
    9 years ago
    Kindly note that, soapUI is tool for testing. And not sure what is maintenance step, not heard of it.
    • IBaxter's avatar
      IBaxter
      Occasional Contributor
      9 years ago

      If you need to test an API that creates an user. And you need to automate this step -  how are you going to get rid of this user at the end of you test? You need to add steps to do cleanup, to delete your user. That is what I call 'mainantanance' steps. And because users's properties are written in several tables - I have to delete it from several tables meaning create several sql statements. 

       

      • nmrao's avatar
        nmrao
        Champion Level 3
        9 years ago
        Ok.
        "Create several sql statements" - You mean, need to have multiple jdbc steps?
        How about having an sql file with all statements that are needed, and run this sql using tear down script of test case or suite (what ever fits you)