#!/usr/bin/env bash
set -euo pipefail
cd /srv/apps/sotlab-music
set -a
. ./.env
set +a
printf '%s\n' '--- compose volumes ---'
grep -nE 'volumes:|/mnt/main_nas_music|9001|ampache' compose.yml | sed -n '1,120p'
printf '%s\n' '--- path inside ampache ---'
sudo docker exec sotlab-music-ampache-1 sh -lc 'id; ls -ld /media 2>/dev/null || true; find /media -type f \( -iname "*.mp3" -o -iname "*.flac" -o -iname "*.m4a" -o -iname "*.ogg" -o -iname "*.wav" -o -iname "*.aac" \) 2>/dev/null | wc -l; find /media -maxdepth 3 -type f \( -iname "*.mp3" -o -iname "*.flac" -o -iname "*.m4a" -o -iname "*.ogg" -o -iname "*.wav" -o -iname "*.aac" \) 2>/dev/null | head -8'
printf '%s\n' '--- db counts ---'
sudo docker exec sotlab-music-db-1 mariadb -u"$AMPACHE_DB_USER" -p"$AMPACHE_DB_PASSWORD" "$DB_NAME" -e "SHOW TABLES LIKE 'catalog'; SELECT COUNT(*) AS catalogs FROM catalog; SELECT id,name,path,catalog_type,enabled FROM catalog; SELECT COUNT(*) AS songs FROM song; SELECT COUNT(*) AS albums FROM album; SELECT COUNT(*) AS artists FROM artist;" 2>/dev/null