homelab/lab/ansible/roles/mopidy/files/generate-random-playlist.sh

#!/usr/bin/env sh
# select X tracks at random and create a playlist

num=50
playlist="/var/lib/mopidy/playlists/Today.m3u8"
echo "#EXTM3U" > ${playlist}
for uri in $(sqlite3 /var/lib/mopidy/local/library.db "SELECT uri FROM track ORDER BY RANDOM() LIMIT $num;"); do
	name=$(sqlite3 /var/lib/mopidy/local/library.db "SELECT name FROM track WHERE uri = \"$uri\";")
	echo "#EXTINF:-1,$name"
	echo "$uri"
done >> ${playlist}