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
|
/*
* 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.AllVideos : Rygel.LMS.CategoryContainer {
private static const string SQL_ALL =
"SELECT videos.id, title, artist, length, path, dtime, size, dlna_profile, dlna_mime " +
"FROM videos, files " +
"WHERE videos.id = files.id " +
"LIMIT ? OFFSET ?;";
private static const string SQL_COUNT =
"SELECT count(videos.id) " +
"FROM videos, files " +
"WHERE videos.id = files.id;";
private static const string SQL_FIND_OBJECT =
"SELECT videos.id, title, artist, length, path, dtime, size, dlna_profile, dlna_mime " +
"FROM videos, files " +
"WHERE files.id = ? AND videos.id = files.id;";
protected override MediaObject? object_from_statement (Statement statement) {
var id = statement.column_int(0);
var mime_type = statement.column_text(8);
var path = statement.column_text(4);
var file = File.new_for_path(path);
/* TODO: Temporary code to extract the MIME TYPE. LMS does not seem
to compute the mime type of videos. Don't know why. */
if (mime_type == null || mime_type.length == 0) {
try {
FileInfo info = file.query_info(FileAttribute.STANDARD_CONTENT_TYPE,
FileQueryInfoFlags.NONE, null);
mime_type = info.get_content_type();
} catch {}
}
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(1);
var video = new VideoItem(this.build_child_id (id), this, title);
video.creator = statement.column_text(2);
video.duration = statement.column_int(3);
TimeVal tv = { (long) statement.column_int(5), (long) 0 };
video.date = tv.to_iso8601 ();
video.size = statement.column_int(6);
video.dlna_profile = statement.column_text(7);
video.mime_type = mime_type;
video.add_uri (file.get_uri ());
return video;
}
public AllVideos (string id, MediaContainer parent, string title, LMS.Database lms_db){
base (id,
parent,
title,
lms_db,
AllVideos.SQL_ALL,
AllVideos.SQL_FIND_OBJECT,
AllVideos.SQL_COUNT);
}
}
|