SoapUI Pro Project Solution Collection-change the JDBC Request behavior

浏览数：71 / 时间：2015年06月12日

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);
                }
            }
        }