def __upgrade_44(self, db):
"""
Delete spotify albums as spotify id is not stored in URI
"""
from lollypop.database_albums import AlbumsDatabase
from lollypop.database_artists import ArtistsDatabase
from lollypop.database_tracks import TracksDatabase
albums = AlbumsDatabase(db)
artists = ArtistsDatabase(db)
tracks = TracksDatabase(db)
for storage_type in [
StorageType.SPOTIFY_NEW_RELEASES, StorageType.SPOTIFY_SIMILARS,
StorageType.DEEZER_CHARTS
]:
album_ids = albums.get_for_storage_type(storage_type)
for album_id in album_ids:
# EPHEMERAL with not tracks will be cleaned below
albums.set_storage_type(album_id, StorageType.EPHEMERAL)
tracks.remove_album(album_id)
tracks.clean()
albums.clean()
artists.clean()
