2 set -e; .
/usr
/local
/lib
/err
; set +e
3 source /a
/bin
/ds
/beet-data
6 sqlite3
/i
/navidrome
/navidrome.db
".output $r" "select path from annotation inner join media_file on item_id = id where rating = $r;"
8 find /i
/m
-type f
-name '*.flac' >flacs
9 for plist
in ${nav_tags[@]}; do
10 sqlite3
/i
/navidrome
/navidrome.db
"select path from media_file inner join playlist_tracks on media_file.id = media_file_id where playlist_id = (select id from playlist where name = '_$plist');" |
sed 's,^/i/converted,/i/m,' |
sort >$plist
12 while read -r id name
; do
14 sqlite3
/i
/navidrome
/navidrome.db
"select path from media_file inner join playlist_tracks on media_file.id = media_file_id where playlist_id = '$id';" |
sed 's,^/i/converted,/i/m,' |
sort >2genre
/$id/$name
15 done < <(sqlite3
/i
/navidrome
/navidrome.db
".separator ' '" "select id, name from playlist where name like '2%'")