#!/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'
SHOW COLUMNS FROM catalog;
SELECT * FROM catalog\G
SHOW COLUMNS FROM song;
SELECT COUNT(*) AS songs FROM song;
SHOW TABLES LIKE '%catalog%';
SQL