ViewVC Help
View File | Revision Log | Show Annotations | Download File | View Changeset | Root Listing
root/repos/DecentralizedMedia/Library.cpp
(Generate patch)

Comparing DecentralizedMedia/Library.cpp (file contents):
Revision 549 by douglas, 2005-07-04T21:28:02-07:00 vs.
Revision 550 by douglas, 2005-07-04T23:37:40-07:00

# Line 17 | Line 17 | Library::Library(const _R<dbi::Connectio
17  
18   _L<cse::String> Library::GetArtists() const
19   {
20 <        _R<dbi::ResultSet> artists_(connection->Execute(_B("SELECT DISTINCT artist FROM files WHERE live = TRUE")));
20 >        _R<dbi::ResultSet> artists_(connection->Execute(_B("SELECT DISTINCT artist FROM files WHERE live = TRUE ORDER BY artist")));
21          _L<cse::String> artists;
22  
23          while (artists_->MoveNext())
# Line 28 | Line 28 | _L<cse::String> Library::GetArtists() co
28  
29   _L<cse::String> Library::GetTitles() const
30   {
31 <        _R<dbi::ResultSet> titles_(connection->Execute(_B("SELECT DISTINCT title FROM files WHERE live = TRUE")));
31 >        _R<dbi::ResultSet> titles_(connection->Execute(_B("SELECT DISTINCT title FROM files WHERE live = TRUE ORDER BY title")));
32          _L<cse::String> titles;
33  
34          while (titles_->MoveNext())
# Line 39 | Line 39 | _L<cse::String> Library::GetTitles() con
39  
40   _L<cse::String> Library::GetAlbums() const
41   {
42 <        _R<dbi::ResultSet> albums_(connection->Execute(_B("SELECT DISTINCT album FROM files WHERE live = TRUE")));
42 >        _R<dbi::ResultSet> albums_(connection->Execute(_B("SELECT DISTINCT album FROM files WHERE live = TRUE ORDER BY album")));
43          _L<cse::String> albums;
44  
45          while (albums_->MoveNext())
# Line 50 | Line 50 | _L<cse::String> Library::GetAlbums() con
50  
51   _L<cse::String> Library::GetGenres() const
52   {
53 <        _R<dbi::ResultSet> genres_(connection->Execute(_B("SELECT DISTINCT album FROM files WHERE live = TRUE")));
53 >        _R<dbi::ResultSet> genres_(connection->Execute(_B("SELECT DISTINCT genre FROM files WHERE live = TRUE ORDER BY genre")));
54          _L<cse::String> genres;
55  
56          while (genres_->MoveNext())
# Line 61 | Line 61 | _L<cse::String> Library::GetGenres() con
61  
62   _L<MediaFolder> Library::GetFolders() const
63   {
64 <        _R<dbi::ResultSet> roots(connection->Execute(_B("SELECT DISTINCT root FROM files WHERE live = TRUE")));
64 >        _R<dbi::ResultSet> roots(connection->Execute(_B("SELECT DISTINCT root FROM files WHERE live = TRUE ORDER By root")));
65          _L<MediaFolder> folders;
66  
67          while (roots->MoveNext())

Diff Legend

– Removed lines
+ Added lines
< Changed lines
> Changed lines