tracker-sparql command_examples

tracker-sparql – Use SparQL to query the Tracker databases.

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
}"

 

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 {
nie:usageCounter ?count
} WHERE {
nie:usageCounter ?count
} INSERT {
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"