Note: The ckanext-sparql extension was tested using Virtuoso sparql instances such as http://semantic.ckan.net/sparql.
I will try to make it work for other type of sparql instances ;)
This is a simple extension, but may be useful for someone that wants to include a Sparql Interface Editor in their CKAN instances. The idea is based on the Sparql Editor of the LODUM project from the University of Munsters Open Data initiative (http://data.uni-muenster.de/php/sparql/).
The extension use:
CKAN Extensions
CodeMirror for the code editor in the browser -> (http://codemirror.net/)May be extended to use SPARQLWrapper (http://sparql-wrapper.sourceforge.net/) library - SPARQL Endpoint interface to Python
$ cd /usr/lib/ckan/default/src
$ git clone https://github.com/georgepm/ckanext-sparql.git
$ cd ckanext-sparql/
$ sudo python setup.py develop
Add it in your configuration file: :
$ vim /etc/ckan/default/production.ini
Go the plugins line and add the sparql_interface plugin :: ckan.plugins = sparql_interface ….. (other plugins…)
Reload Apache: :
$ sudo service apache2 reload
Go to: :: [http://Custom URL]/sparql
Querys work in: :: [http://Custom URL]/query?query=
To send code through http to the sparql interface: :: [http://Custom URL]/sparql?view_code=
In your ckan.ini file set ` ckanext.sparql.endpoint_url = <your default endpoint url> (defaults to http://dbpedia.org/sparql) ckanext.sparql.hide_endpoint_url = (true | false) (defaults to false)`
To configure your own custom query ` Line 54, After <textarea id="sparql_code" name="sparql_code" resize="both"> Here replace the query ... </textarea>`