Hey Ivan On Tue, May 14, 2013 at 8:44 PM, Ivan Mikhailov <[email protected]> wrote: > Hello Vishesh, > > The query says: > > For every triple <resA> nao:lastModified ?mod found in database (if > any), > > prepare future removal of <resA> nao:lastModified ?mod > and > prepare insertion of <resA> nao:lastModified > "2012-01-29T16:29:11Z"^^xsd:dateTime . > > When all (if any) operations are prepared, perform the actual edition of > the database. > > No <resA> nao:lastModified ?mod at the very beginning --- no > manipulations prepared --- no effect. > > The solution is to make separate DELETE and then an unconditional > INSERT.
Thanks for the detailed explanation. I was hoping to optimize it by not having to call a separate delete and insert operation. It would be nice to have something like an 'update or insert' like one has in SQL. > > Best Regards, > > Ivan Mikhailov > OpenLink Software > http://virtuoso.openlinksw.com > > On Tue, 2013-05-14 at 15:27 +0530, Vishesh Handa wrote: >> Hey guys >> >> I've been trying to update some statements in a graph, and I have been >> using the following query - >> >> WITH <nepomuk:/ctx/graph> >> DELETE { <resA> nao:lastModified ?mod . } >> INSERT { <resA> nao:lastModified "2012-01-29T16:29:11Z"^^xsd:dateTime . } >> WHERE { <resA> nao:lastModified ?mod . } >> >> This works fine in the case when the <resA> nao:lastModified ?m triple >> already exists, but it does not insert the new statement if that >> triple does not exist. >> >> I was checking the SPARQL 1.1 Update Standard [1], and I found the >> following text - >> >> "Deleting triples that are not present, or from a graph that is not >> present will have no effect and will result in success." >> >> So in the case when the triple is not present the delete operation >> should result in a success and the insert operation should be carried >> out. But that does not seem to be the case. >> >> Could someone please confirm if this is just a bug or is that the >> intended behaviour? >> >> [1] http://www.w3.org/TR/2012/PR-sparql11-update-20121108/#deleteInsert >> >> -- >> Vishesh Handa >> >> ------------------------------------------------------------------------------ >> AlienVault Unified Security Management (USM) platform delivers complete >> security visibility with the essential security capabilities. Easily and >> efficiently configure, manage, and operate all of your security controls >> from a single console and one unified framework. Download a free trial. >> http://p.sf.net/sfu/alienvault_d2d >> _______________________________________________ >> Virtuoso-users mailing list >> [email protected] >> https://lists.sourceforge.net/lists/listinfo/virtuoso-users > -- Vishesh Handa ------------------------------------------------------------------------------ AlienVault Unified Security Management (USM) platform delivers complete security visibility with the essential security capabilities. Easily and efficiently configure, manage, and operate all of your security controls from a single console and one unified framework. Download a free trial. http://p.sf.net/sfu/alienvault_d2d _______________________________________________ Virtuoso-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/virtuoso-users
