[Webtest] best-practices? using xml/xsl and webtest to populate data

Aatish Arora webtest@lists.canoo.com
Fri, 3 Oct 2003 11:00:49 -0700 (PDT)


--0-1637966273-1065204049=:31482
Content-Type: text/plain; charset=us-ascii

..the most crude way - use the <sql> tag :)
but what database are u using?
a lot would depend on that.
 
I guess almost all databases have an option to load data from csv files.
We used a similar option to populate data ;)
Directly populating the database has its advantages - u can be sure that the data going in is proper - which you might or might not be able to gaurnatee thru the screen as there might be bugs in the application.
 
But then again - if u populate wrong data into the database, it could lead to some drastic problems on the front end - but my view is that if you do have problems - its good cause a lot of bugs are unearthed this way.
 
Cheers!
Aatish
 


Bill Milbratz <Bmilbratz@participate.com> wrote:
Hi,
 
Is anyone using webtest with xml and xsl to populate a system w/ test data?
 
Our qa people have expressed interest in automatic scripts to populate our system w/ some basic data.. I'd like to use webtest for this as the data will be ultimately easier to maintain.
 
I had made a pass at it earlier and it worked fine, though the xsl might seem difficult to maintain...(I recall there was a problem generating ant properties ${foo.bar} in the xsl).... I was curious if anyone is (successfully) using webtest in this regard?
 
I welcome any comments (even "dumb idea. write an sql script".)  some feedback is better than none.
 
bill milbratz
 
 
 
 
 


---------------------------------
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
--0-1637966273-1065204049=:31482
Content-Type: text/html; charset=us-ascii

<DIV>..the most crude way - use the &lt;sql&gt; tag :)</DIV>
<DIV>but what database are u using?</DIV>
<DIV>a lot would depend on that.</DIV>
<DIV>&nbsp;</DIV>
<DIV>I guess almost all databases have an option to load data from csv files.</DIV>
<DIV>We used a similar option to populate data ;)</DIV>
<DIV>Directly populating the database has its advantages - u can be sure that the data going in is proper - which you might or might not be able to gaurnatee thru the screen as there might be bugs in the application.</DIV>
<DIV>&nbsp;</DIV>
<DIV>But then again - if u populate wrong data into the database, it could lead to some drastic problems on the front end - but my view is that if you do have problems - its good cause a lot of bugs are unearthed this way.</DIV>
<DIV>&nbsp;</DIV>
<DIV>Cheers!</DIV>
<DIV>Aatish</DIV>
<DIV>&nbsp;</DIV>
<DIV><BR><BR><B><I>Bill Milbratz &lt;Bmilbratz@participate.com&gt;</I></B> wrote:</DIV>
<BLOCKQUOTE class=replbq style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #1010ff 2px solid">
<META content="MSHTML 6.00.2600.0" name=GENERATOR>
<DIV><SPAN class=319153615-03102003><FONT face=Arial color=#0000ff size=2>Hi,</FONT></SPAN></DIV>
<DIV><SPAN class=319153615-03102003><FONT face=Arial color=#0000ff size=2></FONT></SPAN>&nbsp;</DIV>
<DIV><SPAN class=319153615-03102003><FONT face=Arial color=#0000ff size=2>Is anyone using webtest with xml and xsl to populate&nbsp;a system w/ test data?</FONT></SPAN></DIV>
<DIV><SPAN class=319153615-03102003><FONT face=Arial color=#0000ff size=2></FONT></SPAN>&nbsp;</DIV>
<DIV><SPAN class=319153615-03102003><FONT face=Arial color=#0000ff size=2>Our qa people have expressed interest in automatic scripts to populate our system w/ some basic data.. </FONT></SPAN><SPAN class=319153615-03102003><FONT face=Arial color=#0000ff size=2>I'd like to use webtest for this as the data will be ultimately easier to maintain.</FONT></SPAN></DIV>
<DIV><SPAN class=319153615-03102003><FONT face=Arial color=#0000ff size=2></FONT></SPAN>&nbsp;</DIV>
<DIV><SPAN class=319153615-03102003><FONT face=Arial color=#0000ff size=2>I had made a pass at it earlier and it worked fine, though the xsl might seem difficult to maintain...(I recall there was a problem generating ant properties ${foo.bar} in the xsl).... I was curious if anyone is (successfully) using webtest in this regard?</FONT></SPAN></DIV>
<DIV><SPAN class=319153615-03102003><FONT face=Arial color=#0000ff size=2></FONT></SPAN>&nbsp;</DIV>
<DIV><SPAN class=319153615-03102003><FONT face=Arial color=#0000ff size=2>I welcome any comments (even "dumb idea. write an sql script".)&nbsp;&nbsp;some feedback is better than none.</FONT></SPAN></DIV>
<DIV><SPAN class=319153615-03102003><FONT face=Arial color=#0000ff size=2></FONT></SPAN>&nbsp;</DIV>
<DIV><SPAN class=319153615-03102003><FONT face=Arial color=#0000ff size=2>bill milbratz</FONT></SPAN></DIV>
<DIV><SPAN class=319153615-03102003><FONT face=Arial color=#0000ff size=2></FONT></SPAN>&nbsp;</DIV>
<DIV><SPAN class=319153615-03102003><FONT face=Arial color=#0000ff size=2></FONT></SPAN>&nbsp;</DIV>
<DIV><SPAN class=319153615-03102003><FONT face=Arial color=#0000ff size=2></FONT></SPAN>&nbsp;</DIV>
<DIV><SPAN class=319153615-03102003><FONT face=Arial color=#0000ff size=2></FONT></SPAN>&nbsp;</DIV>
<DIV><SPAN class=319153615-03102003><FONT face=Arial color=#0000ff size=2></FONT></SPAN>&nbsp;</DIV></BLOCKQUOTE><p><hr SIZE=1>
Do you Yahoo!?<br>
<a href="http://shopping.yahoo.com/?__yltc=s%3A150000443%2Cd%3A22708228%2Cslk%3Atext%2Csec%3Amail">The New Yahoo! Shopping</a> - with improved product search
--0-1637966273-1065204049=:31482--