adm_influxdb_show_all_db.sh

#!/bin/bash
#
# Testing Influxdb - container must be in running state
#

echo "=> Testing Influxdb - container must be in running state"

if [ ! -e .env ]
then
    echo "<!> Please create proper .env file! Exiting."
    exit 1
fi

if [ ! -e influxdb.env ]
then
    echo "<!> Please create proper influxdb.env file! Exiting."
    exit 1
fi

set -o allexport
source .env
source influxdb.env
set +o allexport

cd ${STACKDIR}

echo `pwd`
echo "Compose up influxdb"
${COMPOSECOMMAND} -f docker-compose.yml up -d influxdb
echo "Waiting for 2 sec"
sleep 2

curl -G http://localhost:8086/query  --data-urlencode "u=${INFLUXDB_ADMIN_USER}" --data-urlencode "p=${INFLUXDB_ADMIN_PASSWORD}" --data-urlencode "q=SHOW DATABASES"

echo "SHOW USERS"
echo "--------------"
${COMPOSECOMMAND} exec -it influxdb influx -username ${INFLUXDB_ADMIN_USER} -password "${INFLUXDB_ADMIN_PASSWORD}"  -execute "SHOW USERS"
read -p "=> Press any key to continue"

echo "SHOW DATABASES"
echo "--------------"
${COMPOSECOMMAND} exec -it influxdb influx -username ${INFLUXDB_ADMIN_USER} -password "${INFLUXDB_ADMIN_PASSWORD}"  -execute "USE sensors
SHOW DATABASES"
read -p "=> Press any key to continue"

echo "SHOW SERIES"
echo "-----------"
${COMPOSECOMMAND} exec -it influxdb influx -username ${INFLUXDB_ADMIN_USER} -password "${INFLUXDB_ADMIN_PASSWORD}"  -execute "USE sensors
SHOW SERIES"
read -p "=> Press any key to continue"

echo "Show last 20 values"
echo "-------------------"
${COMPOSECOMMAND} exec -it influxdb influx -username ${INFLUXDB_ADMIN_USER} -password "${INFLUXDB_ADMIN_PASSWORD}"  -execute "USE sensors
precision rfc3339
SELECT * FROM mqtt_consumer ORDER BY time DESC LIMIT 20"
echo "-------------------"