summaryrefslogtreecommitdiff
path: root/src/plugins/lms
diff options
context:
space:
mode:
Diffstat (limited to 'src/plugins/lms')
-rw-r--r--src/plugins/lms/rygel-lms-album.vala12
-rw-r--r--src/plugins/lms/rygel-lms-albums.vala14
-rw-r--r--src/plugins/lms/rygel-lms-all-images.vala10
-rw-r--r--src/plugins/lms/rygel-lms-all-music.vala12
-rw-r--r--src/plugins/lms/rygel-lms-all-videos.vala10
-rw-r--r--src/plugins/lms/rygel-lms-artist.vala6
-rw-r--r--src/plugins/lms/rygel-lms-artists.vala6
-rw-r--r--src/plugins/lms/rygel-lms-image-year.vala10
-rw-r--r--src/plugins/lms/rygel-lms-image-years.vala6
9 files changed, 43 insertions, 43 deletions
diff --git a/src/plugins/lms/rygel-lms-album.vala b/src/plugins/lms/rygel-lms-album.vala
index 27476755..65808578 100644
--- a/src/plugins/lms/rygel-lms-album.vala
+++ b/src/plugins/lms/rygel-lms-album.vala
@@ -24,7 +24,7 @@ using Rygel;
using Sqlite;
public class Rygel.LMS.Album : Rygel.LMS.CategoryContainer {
- private static const string SQL_ALL_TEMPLATE =
+ private const string SQL_ALL_TEMPLATE =
"SELECT files.id, files.path, files.size, " +
"audios.title as title, audios.trackno, audios.length, " +
"audios.channels, audios.sampling_rate, audios.bitrate, " +
@@ -39,12 +39,12 @@ public class Rygel.LMS.Album : Rygel.LMS.CategoryContainer {
"WHERE dtime = 0 AND audios.id = files.id AND audios.album_id = %s " +
"LIMIT ? OFFSET ?;";
- private static const string SQL_COUNT_TEMPLATE =
+ private const string SQL_COUNT_TEMPLATE =
"SELECT COUNT(audios.id) " +
"FROM audios, files " +
"WHERE dtime = 0 AND audios.id = files.id AND audios.album_id = %s;";
- private static const string SQL_COUNT_WITH_FILTER_TEMPLATE =
+ private const string SQL_COUNT_WITH_FILTER_TEMPLATE =
"SELECT COUNT(audios.id), audios.title as title, " +
"audio_artists.name as artist, " +
"audio_albums.name " +
@@ -55,7 +55,7 @@ public class Rygel.LMS.Album : Rygel.LMS.CategoryContainer {
"ON audios.album_id = audio_albums.id " +
"WHERE dtime = 0 AND audios.id = files.id AND audios.album_id = %s;";
- private static const string SQL_FIND_OBJECT_TEMPLATE =
+ private const string SQL_FIND_OBJECT_TEMPLATE =
"SELECT files.id, files.path, files.size, " +
"audios.title, audios.trackno, audios.length, " +
"audios.channels, audios.sampling_rate, audios.bitrate, " +
@@ -70,7 +70,7 @@ public class Rygel.LMS.Album : Rygel.LMS.CategoryContainer {
"WHERE dtime = 0 AND files.id = ? AND audios.id = files.id " +
"AND audios.album_id = %s;";
- private static const string SQL_ADDED_TEMPLATE =
+ private const string SQL_ADDED_TEMPLATE =
"SELECT files.id, files.path, files.size, " +
"audios.title as title, audios.trackno, audios.length, " +
"audios.channels, audios.sampling_rate, audios.bitrate, " +
@@ -85,7 +85,7 @@ public class Rygel.LMS.Album : Rygel.LMS.CategoryContainer {
"WHERE dtime = 0 AND audios.id = files.id AND audios.album_id = %s " +
"AND update_id > ? AND update_id <= ?;";
- private static const string SQL_REMOVED_TEMPLATE =
+ private const string SQL_REMOVED_TEMPLATE =
"SELECT files.id, files.path, files.size, " +
"audios.title as title, audios.trackno, audios.length, " +
"audios.channels, audios.sampling_rate, audios.bitrate, " +
diff --git a/src/plugins/lms/rygel-lms-albums.vala b/src/plugins/lms/rygel-lms-albums.vala
index cf2fe51c..f76648b2 100644
--- a/src/plugins/lms/rygel-lms-albums.vala
+++ b/src/plugins/lms/rygel-lms-albums.vala
@@ -25,7 +25,7 @@ using Rygel.Database;
using Sqlite;
public class Rygel.LMS.Albums : Rygel.LMS.CategoryContainer {
- private static const string SQL_ALL =
+ private const string SQL_ALL =
"SELECT audio_albums.id, audio_albums.name as title, " +
"audio_artists.name as artist " +
"FROM audio_albums " +
@@ -33,7 +33,7 @@ public class Rygel.LMS.Albums : Rygel.LMS.CategoryContainer {
"ON audio_albums.artist_id = audio_artists.id " +
"LIMIT ? OFFSET ?;";
- private static const string SQL_ALL_WITH_FILTER_TEMPLATE =
+ private const string SQL_ALL_WITH_FILTER_TEMPLATE =
"SELECT audio_albums.id, audio_albums.name as title, " +
"audio_artists.name as artist " +
"FROM audio_albums " +
@@ -42,11 +42,11 @@ public class Rygel.LMS.Albums : Rygel.LMS.CategoryContainer {
"WHERE %s " +
"LIMIT ? OFFSET ?;";
- private static const string SQL_COUNT =
+ private const string SQL_COUNT =
"SELECT COUNT(audio_albums.id) " +
"FROM audio_albums;";
- private static const string SQL_COUNT_WITH_FILTER_TEMPLATE =
+ private const string SQL_COUNT_WITH_FILTER_TEMPLATE =
"SELECT COUNT(audio_albums.id), audio_albums.name as title, " +
"audio_artists.name as artist " +
"FROM audio_albums " +
@@ -55,7 +55,7 @@ public class Rygel.LMS.Albums : Rygel.LMS.CategoryContainer {
"WHERE %s;";
/* count songs inside albums */
- private static const string SQL_CHILD_COUNT_WITH_FILTER_TEMPLATE =
+ private const string SQL_CHILD_COUNT_WITH_FILTER_TEMPLATE =
"SELECT COUNT(audios.id), audios.title as title, " +
"audio_artists.name as artist " +
"FROM audios, files, audio_albums " +
@@ -64,7 +64,7 @@ public class Rygel.LMS.Albums : Rygel.LMS.CategoryContainer {
"WHERE dtime = 0 AND audios.id = files.id AND audios.album_id = audio_albums.id %s;";
/* select songs inside albums */
- private static const string SQL_CHILD_ALL_WITH_FILTER_TEMPLATE =
+ private const string SQL_CHILD_ALL_WITH_FILTER_TEMPLATE =
"SELECT files.id, files.path, files.size, " +
"audios.title as title, audios.trackno, audios.length, audios.channels, audios.sampling_rate, audios.bitrate, audios.dlna_profile, audios.dlna_mime, " +
"audio_artists.name as artist, " +
@@ -76,7 +76,7 @@ public class Rygel.LMS.Albums : Rygel.LMS.CategoryContainer {
"LIMIT ? OFFSET ?;";
- private static const string SQL_FIND_OBJECT =
+ private const string SQL_FIND_OBJECT =
"SELECT audio_albums.id, audio_albums.name " +
"FROM audio_albums " +
"WHERE audio_albums.id = ?;";
diff --git a/src/plugins/lms/rygel-lms-all-images.vala b/src/plugins/lms/rygel-lms-all-images.vala
index 87505a7c..e1da656d 100644
--- a/src/plugins/lms/rygel-lms-all-images.vala
+++ b/src/plugins/lms/rygel-lms-all-images.vala
@@ -24,32 +24,32 @@ using Rygel;
using Sqlite;
public class Rygel.LMS.AllImages : Rygel.LMS.CategoryContainer {
- private static const string SQL_ALL =
+ private const string SQL_ALL =
"SELECT images.id, title, artist, date, width, height, path, size, " +
"dlna_profile, dlna_mime " +
"FROM images, files " +
"WHERE dtime = 0 AND images.id = files.id " +
"LIMIT ? OFFSET ?;";
- private static const string SQL_COUNT =
+ private const string SQL_COUNT =
"SELECT count(images.id) " +
"FROM images, files " +
"WHERE dtime = 0 AND images.id = files.id;";
- private static const string SQL_FIND_OBJECT =
+ private const string SQL_FIND_OBJECT =
"SELECT images.id, title, artist, date, width, height, path, size, " +
"dlna_profile, dlna_mime " +
"FROM images, files " +
"WHERE dtime = 0 AND files.id = ? AND images.id = files.id;";
- private static const string SQL_ADDED =
+ private const string SQL_ADDED =
"SELECT images.id, title, artist, date, width, height, path, size, " +
"dlna_profile, dlna_mime " +
"FROM images, files " +
"WHERE dtime = 0 AND images.id = files.id " +
"AND update_id > ? AND update_id <= ?;";
- private static const string SQL_REMOVED =
+ private const string SQL_REMOVED =
"SELECT images.id, title, artist, date, width, height, path, size, " +
"dlna_profile, dlna_mime " +
"FROM images, files " +
diff --git a/src/plugins/lms/rygel-lms-all-music.vala b/src/plugins/lms/rygel-lms-all-music.vala
index 23fd8b27..f99b736d 100644
--- a/src/plugins/lms/rygel-lms-all-music.vala
+++ b/src/plugins/lms/rygel-lms-all-music.vala
@@ -24,7 +24,7 @@ using Rygel;
using Sqlite;
public class Rygel.LMS.AllMusic : Rygel.LMS.CategoryContainer {
- private static const string SQL_ALL_TEMPLATE =
+ private const string SQL_ALL_TEMPLATE =
"SELECT files.id, files.path, files.size, " +
"audios.title as title, audios.trackno, audios.length, " +
"audios.channels, audios.sampling_rate, audios.bitrate, " +
@@ -43,12 +43,12 @@ public class Rygel.LMS.AllMusic : Rygel.LMS.CategoryContainer {
"WHERE dtime = 0 AND audios.id = files.id %s " +
"LIMIT ? OFFSET ?;";
- private static const string SQL_COUNT =
+ private const string SQL_COUNT =
"SELECT COUNT(audios.id) " +
"FROM audios, files " +
"WHERE dtime = 0 AND audios.id = files.id;";
- private static const string SQL_COUNT_WITH_FILTER_TEMPLATE =
+ private const string SQL_COUNT_WITH_FILTER_TEMPLATE =
"SELECT COUNT(audios.id), audios.title as title, " +
"audio_artists.name as artist " +
"FROM audios, files " +
@@ -56,7 +56,7 @@ public class Rygel.LMS.AllMusic : Rygel.LMS.CategoryContainer {
"ON audios.artist_id = audio_artists.id " +
"WHERE dtime = 0 AND audios.id = files.id %s;";
- private static const string SQL_FIND_OBJECT =
+ private const string SQL_FIND_OBJECT =
"SELECT files.id, files.path, files.size, " +
"audios.title, audios.trackno, audios.length, " +
"audios.channels, audios.sampling_rate, audios.bitrate, " +
@@ -74,7 +74,7 @@ public class Rygel.LMS.AllMusic : Rygel.LMS.CategoryContainer {
"ON audios.genre_id = audio_genres.id " +
"WHERE dtime = 0 AND files.id = ? AND audios.id = files.id;";
- private static const string SQL_ADDED =
+ private const string SQL_ADDED =
"SELECT files.id, files.path, files.size, " +
"audios.title as title, audios.trackno, audios.length, " +
"audios.channels, audios.sampling_rate, audios.bitrate, " +
@@ -93,7 +93,7 @@ public class Rygel.LMS.AllMusic : Rygel.LMS.CategoryContainer {
"WHERE dtime = 0 AND audios.id = files.id " +
"AND update_id > ? AND update_id <= ?;";
- private static const string SQL_REMOVED =
+ private const string SQL_REMOVED =
"SELECT files.id, files.path, files.size, " +
"audios.title as title, audios.trackno, audios.length, " +
"audios.channels, audios.sampling_rate, audios.bitrate, " +
diff --git a/src/plugins/lms/rygel-lms-all-videos.vala b/src/plugins/lms/rygel-lms-all-videos.vala
index 42723d48..3721ac28 100644
--- a/src/plugins/lms/rygel-lms-all-videos.vala
+++ b/src/plugins/lms/rygel-lms-all-videos.vala
@@ -25,29 +25,29 @@ using Rygel.Database;
using Sqlite;
public class Rygel.LMS.AllVideos : Rygel.LMS.CategoryContainer {
- private static const string SQL_ALL =
+ private const string SQL_ALL =
"SELECT videos.id, title, artist, length, path, mtime, size, dlna_profile, dlna_mime " +
"FROM videos, files " +
"WHERE dtime = 0 AND videos.id = files.id " +
"LIMIT ? OFFSET ?;";
- private static const string SQL_COUNT =
+ private const string SQL_COUNT =
"SELECT count(videos.id) " +
"FROM videos, files " +
"WHERE dtime = 0 AND videos.id = files.id;";
- private static const string SQL_FIND_OBJECT =
+ private const string SQL_FIND_OBJECT =
"SELECT videos.id, title, artist, length, path, mtime, size, dlna_profile, dlna_mime " +
"FROM videos, files " +
"WHERE dtime = 0 AND files.id = ? AND videos.id = files.id;";
- private static const string SQL_ADDED =
+ private const string SQL_ADDED =
"SELECT videos.id, title, artist, length, path, mtime, size, dlna_profile, dlna_mime " +
"FROM videos, files " +
"WHERE dtime = 0 AND videos.id = files.id " +
"AND update_id > ? AND update_id <= ?;";
- private static const string SQL_REMOVED =
+ private const string SQL_REMOVED =
"SELECT videos.id, title, artist, length, path, mtime, size, dlna_profile, dlna_mime " +
"FROM videos, files " +
"WHERE dtime <> 0 AND videos.id = files.id " +
diff --git a/src/plugins/lms/rygel-lms-artist.vala b/src/plugins/lms/rygel-lms-artist.vala
index 90ac2848..0e8059a3 100644
--- a/src/plugins/lms/rygel-lms-artist.vala
+++ b/src/plugins/lms/rygel-lms-artist.vala
@@ -24,18 +24,18 @@ using Rygel;
using Sqlite;
public class Rygel.LMS.Artist : Rygel.LMS.CategoryContainer {
- private static const string SQL_ALL_TEMPLATE =
+ private const string SQL_ALL_TEMPLATE =
"SELECT audio_albums.id, audio_albums.name " +
"FROM audio_albums " +
"WHERE audio_albums.artist_id = %s " +
"LIMIT ? OFFSET ?;";
- private static const string SQL_COUNT_TEMPLATE =
+ private const string SQL_COUNT_TEMPLATE =
"SELECT COUNT(audio_albums.id) " +
"FROM audio_albums " +
"WHERE audio_albums.artist_id = %s";
- private static const string SQL_FIND_OBJECT_TEMPLATE =
+ private const string SQL_FIND_OBJECT_TEMPLATE =
"SELECT audio_albums.id, audio_albums.name " +
"FROM audio_albums " +
"WHERE audio_albums.id = ? AND audio_albums.artist_id = %s;";
diff --git a/src/plugins/lms/rygel-lms-artists.vala b/src/plugins/lms/rygel-lms-artists.vala
index 1049fba9..be715958 100644
--- a/src/plugins/lms/rygel-lms-artists.vala
+++ b/src/plugins/lms/rygel-lms-artists.vala
@@ -24,16 +24,16 @@ using Rygel;
using Sqlite;
public class Rygel.LMS.Artists : Rygel.LMS.CategoryContainer {
- private static const string SQL_ALL =
+ private const string SQL_ALL =
"SELECT audio_artists.id, audio_artists.name " +
"FROM audio_artists " +
"LIMIT ? OFFSET ?;";
- private static const string SQL_COUNT =
+ private const string SQL_COUNT =
"SELECT COUNT(audio_artists.id) " +
"FROM audio_artists;";
- private static const string SQL_FIND_OBJECT =
+ private const string SQL_FIND_OBJECT =
"SELECT audio_artists.id, audio_artists.name " +
"FROM audio_artists " +
"WHERE audio_artists.id = ?;";
diff --git a/src/plugins/lms/rygel-lms-image-year.vala b/src/plugins/lms/rygel-lms-image-year.vala
index 2b21cf03..a3761114 100644
--- a/src/plugins/lms/rygel-lms-image-year.vala
+++ b/src/plugins/lms/rygel-lms-image-year.vala
@@ -24,32 +24,32 @@ using Rygel;
using Sqlite;
public class Rygel.LMS.ImageYear : Rygel.LMS.CategoryContainer {
- private static const string SQL_ALL_TEMPLATE =
+ private const string SQL_ALL_TEMPLATE =
"SELECT images.id, title, artist, date, width, height, path, size, " +
"dlna_profile, dlna_mime, strftime('%Y', date, 'unixepoch') as year " +
"FROM images, files " +
"WHERE dtime = 0 AND images.id = files.id AND year = '%s' " +
"LIMIT ? OFFSET ?;";
- private static const string SQL_COUNT_TEMPLATE =
+ private const string SQL_COUNT_TEMPLATE =
"SELECT count(images.id), strftime('%Y', date, 'unixepoch') as year " +
"FROM images, files " +
"WHERE dtime = 0 AND images.id = files.id AND year = '%s';";
- private static const string SQL_FIND_OBJECT_TEMPLATE =
+ private const string SQL_FIND_OBJECT_TEMPLATE =
"SELECT images.id, title, artist, date, width, height, path, size, " +
"dlna_profile, dlna_mime, strftime('%Y', date, 'unixepoch') as year " +
"FROM images, files " +
"WHERE dtime = 0 AND files.id = ? AND images.id = files.id AND year = '%s';";
- private static const string SQL_ADDED_TEMPLATE =
+ private const string SQL_ADDED_TEMPLATE =
"SELECT images.id, title, artist, date, width, height, path, size, " +
"dlna_profile, dlna_mime, strftime('%Y', date, 'unixepoch') as year " +
"FROM images, files " +
"WHERE dtime = 0 AND images.id = files.id AND year = '%s' " +
"AND update_id > ? AND update_id <= ?;";
- private static const string SQL_REMOVED_TEMPLATE =
+ private const string SQL_REMOVED_TEMPLATE =
"SELECT images.id, title, artist, date, width, height, path, size, " +
"dlna_profile, dlna_mime, strftime('%Y', date, 'unixepoch') as year " +
"FROM images, files " +
diff --git a/src/plugins/lms/rygel-lms-image-years.vala b/src/plugins/lms/rygel-lms-image-years.vala
index 9feb1ed5..501a6f48 100644
--- a/src/plugins/lms/rygel-lms-image-years.vala
+++ b/src/plugins/lms/rygel-lms-image-years.vala
@@ -24,12 +24,12 @@ using Rygel;
using Sqlite;
public class Rygel.LMS.ImageYears : Rygel.LMS.CategoryContainer {
- private static const string SQL_ALL =
+ private const string SQL_ALL =
"SELECT DISTINCT(strftime('%Y', images.date, 'unixepoch')) as year " +
"FROM images " +
"LIMIT ? OFFSET ?;";
- private static const string SQL_COUNT =
+ private const string SQL_COUNT =
"SELECT COUNT(DISTINCT(strftime('%Y', images.date, 'unixepoch'))) " +
"FROM images;";
@@ -37,7 +37,7 @@ public class Rygel.LMS.ImageYears : Rygel.LMS.CategoryContainer {
/* Casting the year is a workaround so we can keep using
* Database.find_object() without making the argument a variant or
* something like it */
- private static const string SQL_FIND_OBJECT =
+ private const string SQL_FIND_OBJECT =
"SELECT strftime('%Y', images.date, 'unixepoch') as year " +
"FROM images " +
"WHERE year = CAST(? AS TEXT)";
View Lorry Controller Status