92
92
protected bool error_source_visible = false;
94
94
protected string remove_range_sql = @"
95
INSERT INTO CoreRemovedTracks (DateRemovedStamp, TrackID, Uri) SELECT ?, TrackID, Uri FROM CoreTracks WHERE TrackID IN (SELECT {0});
95
INSERT INTO CoreRemovedTracks (DateRemovedStamp, TrackID, Uri)
96
SELECT ?, TrackID, " + BansheeQuery.UriField.Column + @"
97
FROM CoreTracks WHERE TrackID IN (SELECT {0});
96
98
DELETE FROM CoreTracks WHERE TrackID IN (SELECT {0})";
98
protected HyenaSqliteCommand remove_list_command = new HyenaSqliteCommand (@"
99
INSERT INTO CoreRemovedTracks (DateRemovedStamp, TrackID, Uri) SELECT ?, TrackID, Uri FROM CoreTracks WHERE TrackID IN (SELECT ItemID FROM CoreCache WHERE ModelID = ?);
100
protected HyenaSqliteCommand remove_list_command = new HyenaSqliteCommand (String.Format (@"
101
INSERT INTO CoreRemovedTracks (DateRemovedStamp, TrackID, Uri)
102
SELECT ?, TrackID, {0} FROM CoreTracks WHERE TrackID IN (SELECT ItemID FROM CoreCache WHERE ModelID = ?);
100
103
DELETE FROM CoreTracks WHERE TrackID IN (SELECT ItemID FROM CoreCache WHERE ModelID = ?)
104
", BansheeQuery.UriField.Column));
103
106
protected HyenaSqliteCommand prune_artists_albums_command = new HyenaSqliteCommand (@"
104
107
DELETE FROM CoreArtists WHERE ArtistID NOT IN (SELECT ArtistID FROM CoreTracks);