[Netatalk-devel] Invalid sparql queries for audio metadata?

[Piotr M. <pio...@mo...>]

I’m on 3.1.7, compiled with tracker-1.2.6, and from what I see, the audio metadata doesn’t seem to be queried the right way. 

tracker-info 2-01\ Tanker\ Incident.mp3
Querying information for entity:'2-01 Tanker Incident.mp3'
  'urn:uuid:981b2ec3-b18a-8091-51e0-43d66bf32fae'
Results:
  'http://purl.org/dc/elements/1.1/contributor' = 'urn:artist:Norihiko%20Hibino'
  'http://purl.org/dc/elements/1.1/date' = '2002-01-01T00:00:00Z'
  'http://purl.org/dc/elements/1.1/date' = '2014-08-09T12:36:07Z'
  'http://purl.org/dc/elements/1.1/date' = '2014-08-09T12:36:08Z'
  'http://purl.org/dc/elements/1.1/source' = 'http://www.tracker-project.org/ontologies/tracker#extractor-data-source'
  'http://purl.org/dc/elements/1.1/source' = 'urn:nepomuk:datasource:9291a450-1d49-11de-8c30-0800200c9a66'
  'http://purl.org/dc/elements/1.1/title' = 'Tanker Incident'
  'tracker:added' = '2015-07-13T22:17:17Z'
  'tracker:modified' = '731670'
  'rdf:type' = 'http://www.w3.org/2000/01/rdf-schema#Resource'
  'rdf:type' = 'http://www.semanticdesktop.org/ontologies/2007/01/19/nie#DataObject'
  'rdf:type' = 'http://www.semanticdesktop.org/ontologies/2007/01/19/nie#InformationElement'
  'rdf:type' = 'http://www.semanticdesktop.org/ontologies/2007/03/22/nfo#FileDataObject'
  'rdf:type' = 'http://www.semanticdesktop.org/ontologies/2007/03/22/nfo#Media'
  'rdf:type' = 'http://www.semanticdesktop.org/ontologies/2007/03/22/nfo#Audio'
  'rdf:type' = 'http://www.tracker-project.org/temp/nmm#MusicPiece'
  'nie:byteSize' = '23010863'
  'nie:dataSource' = 'http://www.tracker-project.org/ontologies/tracker#extractor-data-source'
  'nie:dataSource' = 'urn:nepomuk:datasource:9291a450-1d49-11de-8c30-0800200c9a66'
  'nie:isPartOf' = 'urn:uuid:1664f6ad-537a-4e78-dedb-5fc0c154fb84'
  'nie:url' = 'file:///Library/Music/iTunes/Konami/Metal%20Gear%20Solid%202%20Sons%20Of%20Liberty/2-01%20Tanker%20Incident.mp3'
  'nfo:belongsToContainer' = 'urn:uuid:1664f6ad-537a-4e78-dedb-5fc0c154fb84'
  'tracker:available' = 'true'
  'nie:comment' = ':: KMCA 144 ::'
  'nie:contentCreated' = '2002-01-01T00:00:00Z'
  'nie:informationElementDate' = '2002-01-01T00:00:00Z'
  'nie:isLogicalPartOf' = 'urn:album:Metal%20Gear%20Solid%202%20Sons%20Of%20Liberty'
  'nie:isLogicalPartOf' = 'urn:album-disc:Metal%20Gear%20Solid%202%20Sons%20Of%20Liberty:Disc2'
  'nie:isStoredAs' = 'urn:uuid:981b2ec3-b18a-8091-51e0-43d66bf32fae'
  'nie:mimeType' = 'audio/mpeg'
  'nie:title' = 'Tanker Incident'
  'nco:contributor' = 'urn:artist:Norihiko%20Hibino'
  'nfo:fileLastAccessed' = '2014-08-09T12:36:07Z'
  'nfo:fileLastModified' = '2014-08-09T12:36:08Z'
  'nfo:fileName' = '2-01 Tanker Incident.mp3'
  'nfo:fileSize' = '23010863'
  'nfo:averageBitrate' = '320000.0'
  'nfo:codec' = 'MPEG'
  'nfo:duration' = '567'
  'nfo:encodedBy' = 'iTunes v7.6.0.29'
  'nfo:genre' = 'Game'
  'nmm:dlnaMime' = 'audio/mpeg'
  'nmm:dlnaProfile' = 'MP3'
  'nfo:channels' = '2'
  'nfo:sampleRate' = '44100.0'
  'nmm:composer' = 'urn:artist:Norihiko%20Hibino'
  'nmm:musicAlbum' = 'urn:album:Metal%20Gear%20Solid%202%20Sons%20Of%20Liberty'
  'nmm:musicAlbumDisc' = 'urn:album-disc:Metal%20Gear%20Solid%202%20Sons%20Of%20Liberty:Disc2'
  'nmm:performer' = 'urn:artist:Norihiko%20Hibino'
  'nmm:trackNumber' = ‘1'

The query emmited looks like this

SELECT ?url WHERE { ?obj fts:match 'Hibino*' . ?obj nie:url ?url . FILTER(tracker:uri-is-descendant('file:///Library/Music/', ?url)) }

But that gives 0 results. It should give us back the file:// url for the file that contain the text in any metadata i guess?

tracker-sparql -q "SELECT * WHERE { ?obj fts:match 'Hibino*'  }"               
Results:
  urn:artist:Norihiko%20Hibino
  urn:artist:Harry%20Gregson-Williams,%20Norihiko%20Hibino
  urn:artist:Harry%20Gregson-Williams%20and%20Hibino%20Norihiko
  urn:artist:Nobuko%20Toda,%20Norihiko%20Hibino
  urn:artist:Nobuko%20Toda%20&%20Norihiko%20Hibino
  urn:artist:Harry%20Gregson-Williams%20&%20Norihiko%20Hibino

However, I’m not versed in sparql to suggest a patch.