#!/bin/bash

_MY_DIR="$(cd "$(dirname "${0:-.}")" && pwd)"
_EX_DIR="$(realpath --relative-to=. "$_MY_DIR")"
test -z "$_EX_DIR" && _EX_DIR=.

# shellcheck source=./Queries_common.sh
. $_EX_DIR/Queries_common.sh
# disable globbing for star queries (*)
set -f
cat <<EOF
-- Source this file from within mclient using \< Queries_MonetDB.sql
-- If "\f trash" does not work (usually when using content from stdin), set
-- "--interactive" option when starting mclient
-- disable auto commit
\a
-- initially disable performance timing (trace command)
\t none
set schema ds2;
-- FIXME: set correct permissions to select from sys.tracelog as ds2 user
set role sysadmin;
--
$(for q in "${queries[@]}"; do
	aufgabe="$(cut -d'|' -f2 <<<"$q")";
	aufgabe_desc="$(cut -d'|' -f3 <<<"$q")";
	query="$(cut -d'|' -f4 <<<"$q")";
	query_escaped="$(echo -n "$query" | sed 's/\x27/\\\x27/g')";
	echo "\f tab"
	echo "select '--== Query $aufgabe_desc ==--';"
	echo "select '-- tag::${aufgabe}[]';"
	echo "select '-- tag::${aufgabe}-query[]';"
	echo "select '$query_escaped';"
	echo "select '-- end::${aufgabe}-query[]';"
	echo "select '-- tag::${aufgabe}-plan[]';"
	echo "\f raw"
	echo "plan $query"
	echo "\f tab"
	echo "select '-- end::${aufgabe}-plan[]';"
	echo "\f trash"
	echo "$query"
	echo "\f tab"
	echo "select '-- tag::${aufgabe}-timing[]';"
	echo "\f trash"
	# shellcheck disable=SC2028
	echo "\t performance"
	echo "$query"
	# shellcheck disable=SC2028
	echo "\t none"
	echo "\f tab"
	echo "select '-- end::${aufgabe}-timing[]';"
	echo "select '-- tag::${aufgabe}-trace[]';"
	echo "\f rowcount"
	echo "trace $query"
	echo "\f csv+;"
	echo "select ticks as usec, stmt from sys.tracelog;"
	echo "\f tab"
	echo "select '-- end::${aufgabe}-trace[]';"
	echo "select '-- end::${aufgabe}[]';"
done)
EOF