6 |
|
|
7 |
|
#include "MediaFolder.hpp" |
8 |
|
|
9 |
+ |
#include <menes-dbi/resultset.hpp> |
10 |
+ |
|
11 |
|
MediaFolder::MediaFolder(_H<dbi::Connection>& connection, const api::Path& path) : connection(connection), path(path) |
12 |
|
{ |
13 |
|
// XXX: implement |
15 |
|
|
16 |
|
_L<MediaFile> MediaFolder::GetFiles() const |
17 |
|
{ |
18 |
< |
_H<dbi::ResultSet> paths(connection->Parse(_B("SELECT path FROM files WHERE folder = ?"))->Execute(path.GetPath())); |
18 |
> |
_H<dbi::ResultSet> paths(connection->Parse(_B("SELECT path FROM files WHERE live = TRUE AND folder = ?"))->Execute(path.GetPath())); |
19 |
|
_L<MediaFile> files; |
20 |
|
|
21 |
|
while (paths->MoveNext()) |
26 |
|
|
27 |
|
_L<MediaFolder> MediaFolder::GetFolders() const |
28 |
|
{ |
29 |
< |
_H<dbi::ResultSet> paths(connection->Parse(_B("SELECT path FROM folders WHERE folder = ?"))->Execute(path.GetPath())); |
29 |
> |
_H<dbi::ResultSet> paths(connection->Parse(_B("SELECT path FROM folders WHERE live = TRUE AND folder = ?"))->Execute(path.GetPath())); |
30 |
|
_L<MediaFolder> folders; |
31 |
|
|
32 |
|
while (paths->MoveNext()) |