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!
#	Content
1	// Media File
2	//
3	// Douglas Thrift
4	//
5	// $Id$
6
7	#include "MediaFile.hpp"
8
9	#include <menes-dbi/resultset.hpp>
10
11	MediaFile::MediaFile(_H<dbi::Connection>& connection, const api::Path& path) : connection(connection), path(path)
12	{
13	_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	}
25
26	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	{
28	_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	}