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
);
}
}
}