Hi Holger, In this case, I was aligning some of my ontologies with EDG ontologies, e.g. changing the inheritance hierarchies, converting some of the property shapes, etc... I was able to accomplish what I needed by making the target graph the current graph and importing the necessary graphs for the purpose of the insert.
Overall, I've made good use of the batch operation capabilities in TBC or direct insert/delete operations to move things between graphs or change namespaces. Ontologies are always evolving and eventually need to be refactored so moving a class and it's property shapes, etc... to another graph is a common use case. Another common use case is to create a "mapping graph" in which I create a number of helper classes and instances to assist in mapping data sources (typically XLSX or CSV) into an ontology. I run an insert query to create the instances (or new schema) and insert the results into a target graph. I think I can do the same in EDG by making the target graph the current graph and import everything there,removing the imports when the insert is complete. TIm On Tue, Jun 30, 2020 at 8:28 PM Holger Knublauch <[email protected]> wrote: > On 1/07/2020 06:29, Tim Smith wrote: > > Hi, > > I am refactoring an ontology and I intended to use INSERT/DELETE queries > to make it easier. However, when I execute the following query, I > receive the error below: > > Is the error valid in that I cannot insert into a designated graph from > the SPARQL query window? > > Yes, that panel is only meant for the currently active graph. That is the > one that the user has access to and where the change history would be > recorded. Manipulating some other graph would not go into the change > history. > > Does this same restriction hold for the SPARQL endpoint? > > No. You can modify any graph there. > > How do I move things between graphs in EDG? > > We have some partial solutions, but only a combination of them may do what > you need: > > - Transform tab > Copy or Move Instances from Other Asset Collection > > - Source code panel (cut/paste between two browser tabs, then save both) > > - SPARQL updates > > I am sure there is a lot of room for improvements here. Could you > elaborate a bit on what type of data you are trying to move? > > Holger > > > > Thanks, > > Tim > > PS: Being able to use Crtl-<Enter> to execute a query is so much better! > Thanks for adding that in 6.4. > > > *{"message":"Exception while fetching data (/sparql) : **INSERT can only > modify the default graph * > INSERT { > GRAPH <urn:x-evn-master:schema_equipment> { > ?s rdfs:subClassOf edg:Sensor . > } > } > WHERE { > ?s rdfs:subClassOf pgont:Sensor . > } > > Error(s): > > - {"message":"Exception while fetching data (/sparql) : INSERT can > only modify the default > graph","locations":[{"line":2,"column":21}],"path":["sparql"]} > > Query: mutation sparqlUpdate($sparql: String!) { sparql(query: $sparql) > report { diff results { message severity focusNode { label uri } path > pathLabel value { label uri } constraintComponentName suggestions { message > confidence applyData } } } commit(message:"Update from SPARQL Query panel", > strict: false)} > > Variables: {"sparql":"PREFIX afn: > <http://jena.hpl.hp.com/ARQ/function#>\nPREFIX > arg: <http://spinrdf.org/arg#>\nPREFIX bbase: < > http://ontologies.pg.com/businessbase#>\nPREFIX crosswalkprojects: < > http://teamwork.topbraidlive.org/crosswalkprojects#>\nPREFIX dash: < > http://datashapes.org/dash#>\nPREFIX data: <http://data.pg.com/data/>\nPREFIX > datatype: <http://qudt.org/vocab/datatype/>\nPREFIX dc: < > http://purl.org/dc/elements/1.1/>\nPREFIX dcam: > <http://purl.org/dc/dcam/>\nPREFIX > dct: <http://purl.org/dc/terms/>\nPREFIX dimprop: < > http://ontologies.pg.com/dimensionandproperties#>\nPREFIX dtype: < > http://www.linkedmodel.org/schema/dtype#>\nPREFIX edg.c: < > http://edg.topbraid.solutions/controller/>\nPREFIX edg.glossary: < > http://edg.topbraid.solutions/glossary/>\nPREFIX edg.sqoop: < > http://edg.topbraid.solutions/model/sqoop/>\nPREFIX edg.v: < > http://edg.topbraid.solutions/view/>\nPREFIX edg: < > http://edg.topbraid.solutions/model/>\nPREFIX fn: < > http://www.w3.org/2005/xpath-functions#>\nPREFIX foaf: < > http://xmlns.com/foaf/0.1/>\nPREFIX gen: < > http://ontologies.pg.com/general#>\nPREFIX geo: < > http://www.w3.org/2003/01/geo/wgs84_pos#>\nPREFIX gr: < > http://purl.org/goodrelations/v1#>\nPREFIX graphql: < > http://datashapes.org/graphql#>\nPREFIX html: > <http://uispin.org/html#>\nPREFIX > metadata: <http://topbraid.org/metadata#>\nPREFIX ontologyprojects: < > http://teamwork.topbraidlive.org/ontologyprojects#>\nPREFIX org: < > http://www.w3.org/ns/org#>\nPREFIX owl: > <http://www.w3.org/2002/07/owl#>\nPREFIX > owlTime: <http://www.w3.org/2006/time#>\nPREFIX p1: < > http://example.org/file1#>\nPREFIX pgont: < > http://ontologies.pg.com/pgontology/>\nPREFIX prov: < > http://www.w3.org/ns/prov#>\nPREFIX quantity: < > http://qudt.org/vocab/quantity/>\nPREFIX quantitykind: < > http://qudt.org/vocab/quantitykind/>\nPREFIX qudt-refdata: < > http://qudt.org/vocab/refdata/>\nPREFIX qudt.type: < > http://qudt.org/vocab/type/>\nPREFIX qudt: > <http://qudt.org/schema/qudt/>\nPREFIX > raci: <http://topbraid.org/raci#>\nPREFIX rdf: < > http://www.w3.org/1999/02/22-rdf-syntax-ns#>\nPREFIX rdfs: < > http://www.w3.org/2000/01/rdf-schema#>\nPREFIX rdm: < > http://rdm.topbraidlive.org/rdm/>\nPREFIX rdmfact: < > http://topbraid.org/rdmfact#>\nPREFIX rdmprojects: < > http://rdm.topbraidlive.org/rdmprojects#>\nPREFIX refdata: < > http://ontologies.pg.com/refdata#>\nPREFIX s3: > <http://topbraid.org/s3#>\nPREFIX > search: <http://topbraid.org/search#>\nPREFIX sh: < > http://www.w3.org/ns/shacl#>\nPREFIX sioc: <http://rdfs.org/sioc/ns#>\nPREFIX > skos: <http://www.w3.org/2004/02/skos/core#>\nPREFIX skosxl: < > http://www.w3.org/2008/05/skos-xl#>\nPREFIX smf: < > http://topbraid.org/sparqlmotionfunctions#>\nPREFIX softwareprojects: < > http://teamwork.topbraidlive.org/software/softwareprojects#>\nPREFIX sp: < > http://spinrdf.org/sp#>\nPREFIX sparql: > <http://datashapes.org/sparql#>\nPREFIX > spif: <http://spinrdf.org/spif#>\nPREFIX spin: > <http://spinrdf.org/spin#>\nPREFIX > spl: <http://spinrdf.org/spl#>\nPREFIX spr: <http://spinrdf.org/spr#>\nPREFIX > swa: <http://topbraid.org/swa#>\nPREFIX swash: > <http://topbraid.org/swash#>\nPREFIX > taggerprojects: <http://evn.topbraidlive.org/taggerprojects#>\nPREFIX > taxonomies: <http://evn.topbraidlive.org/evnprojects#>\nPREFIX teamwork: < > http://topbraid.org/teamwork#>\nPREFIX teamworkconstraints: < > http://topbraid.org/teamworkconstraints#>\nPREFIX tops: < > http://www.topbraid.org/tops#>\nPREFIX tosh: > <http://topbraid.org/tosh#>\nPREFIX > ui: <http://uispin.org/ui#>\nPREFIX unit: > <http://qudt.org/vocab/unit/>\nPREFIX > vaem: <http://www.linkedmodel.org/schema/vaem#>\nPREFIX vcard: < > http://www.w3.org/2006/vcard/>\nPREFIX voag: < > http://voag.linkedmodel.org/voag/>\nPREFIX vs: < > http://www.w3.org/2003/06/sw-vocab-status/ns#>\nPREFIX wot: < > http://xmlns.com/wot/0.1/>\nPREFIX wp: < > http://ontologies.pg.com/v1.0/workprocess#>\nPREFIX xml: < > http://www.w3.org/XML/1998/namespace>\nPREFIX xsd: < > http://www.w3.org/2001/XMLSchema#>\n\nINSERT {\n GRAPH > <urn:x-evn-master:schema_equipment> {\n ?s rdfs:subClassOf edg:Sensor .\n > }\n}\nWHERE {\n ?s rdfs:subClassOf pgont:Sensor . \n}\n"} > > Service URL: > graphql/schema_equipment/generic?message=Update_from_SPARQL_Query_panel > Ok > > -- > You received this message because you are subscribed to the Google Groups > "TopBraid Suite Users" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/topbraid-users/CAF0WbnKb4CXbGasM1Q2j_p4tfJJuNnPZb%3Dpyn0EEO01i0MTKYw%40mail.gmail.com > <https://groups.google.com/d/msgid/topbraid-users/CAF0WbnKb4CXbGasM1Q2j_p4tfJJuNnPZb%3Dpyn0EEO01i0MTKYw%40mail.gmail.com?utm_medium=email&utm_source=footer> > . > > -- > You received this message because you are subscribed to the Google Groups > "TopBraid Suite Users" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/topbraid-users/1cfdc63f-d7b4-57ca-2965-56084ca9b0af%40topquadrant.com > <https://groups.google.com/d/msgid/topbraid-users/1cfdc63f-d7b4-57ca-2965-56084ca9b0af%40topquadrant.com?utm_medium=email&utm_source=footer> > . > -- You received this message because you are subscribed to the Google Groups "TopBraid Suite Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/topbraid-users/CAF0WbnJ1cAKcp93N%3D%2B50DEOEByyPGnh8AXC2FvGjm3OQhe2j0Q%40mail.gmail.com.
