Forum Discussion

IBaxter's avatar
IBaxter
Occasional Contributor
10 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
Community Hero
10 years ago
Are you surprised with that?
If there are multiple queries allowed, how do you assert result?
  • IBaxter's avatar
    IBaxter
    Occasional Contributor
    10 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
      Community Hero
      10 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
        10 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.