Sha256: f9ce47409092b766078b04bcbd4b30285819f73e9757961ae9f2f08393f2635f
Contents?: true
Size: 1.03 KB
Versions: 33
Compression:
Stored size: 1.03 KB
Contents
#!/usr/bin/env bash
set -e
echo
default_name=message_store
if [ -z ${DATABASE_USER+x} ]; then
echo "(DATABASE_USER is not set)"
user=$default_name
else
user=$DATABASE_USER
fi
echo "Database user is: $user"
if [ -z ${DATABASE_NAME+x} ]; then
echo "(DATABASE_NAME is not set)"
database=$default_name
else
database=$DATABASE_NAME
fi
echo "Database name is: $database"
if [ -z ${TYPE+x} ]; then
echo "(TYPE is not set)"
type=''
else
type=$TYPE
echo "Type is: $TYPE"
fi
echo
echo "Type Stream Summary"
echo "= = ="
echo
if [ -z $type ]; then
psql $database -U $user -P pager=off -c "SELECT * FROM type_stream_summary ORDER BY type, message_count DESC, stream_name;"
psql $database -U $user -P pager=off -c "SELECT COUNT(*) AS total_count FROM messages;"
else
psql $database -U $user -P pager=off -c "SELECT * FROM type_stream_summary WHERE type LIKE '%$type%' ORDER BY type, message_count DESC, stream_name;"
psql $database -U $user -P pager=off -c "SELECT COUNT(*) AS total_count FROM messages WHERE type LIKE '%$type%';"
fi
Version data entries
33 entries across 33 versions & 2 rubygems