diff options
author | Jesse Luehrs <doy@tozt.net> | 2014-04-08 11:10:38 -0400 |
---|---|---|
committer | Jesse Luehrs <doy@tozt.net> | 2014-04-08 20:54:53 -0400 |
commit | 075bac245e0255eb49293a80bbae0ed472bc550d (patch) | |
tree | 39e2c4c2789de4fbdffef5939b23bb9000d5a63d /aliases | |
parent | 7fd13f947bf91393a76898f4917dbba92375280c (diff) | |
download | conf-075bac245e0255eb49293a80bbae0ed472bc550d.tar.gz conf-075bac245e0255eb49293a80bbae0ed472bc550d.zip |
need to point to the db in ~/
Diffstat (limited to 'aliases')
-rw-r--r-- | aliases | 2 |
1 files changed, 1 insertions, 1 deletions
@@ -131,7 +131,7 @@ function rand_music { fi lastfm_export --user doyster --dsn dbi:SQLite:${HOME}/.tracks.sqlite for i in $(seq 1 $([ -z "$1" ] && echo 20 || echo $1)); do - echo "select distinct(artist) from $db where artist not in (select distinct(artist) from weekly_tracks);" | sqlite3 .tracks.sqlite | rand_line | sed "s/'/''/" | sed "s/.*/select artist, album from $db where artist = '&' group by artist, album;/" | sqlite3 .tracks.sqlite | rand_line | sed 's/|/ - /' + echo "select distinct(artist) from $db where artist not in (select distinct(artist) from weekly_tracks);" | sqlite3 ~/.tracks.sqlite | rand_line | sed "s/'/''/" | sed "s/.*/select artist, album from $db where artist = '&' group by artist, album;/" | sqlite3 ~/.tracks.sqlite | rand_line | sed 's/|/ - /' done } function t { |