首页 > 代码库 > SoapUI Pro Project Solution Collection-change the JDBC Request behavior

SoapUI Pro Project Solution Collection-change the JDBC Request behavior

change the jdbc request :

1.change the driver name,connection string,query string or assert.

  • the object we will use here is : JdbcRequestTestStep
        TestCase newcase=testRunner.getTestCase();        JdbcRequestTestStep step1=(JdbcRequestTestStep) newcase.getTestStepByName("");                String driver=step1.getDriver();        String constr=step1.getConnectionString();        String password=step1.getPassword();                step1.setDriver(""); //if there‘s no driver should set as  step1.setDriver(null)                step1.setConnectionString("");        step1.setPassword("");

  • change the jdbc sql statement:
        step1.setQuery("");        step1.setQueryTimeout("");
  • change the assertion behavior(like xpath string,jquery string):

http://www.soapui.org/apidocs/com/eviware/soapui/model/testsuite/TestAssertion.html

http://www.soapui.org/apidocs/com/eviware/soapui/impl/wsdl/teststeps/assertions/basic/XPathContainsAssertion.html

http://www.soapui.org/apidocs/com/eviware/soapui/impl/wsdl/teststeps/assertions/basic/GroovyScriptAssertion.html

        int totalassert=step1.getAssertionCount();        for(int k=0;k<totalassert;k++){            TestAssertion asserts=step1.getAssertionAt(k);            if(asserts instanceof XPathContainsAssertion ){                if(asserts.getName().contains("Check count")){                    String originalxpath=((XPathContainsAssertion) asserts).getPath();                    String newxpath=originalxpath.replaceAll("Row", "Row2");                    ((XPathContainsAssertion) asserts).setPath(newxpath);                }            }        }

SoapUI Pro Project Solution Collection-change the JDBC Request behavior