s = n + 1
if cell == '':
empty_cell = cell
else:
dict_1[s] = {}
sep1 = ','
data = cell.split(sep1)
term_1 = cell
term_2 = term_1.replace('(', '').replace(')', '')
term_3 = term_2.replace('&', '').replace('feat.', '')
return_list.append(term_3)
return return_list #returns dictionary of search terms and sheet name
search_list = search_sheet()
#exclusion_p1 = [playlist_name]
#exclusion_p2 = functions.exclusion_terms()
#exclusion_list = exclusion_p1 + exclusion_p2
# worksheet_list = spreadsheet.worksheets()
# for n,worksheet in enumerate(worksheet_list):
# print(str(n)+" : "+str(worksheet))
exclusion_list = []
track_list = functions.track_search(search_list)
functions.add_to_playlist(functions.playlist_creation("Top 99 of Decade"),
track_list, exclusion_list)
#creation_dict = playlist_check_and_creation(track_id_list) #creates dictionary or finds existing
#add_to_playlist(creation_dict)
from spotipy.oauth2 import SpotifyClientCredentials
import spotipy
import functions as f
import pprint
tt = f.top_tracks() #get dictionary of top track lists from Spotify
for x in tt:
playlist_id = f.playlist_creation(
x) #create playlist with name defined in f.top_tracks
current = f.playlist_tracks(
playlist_id) #get the current tracks in the playlist
add_list = []
remove_list = []
for track in tt[x]: #for track in new list
if track not in current:
add_list.append(track) #add the track to be added
for track in current: #for track in current list
if track not in tt[x]:
remove_list.append(track)
if add_list:
print("add_list")
pprint.pprint(add_list)
print("*****")
print('Adding songs to Saved for you boss!')
f.add_to_saved(add_list)
f.add_to_playlist(playlist_id, add_list, [])
if remove_list:
term_3 = term_2.replace('&', '').replace('feat.', '')
return_list.append(term_3)
return return_list #returns dictionary of search terms and sheet name
playlist_name = 'STARRED'
exclusion_p1 = [playlist_name]
exclusion_p2 = functions.exclusion_terms()
exclusion_list = exclusion_p1 + exclusion_p2
worksheet_list = spreadsheet.worksheets()
for n, worksheet in enumerate(worksheet_list):
print(str(n) + " : " + str(worksheet))
while True:
for n, worksheet in enumerate(worksheet_list):
print(str(n) + " : " + str(worksheet))
sheet_number = int(input("What is the playlist number? "))
search_list = create_search_dictionary(
sheet_number) #grabs sheet track search terms and name
#track_id_list = track_convert(search_list,current_sheet_name) #creats spotify track id list
track_list = functions.track_search(search_list)
functions.add_to_playlist(functions.playlist_creation(playlist_name),
track_list, exclusion_list)
#creation_dict = playlist_check_and_creation(track_id_list) #creates dictionary or finds existing
#add_to_playlist(creation_dict)
print()
print()
user_playlists = functions.get_user_playlists()
#Generate possible playlists to seach
q = ['Q1', 'Q2', 'Q3', 'Q4']
y = list(range(2010, 2051, 1))
names = []
for r in q:
for s in y:
names.append(str(s) + " " + r)
#Find the actual playlists that exist
pl_actual = {}
for pl_name in names: #for the names we just made
for user_pl_name in user_playlists: #for the actual playlists that exist
if pl_name == user_pl_name: #if they match
pl_actual[pl_name] = user_playlists[
user_pl_name] #append ID to list
#find ID of mega playlist
pl_id = functions.playlist_creation(mega_playlist) #get mega playlist
#add songs from each baby playlist to mega playlist using exclusions
for playlist_id in sorted(pl_actual.keys()): # for reach yearly playlist
print("Getting songs from: " + str(playlist_id))
exclusion_list = functions.playlist_tracks(
pl_id) #songs already in mega playlist
track_list = functions.playlist_tracks(pl_actual[playlist_id])
functions.add_to_playlist(pl_id, track_list, exclusion_list)
print("Done")
quarter_dict[x] = str(track_dict[x].year) + " Q2"
elif 7 <= track_dict[x].month <= 9:
quarter_dict[x] = str(track_dict[x].year) + " Q3"
elif 10 <= track_dict[x].month <= 12:
quarter_dict[x] = str(track_dict[x].year) + " Q4"
for x in quarter_dict: #create list of playlist names
if quarter_dict[x] not in playlist_list:
playlist_list.append(quarter_dict[x])
#playlist_list.append(quarter_dict[x]) if quarter_dict[x] not in playlist_list except: pass
final_playlist_dict = {} #holds playlist names/ids
for x in playlist_list: #checks by name ex 2017 Q4, gets playlist IDS or creates them
#input is a playlist name string (x)
final_playlist_dict[x] = functions.playlist_creation(x)
plist_and_tracks = {}
for x in quarter_dict: #creates dictionary of playlist IDS as keys and track list as values
#for each track in the quarter dict (track ID as key and playlist name as value)
if final_playlist_dict[quarter_dict[
x]] in plist_and_tracks: #if playlist id exists already, skip
pass
else:
plist_and_tracks[final_playlist_dict[quarter_dict[x]]] = [
] #else, create it
plist_and_tracks[final_playlist_dict[quarter_dict[x]]].append(
x) #then add track to appropriate list
exclusion_list = functions.exclusion_terms() #creates exclusion terms
for playlist in plist_and_tracks: #for each playlist, add associated track list