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 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.1.3-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 9909b4cff08688a901586e8abadb8756e5689bc3c848e8fd163f52d91db340da |
|
MD5 | df6fe93f6bed26db6188484fd8c65390 |
|
BLAKE2b-256 | fb39f3d04c6b56f4e16dfea0a832e25bff9d9265d49584e83e12341e2aa1a093 |