Notes for Violet. DRAFT v.1.0.1 def call_refresh(self): ## Note:1 - Euan Morgan's fix for refresh timeout errors. def create_connection(self, db_file): ## Note:2 - Create a database connection, to provide access to 'Track_List_Details' table. def get_the_playlist(self): ## Note:3 - Set-up a few things and prepare for the importing of the Endless MASTER playlist track details. def get_track_count_from_playlist(self): ## Note:4 - Get the Endless MASTER playlist name via its URL and save total track count. def reset_playlist_database(self): ## Note:5 - Reset the 'present' flag for every track. These will be set only if the track still exists in the playlist. def get_track_from_playlist(self): ## Note:6 - Step through every track in the playlist getting info about it, (Error trap for loss of connection). def check_database(self): ## Note:7 - See if the track is already in the database, if it is, set 'present' flag, If not, then add it. def add_to_db(self, conn): ## Note:8 - Add each of the tracks details to the database. def clear_db_deleted_tracks(self): ## Note:9 - Get rid of any tracks NOT in the MASTER playlist but still exists in the database. 08-03-2022