repos/DecentralizedMedia/MediaFile.cpp

// Media File
//
// Douglas Thrift
//
// $Id$

#include <menes/standard.hh>

#include <menes-dbi/resultset.hpp>

#include "MediaFile.hpp"

MediaFile::MediaFile(const _R<dbi::Connection>& connection, const api::Path& path) : connection(connection), path(path)
{
        _R<dbi::ResultSet> info(connection->Parse(_B("SELECT artist, title, album, genre FROM files WHERE path = ?"))->Execute(path.GetPath()));

        if (info->MoveNext())
        {
                artist = info->GetString(_B("artist"));
                title = info->GetString(_B("title"));
                album = info->GetString(_B("album"));
                genre = info->GetString(_B("genre"));
        }
        /*else
                throw;*/
}

MediaFile::MediaFile(const _R<dbi::Connection>& connection, const api::Path& path, const cse::String& artist, const cse::String& title, const cse::String& album, const cse::String& genre, const api::Path& root) : connection(connection), path(path), artist(artist), title(title), album(album), genre(genre)
{
        _R<dbi::ResultSet> path_(connection->Parse(_B("SELECT path FROM files WHERE path = ?"))->Execute(path.GetPath()));

        if (path_->MoveNext())
        {
                connection->Parse(_B("UPDATE files SET live = TRUE WHERE path = ?"))->Execute(path.GetPath());

                if (!artist.IsEmpty())
                        connection->Parse(_B("UPDATE files SET artist = ? WHERE path = ?"))->Execute(artist, path.GetPath());

                if (!title.IsEmpty())
                        connection->Parse(_B("UPDATE files SET title = ? WHERE path = ?"))->Execute(title, path.GetPath());

                if (!album.IsEmpty())
                        connection->Parse(_B("UPDATE files SET album = ? WHERE path = ?"))->Execute(album, path.GetPath());

                if (!genre.IsEmpty())
                        connection->Parse(_B("UPDATE files SET genre = ? WHERE path = ?"))->Execute(genre, path.GetPath());

                connection->Parse(_B("UPDATE files SET root = ? WHERE path = ?"))->Execute(root.GetPath(), path.GetPath());
        }
        else
                connection->Parse(_B("INSERT INTO files (path, artist, title, album, genre, folder, root) VALUES (?, ?, ?, ?, ?, ?, ?)"))->Execute(path.GetPath(), artist, title, album, genre, path.GetParent().GetPath(), root.GetPath());
}
Revision:	542
Committed:	2005-07-03T00:31:07-07:00 (19 years, 11 months ago) by douglas
File size:	2022 byte(s)
Log Message:	Grr!
#	User	Rev	Content
1	douglas	475	// Media File
2			//
3			// Douglas Thrift
4			//
5			// $Id$
6
7	douglas	516	#include <menes/standard.hh>
8	douglas	476
9	douglas	489	#include <menes-dbi/resultset.hpp>
10
11	douglas	516	#include "MediaFile.hpp"
12
13	douglas	542	MediaFile::MediaFile(const _R<dbi::Connection>& connection, const api::Path& path) : connection(connection), path(path)
14	douglas	476	{
15	douglas	541	_R<dbi::ResultSet> info(connection->Parse(_B("SELECT artist, title, album, genre FROM files WHERE path = ?"))->Execute(path.GetPath()));
16	douglas	488
17			if (info->MoveNext())
18			{
19			artist = info->GetString(_B("artist"));
20			title = info->GetString(_B("title"));
21			album = info->GetString(_B("album"));
22			genre = info->GetString(_B("genre"));
23			}
24	douglas	542	/*else
25			throw;*/
26	douglas	476	}
27	douglas	478
28	douglas	542	MediaFile::MediaFile(const _R<dbi::Connection>& connection, const api::Path& path, const cse::String& artist, const cse::String& title, const cse::String& album, const cse::String& genre, const api::Path& root) : connection(connection), path(path), artist(artist), title(title), album(album), genre(genre)
29	douglas	478	{
30	douglas	541	_R<dbi::ResultSet> path_(connection->Parse(_B("SELECT path FROM files WHERE path = ?"))->Execute(path.GetPath()));
31	douglas	500
32			if (path_->MoveNext())
33			{
34	douglas	514	connection->Parse(_B("UPDATE files SET live = TRUE WHERE path = ?"))->Execute(path.GetPath());
35
36	douglas	500	if (!artist.IsEmpty())
37			connection->Parse(_B("UPDATE files SET artist = ? WHERE path = ?"))->Execute(artist, path.GetPath());
38
39			if (!title.IsEmpty())
40			connection->Parse(_B("UPDATE files SET title = ? WHERE path = ?"))->Execute(title, path.GetPath());
41
42			if (!album.IsEmpty())
43			connection->Parse(_B("UPDATE files SET album = ? WHERE path = ?"))->Execute(album, path.GetPath());
44
45			if (!genre.IsEmpty())
46			connection->Parse(_B("UPDATE files SET genre = ? WHERE path = ?"))->Execute(genre, path.GetPath());
47
48			connection->Parse(_B("UPDATE files SET root = ? WHERE path = ?"))->Execute(root.GetPath(), path.GetPath());
49			}
50			else
51			connection->Parse(_B("INSERT INTO files (path, artist, title, album, genre, folder, root) VALUES (?, ?, ?, ?, ?, ?, ?)"))->Execute(path.GetPath(), artist, title, album, genre, path.GetParent().GetPath(), root.GetPath());
52	douglas	478	}