private void InitializeOrderedTracks()
{
foreach (long playlist_id in connection.QueryEnumerable <long> ("SELECT PlaylistID FROM CorePlaylists ORDER BY PlaylistID"))
{
if (connection.Query <long> (@"SELECT COUNT(*) FROM CorePlaylistEntries
WHERE PlaylistID = ? AND ViewOrder > 0", playlist_id) <= 0)
{
long first_id = connection.Query <long> ("SELECT COUNT(*) FROM CorePlaylistEntries WHERE PlaylistID < ?", playlist_id);
connection.Execute(
@"UPDATE CorePlaylistEntries SET ViewOrder = (ROWID - ?) WHERE PlaylistID = ?",
first_id, playlist_id
);
}
}
}
protected override void ImportCore ()
{
LibraryImportManager import_manager = ServiceManager.Get<LibraryImportManager> ();
HyenaSqliteConnection conn;
try {
conn = new HyenaSqliteConnection (amarok_db_path);
} catch (Exception e) {
LogError (amarok_db_path, String.Format (
"Unable to open Amarok database: {0}", e.Message));
return;
}
int count = 0;
try {
count = conn.Query<int> ("SELECT COUNT(*) FROM tags");
} catch (Exception) {}
try {
HyenaSqliteCommand cmd = new HyenaSqliteCommand (@"
SELECT DISTINCT NULL,
tags.url,
tags.title,
artist.name,
genre.name,
album.name,
year.name,
tags.track,
tags.length
FROM tags,
artist,
album,
genre,
year
WHERE tags.deviceid = -1
AND tags.artist = artist.id
AND tags.album = album.id
AND tags.genre = genre.id
AND tags.year = year.id"
);
HyenaSqliteCommand stats_cmd = new HyenaSqliteCommand (@"
SELECT DISTINCT (rating+rating%2)/2, playcounter, createdate, accessdate
FROM statistics
WHERE url = ? AND deviceid = -1");
int processed = 0;
IDataReader reader = conn.Query (cmd);
while (reader.Read ()) {
if (CheckForCanceled ())
break;
processed++;
try {
string path = (string) reader[1];
SafeUri uri = null;
if (path.StartsWith ("./")) {
uri = new SafeUri (path.Substring (1));
} else if (path.StartsWith ("/")) {
uri = new SafeUri (path);
} else {
continue;
}
string title = (string) reader[2];
string artist = (string) reader[3];
//Console.WriteLine ("Amarok import has {0}/{1} - {2}", artist, title, uri);
// the following fields are not critical and can be skipped if something goes wrong
int rating = 0, playcount = 0;
long created = 0, accessed = 0;
// Try to read stats
try {
IDataReader stats_reader = conn.Query (stats_cmd, path);
while (stats_reader.Read ()) {
rating = Convert.ToInt32 (stats_reader[0]);
playcount = Convert.ToInt32 (stats_reader[1]);
created = Convert.ToInt64 (stats_reader[2]);
accessed = Convert.ToInt64 (stats_reader[3]);
}
stats_reader.Dispose ();
} catch (Exception) {}
UpdateUserJob (processed, count, artist, title);
try {
DatabaseTrackInfo track = import_manager.ImportTrack (uri);
if (track == null) {
throw new Exception (String.Format (Catalog.GetString ("Unable to import track: {0}"), uri.AbsoluteUri));
}
if (rating > 0 || playcount > 0 || created > 0 || accessed > 0) {
track.Rating = rating;
track.PlayCount = playcount;
if (created > 0)
track.DateAdded = Hyena.DateTimeUtil.FromTimeT (created);
if (accessed > 0)
track.LastPlayed = Hyena.DateTimeUtil.FromTimeT (accessed);
track.Save (false);
}
} catch (Exception e) {
LogError (SafeUri.UriToFilename (uri), e);
}
} catch (Exception e) {
Hyena.Log.Exception (e);
// something went wrong, skip entry
}
}
reader.Dispose ();
import_manager.NotifyAllSources ();
// TODO migrating more than the podcast subscriptions (eg whether to auto sync them etc) means 1) we need to have those features
// and 2) we need to depend on Migo and/or the Podcast extension
DBusCommandService cmd_service = ServiceManager.Get<DBusCommandService> ();
if (cmd_service != null && ServiceManager.DbConnection.TableExists ("PodcastSyndications")) {
foreach (string podcast_url in conn.QueryEnumerable<string> ("SELECT url FROM podcastchannels")) {
cmd_service.PushFile (podcast_url.Replace ("http:", "feed:"));
}
}
} catch (Exception e) {
Hyena.Log.Exception (e);
LogError (amarok_db_path, Catalog.GetString ("Importing from Amarok failed"));
} finally {
conn.Dispose ();
}
}
protected override void ImportCore()
{
LibraryImportManager import_manager = ServiceManager.Get <LibraryImportManager> ();
HyenaSqliteConnection conn;
try {
conn = new HyenaSqliteConnection(amarok_db_path);
} catch (Exception e) {
LogError(amarok_db_path, String.Format(
"Unable to open Amarok database: {0}", e.Message));
return;
}
int count = 0;
try {
count = conn.Query <int> ("SELECT COUNT(*) FROM tags");
} catch (Exception) {}
try {
HyenaSqliteCommand cmd = new HyenaSqliteCommand(@"
SELECT DISTINCT NULL,
tags.url,
tags.title,
artist.name,
genre.name,
album.name,
year.name,
tags.track,
tags.length
FROM tags,
artist,
album,
genre,
year
WHERE tags.deviceid = -1
AND tags.artist = artist.id
AND tags.album = album.id
AND tags.genre = genre.id
AND tags.year = year.id"
);
HyenaSqliteCommand stats_cmd = new HyenaSqliteCommand(@"
SELECT DISTINCT (rating+rating%2)/2, playcounter, createdate, accessdate
FROM statistics
WHERE url = ? AND deviceid = -1");
int processed = 0;
IDataReader reader = conn.Query(cmd);
while (reader.Read())
{
if (CheckForCanceled())
{
break;
}
processed++;
try {
string path = (string)reader[1];
SafeUri uri = null;
if (path.StartsWith("./"))
{
uri = new SafeUri(path.Substring(1));
}
else if (path.StartsWith("/"))
{
uri = new SafeUri(path);
}
else
{
continue;
}
string title = (string)reader[2];
string artist = (string)reader[3];
//Console.WriteLine ("Amarok import has {0}/{1} - {2}", artist, title, uri);
// the following fields are not critical and can be skipped if something goes wrong
int rating = 0, playcount = 0;
long created = 0, accessed = 0;
// Try to read stats
try {
IDataReader stats_reader = conn.Query(stats_cmd, path);
while (stats_reader.Read())
{
rating = Convert.ToInt32(stats_reader[0]);
playcount = Convert.ToInt32(stats_reader[1]);
created = Convert.ToInt64(stats_reader[2]);
accessed = Convert.ToInt64(stats_reader[3]);
}
stats_reader.Dispose();
} catch (Exception) {}
UpdateUserJob(processed, count, artist, title);
try {
DatabaseTrackInfo track = import_manager.ImportTrack(uri);
if (track == null)
{
throw new Exception(String.Format(Catalog.GetString("Unable to import track: {0}"), uri.AbsoluteUri));
}
if (rating > 0 || playcount > 0 || created > 0 || accessed > 0)
{
track.Rating = rating;
track.PlayCount = playcount;
if (created > 0)
{
track.DateAdded = Hyena.DateTimeUtil.FromTimeT(created);
}
if (accessed > 0)
{
track.LastPlayed = Hyena.DateTimeUtil.FromTimeT(accessed);
}
track.Save(false);
}
} catch (Exception e) {
LogError(SafeUri.UriToFilename(uri), e);
}
} catch (Exception e) {
Hyena.Log.Exception(e);
// something went wrong, skip entry
}
}
reader.Dispose();
import_manager.NotifyAllSources();
// TODO migrating more than the podcast subscriptions (eg whether to auto sync them etc) means 1) we need to have those features
// and 2) we need to depend on Migo and/or the Podcast extension
DBusCommandService cmd_service = ServiceManager.Get <DBusCommandService> ();
if (cmd_service != null && ServiceManager.DbConnection.TableExists("PodcastSyndications"))
{
foreach (string podcast_url in conn.QueryEnumerable <string> ("SELECT url FROM podcastchannels"))
{
cmd_service.PushFile(podcast_url.Replace("http:", "feed:"));
}
}
} catch (Exception e) {
Hyena.Log.Exception(e);
LogError(amarok_db_path, Catalog.GetString("Importing from Amarok failed"));
} finally {
conn.Dispose();
}
}