> In [61]: connect.execute('''DB.DBA.RDF_LOAD_RDFXML (file_to_string
> ('/test-virtuoso/cmn2.rdf'), '', 'http://mygraph.com') ; ''')

finally, it seems the problem here is the ';' omitting this it takes the command

but there's another problem now:

In [4]: connect.execute('''DB.DBA.RDF_LOAD_RDFXML
(file_to_string('/test-virtuoso/cmn2.rdf'), '',
'http://mygraphfunky.com')''')
Out[4]: <pyodbc.Cursor object at 0xf9ab80>

In [5]: connect.execute('''sparql select * from
<http://mygraphfunky.com> where {?s ?p ?o }''')
Out[5]: <pyodbc.Cursor object at 0xf9ac28>

In [6]: for r in Out[5]: print r
   ...:
('#BOLC', 'http://www.w3.org/1999/02/22-rdf-syntax-ns#type',
'http://purl.org/ontology/mo/Composer')
....

(loads of results, what we'd expect to see)

...
('#BIBE', 'http://xmlns.com/foaf/0.1/birthday', '1644-1704')
('#BIBE', 'http://grasstunes.com/ontology/musicnet.owl#cmnHasInfluenced',
'#COWE')
('#BIBE', 'http://grasstunes.com/ontology/musicnet.owl#cmnHasInfluenced',
'#SCHU3')

In [7]: connect.close()

In [8]: connect =
pyodbc.connect('DSN=SysVirt;UID=dba;PWD=dba;HOST=localhost:1112')

In [9]: connect.execute('''sparql select * from
<http://mygraphfunky.com> where {?s ?p ?o }''')
Out[9]: <pyodbc.Cursor object at 0xf9aaa0>

In [10]: for r in Out[9]: print r
   ....:

after closing the odbc connection the graph is empty!  any idea what gives?

-kurt j

Reply via email to