#!/bin/bash

[ -r /etc/check_mk/galaxy_counts.cfg ] && . /etc/check_mk/galaxy_counts.cfg
[[ "x$GALAXY_DATABASE" == "x" ]] && exit 0

if which psql > /dev/null 2>&1 ; then
    echo "<<<galaxy_counts>>>"
    cd /tmp
    sudo -u postgres psql --csv -t -d $GALAXY_DATABASE -c "SELECT s.state, count(j.id) FROM (SELECT DISTINCT state FROM job_state_history) AS s LEFT JOIN job j ON j.state = s.state GROUP BY s.state ORDER BY s.state;" 2>&1
fi
