RE: [Webtest] Inserting SQL queriesThat would be something I would like to see. Please post this tutorial.

Carlton Nettleton -----Original Message----- From: webt...@lists.canoo.com [mailto:webt...@lists.canoo.com]On Behalf Of EPu...@upstate.com Sent: Tuesday, January 21, 2003 7:47 AM To: webt...@lists.canoo.com Subject: RE: [Webtest] Inserting SQL queries

A couple of posts have gone around on the Maven and Webtest lists about mixing SQL queries and WebTest. And pointed out has been my favorite tool, DBUnit, to set up data instead of raw SQL.

I will attempt to put together a tutorial demonstrating this functionality in the next day or too. I use it extensively to test my ASP websites!

Eric Pugh

-----Original Message----- From: Aatish Arora [mailto:a_aa...@yahoo.com] Sent: Tuesday, January 21, 2003 10:38 AM To: webt...@lists.canoo.com Subject: RE: [Webtest] Inserting SQL queries

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 > > > > __________________________________________________ > > Do you Yahoo!? > > Yahoo! Mail Plus - Powerful. Affordable. Sign up > now. > > http://mailplus.yahoo.com > > _______________________________________________ > > WebTest mailing list > > WebT...@lists.canoo.com > > http://lists.canoo.com/mailman/listinfo/webtest > > > _______________________________________________ > WebTest mailing list > WebT...@lists.canoo.com > http://lists.canoo.com/mailman/listinfo/webtest