#!/bin/bash

# importxml.sh -- import a .sum file into MySQL.

#

# 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 takes a compressed or uncompressed sum file from a

# DejaGnu test run. It then extracts the relevant information about

# the build and writes that to the dejagnu.testruns control

# table. After that it converts the sum file to XML, and imports it

# into an SQL database, in this case MySQL.

if test x"$1" = x; then

  infile="/tmp/testrun.xml"

  outfile="/tmp/testrun.xml"

else

  infile=$1

  outfile=${1//\.sum.*/.xml}

fi

if test ! -e "$infile"; then

  echo "ERROR: no input file specified!"

  exit

fi

# These are required to access the database

user="USER"

passwd="PASSWD"

# 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

total=$(mysql -u"$user" -p"$passwd" -e "SELECT testrun from testruns ORDER BY testrun DESC LIMIT 1" dejagnu | tail -1)

total=$((total + 1))

type=$(file "$infile")

build_machine=$(dirname "$infile" | cut -d '-' -f 8)

# If compressed, uncompress it

count=$(echo "$type" | grep -c "XZ compressed data")

if test "$count" -gt 0; then

  catprog="xzcat"

  uncomp="xz -d"

else

  count=$(echo "$type" | grep -c "XZ compressed data")

  if test "$count" -gt 0; then

    catprog="gzcat"

    uncomp="gnzip"

  else

    catprog="cat"

    uncomp=""

  fi

fi

# extract the build info from the sum file.

# This goes in the dejagnu.testruns table

tool=$(${catprog} "$infile" | grep "tests ===" | cut -d ' ' -f 2)

target=$(${catprog} "$infile" | head -20 | grep "configuration is " | cut -d ' ' -f 4)

version=$(${catprog} "$infile" | head -20 | grep "Running /" | cut -d '/' -f 7 | sed -e 's:^[a-z-]*-::' -e 's:_:.:' -e 's:-branch::' | tail -1)

date=$(${catprog} "$infile" | head -1 | sed -e 's:Test Run By [a-zA-Z]* on ::')

date=$(date -d "${date}" "+%Y-%m-%d %H:%M:%S")

echo "Adding to DB: $target, $version, $date, $tool"

# Add an entry in the testrun table for this sum file

echo "Adding the test run into the testruns control table."

mysql -u"$user" -p"$passwd" --local -e "INSERT INTO dejagnu.testruns VALUES('${tool}','${date}','${version}','svn','${total}','${target}','${build_machine}');" dejagnu

# Make the temp file copy

if test x"${uncomp}" != x; then

  rm -f tmp.sum

  ${catprog} "$infile" > tmp.sum

fi

# convert the sum file to an xml file so it can be imported

echo "Converting the sum file to XML for importing into MySQL."

bash "$(dirname "$0")/sum2xml.sh" "$infile"

# import the the xml file into MySQL. Note that we add the testrun index which is

# retreived from the database earlier in this script.

echo "Adding the sum file into the testruns control file."

mysql -u"$user" -p"$passwd" --local -e "LOAD XML LOCAL INFILE '${outfile}' INTO TABLE dejagnu.test ROWS IDENTIFIED BY '<test>' SET testrun = '${total}';" dejagnu