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())
        {
                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:	514
Committed:	2005-06-20T00:19:47-07:00 (20 years ago) by douglas
File size:	1976 byte(s)
Log Message:	Added beginnings of Share stuff.
#	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	douglas	514	connection->Parse(_B("UPDATE files SET live = TRUE WHERE path = ?"))->Execute(path.GetPath());
33
34	douglas	500	if (!artist.IsEmpty())
35			connection->Parse(_B("UPDATE files SET artist = ? WHERE path = ?"))->Execute(artist, path.GetPath());
36
37			if (!title.IsEmpty())
38			connection->Parse(_B("UPDATE files SET title = ? WHERE path = ?"))->Execute(title, path.GetPath());
39
40			if (!album.IsEmpty())
41			connection->Parse(_B("UPDATE files SET album = ? WHERE path = ?"))->Execute(album, path.GetPath());
42
43			if (!genre.IsEmpty())
44			connection->Parse(_B("UPDATE files SET genre = ? WHERE path = ?"))->Execute(genre, path.GetPath());
45
46			connection->Parse(_B("UPDATE files SET root = ? WHERE path = ?"))->Execute(root.GetPath(), path.GetPath());
47			}
48			else
49			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());
50	douglas	478	}