spotify-to-sqlite

Convert a Spotify export zip to a SQLite database

Installation

Install this library using pip:

$ pip install spotify-to-sqlite

Usage

Convert a Spotify export zip to a SQLite database

spotify-to-sqlite convert my_spotify_data.zip spotify.db

You can use Spotify's Web API to retrieve audio features tracks in your streaming_history and your_library_tracks tables. You will need a CLIENT_ID and a CLIENT_SECRET which you can get when you register an application the Spotify Developer's site. You can export those as SPOTIPY_CLIENT_ID and SPOTIPY_CLIENT_SECRET (notice it's SPOTIPY not SPOTIFY). You can also save those on a .env file on your working directory as such:

# .env example
SPOTIPY_CLIENT_ID=adfgahjklsdf73932bcdlavsd7892dgfasd
SPOTIPY_CLIENT_SECRET=dabjgsd77507davsd12344dhgvafsdl

# when your converting export
spotify-to-sqlite --audio-features my_spotify_data.zip spotify.db

# if you already had converted your export you can pass a "-"
spotify-to-sqlite --audio-features - spotify.db

Development

To contribute to this library, first checkout the code. Then create a new virtual environment:

cd spotify-to-sqlite
python -m venv venv
source venv/bin/activate

Or if you are using pipenv:

pipenv shell

Now install the dependencies and test dependencies:

pip install -e '.[test]'

To run the tests:

pytest