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

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

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


%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 On the <strong>QBE</strong> tab, change the Type (shown below the Canvas) to <strong>INSERT</strong>. 
%BR%%BR%<img src="%ATTACHURLPATH%/iss10.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%/iss11.png" style="wikiautogen"/>%BR%%BR%
   1 We are going to modify the query by adding the values to be inserted in 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> .
<s3> <p3> <o3> 
</verbatim>
%BR%%BR%<img src="%ATTACHURLPATH%/iss12.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 insertion of 3 triples:
%BR%%BR%<img src="%ATTACHURLPATH%/iss13.png" style="wikiautogen"/>%BR%%BR%
   1 Now you may want to view the produced <strong>Graph Model</strong>. Click the <strong>Load Query into QBE</strong> icon.
   1 The QBE Working Canvas will now display the produced Graph:
%BR%%BR%<img src="%ATTACHURLPATH%/iss14.png" style="wikiautogen"/>%BR%%BR%
   1 To check what triples there are in the <strong><nowiki>http://mytest.com</nowiki></strong> Named Graph, go to the strong>Advanced</strong> tab.
   1 Enter the following query 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%/iss15.png" style="wikiautogen"/>%BR%%BR%
   1 Click the <strong>Run Query</strong> icon on the <strong>Advanced</strong> toolbar.
   1 You should see that the 3 triples we inserted above are now found in the <strong><nowiki>http://mytest.com</nowiki></strong> Named Graph.
%BR%%BR%<img src="%ATTACHURLPATH%/iss16.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]]
   * [[InteractiveSparqlQueryBuilderQueryTutorialDelete][iSPARQL Querying Tutorial with SPARQL Query type "DELETE"]]
   * [[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