1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
|
/*
* Copyright (C) 2013 Intel Corporation.
*
* Author: Jussi Kukkonen <jussi.kukkonen@intel.com>
*
* This file is part of Rygel.
*
* Rygel is free software; you can redistribute it and/or modify
* it under the terms of the GNU Lesser General Public License as published by
* the Free Software Foundation; either version 2 of the License, or
* (at your option) any later version.
*
* Rygel is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU Lesser General Public License for more details.
*
* You should have received a copy of the GNU Lesser General Public License
* along with this program; if not, write to the Free Software Foundation,
* Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA.
*/
using Rygel;
using Sqlite;
public class Rygel.LMS.AllMusic : Rygel.LMS.CategoryContainer {
private static 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, audios.dlna_profile, audios.dlna_mime, " +
"audio_artists.name as artist, " +
"audio_albums.name " +
"FROM audios, files " +
"LEFT JOIN audio_artists " +
"ON audios.artist_id = audio_artists.id " +
"LEFT JOIN audio_albums " +
"ON audios.album_id = audio_albums.id " +
"WHERE audios.id = files.id %s " +
"LIMIT ? OFFSET ?;";
private static const string SQL_COUNT =
"SELECT COUNT(audios.id) " +
"FROM audios, files " +
"WHERE audios.id = files.id;";
private static const string SQL_COUNT_WITH_FILTER_TEMPLATE =
"SELECT COUNT(audios.id), audios.title as title, " +
"audio_artists.name as artist " +
"FROM audios, files " +
"LEFT JOIN audio_artists " +
"ON audios.artist_id = audio_artists.id " +
"WHERE audios.id = files.id %s;";
private static 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, audios.dlna_profile, audios.dlna_mime, " +
"audio_artists.name, " +
"audio_albums.name " +
"FROM audios, files " +
"LEFT JOIN audio_artists " +
"ON audios.artist_id = audio_artists.id " +
"LEFT JOIN audio_albums " +
"ON audios.album_id = audio_albums.id " +
"WHERE files.id = ? AND audios.id = files.id;";
protected override string get_sql_all_with_filter (string filter) {
if (filter.length == 0) {
return this.sql_all;
}
var filter_str = "AND %s".printf (filter);
return (AllMusic.SQL_ALL_TEMPLATE.printf (filter_str));
}
protected override string get_sql_count_with_filter (string filter) {
if (filter.length == 0) {
return this.sql_count;
}
var filter_str = "AND %s".printf (filter);
return (AllMusic.SQL_COUNT_WITH_FILTER_TEMPLATE.printf (filter_str));
}
protected override MediaObject? object_from_statement (Statement statement) {
var id = statement.column_int (0);
var path = statement.column_text (1);
var mime_type = statement.column_text(10);
if (mime_type == null || mime_type.length == 0) {
/* TODO is this correct? */
debug ("Skipping music item %d (%s) with no MIME type",
id,
path);
return null;
}
var title = statement.column_text(3);
var song_id = this.build_child_id (id);
var song = new MusicItem (song_id, this, title);
song.size = statement.column_int(2);
song.track_number = statement.column_int(4);
song.duration = statement.column_int(5);
song.channels = statement.column_int(6);
song.sample_freq = statement.column_int(7);
song.bitrate = statement.column_int(8);
song.dlna_profile = statement.column_text(9);
song.mime_type = mime_type;
song.artist = statement.column_text(11);
song.album = statement.column_text(12);
File file = File.new_for_path (path);
song.add_uri (file.get_uri ());
return song;
}
public AllMusic (MediaContainer parent, LMS.Database lms_db) {
base("all",
parent,
_("All"),
lms_db,
AllMusic.SQL_ALL_TEMPLATE.printf (""),
AllMusic.SQL_FIND_OBJECT,
AllMusic.SQL_COUNT);
}
}
|