[dbunit-commit] dbunit/docs/sample_webtest build.properties,NONE,1.1 build.xml,NONE,1.1 sharedConfiguration.xml,NONE,1.1 subscribeEmailAddressWithOptedOutEmail.xml,NONE,1.1 TestSuiteEDM.xml,NONE,1.1

[<de...@us...>]

Update of /cvsroot/dbunit/dbunit/docs/sample_webtest
In directory sc8-pr-cvs1:/tmp/cvs-serv2053

Added Files:
	build.properties build.xml sharedConfiguration.xml 
	subscribeEmailAddressWithOptedOutEmail.xml TestSuiteEDM.xml 
Log Message:
Supporting sample files for Howto on DbUnit and WebTest

--- NEW FILE: build.properties ---
# The webserver that you will be point WebTest at
web.server=localhost

# Standard WebTest configuration.
host=${web.server}
port=80
protocol=http
basepath=
showhtmlparseroutput=no
resultpath=result
resultfile=WebTestResults.xml

# How to find the WebTest libraries
webtest.home=c:/java/test/canoo
start.page=default.asp
r.page=r.asp



# How to find the DbUnit libraries
dbunit.classpath=C:/java/test/dbunit-1.3/dbunit/lib/
# The sql server that you will be updating with DbUnit.
sql.server=trujillo

#sql.server login
sql.user=MySQLUser
sql.password=MySQLPassword
sql.database=MyWebSite

sql.jdbcdriver = com.microsoft.jdbc.sqlserver.SQLServerDriver
sql.url =jdbc:microsoft:sqlserver://${sql.server}:1433;DatabaseName=${sql.database};SelectMethod=cursor
sql.username =${sql.user}
--- NEW FILE: build.xml ---

<!--
Sample Created by David Eric Pugh.  Free for all!
de...@ya...
-->

<project name="TestSuite" default="test">

<!-- Allow any user specific values to override the defaults -->
  <property file="${user.home}/build.properties" />

  <property file="project.properties"/>
  <property file="build.properties"/>
  



  <property name="resultfile" value="WebTestResults.xml"/>
  <property name="resultfile.txt" value="WebTestResults.txt"/>
  <property name="resultfile.html" value="WebTestResults.html"/>
  <property name="start.page" value="menu.jsp"/>
  <property name="base.dir" value="${basedir}"/>

  <taskdef name="testSpec" classname="com.canoo.webtest.ant.TestSpecificationTask">
    <classpath>
      <pathelement location="${webtest.home}/classes"/>
      <fileset dir="${webtest.home}" includes="**/lib/*.jar"/>
    </classpath>
  </taskdef>  
  
  <taskdef name="dbunit" classname="org.dbunit.ant.DbUnitTask">
      <classpath>
          <fileset dir="${dbunit.classpath}" includes="dbunit.jar"/>
          <fileset dir="${dbunit.classpath}" includes="exml.jar"/>
      </classpath>
  </taskdef>


  <target name="test" depends="prepareResultDir,init" description="run all the tests">
    <echo>
      Executing ALL testcases
      Webserver: ${web.server}
      Database: ${sql.server}/${sql.database}
    </echo>
  
    <ant antFile="TestSuiteEDM.xml"/>
    <echo>Finished testSuiteEDM for SniffTest.</echo>
    
    <ant antFile="TestSuiteSeachEngineFriendlyURLs.xml"/>
    <echo>Finished testSuiteSearchEngineFriendlyURLs for SniffTest.</echo>
    
    <ant antFile="TestSuiteSkuStartsWith.xml"/>
    <echo>Finished TestSuiteSkuStartsWith for SniffTest.</echo>
    
    <echo>Finished All Test Suites.</echo>
    <antcall target="CreateSummaryReport"/>
  </target>

  
  <target name="test:single" depends="prepareResultDir,init" description="run a single test in a suite, passed in via -Dtestcase -Dsuite">
  
      <echo>
      Executing testcase ${testcase} for suite ${suite}.
      </echo>
      <ant target="${testcase}" antFile="${suite}"/>
      <antcall target="CreateSummaryReport"/>
  </target>
  
  <target name="test:suite" depends="prepareResultDir,init" description="run a single suite, passed in via -Dsuite">
      
    <echo>
    Executing suite: ${suite}
    </echo>
    <ant antFile="${suite}"/>
    <antcall target="CreateSummaryReport"/>
  </target>  
  
    
  <target name="CreateSummaryReport">
    <copy file="${webtest.home}/template/report.css" todir="${resultpath}"/>
    <copy file="${webtest.home}/template/Services.css" todir="${resultpath}"/>
    <copy file="${resultpath}/${resultfile}" todir="${base.dir}"/>
    <copy file="${webtest.home}/template/WebTestReport.xml" todir="${base.dir}"/>
    <tstamp>
        <format property="report.time" pattern="dd.MM.yyyy hh:mm:ss"/>
    </tstamp>
    <ant antfile="${webtest.home}/template/ApplyXSL.xml" target="applySingle">
        <!-- report.time  already set -->
        <property name="resultpath" value="${base.dir}"/>
        <property name="resultfile" value="WebTestReport.xml"/>
        <property name="resultfile.html" value="TestResultOverview.html"/>
        <property name="style" value="${webtest.home}/template/WebTestReport.xsl"/>
    </ant>
    <move file="${base.dir}/TestResultOverview.html" todir="${resultpath}"/>
    <delete file="${base.dir}/${resultfile}" />
    <delete file="${base.dir}/WebTestReport.xml" />
  </target>


  <target name="prepareResultDir">
    <mkdir dir="${resultpath}"/>
    <delete file="${resultpath}/${resultfile}"/>
    <delete file="${resultpath}/_resultCore.xml"/>
    <delete file="${resultpath}/${resultfile.txt}"/>
    <delete file="${resultpath}/${resultfile.html}"/>
    <delete file="${resultfile}"/>
    <delete>
      <fileset dir="${resultpath}" includes="*.html"/>
    </delete>
  </target>

  <target name="com.canoo.webtest.AllTests">
    <junit>
      <classpath>
    <pathelement location="${webtest.home}/classes"/>
    <fileset dir="${webtest.home}" includes="**/lib/*.jar"/>
      </classpath>
      <test name="com.canoo.webtest.AllTests"/>
    </junit>
  </target>

  <target name="com.canoo.webtest.reporting.XmlReporterTest">
    <junit>
      <classpath>
    <pathelement location="${webtest.home}/classes"/>
    <fileset dir="${webtest.home}" includes="**/lib/*.jar"/>
    <fileset dir="${webtest.home}" includes="${lib.repo}/*.jar"/>
      </classpath>
      <test name="com.canoo.webtest.reporting.XmlReporterTest"/>
    </junit>
  </target>


  
  <target name="init">
    <echo>
    Running Tests against:
    web.server=${web.server}
    sql.server=${sql.server}
    </echo>
  </target>

</project>

--- NEW FILE: sharedConfiguration.xml ---
<!--
	Shared Configuration for the WebTest
-->

<config
	host="${host}"
	port="${port}"
	protocol="${protocol}"
	basepath="${basepath}"
	summary="true"
	verbose="true"
	saveresponse="true"
	resultpath="${resultpath}"
	resultfile="${resultfile}"
	haltonfailure="false"
  showhtmlparseroutput="false"
/>
--- NEW FILE: subscribeEmailAddressWithOptedOutEmail.xml ---


<dataset>

  <EMAIL EMAIL_ID='1' EMAIL='sub...@te...' OPTIN='0'/>
    
</dataset>
--- NEW FILE: TestSuiteEDM.xml ---
<!DOCTYPE project [
  <!ENTITY sharedConfiguration SYSTEM "./includes/sharedConfiguration.xml">
  <!ENTITY invokeHome   SYSTEM "file:./includes/invokeHome.xml">
  

  

  
]>


<project name="TestSuiteEDM" default="testSuite">
  <!-- Allow any user specific values to override the defaults -->
  <property file="${user.home}/build.properties" />

  <property file="project.properties"/>
  <property file="build.properties"/>
  



  <property name="resultfile" value="WebTestResults.xml"/>
  <property name="resultfile.txt" value="WebTestResults.txt"/>
  <property name="resultfile.html" value="WebTestResults.html"/>
  <property name="start.page" value="menu.jsp"/>
  <property name="base.dir" value="${basedir}"/>
  
    <taskdef name="dbunit" classname="org.dbunit.ant.DbUnitTask">
        <classpath>
            <fileset dir="${dbunit.classpath}" includes="dbunit.jar"/>
            <fileset dir="${dbunit.classpath}" includes="exml.jar"/>
        </classpath>
  </taskdef>



<target name="testSuite">
  <antcall target="sniffTest"/>
  <antcall target="userWithNoRedirectionID"/>
  <antcall target="userWithRedirectionIDOldStyle"/>
  <antcall target="userWithRedirectionID"/>
  <antcall target="userWithRedirectionIDBadEmailOldStyle"/>
  <antcall target="userWithRedirectionIDBadEmail"/>
  
  <antcall target="userWithExistingEmailAddress"/>
  <antcall target="userWithExistingEmailAddressOldStyle"/>
  <antcall target="userWithNewEmailAddress"/>
  <antcall target="userWithNewEmailAddressOldStyle"/>
  
  <antcall target="userWithCampaignId"/>
  <antcall target="userWithEverythingRedirectToProduct"/>
  <antcall target="userWithEverythingRedirectToProductOldStyle"/>
  
  <antcall target="redirectToExternalWebsite"/>
  <antcall target="redirectToExternalWebsiteOldStyle"/>
  <antcall target="redirectionURLEndingInSlash"/>
  
  <antcall target="unsubscribeWithBadEmailId"/>
  <antcall target="unsubscribeWithNoParameters"/>
  <antcall target="unsubscribeWithInvalidEmail"/>

  <antcall target="unsubscribeEmailAddressWithEmail"/>
  <antcall target="unsubscribeEmailAddressWithEmailID"/>
  <antcall target="unsubscribeEmailAddressWithNewEmailAddress"/>
  
  <antcall target="subscribeEmailAddressWithOptedOutEmail"/>
  <antcall target="subscribeEmailAddressWithNewEmailAddress"/>
  <antcall target="subscribeEmailAddressWithInvalidEmailAddress"/>
  
  <antcall target="productWithCustomCOAHeader"/>
  <!-- NO PRODUCT CURRENTLY AVAILABLE
  <antcall target="productWithPartnerLink"/>
  -->
  
</target>


<target name="userWithNoRedirectionID">
  <testSpec name="userWithNoRedirectionID">
    &sharedConfiguration;
    <steps>
      <invoke stepid="main page"
              url="${r.page}"
        save="userWithNoRedirectionID"/>
      <verifytext stepid="Make sure we are on the homepage"
        text="Our Newest Product Releases"/>            
        
    </steps>
  </testSpec>                             
</target>

<target name="userWithRedirectionIDOldStyle">
  <dbunit 
    driver="${sql.jdbcdriver}"          
    url="${sql.url}"          
    userid="${sql.username}"          
    password="${sql.password}">    
        <operation type="MSSQL_REFRESH" src="data/userWithRedirectionID.xml" format="flat"/>
  </dbunit>

  <testSpec name="userWithRedirectionIDOldStyle">
    &sharedConfiguration;
    <steps>
      <invoke stepid="main page"
              url="${r.page}?r=1"
        save="userWithRedirectionID"/>
      <verifytext stepid="Make sure we are redirected to the upstate info page"
        text="Upstate develops the most innovative products"/>  
      
    </steps>
  </testSpec>                             
</target>

<target name="userWithRedirectionID">
  <dbunit 
    driver="${sql.jdbcdriver}"          
    url="${sql.url}"          
    userid="${sql.username}"          
    password="${sql.password}">    
        <operation type="MSSQL_REFRESH" src="data/userWithRedirectionID.xml" format="flat"/>
  </dbunit>

  <testSpec name="userWithRedirectionID">
    &sharedConfiguration;
    <steps>
      <invoke stepid="main page"
              url="r.q.r.e.1"
        save="userWithRedirectionID"/>
      <verifytext stepid="Make sure we are redirected to the upstate info page"
        text="Upstate develops the most innovative products"/>  
      
    </steps>
  </testSpec>                             
</target>

<target name="userWithRedirectionIDBadEmail">
  <dbunit 
    driver="${sql.jdbcdriver}"          
    url="${sql.url}"          
    userid="${sql.username}"          
    password="${sql.password}">    
        <operation type="MSSQL_REFRESH" src="data/userWithRedirectionIDBadEmail.xml" format="flat"/>
  </dbunit>


  <testSpec name="userWithRedirectionIDBadEmail">
    &sharedConfiguration;
    <steps>
      <invoke stepid="main page"
              url="/r.q.r.e.1.a.e.e.userWithRedirectionIDBadEmail"
        save="userWithRedirectionIDBadEmail"/>
      <verifytext stepid="Make sure we are redirected to the upstate info page despite the bad email"
        text="Upstate develops the most innovative products"/>  
      
    </steps>
  </testSpec>                             
</target>

<target name="userWithRedirectionIDBadEmailOldStyle">
  <dbunit 
    driver="${sql.jdbcdriver}"          
    url="${sql.url}"          
    userid="${sql.username}"          
    password="${sql.password}">    
        <operation type="MSSQL_REFRESH" src="data/userWithRedirectionIDBadEmail.xml" format="flat"/>
  </dbunit>


  <testSpec name="userWithRedirectionIDBadEmailOldStyle">
    &sharedConfiguration;
    <steps>
      <invoke stepid="main page"
              url="${r.page}?r=1&amp;e=userWithRedirectionIDBadEmail"
        save="userWithRedirectionIDBadEmail"/>
      <verifytext stepid="Make sure we are redirected to the upstate info page despite the bad email"
        text="Upstate develops the most innovative products"/>  
      
    </steps>
  </testSpec>                             
</target>

<target name="redirectionURLEndingInSlash">
  <dbunit 
    driver="${sql.jdbcdriver}"          
    url="${sql.url}"          
    userid="${sql.username}"          
    password="${sql.password}">    
        <operation type="MSSQL_REFRESH" src="data/redirectionURLEndingInSlash.xml" format="flat"/>
  </dbunit>


  <testSpec name="redirectionURLEndingInSlash">
    &sharedConfiguration;
    <steps>
      <invoke stepid="redirection url ending in a slash"
              url="${r.page}?r=1/"
        save="redirectionURLEndingInSlash"/>
      <verifytext stepid="Make sure we are redirected to the upstate info page"
        text="Upstate develops the most innovative products"/> 
        
    </steps>
  </testSpec>                             
</target>


<target name="userWithExistingEmailAddressOldStyle">
  <dbunit 
      driver="${sql.jdbcdriver}"          
      url="${sql.url}"          
      userid="${sql.username}"          
      password="${sql.password}">    
          <operation type="MSSQL_REFRESH" src="data/userWithExistingEmailAddress.xml" format="flat"/>
  </dbunit>
  <testSpec name="userWithExistingEmailAddressOldStyle">
    &sharedConfiguration;
    <steps>
      <invoke stepid="main page"
              url="${r.page}?r=1&amp;e=1"
        save="userWithExistingEmailAddress"/>
      <verifytext stepid="Make sure we are redirected to the upstate info page"
        text="Upstate develops the most innovative products"/>       
          
    </steps>
  </testSpec>                             
</target>

<target name="userWithExistingEmailAddress">
  <dbunit 
      driver="${sql.jdbcdriver}"          
      url="${sql.url}"          
      userid="${sql.username}"          
      password="${sql.password}">    
          <operation type="MSSQL_REFRESH" src="data/userWithExistingEmailAddress.xml" format="flat"/>
  </dbunit>
  <testSpec name="userWithExistingEmailAddress">
    &sharedConfiguration;
    <steps>
      <invoke stepid="main page"
              url="/r.q.r.e.1.a.e.e.1"
        save="userWithExistingEmailAddress"/>
      <verifytext stepid="Make sure we are redirected to the upstate info page"
        text="Upstate develops the most innovative products"/>       
          
    </steps>
  </testSpec>                             
</target>

<target name="userWithNewEmailAddress">
  <testSpec name="userWithNewEmailAddress">
    &sharedConfiguration;
    <steps>
      <invoke stepid="main page"
              url="/r.q...@te....a.r.e.1"
        save="userWithNewEmailAddress"/>          
      <verifytext stepid="Make sure we are redirected to the upstate info page"
        text="Upstate develops the most innovative products"/>       
    </steps>
    
  </testSpec>                             
</target>
<target name="userWithNewEmailAddressOldStyle">
  <testSpec name="userWithNewEmailAddressOldStyle">
    &sharedConfiguration;
    <steps>
      <invoke stepid="main page"
              url="${r.page}?e=...@te...&amp;r=1"
        save="userWithNewEmailAddressOldStyle"/>          
      <verifytext stepid="Make sure we are redirected to the upstate info page"
        text="Upstate develops the most innovative products"/>       
    </steps>
    
  </testSpec>                             
</target>
<target name="userWithCampaignId">
  <dbunit 
      driver="${sql.jdbcdriver}"          
      url="${sql.url}"          
      userid="${sql.username}"          
      password="${sql.password}">    
          <operation type="MSSQL_REFRESH" src="data/userWithCampaignId.xml" format="flat"/>
  </dbunit>
  <testSpec name="userWithCampaignId">
    &sharedConfiguration;
    <steps>
      <invoke stepid="main page"
              url="${r.page}?r=1&amp;e=1&amp;c=1"
        save="userWithCampaignId"/>
      <verifytext stepid="Make sure we are redirected to the upstate info page"
        text="Upstate develops the most innovative products"/>       
          
    </steps>
  </testSpec>                             
</target>

<target name="userWithEverythingRedirectToProduct">
  <dbunit 
      driver="${sql.jdbcdriver}"          
      url="${sql.url}"          
      userid="${sql.username}"          
      password="${sql.password}">    
          <operation type="MSSQL_REFRESH" src="data/userWithEverythingRedirectToProduct.xml" format="flat"/>
  </dbunit>
  <testSpec name="userWithEverythingRedirectToProduct">
    &sharedConfiguration;
    <steps>
      <invoke stepid="main page"
              url="/r.q.r.e.2.a.e.e.2.a.c.e.2"
        save="userWithEverythingRedirectToProduct"/>
      <verifytext stepid="Make sure we are redirected to the Anti-Striatin page"
        text="Anti-Striatin"/>       
          
    </steps>
  </testSpec>                             
</target>

<target name="userWithEverythingRedirectToProductOldStyle">
  <dbunit 
      driver="${sql.jdbcdriver}"          
      url="${sql.url}"          
      userid="${sql.username}"          
      password="${sql.password}">    
          <operation type="MSSQL_REFRESH" src="data/userWithEverythingRedirectToProduct.xml" format="flat"/>
  </dbunit>
  <testSpec name="userWithEverythingRedirectToProductOldStyle">
    &sharedConfiguration;
    <steps>
      <invoke stepid="main page"
              url="${r.page}?r=2&amp;e=2&amp;c=2"
        save="userWithEverythingRedirectToProductOldStyle"/>
      <verifytext stepid="Make sure we are redirected to the Anti-Striatin page"
        text="Anti-Striatin"/>       
          
    </steps>
  </testSpec>                             
</target>


<target name="redirectToExternalWebsite">
  <dbunit 
      driver="${sql.jdbcdriver}"          
      url="${sql.url}"          
      userid="${sql.username}"          
      password="${sql.password}">    
          <operation type="MSSQL_REFRESH" src="data/redirectToExternalWebsite.xml" format="flat"/>
  </dbunit>
  <testSpec name="redirectToExternalWebsite">
    &sharedConfiguration;
    <steps>
      <invoke stepid="main page"
              url="${r.page}?r=3"
        save="redirectToExternalWebsite"/>
      <verifytext stepid="Make sure we are redirected to the Sun website"
        text="Sun"/>       
          
    </steps>
  </testSpec>                             
</target>

<target name="redirectToExternalWebsiteOldStyle">
  <dbunit 
      driver="${sql.jdbcdriver}"          
      url="${sql.url}"          
      userid="${sql.username}"          
      password="${sql.password}">    
          <operation type="MSSQL_REFRESH" src="data/redirectToExternalWebsite.xml" format="flat"/>
  </dbunit>
  <testSpec name="redirectToExternalWebsiteOldStyle">
    &sharedConfiguration;
    <steps>
      <invoke stepid="main page"
              url="${r.page}?r=3"
        save="redirectToExternalWebsite"/>
      <verifytext stepid="Make sure we are redirected to the Sun website"
        text="Sun"/>       
          
    </steps>
  </testSpec>                             
</target>

<target name="unsubscribeWithBadEmailId">
  <testSpec name="unsubscribeWithBadEmailId">
    &sharedConfiguration;
    <steps>
      <invoke stepid="main page"
              url="/edm/unsubscribe.asp?e=9999999"
        save="unsubscribeWithBadEmailId"/>
      <verifytext stepid="Make sure we recieved the error message"
        text="We're sorry, but your email address could not be located."/>       
          
    </steps>
  </testSpec>                             
</target>

<target name="unsubscribeWithNoParameters">
  <testSpec name="unsubscribeWithNoParameters">
    &sharedConfiguration;
    <steps>
      <invoke stepid="main page"
              url="/edm/unsubscribe.asp"
        save="unsubscribeWithNoParameters"/>
      <verifytext stepid="Make sure we recieved the error message"
        text="We're sorry, but your email address could not be located."/>       
          
    </steps>
  </testSpec>                             
</target>

<target name="unsubscribeWithInvalidEmail">
  <testSpec name="unsubscribeWithInvalidEmail">
    &sharedConfiguration;
    <steps>
      <invoke stepid="main page"
              url="/edm/unsubscribe.asp?e=unsubscribeWithInvalidEmail"
        save="unsubscribeWithInvalidEmail"/>
      <verifytext stepid="Make sure we recieved the error message"
        text="We're sorry, but your email address could not be located."/>       
          
    </steps>
  </testSpec>                             
</target>
         
<target name="unsubscribeEmailAddressWithEmail">
  <dbunit 
      driver="${sql.jdbcdriver}"          
      url="${sql.url}"          
      userid="${sql.username}"          
      password="${sql.password}">    
          <operation type="MSSQL_REFRESH" src="data/unsubscribeEmailAddressWithEmail.xml" format="flat"/>
  </dbunit>
  <testSpec name="unsubscribeEmailAddress">
    &sharedConfiguration;
    <steps>
      <invoke stepid="main page"
              url="/edm/unsubscribe.asp?e=u...@te..."
        save="unsubscribeEmailAddress"/>
      <verifytext stepid="Make sure we recieved the success message"
        text="You have been removed from the Upstate mailing list."/>       
          
    </steps>
  </testSpec>                             
</target>         

<target name="unsubscribeEmailAddressWithEmailID">
  <dbunit 
      driver="${sql.jdbcdriver}"          
      url="${sql.url}"          
      userid="${sql.username}"          
      password="${sql.password}">    
          <operation type="MSSQL_REFRESH" src="data/unsubscribeEmailAddressWithEmailID.xml" format="flat"/>
  </dbunit>
  <testSpec name="unsubscribeEmailAddressWithEmailID">
    &sharedConfiguration;
    <steps>
      <invoke stepid="main page"
              url="/edm/unsubscribe.asp?e=1"
        save="unsubscribeEmailAddressWithEmailID"/>
      <verifytext stepid="Make sure we recieved the success message"
        text="You have been removed from the Upstate mailing list."/>       
          
    </steps>
  </testSpec>                             
</target> 

<target name="unsubscribeEmailAddressWithNewEmailAddress">
  <sql
        driver="${sql.jdbcdriver}"
        url="${sql.url}"
        userid="${sql.username}"
        password="${sql.password}">
      UPDATE email set email='uns...@te...' + convert(varchar(10),email_id)
      WHERE email='te...@te...'

  </sql>
  <testSpec name="unsubscribeEmailAddressWithNewEmailAddress">
    &sharedConfiguration;
    <steps>
      <invoke stepid="main page"
              url="/edm/unsubscribe.asp?e=...@te..."
        save="unsubscribeEmailAddressWithNewEmailAddress"/>
      <verifytext stepid="Make sure we recieved the success message"
        text="You have been removed from the Upstate mailing list."/>       
          
    </steps>
  </testSpec>                             
</target> 


<target name="subscribeEmailAddressWithNewEmailAddress">
  <sql
        driver="${sql.jdbcdriver}"
        url="${sql.url}"
        userid="${sql.username}"
        password="${sql.password}">
      UPDATE email set email='sub...@te...' + convert(varchar(10),email_id)
      WHERE email='te...@te...'

  </sql>
  <testSpec name="subscribeEmailAddressWithNewEmailAddress">
    &sharedConfiguration;
    <steps>
      <invoke stepid="main page"
              url="/edm/subscribe.asp?e=...@te..."
        save="subscribeEmailAddressWithNewEmailAddress"/>
      <verifytext stepid="Make sure we recieved the success message"
        text="You have been subscribed to the Upstate mailing list"/>       
          
    </steps>
  </testSpec>                             
</target> 

<target name="subscribeEmailAddressWithOptedOutEmail">
  <dbunit 
      driver="${sql.jdbcdriver}"          
      url="${sql.url}"          
      userid="${sql.username}"          
      password="${sql.password}">    
          <operation type="MSSQL_REFRESH" src="data/subscribeEmailAddressWithOptedOutEmail.xml" format="flat"/>
  </dbunit>
  <testSpec name="subscribeEmailAddressWithOptedOutEmail">
    &sharedConfiguration;
    <steps>
      <invoke stepid="main page"
              url="/edm/subscribe.asp?e=s...@te..."
        save="subscribeEmailAddressWithNewEmailAddress"/>
      <verifytext stepid="Make sure we recieved the success message"
        text="You have been subscribed to the Upstate mailing list"/>       
          
    </steps>
  </testSpec>                             
</target> 

<target name="subscribeEmailAddressWithInvalidEmailAddress">
  <testSpec name="subscribeEmailAddressWithInvalidEmailAddress">
    &sharedConfiguration;
    <steps>
      <invoke stepid="main page"
              url="/edm/subscribe.asp?e=subscribeEmailAddressWithInvalidEmailAddress"
        save="subscribeEmailAddressWithInvalidEmailAddress"/>
      <verifytext stepid="Make sure we recieved the failure message"
        text="We're sorry, but your email address appears to not be a valid email address."/>       
      <invoke stepid="main page"
              url="/edm/subscribe.asp?e=44"
        save="subscribeEmailAddressWithInvalidEmailAddress2"/>
      <verifytext stepid="Make sure we recieved the failure message"
        text="We're sorry, but your email address appears invalid."/>            
    </steps>
  </testSpec>                             
</target> 

<target name="productWithCustomCOAHeader">
  <testSpec name="productWithCustomCOAHeader">
    &sharedConfiguration;
    <steps>
      <invoke stepid="main page"
              url="${start.page}"
        save="productWithCustomCOAHeader"/>
      <setinputfield stepid="search for test product 14-000"
        name="query"
        value="14-000"/>
      <clickbutton stepid="Click link to Execute QuickSearch"
        name="imageField"/>
      <verifytitle stepid="Make sure we are on product 14-000"
        text="Upstate - Product #14-000 - TEST ( 14000 )"/>  
      <not>
        <verifytext stepid="Make sure there is no COA message."
          text="Certificate of Analysis:"/>       
      </not>
      <verifytext stepid="Make sure there is a Product Description message."
        text="PRODUCT DESCRIPTION:"/>             
    </steps>
  </testSpec>                             
</target> 

<target name="productWithPartnerLink">
  <testSpec name="productWithPartnerLink">
    &sharedConfiguration;
    <steps>
      <invoke stepid="main page"
              url="${start.page}"
        save="productWithPartnerLink"/>
      <setinputfield stepid="search for test product 14-000"
        name="query"
        value="14-000"/>
      <clickbutton stepid="Click link to Execute QuickSearch"
        name="imageField"/>
      <verifytitle stepid="Make sure we are on product 14-000"
        text="Upstate - Product #14-000 - TEST ( 14000 )"/>  
     
      <verifytext stepid="Make sure there is a link to Molecular Devices."
        text="Also available from Molecular Devices Corp."/>             
    </steps>
  </testSpec>                             
</target> 

<target name="sniffTest">                                 
  <testSpec name="Sniff">
    &sharedConfiguration;
    <steps>
      &invokeHome;
    </steps>
  </testSpec>                             
</target>

</project>