#!/usr/bin/env bash
set -euo pipefail
cd /srv/apps/sotlab-music
set -a
. ./.env
set +a
sudo docker exec -i sotlab-music-db-1 mariadb -u"$AMPACHE_DB_USER" -p"$AMPACHE_DB_PASSWORD" "$DB_NAME" <<'SQL'
SELECT COUNT(*) AS songs FROM song;
SELECT COUNT(*) AS albums FROM album;
SELECT COUNT(*) AS artists FROM artist;
SELECT COUNT(*) AS videos FROM video;
SELECT COUNT(*) AS live_streams FROM live_stream;
SELECT COUNT(*) AS podcast_episodes FROM podcast_episode;
SELECT COUNT(*) AS catalog_map_rows FROM catalog_map;
SELECT COUNT(*) AS catalog_local_rows FROM catalog_local;
SELECT object_type, COUNT(*) AS rows_count FROM catalog_map GROUP BY object_type;
SELECT id,file,title FROM song ORDER BY id LIMIT 10;
SELECT COUNT(*) AS apple_double_rows FROM song WHERE file LIKE '%/._%';
SQL