Hugh -- thanks for reply
The % thing isn't a problem at isql interface ... just when its called
as part of a bash script, that passes a string to the exec part of a
call. My workaround is to use curl insteead of isql to the sparql
endpoint, as I can url encode as part of that and get round the
character issues.
Thanks
Ian
On 15/12/2016 00:08, Hugh Williams wrote:
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
<mailto: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>
{ <a> <http://www.w3.org/2008/05/skos-xl#literalForm>
"EAME\\L300641" } };
Done. -- 10 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
EAME\L300641
1 Rows. -- 14 msec.
SQL>
Hughs-MBP-2:~ hwilliams$ isql 1111 dba dba exec='SPARQL WITH
<http://example.com/core/graph/data> DELETE { <a>
<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> 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/
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 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> "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> DELETE { <x>
<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> "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
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
<mailto:Virtuoso-users@lists.sourceforge.net>
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
--
Ian Harrison Email: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_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
<mailto:Virtuoso-users@lists.sourceforge.net>
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
--
Ian Harrison Email: i...@big-data-analytics.com
Tel: +44 (0)7580 618125
------------------------------------------------------------------------------
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
