repos/DecentralizedMedia/MediaFile.cpp

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

#include "MediaFile.hpp"

#include <menes-dbi/resultset.hpp>

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

        if (path_->MoveNext())
        {
                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:	500
Committed:	2005-06-17T23:23:46-07:00 (20 years ago) by douglas
File size:	1878 byte(s)
Log Message:	W00t!
#	User	Rev	Content
1	douglas	475	// Media File
2			//
3			// Douglas Thrift
4			//
5			// $Id$
6
7			#include "MediaFile.hpp"
8	douglas	476
9	douglas	489	#include <menes-dbi/resultset.hpp>
10
11	douglas	485	MediaFile::MediaFile(_H<dbi::Connection>& connection, const api::Path& path) : connection(connection), path(path)
12	douglas	476	{
13	douglas	488	_H<dbi::ResultSet> info(connection->Parse(_B("SELECT artist, title, album, genre FROM files WHERE path = ?"))->Execute(path.GetPath()));
14
15			if (info->MoveNext())
16			{
17			artist = info->GetString(_B("artist"));
18			title = info->GetString(_B("title"));
19			album = info->GetString(_B("album"));
20			genre = info->GetString(_B("genre"));
21			}
22			else
23			throw;
24	douglas	476	}
25	douglas	478
26	douglas	500	MediaFile::MediaFile(_H<dbi::Connection>& connection, const api::Path& path, const ext::String& artist, const ext::String& title, const ext::String& album, const ext::String& genre, const api::Path& root) : connection(connection), path(path), artist(artist), title(title), album(album), genre(genre)
27	douglas	478	{
28	douglas	500	_H<dbi::ResultSet> path_(connection->Parse(_B("SELECT path FROM files WHERE path = ?"))->Execute(path.GetPath()));
29
30			if (path_->MoveNext())
31			{
32			if (!artist.IsEmpty())
33			connection->Parse(_B("UPDATE files SET artist = ? WHERE path = ?"))->Execute(artist, path.GetPath());
34
35			if (!title.IsEmpty())
36			connection->Parse(_B("UPDATE files SET title = ? WHERE path = ?"))->Execute(title, path.GetPath());
37
38			if (!album.IsEmpty())
39			connection->Parse(_B("UPDATE files SET album = ? WHERE path = ?"))->Execute(album, path.GetPath());
40
41			if (!genre.IsEmpty())
42			connection->Parse(_B("UPDATE files SET genre = ? WHERE path = ?"))->Execute(genre, path.GetPath());
43
44			connection->Parse(_B("UPDATE files SET root = ? WHERE path = ?"))->Execute(root.GetPath(), path.GetPath());
45			}
46			else
47			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());
48	douglas	478	}