[Webtest] Inserting SQL queries
Carlton Nettleton
webtest@lists.canoo.com
Tue, 21 Jan 2003 08:39:57 -0800
This is a multi-part message in MIME format.
------=_NextPart_000_0004_01C2C128.AD7A4800
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
RE: [Webtest] Inserting SQL queriesThat would be something I would like to
see. Please post this tutorial.
Carlton Nettleton
-----Original Message-----
From: webtest-admin@lists.canoo.com
[mailto:webtest-admin@lists.canoo.com]On Behalf Of EPugh@upstate.com
Sent: Tuesday, January 21, 2003 7:47 AM
To: webtest@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_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_000_0004_01C2C128.AD7A4800
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>RE: [Webtest] Inserting SQL queries</TITLE>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2800.1126" name=3DGENERATOR></HEAD>
<BODY>
<DIV><SPAN class=3D234063916-21012003><FONT face=3DArial color=3D#0000ff =
size=3D2>That=20
would be something I would like to see. Please post this=20
tutorial.</FONT></SPAN></DIV>
<DIV><SPAN class=3D234063916-21012003><FONT face=3DArial color=3D#0000ff =
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D234063916-21012003><FONT face=3DArial color=3D#0000ff =
size=3D2>Carlton Nettleton</FONT></SPAN></DIV>
<BLOCKQUOTE dir=3Dltr style=3D"MARGIN-RIGHT: 0px">
<DIV class=3DOutlookMessageHeader dir=3Dltr align=3Dleft><FONT =
face=3DTahoma=20
size=3D2>-----Original Message-----<BR><B>From:</B>=20
webtest-admin@lists.canoo.com =
[mailto:webtest-admin@lists.canoo.com]<B>On=20
Behalf Of </B>EPugh@upstate.com<BR><B>Sent:</B> Tuesday, January 21, =
2003 7:47=20
AM<BR><B>To:</B> webtest@lists.canoo.com<BR><B>Subject:</B> RE: =
[Webtest]=20
Inserting SQL queries<BR><BR></FONT></DIV>
<P><FONT size=3D2>A couple of posts have gone around on the Maven and =
Webtest=20
lists about mixing SQL queries and WebTest. And pointed out has =
been my=20
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=20
functionality in the next day or too. I use it extensively to =
test my=20
ASP websites!</FONT></P>
<P><FONT size=3D2>Eric Pugh</FONT> </P>
<P><FONT size=3D2>-----Original Message-----</FONT> <BR><FONT =
size=3D2>From:=20
Aatish Arora [<A=20
=
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=20
size=3D2>To: webtest@lists.canoo.com</FONT> <BR><FONT =
size=3D2>Subject: RE:=20
[Webtest] Inserting SQL queries</FONT> </P><BR>
<P><FONT size=3D2>Thanks Mittie!</FONT> </P>
<P><FONT size=3D2>This is getting Interesting. Ill check it up =
:)</FONT> </P>
<P><FONT size=3D2>regards,</FONT> <BR><FONT size=3D2>Aatish =
Arora</FONT> </P>
<P><FONT size=3D2>--- Dierk Koenig <dierk.koenig@canoo.com> =
wrote:</FONT>=20
<BR><FONT size=3D2>> Hi Aatish,</FONT> <BR><FONT size=3D2>> =
</FONT><BR><FONT=20
size=3D2>> some WebTest users use dbUnit in addition to</FONT> =
<BR><FONT=20
size=3D2>> WebTest. </FONT><BR><FONT size=3D2>> You may want to =
search the=20
archive of this</FONT> <BR><FONT size=3D2>> mailinglist to that =
end.</FONT>=20
<BR><FONT size=3D2>> </FONT><BR><FONT size=3D2>> For mixing in =
db=20
queries:</FONT> <BR><FONT size=3D2>> </FONT><BR><FONT size=3D2>> =
1) you can=20
try to keep your TestSpecs as short as</FONT> <BR><FONT size=3D2>>=20
possible</FONT> <BR><FONT size=3D2>> (this is recommended anyway) =
and do your=20
db-calls</FONT> <BR><FONT size=3D2>> beforen and </FONT><BR><FONT =
size=3D2>>=20
after it.</FONT> <BR><FONT size=3D2>> </FONT><BR><FONT =
size=3D2>> 2) if you=20
need to mix your queries in between the</FONT> <BR><FONT size=3D2>> =
steps,</FONT> <BR><FONT size=3D2>> a small "db-servlet" (or =
JSP/ASP/..) may=20
help that</FONT> <BR><FONT size=3D2>> you can</FONT> <BR><FONT =
size=3D2>>=20
drive through WebTest an executes the query on your</FONT> <BR><FONT=20
size=3D2>> behalf.</FONT> <BR><FONT size=3D2>> </FONT><BR><FONT =
size=3D2>>=20
cheers</FONT> <BR><FONT size=3D2>> Mittie</FONT> <BR><FONT =
size=3D2>>=20
</FONT><BR><FONT size=3D2>> > -----Original Message-----</FONT> =
<BR><FONT=20
size=3D2>> > From: webtest-admin@lists.canoo.com</FONT> =
<BR><FONT=20
size=3D2>> > [<A=20
=
href=3D"mailto:webtest-admin@lists.canoo.com">mailto:webtest-admin@lists.=
canoo.com</A>]On=20
Behalf Of</FONT> <BR><FONT size=3D2>> Aatish Arora</FONT> <BR><FONT =
size=3D2>> > Sent: Dienstag, 21. Januar 2003 6:29</FONT> =
<BR><FONT=20
size=3D2>> > To: webtest@lists.canoo.com</FONT> <BR><FONT =
size=3D2>> >=20
Subject: [Webtest] Inserting SQL queries</FONT> <BR><FONT =
size=3D2>> >=20
</FONT><BR><FONT size=3D2>> > </FONT><BR><FONT size=3D2>> =
> Hi,</FONT>=20
<BR><FONT size=3D2>> > </FONT><BR><FONT size=3D2>> > I =
have downloaded=20
the latest version of webtest</FONT> <BR><FONT size=3D2>> =
and</FONT>=20
<BR><FONT size=3D2>> > installed it. From what I know till now - =
it=20
is</FONT> <BR><FONT size=3D2>> pretty</FONT> <BR><FONT =
size=3D2>> > cool.=20
But I have a small problem most of my tests</FONT> <BR><FONT =
size=3D2>> >=20
would look something like this:</FONT> <BR><FONT size=3D2>> >=20
</FONT><BR><FONT size=3D2>> > 1) Invoke a page</FONT> <BR><FONT=20
size=3D2>> > 2) Perform a set of actions</FONT> <BR><FONT =
size=3D2>> >=20
3) Check the database</FONT> <BR><FONT size=3D2>> > =
</FONT><BR><FONT=20
size=3D2>> > One of our devlopers suggested using ANT =
scripts</FONT>=20
<BR><FONT size=3D2>> for</FONT> <BR><FONT size=3D2>> > the =
SQL queries.=20
But the problem lies in the fact</FONT> <BR><FONT size=3D2>> =
that</FONT>=20
<BR><FONT size=3D2>> > there would be SQL queries before and =
after=20
every</FONT> <BR><FONT size=3D2>> > test. Is there a way I can =
manage=20
this? or is</FONT> <BR><FONT size=3D2>> there a</FONT> <BR><FONT =
size=3D2>>=20
> workaround?</FONT> <BR><FONT size=3D2>> > </FONT><BR><FONT=20
size=3D2>> > TIA</FONT> <BR><FONT size=3D2>> > =
</FONT><BR><FONT=20
size=3D2>> > Aatish</FONT> <BR><FONT size=3D2>> > =
</FONT><BR><FONT=20
size=3D2>> > =
__________________________________________________</FONT>=20
<BR><FONT size=3D2>> > Do you Yahoo!?</FONT> <BR><FONT =
size=3D2>> >=20
Yahoo! Mail Plus - Powerful. Affordable. Sign up</FONT> <BR><FONT =
size=3D2>>=20
now.</FONT> <BR><FONT size=3D2>> > <A =
href=3D"http://mailplus.yahoo.com"=20
target=3D_blank>http://mailplus.yahoo.com</A></FONT> <BR><FONT =
size=3D2>> >=20
_______________________________________________</FONT> <BR><FONT =
size=3D2>>=20
> WebTest mailing list</FONT> <BR><FONT size=3D2>> >=20
WebTest@lists.canoo.com</FONT> <BR><FONT size=3D2>> > <A=20
href=3D"http://lists.canoo.com/mailman/listinfo/webtest"=20
=
target=3D_blank>http://lists.canoo.com/mailman/listinfo/webtest</A></FONT=
>=20
<BR><FONT size=3D2>> > </FONT><BR><FONT size=3D2>>=20
_______________________________________________</FONT> <BR><FONT =
size=3D2>>=20
WebTest mailing list</FONT> <BR><FONT size=3D2>>=20
WebTest@lists.canoo.com</FONT> <BR><FONT size=3D2>> <A=20
href=3D"http://lists.canoo.com/mailman/listinfo/webtest"=20
=
target=3D_blank>http://lists.canoo.com/mailman/listinfo/webtest</A></FONT=
>=20
</P><BR>
<P><FONT =
size=3D2>__________________________________________________</FONT>=20
<BR><FONT size=3D2>Do you Yahoo!?</FONT> <BR><FONT size=3D2>Yahoo! =
Mail Plus -=20
Powerful. Affordable. Sign up now.</FONT> <BR><FONT size=3D2><A=20
href=3D"http://mailplus.yahoo.com"=20
target=3D_blank>http://mailplus.yahoo.com</A></FONT> <BR><FONT=20
size=3D2>_______________________________________________</FONT> =
<BR><FONT=20
size=3D2>WebTest mailing list</FONT> <BR><FONT=20
size=3D2>WebTest@lists.canoo.com</FONT> <BR><FONT size=3D2><A=20
href=3D"http://lists.canoo.com/mailman/listinfo/webtest"=20
=
target=3D_blank>http://lists.canoo.com/mailman/listinfo/webtest</A></FONT=
>=20
</P></BLOCKQUOTE></BODY></HTML>
------=_NextPart_000_0004_01C2C128.AD7A4800--