From dc6416f8d45f02b5ba9e38a4236c1821a4cf596e Mon Sep 17 00:00:00 2001 From: Jesse Luehrs Date: Mon, 16 Jan 2017 07:32:44 -0500 Subject: split most functions out into scripts --- bin/pick_music | 4 ++++ 1 file changed, 4 insertions(+) create mode 100755 bin/pick_music (limited to 'bin/pick_music') 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)" -- cgit v1.2.3-54-g00ecf