Convert a Spotify export zip to a SQLite database
Project description
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
Project details
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
Hashes for spotify_to_sqlite-0.2.1-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | e74b0f5db0597b6ccce099c09c33cb16143cdab6ea3c8691cbac0ca25e94f7ad |
|
MD5 | 54f92f72a5e25dee8d612c17de0c6d8f |
|
BLAKE2b-256 | bf81b61f4ccce133bea9b379974259e8f8d879c65a7ee51ac03a3799cd928382 |