%META:TOPICPARENT{name="InteractiveSparqlQueryBuilderTutorials"}%

---++iSPARQL Querying Tutorial with SPARQL Query type "DELETE"

This tutorial shows how to execute a SPARQL query with type "DELETE". 


%TOC%

---+++Enter and execute a query

   1 Go to http://cname/isparql, for ex: http://id.myopenlink.net/isparql
   1 The iSPARQL initialization window will be shown:
%BR%%BR% <img src="%ATTACHURLPATH%/isparqlload.png" style="wikiautogen"/>%BR%%BR%
   1 On successful initialization will be presented the iSPARQL <strong>Advanced</strong> tab open with a default SPARQL query:
<verbatim>
SELECT * WHERE {?s ?p ?o}
</verbatim>
%BR%%BR% <img src="%ATTACHURLPATH%/isparql1.png" style="wikiautogen"/>%BR%%BR%
   1 Go to <strong>QBE</strong> tab:
%BR%%BR% <img src="%ATTACHURLPATH%/isparql2.png" style="wikiautogen"/>%BR%%BR%
   1 Click the <strong>Clear Pane</strong> icon on the toolbar to empty the Canvas. 
%BR%%BR% <img src="%ATTACHURLPATH%/isparql3.png" style="wikiautogen"/>%BR%%BR%
%BR%%BR%<img src="%ATTACHURLPATH%/isparql4.png" style="wikiautogen"/>%BR%%BR%
   1 Change the <strong>Data Source URI</strong> field value on the QBE tab for ex. to <strong><nowiki>http://mytest.com</nowiki></strong>. This will be the Graph URL we are going to use in our tutorial. 
%BR%%BR%<img src="%ATTACHURLPATH%/iss9.png" style="wikiautogen"/>%BR%%BR%
   1 Make sure the steps from the [[InteractiveSparqlQueryBuilderQueryTutorialInsert][iSPARQL Insert Query Tutorial]] 
are performed.
   1 From the <strong>QBE</strong> tab change the "Query Option Type" to <strong>DELETE</strong>. 
%BR%%BR%<img src="%ATTACHURLPATH%/iss17.png" style="wikiautogen"/>%BR%%BR%
   1 Click the <strong>Generate</strong> icon on the QBE toolbar.
   1 The <strong>Advanced</strong> tab will open, with the produced SPARQL 
Query shown in the text-area:
%BR%%BR%<img src="%ATTACHURLPATH%/iss18.png" style="wikiautogen"/>%BR%%BR%
   1 We are going to modify the query by adding the triples which we want 
to be deleted from the local Named Graph, <strong><nowiki>http://mytest.com</nowiki></strong>. 
Add (cut-and-paste) the following to the query:
<verbatim>
<s1> <p1> <o1> .
<s2> <p2> <o2> 
</verbatim>
%BR%%BR%<img src="%ATTACHURLPATH%/iss19.png" style="wikiautogen"/>%BR%%BR%
   1 Click the <strong>Run Query</strong> icon on the Advanced toolbar.
   1 In the <strong>Result</strong> sub-tab, you should see a message 
confirming successful deletion of 2 triples:
%BR%%BR%<img src="%ATTACHURLPATH%/iss20.png" style="wikiautogen"/>%BR%%BR%
   1 To check what triples are now found in the <strong><nowiki>http://mytest.com</nowiki></strong> 
Named Graph, click to the <strong>Advanced</strong> tab.
   1 Enter the following into the <strong>SPARQL Query</strong> text-area:
<verbatim>
SELECT ?s ?p ?o 
FROM <http://mytest.com>  
WHERE 
  { 
    GRAPH <http://mytest.com> 
      {
        ?s ?p ?o
      } 
  }
</verbatim>
%BR%%BR%<img src="%ATTACHURLPATH%/iss21.png" style="wikiautogen"/>%BR%%BR%
   1 Click the <strong>Run Query</strong> icon on the <strong>Advanced</strong> toolbar.
   1 You should see that only 1 triple is now found in the 
   <strong><nowiki>http://mytest.com</nowiki></strong> Named Graph.
%BR%%BR%<img src="%ATTACHURLPATH%/iss22.png" style="wikiautogen"/>%BR%%BR%

---+++Related

   * [[InteractiveSparqlQueryBuilderTutorials][iSPARQL Tutorials]]
   * [[InteractiveSparqlQueryBuilderBasicTutorial1][Basic iSPARQL Tutorial with query built from a blank canvas and pre-typed Nodes]]
   * [[InteractiveSparqlQueryBuilderBasicTutorial2][Basic iSPARQL Tutorial with query built from a blank canvas and Nodes dragged from the Toolbar]]
   * [[InteractiveSparqlQueryBuilderBasicTutorial][Basic iSPARQL Tutorial]]
   * [[InteractiveSparqlQueryBuilderQueryTutorialConstruct][iSPARQL Querying Tutorial with SPARQL Query type "CONSTRUCT"]]
   * [[InteractiveSparqlQueryBuilderQueryTutorialDescribe][iSPARQL Querying Tutorial with SPARQL Query type "DESCRIBE"]]
   * [[InteractiveSparqlQueryBuilderQueryTutorialDescribeGoogleMapView][iSPARQL Querying Tutorial "DESCRIBE" with Google Maps View Results]]
   * [[InteractiveSparqlQueryBuilderQueryTutorialInsert][iSPARQL Querying Tutorial with SPARQL Query type "INSERT"]]
   * [[InteractiveSparqlQueryBuilderQueryTutorialSlc][iSPARQL Querying Tutorial with SPARQL Query type "SELECT"]]   
   * [[OATWikiWebIndex][OpenLink AJAX Toolkit (OAT)]]
   * [[http://docs.openlinksw.com/virtuoso/rdfsparul.html#rdfsparulexamples][Virtuoso Documentation SPARQL Query examples]]


CategorySPARQL CategoryRDF CategoryOpenSource CategoryOAT CategoryDocumentation CategoryTutorial