ViewVC Help

View File | Revision Log | Show Annotations | Download File | View Changeset | Root Listing

root/repos/DecentralizedMedia/MediaFile.cpp

Comparing DecentralizedMedia/MediaFile.cpp (file contents):
Revision 478 by douglas, 2005-06-08T17:16:59-07:00 vs.
Revision 500 by douglas, 2005-06-17T23:23:46-07:00

#	Line 6 | Line 6
6
7		#include "MediaFile.hpp"
8
9	<	MediaFile::MediaFile(const ext::String& name) : name(name)
9	>	#include <menes-dbi/resultset.hpp>
10	>
11	>	MediaFile::MediaFile(_H<dbi::Connection>& connection, const api::Path& path) : connection(connection), path(path)
12		{
13	<	// XXX: implement
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(const ext::String& name, const ext::String& artist, const ext::String& title, const ext::String& album, const ext::String& genre) : name(name), artist(artist), title(title), album(album), genre(genre)
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	<	// XXX: implement
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		}

Diff Legend

–	Removed lines
+	Added lines
<	Changed lines
>	Changed lines