[Webtest] Inserting SQL queries

Dierk Koenig webtest@lists.canoo.com
Tue, 21 Jan 2003 12:32:26 +0100


Hi Aatish,

some WebTest users use dbUnit in addition to WebTest. 
You may want to search the archive of this mailinglist to that end.

For mixing in db queries:

1) you can try to keep your TestSpecs as short as possible
(this is recommended anyway) and do your db-calls beforen and 
after it.

2) if you need to mix your queries in between the steps,
a small "db-servlet" (or JSP/ASP/..) may help that you can
drive through WebTest an executes the query on your behalf.

cheers
Mittie

> -----Original Message-----
> From: webtest-admin@lists.canoo.com
> [mailto:webtest-admin@lists.canoo.com]On Behalf Of Aatish Arora
> Sent: Dienstag, 21. Januar 2003 6:29
> To: webtest@lists.canoo.com
> Subject: [Webtest] Inserting SQL queries
> 
> 
> Hi,
> 
> I have downloaded the latest version of webtest and
> installed it. From what I know till now - it is pretty
> cool. But I have a small problem most of my tests
> would look something like this:
> 
> 1) Invoke a page
> 2) Perform a set of actions
> 3) Check the database
> 
> One of our devlopers suggested using ANT scripts for
> the SQL queries. But the problem lies in the fact that
> there would be SQL queries before and after every
> test. Is there a way I can manage this? or is there a
> workaround?
> 
> TIA
> 
> Aatish
> 
> __________________________________________________
> Do you Yahoo!?
> Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
> http://mailplus.yahoo.com
> _______________________________________________
> WebTest mailing list
> WebTest@lists.canoo.com
> http://lists.canoo.com/mailman/listinfo/webtest
>