diff options
| author | Jesse Luehrs <doy@tozt.net> | 2017-01-16 07:32:44 -0500 |
|---|---|---|
| committer | Jesse Luehrs <doy@tozt.net> | 2017-01-21 06:37:31 -0500 |
| commit | dc6416f8d45f02b5ba9e38a4236c1821a4cf596e (patch) | |
| tree | 3594beb07b645598574622c9a6fe4a2b5351185d /bin/pick_music | |
| parent | 37136d5493410cf2f5b72184f952794f33be566e (diff) | |
| download | conf-dc6416f8d45f02b5ba9e38a4236c1821a4cf596e.tar.gz conf-dc6416f8d45f02b5ba9e38a4236c1821a4cf596e.zip | |
split most functions out into scripts
Diffstat (limited to 'bin/pick_music')
| -rwxr-xr-x | bin/pick_music | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/bin/pick_music b/bin/pick_music new file mode 100755 index 0000000..e667960 --- /dev/null +++ b/bin/pick_music @@ -0,0 +1,4 @@ +#!/bin/bash + +lastfm_export --user doyster --dsn dbi:SQLite:${HOME}/.tracks.sqlite +sqlite3 ${HOME}/.tracks.sqlite "SELECT artist FROM yearly_tracks WHERE artist NOT IN (SELECT DISTINCT(artist) FROM weekly_tracks) GROUP BY artist ORDER BY count(artist) * (strftime('%s') - max(timestamp)) DESC LIMIT $([ -z "$1" ] && echo 20 || echo $1)" |