server.py 文件源码

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})