contrib/mysql/plot.sh

#!/bin/bash

# plot.sh
#
# Copyright (C) 2016 Free Software Foundation, Inc.
#
# This file is part of DejaGnu.
#
# DejaGnu is free software; you can redistribute it and/or modify it
# under the terms of the GNU General Public License as published by
# the Free Software Foundation; either version 3 of the License, or
# (at your option) any later version.

# This script executes a series of SQL calls to our testing database,
# and makes a data file for gnuplot.

if test "$#" -eq 0; then
    echo "Need to supply a graph name!"
    name="GCC"
else
    name=$1
fi

# These are required to access the database
user="USER"
passwd="PASSWD"
outfile="testrun.data"

# Check the environment for the database access information
if test x"${CBUILD_DBUSER}" != x; then
    user="${CBUILD_DBUSER}"
fi
if test x"${CBUILD_DBPASSWD}" != x; then
    passwd="${CBUILD_DBPASSWD}"
fi

# setup an array of colors, since the number of data files varies
declare -a colors=('green' 'red' 'cyan' 'blue' 'purple' 'brown' 'coral' 'yellow' 'black')

type="with lines"
type=

machines=$(mysql -u"$user" -p"$passwd" --local -e "SELECT DISTINCT(build_machine) FROM dejagnu.testruns" | sed -e 's/build_machine//'  | sed -e 's:\.::' | tr '\n' ' ')
echo "Build machines are: ${machines}"

tools=$(mysql -u"$user" -p"$passwd" --local -e "SELECT DISTINCT(tool) FROM dejagnu.testruns" | sed -e 's/tool//' | tr '\n' ' ')

# Only graph if there is a data file
#tools="`ls *.data | cut -d '.' -f 1`"
echo "Tools are: ${tools}"

datafiles="${machines}"
if test "$#" -gt 1; then
    case $2 in
	m*) datafiles="echo ${machines}"
	    echo "Separating graphs by build machine name"
	    ;;
	t*) datafiles="${tools}"
	    echo "Separating graphs by tool name"
	    ;;
	*)
	    datafiles="${machines}"
	    ;;
    esac
fi

outfile="gnuplot.cmd"
cindex=0
for j in ${datafiles}; do
    # for now we don't want aarch64 results in the chart as they distort the data
    # heavily.
    if test "$(echo "$j" | grep -c aarch64)" -gt 0; then
	continue
    fi
    if test -f "$j".data -a -s "$j".data; then
	if test ${cindex} -eq 0; then
	    echo "Creating gnuplot comand file: ${outfile}"
	    cat <<EOF >${outfile}
set boxwidth 0.9 relative 
set style data histograms 
set style histogram cluster 
set style fill solid 1.0 border lt -1
set autoscale x
set autoscale y
#set yrange [97:100]
set title "Precentage PASSes"
set ylabel "Precent PASS"
set format y "%g%%"
#set xlabel "Architecture"

# Rotate the X axis labels 90 degrees, so they all fit
set xtics border in scale 1,0.5 nomirror rotate by -90  offset character 0, 0, 0

# Out the key in out of the way
set key right top

set term png size 1900,1024
set output "testrun.png"

set xlabel "${name} Versions"

set grid ytics lt 0 lw 1 lc rgb "#bbbbbb"
#set grid xtics lt 0 lw 1 lc rgb "#bbbbbb"

EOF
#	    echo -n "plot \"$j.data\" using (((\$6+\$9)/\$5)/100):xtic(3) title \"$j\" lt rgb \"${colors[$cindex]}\" ${type}" >> ${outfile}
	    echo -n "plot \"$j.data\" using ((\$6/\$5) * 100):xtic(3) title \"$j\" lt rgb \"${colors[$cindex]}\" ${type}" >> ${outfile}
#	    cindex=`expr $cindex + 1`
#	    echo -n ", \"\" using (((\$7+\$8+\$10+\$11+\$12)/\$5) * 100):xtic(3) title \"FAILS\" lt rgb \"${colors[$cindex]}\" ${type}" >> ${outfile}
	else
#	    echo -n ", \"$j.data\" using ((\$6+\$9/\$5)/100):xtic(3) title \"$j\" lt rgb \"${colors[$cindex]}\" ${type}" >> ${outfile}
	    echo -n ", \"$j.data\" using ((\$6/\$5) * 100):xtic(3) title \"$j\" lt rgb \"${colors[$cindex]}\" ${type}" >> ${outfile}
	fi
	cindex=$((cindex + 1))
    fi
done

#for j in ${datafiles}; do
#    if test -f $j.data -a -s $j.data; then
	cat <<EOF >>${outfile}

set term x11 persist
replot

EOF
#    fi
#done