[Webtest] Inserting SQL queries

Tue, 21 Jan 2003 10:47:08 -0500

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

------_=_NextPart_001_01C2C164.5AF2FF00
Content-Type: text/plain;
	charset="iso-8859-1"

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_aatish@yahoo.com]
Sent: Tuesday, January 21, 2003 10:38 AM
To: webtest@lists.canoo.com
Subject: RE: [Webtest] Inserting SQL queries

Thanks Mittie!

This is getting Interesting. Ill check it up :)

regards,
Aatish Arora

--- Dierk Koenig <dierk.koenig@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: 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
> > 
> _______________________________________________
> WebTest mailing list
> WebTest@lists.canoo.com
> http://lists.canoo.com/mailman/listinfo/webtest

__________________________________________________
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

------_=_NextPart_001_01C2C164.5AF2FF00
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2654.89">
<TITLE>RE: [Webtest] Inserting SQL queries</TITLE>
</HEAD>
<BODY>

<P><FONT SIZE=3D2>A couple of posts have gone around on the Maven and =
Webtest lists about mixing SQL queries and WebTest.&nbsp; And pointed =
out has been my favorite tool, DBUnit, to set up data instead of raw =
SQL.</FONT></P>

<P><FONT SIZE=3D2>I will attempt to put together a tutorial =
demonstrating this functionality in the next day or too.&nbsp; I use it =
extensively to test my ASP websites!</FONT></P>

<P><FONT SIZE=3D2>Eric Pugh</FONT>
</P>

<P><FONT SIZE=3D2>-----Original Message-----</FONT>
<BR><FONT SIZE=3D2>From: Aatish Arora [<A =
HREF=3D"mailto:a_aatish@yahoo.com">mailto:a_aatish@yahoo.com</A>]</FONT>=

<BR><FONT SIZE=3D2>Sent: Tuesday, January 21, 2003 10:38 AM</FONT>
<BR><FONT SIZE=3D2>To: webtest@lists.canoo.com</FONT>
<BR><FONT SIZE=3D2>Subject: RE: [Webtest] Inserting SQL queries</FONT>
</P>
<BR>

<P><FONT SIZE=3D2>Thanks Mittie!</FONT>
</P>

This is getting Interesting. Ill check it up =
:)

<P><FONT SIZE=3D2>regards,</FONT>
<BR><FONT SIZE=3D2>Aatish Arora</FONT>
</P>

--- Dierk Koenig &lt;dierk.koenig@canoo.com&gt; =
wrote:
 &gt; Hi Aatish,
 &gt; 
 &gt; some WebTest users use dbUnit in addition =
to
 &gt; WebTest. 
 &gt; You may want to search the archive of =
this
 &gt; mailinglist to that end.
 &gt; 
 &gt; For mixing in db queries:
 &gt; 
 &gt; 1) you can try to keep your TestSpecs as short =
as
 &gt; possible
 &gt; (this is recommended anyway) and do your =
db-calls
 &gt; beforen and 
 &gt; after it.
 &gt; 
 &gt; 2) if you need to mix your queries in between =
the
 &gt; steps,
 &gt; a small &quot;db-servlet&quot; (or JSP/ASP/..) =
may help that
 &gt; you can
 &gt; drive through WebTest an executes the query on =
your
 &gt; behalf.
 &gt; 
 &gt; cheers
 &gt; Mittie
 &gt; 
 &gt; &gt; -----Original Message-----
 &gt; &gt; From: webtest-admin@lists.canoo.com
 &gt; &gt; [<A =
HREF=3D"mailto:webtest-admin@lists.canoo.com">mailto:webtest-admin@lists=
.canoo.com</A>]On Behalf Of
 &gt; Aatish Arora
 &gt; &gt; Sent: Dienstag, 21. Januar 2003 =
6:29
 &gt; &gt; To: webtest@lists.canoo.com
 &gt; &gt; Subject: [Webtest] Inserting SQL =
queries
 &gt; &gt; 
 &gt; &gt; 
 &gt; &gt; Hi,
 &gt; &gt; 
 &gt; &gt; I have downloaded the latest version of =
webtest
 &gt; and
 &gt; &gt; installed it. From what I know till now - =
it is
 &gt; pretty
 &gt; &gt; cool. But I have a small problem most of =
my tests
 &gt; &gt; would look something like this:
 &gt; &gt; 
 &gt; &gt; 1) Invoke a page
 &gt; &gt; 2) Perform a set of actions
 &gt; &gt; 3) Check the database
 &gt; &gt; 
 &gt; &gt; One of our devlopers suggested using ANT =
scripts
 &gt; for
 &gt; &gt; the SQL queries. But the problem lies in =
the fact
 &gt; that
 &gt; &gt; there would be SQL queries before and =
after every
 &gt; &gt; test. Is there a way I can manage this? or =
is
 &gt; there a
 &gt; &gt; workaround?
 &gt; &gt; 
 &gt; &gt; TIA
 &gt; &gt; 
 &gt; &gt; Aatish
 &gt; &gt; 
 &gt; &gt; =
__________________________________________________
 &gt; &gt; Do you Yahoo!?
 &gt; &gt; Yahoo! Mail Plus - Powerful. Affordable. =
Sign up
 &gt; now.
 &gt; &gt; <A HREF=3D"http://mailplus.yahoo.com" =
TARGET=3D"_blank">http://mailplus.yahoo.com</A>
 &gt; &gt; =
_______________________________________________
 &gt; &gt; WebTest mailing list
 &gt; &gt; WebTest@lists.canoo.com
 &gt; &gt; <A =
HREF=3D"http://lists.canoo.com/mailman/listinfo/webtest" =
TARGET=3D"_blank">http://lists.canoo.com/mailman/listinfo/webtest</A></F=
ONT>
 &gt; &gt; 
 &gt; =
_______________________________________________
 &gt; WebTest mailing list
 &gt; WebTest@lists.canoo.com
 &gt; <A =
HREF=3D"http://lists.canoo.com/mailman/listinfo/webtest" =
TARGET=3D"_blank">http://lists.canoo.com/mailman/listinfo/webtest</A></F=
ONT>

__________________________________________________
 Do you Yahoo!?
 Yahoo! Mail Plus - Powerful. Affordable. Sign up =
now.
 <A HREF=3D"http://mailplus.yahoo.com" =
TARGET=3D"_blank">http://mailplus.yahoo.com</A>
 _______________________________________________
 WebTest mailing list
 WebTest@lists.canoo.com
 <A =
HREF=3D"http://lists.canoo.com/mailman/listinfo/webtest" =
TARGET=3D"_blank">http://lists.canoo.com/mailman/listinfo/webtest</A></F=
ONT>

</BODY>
</HTML>
------_=_NextPart_001_01C2C164.5AF2FF00--