[gnome-music] query: update tracker queries to sparql 1.1 syntax
- From: Felipe Borges <felipeborges src gnome org>
- To: commits-list gnome org
- Cc:
- Subject: [gnome-music] query: update tracker queries to sparql 1.1 syntax
- Date: Thu, 28 Jan 2016 14:11:42 +0000 (UTC)
commit 88b13234e0450149bf70f0d524e0ad1a1a4fee6d
Author: Marinus Schraal <fosero gmail com>
Date: Wed Jan 27 10:36:00 2016 -0200
query: update tracker queries to sparql 1.1 syntax
Following bug #761171 & #761168 apply spec correct
sparql syntax for the AS statement in tracker queries.
https://bugzilla.gnome.org/show_bug.cgi?id=761173
gnomemusic/query.py | 70 +++++++++++++++++++++++++-------------------------
1 files changed, 35 insertions(+), 35 deletions(-)
---
diff --git a/gnomemusic/query.py b/gnomemusic/query.py
index 7660079..b882fb7 100644
--- a/gnomemusic/query.py
+++ b/gnomemusic/query.py
@@ -103,7 +103,7 @@ class Query():
def all_songs_count():
query = '''
SELECT
- COUNT(?song) AS childcount
+ COUNT(?song) AS ?childcount
{
?song a nmm:MusicPiece ;
a nfo:FileDataObject ;
@@ -157,7 +157,7 @@ class Query():
query = '''
SELECT
rdf:type(?album)
- tracker:id(?album) AS id
+ tracker:id(?album) AS ?id
?author
?title
tracker:coalesce((SELECT GROUP_CONCAT(nmm:artistName(?albumArtist), ',') { ?album nmm:albumArtist
?albumArtist }),
@@ -229,9 +229,9 @@ class Query():
query = '''
SELECT DISTINCT
rdf:type(?playlist)
- tracker:id(?playlist) AS id
- nie:title(?playlist) AS title
- nfo:entryCounter(?playlist) AS childcount
+ tracker:id(?playlist) AS ?id
+ nie:title(?playlist) AS ?title
+ nfo:entryCounter(?playlist) AS ?childcount
{
%(where_clause)s
?playlist a nmm:Playlist .
@@ -254,13 +254,13 @@ class Query():
query = '''
SELECT DISTINCT
rdf:type(?song)
- tracker:id(?song) AS id
- nie:url(?song) AS url
- nie:title(?song) AS title
- nmm:artistName(nmm:performer(?song)) AS artist
- nie:title(nmm:musicAlbum(?song)) AS album
- nfo:duration(?song) AS duration
- IF(bound(?tag), 'truth!', '') AS lyrics
+ tracker:id(?song) AS ?id
+ nie:url(?song) AS ?url
+ nie:title(?song) AS ?title
+ nmm:artistName(nmm:performer(?song)) AS ?artist
+ nie:title(nmm:musicAlbum(?song)) AS ?album
+ nfo:duration(?song) AS ?duration
+ IF(bound(?tag), 'truth!', '') AS ?lyrics
WHERE {
?song a nmm:MusicPiece ;
a nfo:FileDataObject ;
@@ -286,13 +286,13 @@ class Query():
query = '''
SELECT
rdf:type(?song)
- tracker:id(?entry) AS id
- nie:url(?song) AS url
- nie:title(?song) AS title
- nmm:artistName(nmm:performer(?song)) AS artist
- nie:title(nmm:musicAlbum(?song)) AS album
- nfo:duration(?song) AS duration
- IF(bound(?tag), 'truth!', '') AS lyrics
+ tracker:id(?entry) AS ?id
+ nie:url(?song) AS ?url
+ nie:title(?song) AS ?title
+ nmm:artistName(nmm:performer(?song)) AS ?artist
+ nie:title(nmm:musicAlbum(?song)) AS ?album
+ nfo:duration(?song) AS ?duration
+ IF(bound(?tag), 'truth!', '') AS ?lyrics
WHERE {
?playlist a nmm:Playlist ;
a nfo:MediaList ;
@@ -333,7 +333,7 @@ class Query():
query = """
SELECT DISTINCT
rdf:type(?album)
- tracker:id(?album) AS id
+ tracker:id(?album) AS ?id
(
SELECT
nmm:artistName(?artist)
@@ -341,9 +341,9 @@ class Query():
?album nmm:albumArtist ?artist
}
LIMIT 1
- ) AS artist
- nie:title(?album) AS title
- nie:title(?album) AS album
+ ) AS ?artist
+ nie:title(?album) AS ?title
+ nie:title(?album) AS ?album
WHERE {
?album a nmm:MusicAlbum .
FILTER (
@@ -361,7 +361,7 @@ class Query():
query = """
SELECT DISTINCT
rdf:type(?album)
- tracker:id(?album) AS id
+ tracker:id(?album) AS ?id
(
SELECT
nmm:artistName(?artist)
@@ -369,9 +369,9 @@ class Query():
?album nmm:albumArtist ?artist
}
LIMIT 1
- ) AS artist
- nie:title(?album) AS title
- nie:title(?album) AS album
+ ) AS ?artist
+ nie:title(?album) AS ?title
+ nie:title(?album) AS ?album
WHERE {
?song a nmm:MusicPiece ;
nmm:musicAlbum ?album .
@@ -404,7 +404,7 @@ class Query():
INSERT OR REPLACE { ?song nie:usageCounter ?playcount . }
WHERE {
SELECT
- IF(bound(?usage), (?usage + 1), 1) AS playcount
+ IF(bound(?usage), (?usage + 1), 1) AS ?playcount
?song
WHERE {
?song a nmm:MusicPiece .
@@ -532,7 +532,7 @@ class Query():
WHERE {
SELECT
?playlist
- (?counter + 1) AS position
+ (?counter + 1) AS ?position
WHERE {
?playlist
a nmm:Playlist ;
@@ -559,7 +559,7 @@ class Query():
WHERE {
SELECT
?entry
- (?old_position - 1) AS position
+ (?old_position - 1) AS ?position
WHERE {
?entry
a nfo:MediaFileListEntry ;
@@ -593,7 +593,7 @@ class Query():
WHERE {
SELECT
?playlist
- (?counter - 1) AS new_counter
+ (?counter - 1) AS ?new_counter
WHERE {
?playlist
a nmm:Playlist ;
@@ -653,7 +653,7 @@ class Query():
def get_playlist_with_urn(playlist_urn):
query = """
SELECT DISTINCT
- tracker:id(<%(playlist_urn)s>) AS id
+ tracker:id(<%(playlist_urn)s>) AS ?id
WHERE {
<%(playlist_urn)s> a nmm:Playlist
}
@@ -670,7 +670,7 @@ class Query():
def get_playlist_song_with_urn(entry_urn):
query = """
SELECT DISTINCT
- tracker:id(<%(entry_urn)s>) AS id
+ tracker:id(<%(entry_urn)s>) AS ?id
WHERE {
<%(entry_urn)s> a nfo:MediaFileListEntry
}
@@ -835,7 +835,7 @@ class Query():
query = '''
{
SELECT DISTINCT
- nmm:musicAlbum(?song) AS album
+ nmm:musicAlbum(?song) AS ?album
{
?song a nmm:MusicPiece .
BIND(tracker:normalize(nie:title(nmm:musicAlbum(?song)), 'nfkd') AS ?match1) .
@@ -882,7 +882,7 @@ class Query():
query = '''
{
SELECT DISTINCT
- nmm:musicAlbum(?song) AS album
+ nmm:musicAlbum(?song) AS ?album
{
?song a nmm:MusicPiece .
BIND(tracker:normalize(nie:title(nmm:musicAlbum(?song)), 'nfkd') AS ?match1) .
[
Date Prev][
Date Next] [
Thread Prev][
Thread Next]
[
Thread Index]
[
Date Index]
[
Author Index]