// Library
//
// Douglas Thrift
//
// $Id$

#include <menes/standard.hh>

#include <menes-dbi/resultset.hpp>

#include "Library.hpp"

Library::Library(const _R<dbi::Connection>& connection) : connection(connection)
{
	connection->Execute(_B("UPDATE files SET live = FALSE"));
}

_L<cse::String> Library::GetArtists() const
{
	_R<dbi::ResultSet> artists_(connection->Execute(_B("SELECT DISTINCT artist FROM files WHERE live = TRUE")));
	_L<cse::String> artists;

	while (artists_->MoveNext())
		artists.InsertLast(artists_->GetString(_B("artist")));

	return artists;
}

_L<cse::String> Library::GetTitles() const
{
	_R<dbi::ResultSet> titles_(connection->Execute(_B("SELECT DISTINCT title FROM files WHERE live = TRUE")));
	_L<cse::String> titles;

	while (titles_->MoveNext())
		titles.InsertLast(titles_->GetString(_B("title")));

	return titles;
}

_L<cse::String> Library::GetAlbums() const
{
	_R<dbi::ResultSet> albums_(connection->Execute(_B("SELECT DISTINCT album FROM files WHERE live = TRUE")));
	_L<cse::String> albums;

	while (albums_->MoveNext())
		albums.InsertLast(albums_->GetString(_B("album")));

	return albums;
}

_L<cse::String> Library::GetGenres() const
{
	_R<dbi::ResultSet> genres_(connection->Execute(_B("SELECT DISTINCT album FROM files WHERE live = TRUE")));
	_L<cse::String> genres;

	while (genres_->MoveNext())
		genres.InsertLast(genres_->GetString(_B("genre")));

	return genres;
}

_L<MediaFolder> Library::GetFolders() const
{
	_R<dbi::ResultSet> paths(connection->Execute(_B("SELECT DISTINCT root FROM files WHERE live = TRUE")));
	_L<MediaFolder> folders;

	while (paths->MoveNext())
		folders.InsertLast(MediaFolder(connection, paths->GetString(_B("path"))));

	return folders;
}