|
|
Creating Music Video
|
|
tracker-sparql(1) User Commands tracker-sparql(1) NAME
tracker-sparql - Use SparQL to query the Tracker databases. SYNOPSIS
tracker-sparql [OPTION...] [-q QUERY] | [-f FILE] DESCRIPTION
tracker-sparql allows the caller to run an RDF query on the database. This can be done two ways. Either by providing a FILE with the query or by providing a string with the QUERY string. The FILE argument can be either a local path or a URI. It also does not have to be an absolute path. OPTIONS
-?, --help Show summary of options. -f, --file=FILE Use a FILE with SPARQL content to query or update. -q, --query=SPARQL Use a SPARQL string to query the database with. -u, --update This has to be used with --query. This tells tracker-sparql to use the SPARQL update extensions so it knows it isn't a regular data lookup request. So if your query is intended to change data in the database, this option is needed. -c, --list-classes Returns a list of classes which describe the ontology used for storing data. These classes are also used in queries. For example, http://www.w3.org/2000/01/rdf-schema#Resource is one of many classes which should be returned here. -x, --list-class-prefixes Returns a list of classes and their related prefixes. Prefixes are used to make querying a lot simpler and are much like an alias. For example, http://www.w3.org/2000/01/rdf-schema#Resource has the prefix rdfs so queries can be cut down to: "SELECT ?u WHERE { ?u a rdfs:Resource }" -p, --list-properties=CLASS Returns a list of properties which pertain to a class. You can use both formats here for the class, either the full name http://www.semanticdesktop.org/ontologies/2007/03/22/nfo#Video or the shortened prefix name nfo:Video. This gives the following result: $ tracker-sparql -p nfo:Video Properties: 2 http://www.semanticdesktop.org/ontologies/2007/03/22/nfo#frameRate http://www.semanticdesktop.org/ontologies/2007/03/22/nfo#frameCount These properties nfo:frameRate and nfo:frameCount can be used in more complex queries (see --query). -n, --list-notifies=CLASS Returns a list of classes which are notified over D-Bus about any changes that occur in the database. CLASS does not have to be sup- plied here. This is optional and filters the results according to any argument supplied. With no CLASS, all classes are listed. -s, --search=TERM Returns a list of classes and properties which partially match TERM in the ontology. This is a case insensitive match, for example: $ tracker-sparql -s text Classes: 4 http://www.semanticdesktop.org/ontologies/2007/03/22/nfo#TextDocument http://www.semanticdesktop.org/ontologies/2007/03/22/nfo#PlainTextDocument http://www.semanticdesktop.org/ontologies/2007/03/22/nfo#PaginatedTextDocument http://www.tracker-project.org/temp/nmm#SynchronizedText Properties: 5 http://www.tracker-project.org/ontologies/tracker#fulltextIndexed http://www.tracker-project.org/ontologies/tracker#fulltextNoLimit http://www.semanticdesktop.org/ontologies/2007/01/19/nie#plainTextContent http://www.semanticdesktop.org/ontologies/2007/03/22/nmo#plainTextMessageContent http://www.tracker-project.org/temp/scal#textLocation -V, --version Print version. EXAMPLES
List all classes $ tracker-sparql -q "SELECT ?cl WHERE { ?cl a rdfs:Class }" List all properties for the Resources class (see --list-properties) $ tracker-sparql -q "SELECT ?prop WHERE { ?prop a rdf:Property ; rdfs:domain <http://www.w3.org/2000/01/rdf-schema#Resource> }" List all class namespace prefixes $ tracker-sparql -q "SELECT ?prefix ?ns WHERE { ?ns a tracker:Namespace ; tracker:prefix ?prefix }" List all music files $ tracker-sparql -q "SELECT ?song WHERE { ?song a nmm:MusicPiece }" List all music albums $ tracker-sparql -q "SELECT ?album ?title COUNT(?song) AS songs SUM(?length) AS totallength WHERE { ?album a nmm:MusicAlbum ; nie:title ?title . ?song nmm:musicAlbum ?album ; nfo:duration ?length } GROUP BY ?album" List all music from a particular artist $ tracker-sparql -q "SELECT ?song ?title WHERE { ?song nmm:performer [ nmm:artistName 'Artist Name' ] ; nie:title ?title }" Set the played count for a song $ tracker-sparql -u -q "DELETE { <file:///home/user/Music/song.mp3> nie:usageCounter ?count } WHERE { <file:///home/user/Music/song.mp3> nie:usageCounter ?count } INSERT { <file:///home/user/Music/song.mp3> nie:usageCounter 42 }" List all image files $ tracker-sparql -q "SELECT ?image WHERE { ?image a nfo:Image }" List all image files with a specific tag $ tracker-sparql -q "SELECT ?image WHERE { ?image a nfo:Image ; nao:hasTag [ nao:prefLabel 'tag' ] }" List all image files created on a specific month and order by date $ tracker-sparql -q "SELECT ?image ?date WHERE { ?image a nfo:Image ; nie:contentCreated ?date . FILTER (?date >= '2008-07-01T00:00:00' && ?date < '2008-08-01T00:00:00') } ORDER BY ?date" SEE ALSO
tracker-store(1), tracker-info(1). http://nepomuk.semanticdesktop.org/ http://www.w3.org/TR/rdf-sparql-query/ GNU
July 2009 tracker-sparql(1)
