view src/sparql/insert_vector_table_details.sparql @ 78:5577d8efc79a

now works on the assumption that all required dimVals already exist

PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX owl: <http://www.w3.org/2002/07/owl#>
PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
PREFIX abc: <http://example.org/abc#>
PREFIX seq: <http://example.org/seq#>
PREFIX sia: <http://example.org/sia#>

INSERT { ?vte sia:dimVal ?dimVal}
WHERE
{
	?vte rdf:type sia:VectorTableElement .
	?vte sia:fromDatapoint ?datapoint1 .
	?vte sia:toDatapoint ?datapoint2 .
	?datapoint1 sia:vector ?vector1 .
	?vector1 sia:dimVal ?dv1 .
	?dv1 sia:dimension ?dim .
	?dv1 sia:value ?val1 .
	?datapoint2 sia:vector ?vector2 .
	?vector2 sia:dimVal ?dv2 .
	?dv2 sia:dimension ?dim .
	?dv2 sia:value ?val2 .
	FILTER ( ( datatype(?val2) = xsd:double ) && ( datatype(?val1) = xsd:double ) )
	BIND (?val2 - ?val1 AS ?val)
	?dimVal a sia:DimensionValue .
	?dimVal sia:dimension ?dim .
	?dimVal sia:value ?val
	FILTER ( datatype(?val) = xsd:double )
}