RE: [Webtest] Inserting SQL queries - Aatish Arora - com.canoo.lists.webtest

7 messages in com.canoo.lists.webtestRE: [Webtest] Inserting SQL queries

From	Sent On	Attachments
Aatish Arora	20 Jan 2003 21:29
Dierk Koenig	21 Jan 2003 03:32
Aatish Arora	21 Jan 2003 07:37
EPu...@upstate.com	21 Jan 2003 07:46
Carlton Nettleton	21 Jan 2003 08:39
Aatish Arora	22 Jan 2003 23:04
Jitendra Joshi	23 Jan 2003 02:06

Subject:	RE: [Webtest] Inserting SQL queries
From:	Aatish Arora (a_aa...@yahoo.com)
Date:	01/21/2003 07:37:11 AM
List:	com.canoo.lists.webtest

Thanks Mittie!

This is getting Interesting. Ill check it up :)

regards, Aatish Arora

--- Dierk Koenig <dier...@canoo.com> wrote:

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: webt...@lists.canoo.com [mailto:webt...@lists.canoo.com]On Behalf Of Aatish Arora Sent: Dienstag, 21. Januar 2003 6:29 To: webt...@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