Hi Ian, Automated escaping for \ cannot be done with isql or via sparql endpoint.
Virtuoso does not have a bulk delete procedure.
I don’t see the problem you report with the % character:
SQL> SPARQL INSERT DATA { GRAPH <http://example.com/core/graph/data> { <a>
<http://www.w3.org/2008/05/skos-xl#literalForm> "10%w/w of solution" } };
Done. -- 8 msec.
SQL> SPARQL SELECT * FROM <http://example.com/core/graph/data> where {?s ?p ?o};
s
p
o
LONG VARCHAR
LONG VARCHAR
LONG VARCHAR
_______________________________________________________________________________
a
http://www.w3.org/2008/05/skos-xl#literalForm
10%w/w of solution
1 Rows. -- 5 msec.
SQL>
Best Regards
Hugh Williams
Professional Services
OpenLink Software, Inc. // http://www.openlinksw.com/
Weblog -- http://www.openlinksw.com/blogs/
LinkedIn -- http://www.linkedin.com/company/openlink-software/
Twitter -- http://twitter.com/OpenLink
Google+ -- http://plus.google.com/100570109519069333827/
Facebook -- http://www.facebook.com/OpenLinkSoftware
Universal Data Access, Integration, and Management Technology Providers
> On 13 Dec 2016, at 12:01, Ian Harrison <i...@big-data-analytics.com> wrote:
>
> Hugh
>
> Is there no automated escaping for \ --- or must one do it by hand?
>
> Also for the literal "10%w/w of solution" this goes in, but is stored as
> "10?w of solution" -- however, "10% w/w of solution" goes in correctly. How
> do you stop %w/ being interpreted as some format/escape command?
>
> Finally, is there a bulk delete procedure?
>
> Ian
>
>
> On 13/12/2016 11:44, Hugh Williams wrote:
>> Hi Ian,
>>
>> You can escape with the “\” character both for insert/update and delete ie
>> “EAME\\L300641” …
>>
>> Hughs-MBP-2:~ hwilliams$ isql 1111
>> Connected to OpenLink Virtuoso
>> Driver: 07.20.3214 OpenLink Virtuoso ODBC Driver
>> OpenLink Interactive SQL (Virtuoso), version 0.9849b.
>> Type HELP; for help and EXIT; to exit.
>> SQL> SPARQL INSERT DATA { GRAPH <http://example.com/core/graph/data
>> <http://example.com/core/graph/data>> { <a>
>> <http://www.w3.org/2008/05/skos-xl#literalForm
>> <http://www.w3.org/2008/05/skos-xl#literalForm>> "EAME\\L300641" } };
>>
>> Done. -- 10 msec.
>> SQL> SPARQL SELECT * FROM <http://example.com/core/graph/data
>> <http://example.com/core/graph/data>> where {?s ?p ?o};
>> s
>> p
>> o
>> LONG VARCHAR
>> LONG VARCHAR
>> LONG VARCHAR
>> _______________________________________________________________________________
>>
>> a
>> http://www.w3.org/2008/05/skos-xl#literalForm
>> <http://www.w3.org/2008/05/skos-xl#literalForm>
>> EAME\L300641
>>
>> 1 Rows. -- 14 msec.
>> SQL>
>>
>> Hughs-MBP-2:~ hwilliams$ isql 1111 dba dba exec='SPARQL WITH
>> <http://example.com/core/graph/data <http://example.com/core/graph/data>>
>> DELETE { <a> <http://www.w3.org/2008/05/skos-xl#literalForm
>> <http://www.w3.org/2008/05/skos-xl#literalForm>> "EAME\\L300641" }'
>> Connected to OpenLink Virtuoso
>> Driver: 07.20.3214 OpenLink Virtuoso ODBC Driver
>> OpenLink Interactive SQL (Virtuoso), version 0.9849b.
>> Type HELP; for help and EXIT; to exit.
>>
>> Done. -- 1 msec.
>>
>>
>> Hughs-MBP-2:~ hwilliams$ isql 1111
>> Connected to OpenLink Virtuoso
>> Driver: 07.20.3214 OpenLink Virtuoso ODBC Driver
>> OpenLink Interactive SQL (Virtuoso), version 0.9849b.
>> Type HELP; for help and EXIT; to exit.
>> SQL> SPARQL SELECT * FROM <http://example.com/core/graph/data
>> <http://example.com/core/graph/data>> where {?s ?p ?o};
>> s
>> p
>> o
>> LONG VARCHAR
>> LONG VARCHAR
>> LONG VARCHAR
>> _______________________________________________________________________________
>>
>>
>> 0 Rows. -- 1 msec.
>> SQL>
>>
>>
>> Best Regards
>> Hugh Williams
>> Professional Services
>> OpenLink Software, Inc. // http://www.openlinksw.com/
>> <http://www.openlinksw.com/>
>> Weblog -- http://www.openlinksw.com/blogs/
>> <http://www.openlinksw.com/blogs/>
>> LinkedIn -- http://www.linkedin.com/company/openlink-software/
>> <http://www.linkedin.com/company/openlink-software/>
>> Twitter -- http://twitter.com/OpenLink <http://twitter.com/OpenLink>
>> Google+ -- http://plus.google.com/100570109519069333827/
>> <http://plus.google.com/100570109519069333827/>
>> Facebook -- http://www.facebook.com/OpenLinkSoftware
>> <http://www.facebook.com/OpenLinkSoftware>
>> Universal Data Access, Integration, and Management Technology Providers
>>
>>> On 13 Dec 2016, at 09:34, Ian Harrison <i...@big-data-analytics.com
>>> <mailto:i...@big-data-analytics.com>> wrote:
>>>
>>> I have a situation where I want to do a delete of a large number of
>>> triples, some of which have escape characters in a literal
>>>
>>> So my question is 2 fold.
>>>
>>> 1) Is there a bulk delete procedure, equivalent to the bulk upload?
>>> 2) If I delete, via isql, on a per triple basis, how can I do so with
>>> triples like this:
>>>
>>> <x> <http://www.w3.org/2008/05/skos-xl#literalForm
>>> <http://www.w3.org/2008/05/skos-xl#literalForm>> "EAME\L300641"
>>>
>>> I'm trying to do via the ISQL interface in a bash script
>>>
>>> i.e. /apps/virtuoso/bin/isql 1111 dba dba exec='SPARQL WITH
>>> <http://example.com/core/graph/data <http://example.com/core/graph/data>>
>>> DELETE { <x>
>>> <http://www.w3.org/2008/05/skos-xl#literalForm
>>> <http://www.w3.org/2008/05/skos-xl#literalForm>> "EAME\L300641" }'
>>>
>>> The error I get is - Bad escape sequence in a SPARQL short double-quoted
>>> string --- issue is the \
>>>
>>> I get the same with a triple like
>>>
>>> <y> <http://www.w3.org/2004/02/skos/core#prefLabel
>>> <http://www.w3.org/2004/02/skos/core#prefLabel>> "10%w/w solution of
>>> Marlox"; -- is is the %
>>>
>>> Is there some way via isql in a bash script to get characters like \ and
>>> % escaped?
>>>
>>> Thanks
>>>
>>> Ian
>>>
>>> --
>>> Ian Harrison Email: i...@big-data-analytics.com
>>> <mailto:i...@big-data-analytics.com>
>>> Tel: +44 (0)7580 618125
>>>
>>>
>>> ------------------------------------------------------------------------------
>>> Check out the vibrant tech community on one of the world's most
>>> engaging tech sites, SlashDot.org <http://slashdot.org/>!
>>> http://sdm.link/slashdot <http://sdm.link/slashdot>
>>> _______________________________________________
>>> Virtuoso-users mailing list
>>> Virtuoso-users@lists.sourceforge.net
>>> <mailto:Virtuoso-users@lists.sourceforge.net>
>>> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
>>> <https://lists.sourceforge.net/lists/listinfo/virtuoso-users>
>>
>
>
> --
> Ian Harrison Email: i...@big-data-analytics.com
> <mailto:i...@big-data-analytics.com>
> Tel: +44 (0)7580 618125
>
> ------------------------------------------------------------------------------
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, SlashDot.org!
> http://sdm.link/slashdot_______________________________________________
> Virtuoso-users mailing list
> Virtuoso-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
smime.p7s
Description: S/MIME cryptographic signature
------------------------------------------------------------------------------ Developer Access Program for Intel Xeon Phi Processors Access to Intel Xeon Phi processor-based developer platforms. With one year of Intel Parallel Studio XE. Training and support from Colfax. Order your platform today.http://sdm.link/intel
_______________________________________________ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
