#!/usr/bin/env bash

# Save SQL query as variable, split to multilines using backslash
sql="                                   \
SELECT                                  \
    SUM(lon) AS 'Lönesumma',            \
    SUM(kompetens) AS 'Tot Kompetens'   \
FROM larare;                            \
"

# Check status before reset
mysql -uuser -ppass skolan -e "$sql"

# Do a reset of the database
for f in ddl dml_insert ddl_migrate ddl_copy dml_update dml_view
do
    mysql -uuser -ppass skolan < $f.sql > /dev/null
done

# Check status after reset
mysql -uuser -ppass skolan -e "$sql"
echo "Should be 330242 and 19."