def add_to_playlist():
"""Add album to user's Spotify playlist from dropdown menu."""
token = session['token']
user_id = session['user_id']
playlist_id = request.form.get('playlist_id')
album_id = request.form.get('album_id')
# Query SQL db for track URIs, which are needed to add entire album to playlist
tracks = db.session.query(Track).join(Track.albums).filter_by(album_id=album_id).all()
list_of_track_uris = []
for track in tracks:
list_of_track_uris.append(track.album_track_uri)
# uses the Spotipy method to add album to Spotify user's playlist
if token:
sp = spotipy.Spotify(auth=token)
sp.user_playlist_add_tracks(user_id, playlist_id, list_of_track_uris)
#The user selects a playlist to add an album to. This queries the name of the
# playlist to include in the flash-like message.
playlist = Playlist.query.filter_by(playlist_id=playlist_id).one()
playlist_name = str(playlist.playlist_name)
#The user selects a playlist to add an album to. This queries the name of the
# album to include in the flash-like message.
album = Album.query.filter_by(album_id=album_id).one()
album_name = album.album_name
# return playlist_name and album_name for flash-like message
return jsonify({'playlist_name': playlist_name, 'album_name': album_name})
评论列表
文章目录