comparison src/sparql/insert_siatec_vector_table_bnodes.sparql @ 62:7cdbe9fdc1bb

creates a new orderedSet bnode and asserts membership thereof for the vte

 PREFIX seq: <http://example.org/seq#>
 PREFIX sia: <http://example.org/sia#>
 
 INSERT { _:vte rdf:type sia:VectorTableElement;
 			sia:fromDatapoint ?datapoint1;
-			sia:toDatapoint ?datapoint2}
+			sia:toDatapoint ?datapoint2;
+			sia:memberOfDataset ?dataset}
 WHERE
 {
- 	?datapoint1 sia:memberOfOrderedSet ?bnode .
- 	?datapoint2 sia:memberOfOrderedSet ?bnode .
-	?bnode a sia:OrderedSet .
+	?datapoint1 a sia:Datapoint .
+	?datapoint2 a sia:Datapoint .
+ 	?datapoint1 sia:memberOfOrderedSet ?orderedSet .
+ 	?datapoint2 sia:memberOfOrderedSet ?orderedSet .
+	?orderedSet a sia:OrderedSet .
 	?datapoint1 sia:orderedIndex ?i1 .
 	?datapoint2 sia:orderedIndex ?i2
+	
+	FILTER ((?datapoint1 != ?datapoint2) && (?i1 < ?i2))
+	FILTER ( datatype(?i1) = xsd:integer && datatype(?i2) = xsd:integer )
+	
+	{
+		SELECT ?dataset ?orderedSet
+   		WHERE
+   		{
+   			?orderedSet a sia:OrderedSet .
+			BIND (bnode() AS ?dataset)
+		}
+	}
 }
-#GROUP BY ?datapoint1 ?datapoint2