Hi Marek,
you can use Ant / sql with the parameter "output" to store the result of
the SQL query. Take a look at:
http://ant.apache.org/manual/CoreTasks/sql.html
A simple test script could look like:
------------------
project name="SimpleSQLTest" basedir=".." default="SQL">
<property name="webtest.home" value="${basedir}/.." />
<import file="${webtest.home}/lib/taskdef.xml"/>
<target name="SQL" description="Tests if webtest can connect to a DB
and submit a query">
<sql
driver="oracle.jdbc.driver.OracleDriver"
url="jdbc:oracle:thin:@blabla:1521:test"
userid="user"
password="pw"
print="yes"
output="someDirectory/SQL_output.txt"
>
<![CDATA[
select count(*) from table where xy=bla;
]]>
</sql>
<webtest name="Queck SQL query output">
&config
<steps>
<invoke url="someDirectory/SQL_output.txt"/>
<verifyText text="test" />
</steps>
</webtest>
</target>
</project>
------------------
Hope that helps. Regards
Michael
Hello Everybody!
I need to get a value from DB and store it.
Then use it in other part of test.
Scenario:
1. Select $something$ from $table$ where $something$= $something$
2. Store thre result of SQL - storedResult
3. Use verifyText with text="#{storedResult}"
Can anyone help me?
Regards
Marek
_______________________________________________
WebTest mailing list
[email protected]
http://lists.canoo.com/mailman/listinfo/webtest
