perfsonar development work

Author: sasa.cavara
Date: 2008-02-08 06:06:23 -0500 (Fri, 08 Feb 2008)
New Revision: 3334

Modified:
   
trunk/functional-testing/JavaSQLMAsoapUI/InterfaceBased/SQL_MA_soapui-project.xml
Log:


Modified: 
trunk/functional-testing/JavaSQLMAsoapUI/InterfaceBased/SQL_MA_soapui-project.xml
===================================================================
--- 
trunk/functional-testing/JavaSQLMAsoapUI/InterfaceBased/SQL_MA_soapui-project.xml
   2008-02-07 20:43:24 UTC (rev 3333)
+++ 
trunk/functional-testing/JavaSQLMAsoapUI/InterfaceBased/SQL_MA_soapui-project.xml
   2008-02-08 11:06:23 UTC (rev 3334)
@@ -855,10 +855,236 @@
 def validator = schema.newValidator();
 def node = holder.getDomNode("//nmwg:message")
 validator.validate(new DOMSource(node));
-</scriptText></con:configuration></con:assertion></con:request></con:config></con:testStep><con:testStep
 type="request" name="Metadata with Key-Errors"><con:settings/><con:config 
xsi:type="con:RequestStep" 
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";><con:interface>MetadataRequest</con:interface><con:operation>Metadata</con:operation><con:request
 name="Metadata with Key-Errors" 
wssPasswordType=""><con:settings><con:setting 
id="com.eviware.soapui.impl.wsdl.WsdlRequest@request-headers">&lt;xml-fragment/></con:setting></con:settings><con:encoding>UTF-8</con:encoding><con:endpoint>http://perfsonar.carnet.hr:8080/perfSONAR-SQL-MA/services/MeasurementArchiveService</con:endpoint><con:request><![CDATA[<soapenv:Envelope
 xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"; 
xmlns:ns="http://ggf.org/ns/nmwg/base/2.0/"; 
xmlns:ns1="http://ggf.org/ns/nmwg/topology/2.0/"; 
xmlns:ns2="http://ggf.org/ns/nmwg/ops/select/2.0/";>
+</scriptText></con:configuration></con:assertion><con:assertion 
type="GroovyScriptAssertion" 
name="SQL-groovy"><con:configuration><scriptText>import java.io.File;
+import java.io.OutputStream;
+import java.io.StringWriter;
+import javax.xml.transform.*;
+import javax.xml.transform.stream.StreamResult;
+import javax.xml.transform.stream.StreamSource;
+import javax.xml.transform.TransformerFactory;
+import javax.xml.transform.dom.DOMSource;
+import javax.xml.XMLConstants
+import javax.xml.validation.SchemaFactory
+import java.io.StringWriter
+import groovy.sql.Sql
+
+def sql = 
Sql.newInstance("jdbc:mysql://perfsonar.CARNet.hr:3306/perfsonar_ma", 
"perfsonar_ma", "l0291nk1", "com.mysql.jdbc.Driver")
+def resultList=[]   
+sql.eachRow("select metadataId,value,valueUnits,timeValue from 
perfsonar_errors"){
+def result=[:] 
+result=[metadataId:it.metadataId,value:it.value,valueUnits:it.valueUnits]  
+resultList.add(result)
+}
+resultList.each{
+ println "\n We have a match" + "\n"+ it.metadataId +"  "+it.value+"  
"+it.valueUnits
+ 
}</scriptText></con:configuration></con:assertion></con:request></con:config></con:testStep><con:testStep
 type="request" name="Metadata-Discards - No consolidation 
function"><con:settings/><con:config xsi:type="con:RequestStep" 
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";><con:interface>MetadataRequest</con:interface><con:operation>Metadata</con:operation><con:request
 name="Metadata-Discards - No consolidation 
function"><con:settings/><con:encoding>UTF-8</con:encoding><con:endpoint>http://perfsonar.carnet.hr:8080/perfSONAR-SQL-MA/services/MeasurementArchiveService</con:endpoint><con:request><![CDATA[<soapenv:Envelope
 xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"; >
    <soapenv:Header/>
    <soapenv:Body>
 <nmwg:message type="MetadataKeyRequest" 
+            xmlns:nmwg="http://ggf.org/ns/nmwg/base/2.0/"; 
+           
xmlns:discards="http://ggf.org/ns/nmwg/characteristic/discards/2.0/";
+           xmlns:nmwgt="http://ggf.org/ns/nmwg/topology/2.0/";
+           xmlns:select="http://ggf.org/ns/nmwg/ops/select/2.0/";> 
+
+  <nmwg:metadata id="m1">
+    <discards:subject id="s1">
+      <nmwgt:interface>
+        <nmwgt:ifAddress type="ipv4">10.1.2.3</nmwgt:ifAddress>
+        <nmwgt:ifName>test-0</nmwgt:ifName>
+        <nmwgt:direction>in</nmwgt:direction>
+      </nmwgt:interface>
+    </discards:subject>
+    <nmwg:eventType>
+      http://ggf.org/ns/nmwg/characteristic/discards/2.0
+    </nmwg:eventType>
+  </nmwg:metadata>
+
+
+  <nmwg:metadata id="m2">
+    <select:subject id="s2" metadataIdRef="m1"/>
+    <nmwg:eventType>http://ggf.org/ns/nmwg/ops/select/2.0</nmwg:eventType>
+    <select:parameters id="sp1">
+      <nmwg:parameter name="startTime">1186735200</nmwg:parameter>
+      <nmwg:parameter name="endTime">1186739100</nmwg:parameter>
+      <nmwg:parameter name="resolution">60</nmwg:parameter>
+    </select:parameters>
+  </nmwg:metadata>  
+  
+  <nmwg:data id="d2" metadataIdRef="m2"/>
+
+</nmwg:message>
+
+   </soapenv:Body>
+</soapenv:Envelope>]]></con:request><con:assertion type="SOAP 
Response"/><con:assertion type="SOAP Fault Assertion"/><con:assertion 
type="XPath Match"><con:configuration><path>declare namespace 
nmwgt='http://ggf.org/ns/nmwg/topology/2.0/';
+declare namespace select='http://ggf.org/ns/nmwg/ops/select/2.0/';
+declare namespace errors='http://ggf.org/ns/nmwg/characteristic/errors/2.0/';
+declare namespace nmwg='http://ggf.org/ns/nmwg/base/2.0/';
+declare namespace soapenv='http://schemas.xmlsoap.org/soap/envelope/';
+
+//nmwg:message/@type</path><content>MetadataKeyResponse</content><allowWildcards>false</allowWildcards></con:configuration></con:assertion><con:assertion
 type="XPath Match"><con:configuration><path>declare namespace 
nmwgt='http://ggf.org/ns/nmwg/topology/2.0/';
+declare namespace select='http://ggf.org/ns/nmwg/ops/select/2.0/';
+declare namespace 
discards='http://ggf.org/ns/nmwg/characteristic/discards/2.0/';
+declare namespace nmwg='http://ggf.org/ns/nmwg/base/2.0/';
+declare namespace soapenv='http://schemas.xmlsoap.org/soap/envelope/';
+declare namespace fn="http://www.w3.org/2005/xpath-functions";;
+
+(fn:string(//nmwg:message/nmwg:metadata/discards:subject/nmwgt:interface/nmwgt:hostName)="test-hostName")
+and
+(fn:string(//nmwg:message/nmwg:metadata/discards:subject/nmwgt:interface/nmwgt:ifName)="test-0")
+and
+(fn:string(//nmwg:message/nmwg:metadata/discards:subject/nmwgt:interface/nmwgt:ifAddress)="10.1.2.3")
+and
+(fn:string(//nmwg:message/nmwg:metadata/discards:subject/nmwgt:interface/nmwgt:direction)="in")
+and
+(fn:string(//nmwg:message/nmwg:metadata/nmwg:eventType)="http://ggf.org/ns/nmwg/characteristic/discards/2.0";)
+and
+(count(//nmwg:message/nmwg:metadata) = count(//nmwg:message/nmwg:data))
+and
+(every $startTime in 
//nmwg:message/nmwg:data/nmwg:key/select:parameters/nmwg:parameter[@name="startTime"]
 satisfies $startTime="1186735200")
+and
+(every $endTime 
in//nmwg:message/nmwg:data/nmwg:key/select:parameters/nmwg:parameter[@name="endTime"]
 satisfies $endTime= "1186739100")
+and
+(every $resolution 
in//nmwg:message/nmwg:data/nmwg:key/select:parameters/nmwg:parameter[@name="resolution"]
 satisfies $resolution= "60")
+and
+(every $consolidation 
in//nmwg:message/nmwg:data/nmwg:key/select:parameters/nmwg:parameter[@name="consolidationFunction"]
 satisfies $consolidation= "AVERAGE")
+and
+(every $file in 
//nmwg:message/nmwg:data/nmwg:key/nmwg:parameters/nmwg:parameter[@name="file"]
+satisfies 
(fn:string($file)="/home/mike/geant2_java-rrd-ma-2.3-RC5/samples/rrd/test.rrd"))
+and
+(fn:string(//nmwg:message/nmwg:data/nmwg:key/nmwg:parameters/nmwg:parameter[@name="eventType"])="http://ggf.org/ns/nmwg/characteristic/discards/2.0";)
+and
+(count(//nmwg:message/nmwg:data/nmwg:key/nmwg:parameters/nmwg:parameter[@name="consolidationFunction"])=0)</path><content>true</content><allowWildcards>false</allowWildcards></con:configuration></con:assertion><con:assertion
 type="GroovyScriptAssertion"><con:configuration><scriptText>import 
java.io.File;
+import java.io.OutputStream;
+import java.io.StringWriter;
+import javax.xml.transform.*;
+import javax.xml.transform.stream.StreamResult;
+import javax.xml.transform.stream.StreamSource;
+import javax.xml.transform.TransformerFactory;
+import javax.xml.transform.dom.DOMSource;
+import javax.xml.XMLConstants
+import javax.xml.validation.SchemaFactory
+import java.io.StringWriter
+
+
+def groovyUtils = new com.eviware.soapui.support.GroovyUtils( context )
+def holder = groovyUtils.getXmlHolder( messageExchange.getResponseContent());
+def factory = SchemaFactory.newInstance(XMLConstants.RELAXNG_NS_URI);
+def schema = factory.newSchema(new 
File("../JavaSQLMAsoapUI/InterfaceBased/MetadataKeyResponse.rng"));
+def validator = schema.newValidator();
+def node = holder.getDomNode("//nmwg:message")
+validator.validate(new DOMSource(node));
+</scriptText></con:configuration></con:assertion><con:assertion 
type="GroovyScriptAssertion" 
name="SQL-groovy"><con:configuration><scriptText>import java.io.File;
+import java.io.OutputStream;
+import java.io.StringWriter;
+import javax.xml.transform.*;
+import javax.xml.transform.stream.StreamResult;
+import javax.xml.transform.stream.StreamSource;
+import javax.xml.transform.TransformerFactory;
+import javax.xml.transform.dom.DOMSource;
+import javax.xml.XMLConstants
+import javax.xml.validation.SchemaFactory
+import java.io.StringWriter
+import groovy.sql.Sql
+
+def sql = 
Sql.newInstance("jdbc:mysql://perfsonar.CARNet.hr:3306/perfsonar_ma", 
"perfsonar_ma", "l0291nk1", "com.mysql.jdbc.Driver")
+def resultList=[]   
+sql.eachRow("select metadataId,value,valueUnits,timeValue from 
perfsonar_discards"){
+def result=[:] 
+result=[metadataId:it.metadataId,value:it.value,valueUnits:it.valueUnits]  
+resultList.add(result)
+}
+resultList.each{
+ println "\n We have a match" + "\n"+ it.metadataId +"  "+it.value+"  
"+it.valueUnits
+ }</scriptText></con:configuration></con:assertion><con:assertion 
type="Schema Compliance" 
disabled="true"><con:configuration/></con:assertion></con:request></con:config></con:testStep><con:testStep
 type="request" name="Metadata-Utilization-just capacity in 
description"><con:settings/><con:config xsi:type="con:RequestStep" 
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";><con:interface>MetadataRequest</con:interface><con:operation>Metadata</con:operation><con:request
 name="Metadata-Utilization-just capacity in 
description"><con:settings/><con:encoding>UTF-8</con:encoding><con:endpoint>http://perfsonar.carnet.hr:8080/perfSONAR-SQL-MA/services/MeasurementArchiveService</con:endpoint><con:request><![CDATA[<soapenv:Envelope
 xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"; >
+   <soapenv:Header/>
+   <soapenv:Body>
+<nmwg:message type="MetadataKeyRequest"
+         id="mdrq1"
+         
xmlns:netutil="http://ggf.org/ns/nmwg/characteristic/utilization/2.0/"; 
+         xmlns:nmwg="http://ggf.org/ns/nmwg/base/2.0/"; 
+         xmlns:nmwgt="http://ggf.org/ns/nmwg/topology/2.0/";>
+
+  <nmwg:metadata id="meta1">
+    <netutil:subject id="subj1">
+      <nmwgt:interface>
+        <nmwgt:capacity>1000BaseT</nmwgt:capacity>
+      </nmwgt:interface>
+    </netutil:subject>
+    <nmwg:eventType>
+      http://ggf.org/ns/nmwg/characteristic/utilization/2.0
+    </nmwg:eventType>
+  </nmwg:metadata>
+  
+  <nmwg:data id="1" metadataIdRef="meta1"/>
+
+</nmwg:message>
+
+   </soapenv:Body>
+</soapenv:Envelope>]]></con:request><con:assertion type="SOAP 
Response"/><con:assertion type="SOAP Fault Assertion"/><con:assertion 
type="Schema Compliance" 
disabled="true"><con:configuration><definition>file:C:\Documents and 
Settings\IBM\My 
Documents\JavaRRDMAsoapUI\rrd-ma-metadata-res.wsdl</definition></con:configuration></con:assertion><con:assertion
 type="XPath Match"><con:configuration><path>declare namespace 
nmwgt='http://ggf.org/ns/nmwg/topology/2.0/';
+declare namespace select='http://ggf.org/ns/nmwg/ops/select/2.0/';
+declare namespace errors='http://ggf.org/ns/nmwg/characteristic/errors/2.0/';
+declare namespace nmwg='http://ggf.org/ns/nmwg/base/2.0/';
+declare namespace soapenv='http://schemas.xmlsoap.org/soap/envelope/';
+
+//nmwg:message/@type</path><content>MetadataKeyResponse</content><allowWildcards>false</allowWildcards></con:configuration></con:assertion><con:assertion
 type="XPath Match"><con:configuration><path>declare namespace 
nmwgt='http://ggf.org/ns/nmwg/topology/2.0/';
+declare namespace 
netutil='http://ggf.org/ns/nmwg/characteristic/utilization/2.0/';
+declare namespace select='http://ggf.org/ns/nmwg/ops/select/2.0/';
+declare namespace nmwg='http://ggf.org/ns/nmwg/base/2.0/';
+declare namespace soapenv='http://schemas.xmlsoap.org/soap/envelope/';
+declare namespace fn="http://www.w3.org/2005/xpath-functions";;
+
+(every $hostname in 
//nmwg:message/nmwg:metadata/netutil:subject/nmwgt:interface/nmwgt:hostName 
satisfies $hostname="test-hostName")
+and
+(count(//nmwg:message/nmwg:metadata/netutil:subject/nmwgt:interface[nmwgt:direction="in"])=1)
+and
+(every $eventType in //nmwg:message/nmwg:metadata/nmwg:eventType satisfies 
$eventType="http://ggf.org/ns/nmwg/characteristic/utilization/2.0";)
+and
+(count(//nmwg:message/nmwg:data) = 
count(//nmwg:message/nmwg:metadata))</path><content>true</content><allowWildcards>false</allowWildcards></con:configuration></con:assertion><con:assertion
 type="GroovyScriptAssertion"><con:configuration><scriptText>import 
java.io.File;
+import java.io.OutputStream;
+import java.io.StringWriter;
+import javax.xml.transform.*;
+import javax.xml.transform.stream.StreamResult;
+import javax.xml.transform.stream.StreamSource;
+import javax.xml.transform.TransformerFactory;
+import javax.xml.transform.dom.DOMSource;
+import javax.xml.XMLConstants
+import javax.xml.validation.SchemaFactory
+import java.io.StringWriter
+
+
+def groovyUtils = new com.eviware.soapui.support.GroovyUtils( context )
+def holder = groovyUtils.getXmlHolder( messageExchange.getResponseContent());
+def factory = SchemaFactory.newInstance(XMLConstants.RELAXNG_NS_URI);
+def schema = factory.newSchema(new 
File("../JavaSQLMAsoapUI/InterfaceBased/MetadataKeyResponse.rng"));
+def validator = schema.newValidator();
+def node = holder.getDomNode("//nmwg:message")
+validator.validate(new DOMSource(node));
+</scriptText></con:configuration></con:assertion><con:assertion 
type="GroovyScriptAssertion" 
name="SQL-groovy"><con:configuration><scriptText>import java.io.File;
+import java.io.OutputStream;
+import java.io.StringWriter;
+import javax.xml.transform.*;
+import javax.xml.transform.stream.StreamResult;
+import javax.xml.transform.stream.StreamSource;
+import javax.xml.transform.TransformerFactory;
+import javax.xml.transform.dom.DOMSource;
+import javax.xml.XMLConstants
+import javax.xml.validation.SchemaFactory
+import java.io.StringWriter
+import groovy.sql.Sql
+
+def sql = 
Sql.newInstance("jdbc:mysql://perfsonar.CARNet.hr:3306/perfsonar_ma", 
"perfsonar_ma", "l0291nk1", "com.mysql.jdbc.Driver")
+def resultList=[]   
+sql.eachRow("select metadataId,value,valueUnits,timeValue from 
perfsonar_utilization"){
+def result=[:] 
+result=[metadataId:it.metadataId,value:it.value,valueUnits:it.valueUnits]  
+resultList.add(result)
+}
+resultList.each{
+ println "\n We have a match" + "\n"+ it.metadataId +"  "+it.value+"  
"+it.valueUnits
+ 
}</scriptText></con:configuration></con:assertion></con:request></con:config></con:testStep><con:testStep
 type="request" name="Metadata with Key-Errors"><con:settings/><con:config 
xsi:type="con:RequestStep" 
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";><con:interface>MetadataRequest</con:interface><con:operation>Metadata</con:operation><con:request
 name="Metadata with Key-Errors" 
wssPasswordType=""><con:settings><con:setting 
id="com.eviware.soapui.impl.wsdl.WsdlRequest@request-headers">&lt;xml-fragment/></con:setting></con:settings><con:encoding>UTF-8</con:encoding><con:endpoint>http://perfsonar.carnet.hr:8080/perfSONAR-SQL-MA/services/MeasurementArchiveService</con:endpoint><con:request><![CDATA[<soapenv:Envelope
 xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"; 
xmlns:ns="http://ggf.org/ns/nmwg/base/2.0/"; 
xmlns:ns1="http://ggf.org/ns/nmwg/topology/2.0/"; 
xmlns:ns2="http://ggf.org/ns/nmwg/ops/select/2.0/";>
+   <soapenv:Header/>
+   <soapenv:Body>
+<nmwg:message type="MetadataKeyRequest" 
               xmlns:nmwg="http://ggf.org/ns/nmwg/base/2.0/"; 
               xmlns:select="http://ggf.org/ns/nmwg/ops/select/2.0/";> 
 
@@ -1172,102 +1398,6 @@
 def validator = schema.newValidator();
 def node = holder.getDomNode("//nmwg:message")
 validator.validate(new DOMSource(node));
-</scriptText></con:configuration></con:assertion></con:request></con:config></con:testStep><con:testStep
 type="request" name="Metadata-Discards - No consolidation 
function"><con:settings/><con:config xsi:type="con:RequestStep" 
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";><con:interface>MetadataRequest</con:interface><con:operation>Metadata</con:operation><con:request
 name="Metadata-Discards - No consolidation 
function"><con:settings/><con:encoding>UTF-8</con:encoding><con:endpoint>http://perfsonar.carnet.hr:8080/perfSONAR-SQL-MA/services/MeasurementArchiveService</con:endpoint><con:request><![CDATA[<soapenv:Envelope
 xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"; >
-   <soapenv:Header/>
-   <soapenv:Body>
-<nmwg:message type="MetadataKeyRequest" 
-            xmlns:nmwg="http://ggf.org/ns/nmwg/base/2.0/"; 
-           
xmlns:discards="http://ggf.org/ns/nmwg/characteristic/discards/2.0/";
-           xmlns:nmwgt="http://ggf.org/ns/nmwg/topology/2.0/";
-           xmlns:select="http://ggf.org/ns/nmwg/ops/select/2.0/";> 
-
-  <nmwg:metadata id="m1">
-    <discards:subject id="s1">
-      <nmwgt:interface>
-        <nmwgt:ifAddress type="ipv4">10.1.2.3</nmwgt:ifAddress>
-        <nmwgt:ifName>test-0</nmwgt:ifName>
-        <nmwgt:direction>in</nmwgt:direction>
-      </nmwgt:interface>
-    </discards:subject>
-    <nmwg:eventType>
-      http://ggf.org/ns/nmwg/characteristic/discards/2.0
-    </nmwg:eventType>
-  </nmwg:metadata>
-
-
-  <nmwg:metadata id="m2">
-    <select:subject id="s2" metadataIdRef="m1"/>
-    <nmwg:eventType>http://ggf.org/ns/nmwg/ops/select/2.0</nmwg:eventType>
-    <select:parameters id="sp1">
-      <nmwg:parameter name="startTime">1186735200</nmwg:parameter>
-      <nmwg:parameter name="endTime">1186739100</nmwg:parameter>
-      <nmwg:parameter name="resolution">60</nmwg:parameter>
-    </select:parameters>
-  </nmwg:metadata>  
-  
-  <nmwg:data id="d2" metadataIdRef="m2"/>
-
-</nmwg:message>
-
-   </soapenv:Body>
-</soapenv:Envelope>]]></con:request><con:assertion type="SOAP 
Response"/><con:assertion type="SOAP Fault Assertion"/><con:assertion 
type="Schema Compliance" 
disabled="true"><con:configuration><definition>file:C:\Documents and 
Settings\IBM\My 
Documents\JavaRRDMAsoapUI\rrd-ma-metadata-res.wsdl</definition></con:configuration></con:assertion><con:assertion
 type="XPath Match"><con:configuration><path>declare namespace 
nmwgt='http://ggf.org/ns/nmwg/topology/2.0/';
-declare namespace select='http://ggf.org/ns/nmwg/ops/select/2.0/';
-declare namespace errors='http://ggf.org/ns/nmwg/characteristic/errors/2.0/';
-declare namespace nmwg='http://ggf.org/ns/nmwg/base/2.0/';
-declare namespace soapenv='http://schemas.xmlsoap.org/soap/envelope/';
-
-//nmwg:message/@type</path><content>MetadataKeyResponse</content><allowWildcards>false</allowWildcards></con:configuration></con:assertion><con:assertion
 type="XPath Match"><con:configuration><path>declare namespace 
nmwgt='http://ggf.org/ns/nmwg/topology/2.0/';
-declare namespace select='http://ggf.org/ns/nmwg/ops/select/2.0/';
-declare namespace 
discards='http://ggf.org/ns/nmwg/characteristic/discards/2.0/';
-declare namespace nmwg='http://ggf.org/ns/nmwg/base/2.0/';
-declare namespace soapenv='http://schemas.xmlsoap.org/soap/envelope/';
-declare namespace fn="http://www.w3.org/2005/xpath-functions";;
-
-(fn:string(//nmwg:message/nmwg:metadata/discards:subject/nmwgt:interface/nmwgt:hostName)="test-hostName")
-and
-(fn:string(//nmwg:message/nmwg:metadata/discards:subject/nmwgt:interface/nmwgt:ifName)="test-0")
-and
-(fn:string(//nmwg:message/nmwg:metadata/discards:subject/nmwgt:interface/nmwgt:ifAddress)="10.1.2.3")
-and
-(fn:string(//nmwg:message/nmwg:metadata/discards:subject/nmwgt:interface/nmwgt:direction)="in")
-and
-(fn:string(//nmwg:message/nmwg:metadata/nmwg:eventType)="http://ggf.org/ns/nmwg/characteristic/discards/2.0";)
-and
-(count(//nmwg:message/nmwg:metadata) = count(//nmwg:message/nmwg:data))
-and
-(every $startTime in 
//nmwg:message/nmwg:data/nmwg:key/select:parameters/nmwg:parameter[@name="startTime"]
 satisfies $startTime="1186735200")
-and
-(every $endTime 
in//nmwg:message/nmwg:data/nmwg:key/select:parameters/nmwg:parameter[@name="endTime"]
 satisfies $endTime= "1186739100")
-and
-(every $resolution 
in//nmwg:message/nmwg:data/nmwg:key/select:parameters/nmwg:parameter[@name="resolution"]
 satisfies $resolution= "60")
-and
-(every $consolidation 
in//nmwg:message/nmwg:data/nmwg:key/select:parameters/nmwg:parameter[@name="consolidationFunction"]
 satisfies $consolidation= "AVERAGE")
-and
-(every $file in 
//nmwg:message/nmwg:data/nmwg:key/nmwg:parameters/nmwg:parameter[@name="file"]
-satisfies 
(fn:string($file)="/home/mike/geant2_java-rrd-ma-2.3-RC5/samples/rrd/test.rrd"))
-and
-(fn:string(//nmwg:message/nmwg:data/nmwg:key/nmwg:parameters/nmwg:parameter[@name="eventType"])="http://ggf.org/ns/nmwg/characteristic/discards/2.0";)
-and
-(count(//nmwg:message/nmwg:data/nmwg:key/nmwg:parameters/nmwg:parameter[@name="consolidationFunction"])=0)</path><content>true</content><allowWildcards>false</allowWildcards></con:configuration></con:assertion><con:assertion
 type="GroovyScriptAssertion"><con:configuration><scriptText>import 
java.io.File;
-import java.io.OutputStream;
-import java.io.StringWriter;
-import javax.xml.transform.*;
-import javax.xml.transform.stream.StreamResult;
-import javax.xml.transform.stream.StreamSource;
-import javax.xml.transform.TransformerFactory;
-import javax.xml.transform.dom.DOMSource;
-import javax.xml.XMLConstants
-import javax.xml.validation.SchemaFactory
-import java.io.StringWriter
-
-
-def groovyUtils = new com.eviware.soapui.support.GroovyUtils( context )
-def holder = groovyUtils.getXmlHolder( messageExchange.getResponseContent());
-def factory = SchemaFactory.newInstance(XMLConstants.RELAXNG_NS_URI);
-def schema = factory.newSchema(new 
File("../JavaSQLMAsoapUI/InterfaceBased/MetadataKeyResponse.rng"));
-def validator = schema.newValidator();
-def node = holder.getDomNode("//nmwg:message")
-validator.validate(new DOMSource(node));
 
</scriptText></con:configuration></con:assertion></con:request></con:config></con:testStep><con:testStep
 type="request" name="Metadata-Errors - No 
resolution"><con:settings/><con:config xsi:type="con:RequestStep" 
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";><con:interface>MetadataRequest</con:interface><con:operation>Metadata</con:operation><con:request
 name="Metadata-Errors - No 
resolution"><con:settings/><con:encoding>UTF-8</con:encoding><con:endpoint>http://perfsonar.carnet.hr:8080/perfSONAR-SQL-MA/services/MeasurementArchiveService</con:endpoint><con:request><![CDATA[<soapenv:Envelope
 xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"; >
    <soapenv:Header/>
    <soapenv:Body>
@@ -1748,70 +1878,6 @@
 def validator = schema.newValidator();
 def node = holder.getDomNode("//nmwg:message")
 validator.validate(new DOMSource(node));
-</scriptText></con:configuration></con:assertion></con:request></con:config></con:testStep><con:testStep
 type="request" name="Metadata-Utilization-just capacity in 
description"><con:settings/><con:config xsi:type="con:RequestStep" 
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";><con:interface>MetadataRequest</con:interface><con:operation>Metadata</con:operation><con:request
 name="Metadata-Utilization-just capacity in 
description"><con:settings/><con:encoding>UTF-8</con:encoding><con:endpoint>http://perfsonar.carnet.hr:8080/perfSONAR-SQL-MA/services/MeasurementArchiveService</con:endpoint><con:request><![CDATA[<soapenv:Envelope
 xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"; >
-   <soapenv:Header/>
-   <soapenv:Body>
-<nmwg:message type="MetadataKeyRequest"
-         id="mdrq1"
-         
xmlns:netutil="http://ggf.org/ns/nmwg/characteristic/utilization/2.0/"; 
-         xmlns:nmwg="http://ggf.org/ns/nmwg/base/2.0/"; 
-         xmlns:nmwgt="http://ggf.org/ns/nmwg/topology/2.0/";>
-
-  <nmwg:metadata id="meta1">
-    <netutil:subject id="subj1">
-      <nmwgt:interface>
-        <nmwgt:capacity>1000BaseT</nmwgt:capacity>
-      </nmwgt:interface>
-    </netutil:subject>
-    <nmwg:eventType>
-      http://ggf.org/ns/nmwg/characteristic/utilization/2.0
-    </nmwg:eventType>
-  </nmwg:metadata>
-  
-  <nmwg:data id="1" metadataIdRef="meta1"/>
-
-</nmwg:message>
-
-   </soapenv:Body>
-</soapenv:Envelope>]]></con:request><con:assertion type="SOAP 
Response"/><con:assertion type="SOAP Fault Assertion"/><con:assertion 
type="Schema Compliance" 
disabled="true"><con:configuration><definition>file:C:\Documents and 
Settings\IBM\My 
Documents\JavaRRDMAsoapUI\rrd-ma-metadata-res.wsdl</definition></con:configuration></con:assertion><con:assertion
 type="XPath Match"><con:configuration><path>declare namespace 
nmwgt='http://ggf.org/ns/nmwg/topology/2.0/';
-declare namespace select='http://ggf.org/ns/nmwg/ops/select/2.0/';
-declare namespace errors='http://ggf.org/ns/nmwg/characteristic/errors/2.0/';
-declare namespace nmwg='http://ggf.org/ns/nmwg/base/2.0/';
-declare namespace soapenv='http://schemas.xmlsoap.org/soap/envelope/';
-
-//nmwg:message/@type</path><content>MetadataKeyResponse</content><allowWildcards>false</allowWildcards></con:configuration></con:assertion><con:assertion
 type="XPath Match"><con:configuration><path>declare namespace 
nmwgt='http://ggf.org/ns/nmwg/topology/2.0/';
-declare namespace 
netutil='http://ggf.org/ns/nmwg/characteristic/utilization/2.0/';
-declare namespace select='http://ggf.org/ns/nmwg/ops/select/2.0/';
-declare namespace nmwg='http://ggf.org/ns/nmwg/base/2.0/';
-declare namespace soapenv='http://schemas.xmlsoap.org/soap/envelope/';
-declare namespace fn="http://www.w3.org/2005/xpath-functions";;
-
-(every $hostname in 
//nmwg:message/nmwg:metadata/netutil:subject/nmwgt:interface/nmwgt:hostName 
satisfies $hostname="test-hostName")
-and
-(count(//nmwg:message/nmwg:metadata/netutil:subject/nmwgt:interface[nmwgt:direction="in"])=1)
-and
-(every $eventType in //nmwg:message/nmwg:metadata/nmwg:eventType satisfies 
$eventType="http://ggf.org/ns/nmwg/characteristic/utilization/2.0";)
-and
-(count(//nmwg:message/nmwg:data) = 
count(//nmwg:message/nmwg:metadata))</path><content>true</content><allowWildcards>false</allowWildcards></con:configuration></con:assertion><con:assertion
 type="GroovyScriptAssertion"><con:configuration><scriptText>import 
java.io.File;
-import java.io.OutputStream;
-import java.io.StringWriter;
-import javax.xml.transform.*;
-import javax.xml.transform.stream.StreamResult;
-import javax.xml.transform.stream.StreamSource;
-import javax.xml.transform.TransformerFactory;
-import javax.xml.transform.dom.DOMSource;
-import javax.xml.XMLConstants
-import javax.xml.validation.SchemaFactory
-import java.io.StringWriter
-
-
-def groovyUtils = new com.eviware.soapui.support.GroovyUtils( context )
-def holder = groovyUtils.getXmlHolder( messageExchange.getResponseContent());
-def factory = SchemaFactory.newInstance(XMLConstants.RELAXNG_NS_URI);
-def schema = factory.newSchema(new 
File("../JavaSQLMAsoapUI/InterfaceBased/MetadataKeyResponse.rng"));
-def validator = schema.newValidator();
-def node = holder.getDomNode("//nmwg:message")
-validator.validate(new DOMSource(node));
 
</scriptText></con:configuration></con:assertion></con:request></con:config></con:testStep><con:testStep
 type="request" name="Metadata-Errors -Both key and 
select"><con:settings/><con:config xsi:type="con:RequestStep" 
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";><con:interface>MetadataRequest</con:interface><con:operation>Metadata</con:operation><con:request
 name="Metadata-Errors -Both key and 
select"><con:settings/><con:encoding>UTF-8</con:encoding><con:endpoint>http://perfsonar.carnet.hr:8080/perfSONAR-SQL-MA/services/MeasurementArchiveService</con:endpoint><con:request><![CDATA[<soapenv:Envelope
 xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"; >
    <soapenv:Header/>
    <soapenv:Body>
@@ -4493,7 +4559,7 @@
 and
 
(fn:string(//nmwg:message/nmwg:metadata/netutil:subject/nmwgt:interface/nmwgt:ifAddress)="10.1.2.3")
 and
-(fn:string(//nmwg:message/nmwg:metadata/nmwg:eventType)="http://ggf.org/ns/nmwg/characteristic/utilization/2.0";)</path><content>true</content><allowWildcards>true</allowWildcards></con:configuration></con:assertion></con:request></con:config></con:testStep><con:testStep
 type="request" name="SetupData-Errors with select 
parameters"><con:settings/><con:config xsi:type="con:RequestStep" 
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";><con:interface>SetupDataRequest</con:interface><con:operation>SetupData</con:operation><con:request
 name="SetupData-Errors with select 
parameters"><con:settings/><con:encoding>UTF-8</con:encoding><con:endpoint>http://perfsonar.carnet.hr:8080/perfSONAR-SQL-MA/services/MeasurementArchiveService</con:endpoint><con:request><![CDATA[<soapenv:Envelope
 xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"; 
xmlns:ns="http://ggf.org/ns/nmwg/base/2.0/";>
+(fn:string(//nmwg:message/nmwg:metadata/nmwg:eventType)="http://ggf.org/ns/nmwg/characteristic/utilization/2.0";)</path><content>true</content><allowWildcards>true</allowWildcards></con:configuration></con:assertion><con:assertion
 type="Schema Compliance" 
disabled="true"><con:configuration><definition/></con:configuration></con:assertion></con:request></con:config></con:testStep><con:testStep
 type="request" name="SetupData-Errors with select 
parameters"><con:settings/><con:config xsi:type="con:RequestStep" 
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";><con:interface>SetupDataRequest</con:interface><con:operation>SetupData</con:operation><con:request
 name="SetupData-Errors with select 
parameters"><con:settings/><con:encoding>UTF-8</con:encoding><con:endpoint>http://perfsonar.carnet.hr:8080/perfSONAR-SQL-MA/services/MeasurementArchiveService</con:endpoint><con:request><![CDATA[<soapenv:Envelope
 xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"; xmlns:ns="http://g
 gf.org/ns/nmwg/base/2.0/">
    <soapenv:Header/>
    <soapenv:Body>
 <nmwg:message type="SetupDataRequest"
@@ -7163,7 +7229,7 @@
          <nmwg:data id="data" metadataIdRef="meta"/>
       </nmwg:message>
    </soapenv:Body>
-</soapenv:Envelope>]]></con:request><con:assertion type="SOAP 
Response"/><con:assertion type="Schema Compliance" 
disabled="true"><con:configuration><definition>file:/home/sasa/Desktop/soapui-2.0-beta2/JavaSQLMAsoapUI/InterfaceBased/lookupinfo/LookupInfoResponse.wsdl</definition></con:configuration></con:assertion><con:assertion
 type="SOAP Fault Assertion"/><con:assertion type="XPath 
Match"><con:configuration><path>declare namespace 
nmwgt='http://ggf.org/ns/nmwg/topology/2.0/';
+</soapenv:Envelope>]]></con:request><con:assertion type="SOAP 
Response"/><con:assertion type="SOAP Fault Assertion"/><con:assertion 
type="XPath Match"><con:configuration><path>declare namespace 
nmwgt='http://ggf.org/ns/nmwg/topology/2.0/';
 declare namespace select='http://ggf.org/ns/nmwg/ops/select/2.0/';
 declare namespace errors='http://ggf.org/ns/nmwg/characteristic/errors/2.0/';
 declare namespace nmwg='http://ggf.org/ns/nmwg/base/2.0/';
@@ -7212,7 +7278,7 @@
 //t.transform(new DOMSource(node), new StreamResult(sw));
 //String yourAnswer = sw.toString();
 //validator.validate(new StreamSource(new StringReader(yourAnswer)));
-validator.validate(new 
DOMSource(node));</scriptText></con:configuration></con:assertion></con:request></con:config></con:testStep><con:testStep
 type="request" name="LookupInfo - Chained 
metadata"><con:settings/><con:config xsi:type="con:RequestStep" 
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";><con:interface>LookupInfoRequest</con:interface><con:operation>LookupInfo</con:operation><con:request
 name="LookupInfo - Chained metadata" 
wssPasswordType=""><con:settings><con:setting 
id="com.eviware.soapui.impl.wsdl.WsdlRequest@request-headers">&lt;xml-fragment/></con:setting></con:settings><con:encoding>UTF-8</con:encoding><con:endpoint>http://perfsonar.carnet.hr:8080/perfSONAR-SQL-MA/services/MeasurementArchiveService</con:endpoint><con:request><![CDATA[<soapenv:Envelope
 xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"; 
xmlns:ns="http://ggf.org/ns/nmwg/base/2.0/";>
+validator.validate(new 
DOMSource(node));</scriptText></con:configuration></con:assertion><con:assertion
 type="Schema Compliance" 
disabled="true"><con:configuration/></con:assertion></con:request></con:config></con:testStep><con:testStep
 type="request" name="LookupInfo - Chained 
metadata"><con:settings/><con:config xsi:type="con:RequestStep" 
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";><con:interface>LookupInfoRequest</con:interface><con:operation>LookupInfo</con:operation><con:request
 name="LookupInfo - Chained metadata" 
wssPasswordType=""><con:settings><con:setting 
id="com.eviware.soapui.impl.wsdl.WsdlRequest@request-headers">&lt;xml-fragment/></con:setting></con:settings><con:encoding>UTF-8</con:encoding><con:endpoint>http://perfsonar.carnet.hr:8080/perfSONAR-SQL-MA/services/MeasurementArchiveService</con:endpoint><con:request><![CDATA[<soapenv:Envelope
 xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"; 
xmlns:ns="http://ggf.org/ns/nmwg/base/2.0/";>
    <soapenv:Header/>
    <soapenv:Body>
       <nmwg:message type="LookupInfoRequest" id="id1" messageIdRef="msgid1" 
xmlns:nmwg="http://ggf.org/ns/nmwg/base/2.0/";>
@@ -7774,7 +7840,43 @@
 //t.transform(new DOMSource(node), new StreamResult(sw));
 //String yourAnswer = sw.toString();
 //validator.validate(new StreamSource(new StringReader(yourAnswer)));
-validator.validate(new 
DOMSource(node));</scriptText></con:configuration></con:assertion><con:assertion
 type="Schema Compliance" 
disabled="true"><con:configuration/></con:assertion></con:request></con:config></con:testStep><con:testStep
 type="request" name="Store - Utilization with 
key"><con:settings/><con:config xsi:type="con:RequestStep" 
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";><con:interface>MeasurementArchiveStoreRequest</con:interface><con:operation>Store</con:operation><con:request
 name="Store - Utilization with key" 
wssPasswordType=""><con:settings><con:setting 
id="com.eviware.soapui.impl.wsdl.WsdlRequest@request-headers">&lt;xml-fragment/></con:setting></con:settings><con:encoding>UTF-8</con:encoding><con:endpoint>http://perfsonar.carnet.hr:8080/perfSONAR-SQL-MA/services/MeasurementArchiveService</con:endpoint><con:request><![CDATA[<soapenv:Envelope
 xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"; 
xmlns:ns="http://ggf.org/ns/nmwg/base/2.0/"; xmln
 s:ns1="http://ggf.org/ns/nmwg/topology/2.0/";>
+validator.validate(new 
DOMSource(node));</scriptText></con:configuration></con:assertion><con:assertion
 type="Schema Compliance" 
disabled="true"><con:configuration/></con:assertion><con:assertion 
type="GroovyScriptAssertion" 
name="SQL-groovy"><con:configuration><scriptText>import java.io.File;
+import java.io.OutputStream;
+import java.io.StringWriter;
+import javax.xml.transform.*;
+import javax.xml.transform.stream.StreamResult;
+import javax.xml.transform.stream.StreamSource;
+import javax.xml.transform.TransformerFactory;
+import javax.xml.transform.dom.DOMSource;
+import javax.xml.XMLConstants
+import javax.xml.validation.SchemaFactory
+import java.io.StringWriter
+import groovy.sql.Sql
+
+def sql = 
Sql.newInstance("jdbc:mysql://perfsonar.CARNet.hr:3306/perfsonar_ma", 
"perfsonar_ma", "l0291nk1", "com.mysql.jdbc.Driver")
+
+ids='meta1'
+values='12345'
+valueUnitss='Bps'
+timeValues='1139270800'
+
+sql.execute("insert into perfsonar_utilization  (metadataId, value, 
valueUnits, timeValue) "+
+  " values (?,?,?,?)", [ids,values,valueUnitss,timeValues])
+
+def knownResultsMap=[metadataId:ids,value:values,valueUnits:valueUnitss]
+def resultList=[]   
+
+sql.eachRow("select metadataId,value,valueUnits from perfsonar_utilization 
where timeValue=FROM_UNIXTIME(1139270800) "){
+def result=[:] 
+result=[metadataId:it.id,value:it.value,valueUnits:it.valueUnits]  
+resultList.add(result)
+}
+
+resultList.each{
+if((it.id==knownResultsMap.metadataId)&amp;&amp;(it.value==knownResultsMap.value)&amp;&amp;(it.valueUnits==knownResultsMap.valueUnits))
+ println "\n We have a match" + "\n"+ it.id +"  "+it.value+"  "+it.valueUnits
+ }
+</scriptText></con:configuration></con:assertion></con:request></con:config></con:testStep><con:testStep
 type="request" name="Store - Utilization with 
key"><con:settings/><con:config xsi:type="con:RequestStep" 
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";><con:interface>MeasurementArchiveStoreRequest</con:interface><con:operation>Store</con:operation><con:request
 name="Store - Utilization with key" 
wssPasswordType=""><con:settings><con:setting 
id="com.eviware.soapui.impl.wsdl.WsdlRequest@request-headers">&lt;xml-fragment/></con:setting></con:settings><con:encoding>UTF-8</con:encoding><con:endpoint>http://perfsonar.carnet.hr:8080/perfSONAR-SQL-MA/services/MeasurementArchiveService</con:endpoint><con:request><![CDATA[<soapenv:Envelope
 xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"; 
xmlns:ns="http://ggf.org/ns/nmwg/base/2.0/"; 
xmlns:ns1="http://ggf.org/ns/nmwg/topology/2.0/";>
    <soapenv:Header/>
    <soapenv:Body>
      <nmwg:message id="msg"
@@ -7805,7 +7907,7 @@
 
 </nmwg:message>
    </soapenv:Body>
-</soapenv:Envelope>]]></con:request><con:assertion type="SOAP 
Response"/><con:assertion type="Schema Compliance" 
disabled="true"><con:configuration><definition>file:Z:\JRA - 
Stuff\soapui_era\functional-testing\JavaRRDMAsoapUI\store2.3_RC4\rrd-ma-store-res.wsdl</definition></con:configuration></con:assertion><con:assertion
 type="SOAP Fault Assertion"/><con:assertion type="XPath 
Match"><con:configuration><path>declare namespace 
nmwgt='http://ggf.org/ns/nmwg/topology/2.0/';
+</soapenv:Envelope>]]></con:request><con:assertion type="SOAP 
Response"/><con:assertion type="SOAP Fault Assertion"/><con:assertion 
type="XPath Match"><con:configuration><path>declare namespace 
nmwgt='http://ggf.org/ns/nmwg/topology/2.0/';
 declare namespace select='http://ggf.org/ns/nmwg/ops/select/2.0/';
 declare namespace errors='http://ggf.org/ns/nmwg/characteristic/errors/2.0/';
 declare namespace nmwg='http://ggf.org/ns/nmwg/base/2.0/';
@@ -7861,7 +7963,43 @@
 declare namespace 
psservice="http://ggf.org/ns/nmwg/tools/org/perfsonar/service/1.0/";;
 declare namespace xmlns="http://ggf.org/ns/nmwg/base/2.0/";;
 
-count(//nmwg:message/nmwg:metadata/nmwg:key/nmwg:parameters/nmwg:parameter)</path><content>0</content><allowWildcards>true</allowWildcards></con:configuration></con:assertion></con:request></con:config></con:testStep><con:testStep
 type="request" name="Store - Utilization without key, no message 
id"><con:settings/><con:config xsi:type="con:RequestStep" 
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";><con:interface>MeasurementArchiveStoreRequest</con:interface><con:operation>Store</con:operation><con:request
 name="Store - Utilization without key, no message id" 
wssPasswordType=""><con:settings><con:setting 
id="com.eviware.soapui.impl.wsdl.WsdlRequest@request-headers">&lt;xml-fragment/></con:setting></con:settings><con:encoding>UTF-8</con:encoding><con:endpoint>http://perfsonar.carnet.hr:8080/perfSONAR-SQL-MA/services/MeasurementArchiveService</con:endpoint><con:request><![CDATA[<soapenv:Envelope
 xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"; xmlns:ns="http://g
 gf.org/ns/nmwg/base/2.0/" xmlns:ns1="http://ggf.org/ns/nmwg/topology/2.0/";>
+count(//nmwg:message/nmwg:metadata/nmwg:key/nmwg:parameters/nmwg:parameter)</path><content>0</content><allowWildcards>true</allowWildcards></con:configuration></con:assertion><con:assertion
 type="GroovyScriptAssertion" 
name="SQL-groovy"><con:configuration><scriptText>import java.io.File;
+import java.io.OutputStream;
+import java.io.StringWriter;
+import javax.xml.transform.*;
+import javax.xml.transform.stream.StreamResult;
+import javax.xml.transform.stream.StreamSource;
+import javax.xml.transform.TransformerFactory;
+import javax.xml.transform.dom.DOMSource;
+import javax.xml.XMLConstants
+import javax.xml.validation.SchemaFactory
+import java.io.StringWriter
+import groovy.sql.Sql
+
+def sql = 
Sql.newInstance("jdbc:mysql://perfsonar.CARNet.hr:3306/perfsonar_ma", 
"perfsonar_ma", "l0291nk1", "com.mysql.jdbc.Driver")
+
+ids='meta1'
+values='222111'
+valueUnitss='Bps'
+timeValues='1170154688'
+
+sql.execute("insert into perfsonar_utilization  (metadataId, value, 
valueUnits, timeValue) "+
+  " values (?,?,?,?)", [ids,values,valueUnitss,timeValues])
+
+def knownResultsMap=[metadataId:ids,value:values,valueUnits:valueUnitss]
+def resultList=[]   
+
+sql.eachRow("select metadataId,value,valueUnits from perfsonar_utilization 
where timeValue=FROM_UNIXTIME(1170154688) "){
+def result=[:] 
+result=[metadataId:it.id,value:it.value,valueUnits:it.valueUnits]  
+resultList.add(result)
+}
+
+resultList.each{
+if((it.id==knownResultsMap.metadataId)&amp;&amp;(it.value==knownResultsMap.value)&amp;&amp;(it.valueUnits==knownResultsMap.valueUnits))
+ println "\n We have a match" + "\n"+ it.id +"  "+it.value+"  "+it.valueUnits
+ }
+</scriptText></con:configuration></con:assertion><con:assertion type="Schema 
Compliance" 
disabled="true"><con:configuration/></con:assertion></con:request></con:config></con:testStep><con:testStep
 type="request" name="Store - Utilization without key, no message 
id"><con:settings/><con:config xsi:type="con:RequestStep" 
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";><con:interface>MeasurementArchiveStoreRequest</con:interface><con:operation>Store</con:operation><con:request
 name="Store - Utilization without key, no message id" 
wssPasswordType=""><con:settings><con:setting 
id="com.eviware.soapui.impl.wsdl.WsdlRequest@request-headers">&lt;xml-fragment/></con:setting></con:settings><con:encoding>UTF-8</con:encoding><con:endpoint>http://perfsonar.carnet.hr:8080/perfSONAR-SQL-MA/services/MeasurementArchiveService</con:endpoint><con:request><![CDATA[<soapenv:Envelope
 xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"; 
xmlns:ns="http://ggf.org/ns/nmwg/base/2.0/"; xmlns:ns
 1="http://ggf.org/ns/nmwg/topology/2.0/";>
    <soapenv:Header/>
    <soapenv:Body>
        <nmwg:message