2 # I, Ian Kelling, follow the GNU license recommendations at
3 # https://www.gnu.org/licenses/license-recommendations.en.html. They
4 # recommend that small programs, < 300 lines, be licensed under the
5 # Apache License 2.0. This file contains or is part of one or more small
6 # programs. If a small program grows beyond 300 lines, I plan to switch
9 # Copyright 2024 Ian Kelling
11 # Licensed under the Apache License, Version 2.0 (the "License");
12 # you may not use this file except in compliance with the License.
13 # You may obtain a copy of the License at
15 # http://www.apache.org/licenses/LICENSE-2.0
17 # Unless required by applicable law or agreed to in writing, software
18 # distributed under the License is distributed on an "AS IS" BASIS,
19 # WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
20 # See the License for the specific language governing permissions and
21 # limitations under the License.
23 set -e; .
/usr
/local
/lib
/bash-bear
; set +e
24 source /a
/bin
/ds
/beet-data
26 for r
in 1 2 3 4 5; do
27 sqlite3
/i
/navidrome
/navidrome.db
".output $r" "select path from annotation inner join media_file on item_id = id where rating = $r;"
29 find /i
/m
-type f
-name '*.flac' >flacs
30 for plist
in ${nav_tags[@]}; do
31 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
33 while read -r id name
; do
35 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
36 done < <(sqlite3
/i
/navidrome
/navidrome.db
".separator ' '" "select id, name from playlist where name like '2%'")