[Webtest] Simple SQL example needed.

[M Zwick]

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
>