You can just use some Groovy or the <sqlunit> task from SqlUnit.
Some further information about the latter of these can be found
in the manual:
http://webtest.canoo.com/webtest/manual/sqlunit.html
Any sqlunit property starting with "ant." will be available
as an Ant property.
Cheers, Paul.
Lothar Maerkle wrote:
Hello Ivan,
I use the <loadFile/> task after a <sql/> task for this.
Another idea is, to use a dbunit(or the like) task to query the db and store
the result as XML, and then use <invoke/>, <storeXPath/> ... to
extract the values.
hth,
lothar
On Tue, Sep 12, 2006 at 06:09:55AM -0700, Ivan Rancati wrote:
In the webapp I am testing, I need to enter some values in text fields which
are coming from a database.
What is the recommended way to store the result from a sql select statement
into a property (either dynamic or static)?
From the documentation for the sql task
http://ant.apache.org/manual/CoreTasks/sql.html
I see it's possible to specify an output file, but not an output property
thank you
Ivan
--
View this message in context:
http://www.nabble.com/how-to-get-results-from-sql-Ant-task-into-a-property-tf2258806.html#a6265776
Sent from the WebTest forum at Nabble.com.
_______________________________________________
WebTest mailing list
[email protected]
http://lists.canoo.com/mailman/listinfo/webtest
_______________________________________________
WebTest mailing list
[email protected]
http://lists.canoo.com/mailman/listinfo/webtest
