An idea to help organize your music with extra metadata using a SQL Server Database. This repository searches through a folder and gathers metadata already in mp3 files to add to a database
The migration added to this PR is "safe" in that you could run it multiple times and it would only make the changes it needed to once, but I doubt that future migrations will be able to be so simple. For now, we will attempt to make future migrations "safe" also. The migration performs the following only if the Mood and MoodTracks tables are still present:
Playlist track orders are made to be nullable
Adds a new playlist with the name of the mood as the title of the playlist
Sets the name of the playlist to be "SYS: Migrated from Mood Tables"
System playlists and user-created playlists are differentiated by a lack of track ordering on corresponding track tables
Adds a new playlist track entry for each track the mood was originally attached to
The migration added to this PR is "safe" in that you could run it multiple times and it would only make the changes it needed to once, but I doubt that future migrations will be able to be so simple. For now, we will attempt to make future migrations "safe" also. The migration performs the following only if the
MoodandMoodTrackstables are still present:Tests