[gnome-music] query: Replace uri-is-descendant with STRSTARTS
- From: Marinus Schraal <mschraal src gnome org>
- To: commits-list gnome org
- Cc:
- Subject: [gnome-music] query: Replace uri-is-descendant with STRSTARTS
- Date: Sun, 9 Oct 2016 22:41:55 +0000 (UTC)
commit 79956afb70f7804c2136fde8b05653f9c25b3fdd
Author: Marinus Schraal <mschraal src gnome org>
Date: Sun Oct 9 20:15:39 2016 +0200
query: Replace uri-is-descendant with STRSTARTS
Use the same method in all queries and prefer STRSTARTS as commented on
in bug https://bugzilla.gnome.org/show_bug.cgi?id=765476#c7 .
gnomemusic/query.py | 42 ++++++++++--------------------------------
1 files changed, 10 insertions(+), 32 deletions(-)
---
diff --git a/gnomemusic/query.py b/gnomemusic/query.py
index 37cd51a..b688341 100644
--- a/gnomemusic/query.py
+++ b/gnomemusic/query.py
@@ -393,9 +393,7 @@ class Query():
tracker:id(?song) = %(song_id)s
)
FILTER (
- tracker:uri-is-descendant(
- '%(music_dir)s', nie:url(?song)
- )
+ STRSTARTS(nie:url(?song), '%(music_dir)s')
)
FILTER (
NOT EXISTS {
@@ -723,11 +721,7 @@ class Query():
nie:usageCounter ?count ;
nie:isStoredAs ?as .
?as nie:url ?url .
- FILTER (
- tracker:uri-is-descendant(
- '%(music_dir)s', ?url
- )
- )
+ FILTER ( STRSTARTS(?url, '%(music_dir)s') )
} ORDER BY DESC(?count) LIMIT 50
""".replace('\n', ' ').strip() % {
'music_dir': Query.MUSIC_URI
@@ -743,12 +737,8 @@ class Query():
?song a nmm:MusicPiece ;
nie:isStoredAs ?as .
?as nie:url ?url .
- FILTER ( NOT EXISTS { ?song nie:usageCounter ?count .} )
- FILTER (
- tracker:uri-is-descendant(
- '%(music_dir)s', ?url
- )
- )
+ FILTER ( NOT EXISTS { ?song nie:usageCounter ?count .}
+ && STRSTARTS(?url, '%(music_dir)s') )
} ORDER BY nfo:fileLastAccessed(?song) LIMIT 50
""".replace('\n', ' ').strip() % {
'music_dir': Query.MUSIC_URI
@@ -773,13 +763,9 @@ class Query():
nie:isStoredAs ?as ;
nfo:fileLastAccessed ?last_played .
?as nie:url ?url .
- FILTER ( ?last_played > '%(compare_date)s'^^xsd:dateTime )
- FILTER ( EXISTS { ?song nie:usageCounter ?count .} )
- FILTER (
- tracker:uri-is-descendant(
- '%(music_dir)s', ?url
- )
- )
+ FILTER ( ?last_played > '%(compare_date)s'^^xsd:dateTime
+ && EXISTS { ?song nie:usageCounter ?count .}
+ && STRSTARTS(?url, '%(music_dir)s') )
} ORDER BY DESC(?last_played) LIMIT 50
""".replace('\n', ' ').strip() % {
'compare_date': compare_date,
@@ -806,12 +792,8 @@ class Query():
nie:isStoredAs ?as ;
tracker:added ?added .
?as nie:url ?url .
- FILTER ( ?added > '%(compare_date)s'^^xsd:dateTime )
- FILTER (
- tracker:uri-is-descendant(
- '%(music_dir)s', ?url
- )
- )
+ FILTER ( ?added > '%(compare_date)s'^^xsd:dateTime
+ && STRSTARTS(?url, '%(music_dir)s') )
} ORDER BY DESC(?added) LIMIT 50
""".replace('\n', ' ').strip() % {
'compare_date': compare_date,
@@ -829,11 +811,7 @@ class Query():
nie:isStoredAs ?as ;
nao:hasTag nao:predefined-tag-favorite .
?as nie:url ?url .
- FILTER (
- tracker:uri-is-descendant(
- '%(music_dir)s', ?url
- )
- )
+ FILTER ( STRSTARTS(?url, '%(music_dir)s') )
} ORDER BY DESC(tracker:added(?song))
""".replace('\n', ' ').strip() % {
'music_dir': Query.MUSIC_URI,
[
Date Prev][
Date Next] [
Thread Prev][
Thread Next]
[
Thread Index]
[
Date Index]
[
Author Index]