cleanup_fromvalue

#!/bin/bash

#Cleaning results from test number and all higher numbers

source ./config
source ./params
TEST=$1

pushd "results/${SERVERNAME}"
psql -d results -At -c "SELECT test FROM tests WHERE server='${SERVERNAME}' AND test>=$TEST" | xargs rm -rf
psql -d results -At -c "DELETE FROM test_bgwriter WHERE server='${SERVERNAME}' AND test>=$TEST"
psql -d results -At -c "DELETE FROM test_stat_database WHERE server='${SERVERNAME}' AND test>=$TEST"
psql -d results -At -c "DELETE FROM test_statio WHERE server='${SERVERNAME}' AND test>=$TEST"
psql -d results -At -c "DELETE FROM tests WHERE server='${SERVERNAME}' AND test>=$TEST"
psql -d results -At -c "DELETE FROM test_metrics_data WHERE server='${SERVERNAME}' AND test>=$TEST"
psql -d results -At -c "DELETE FROM test_settings WHERE server='${SERVERNAME}' AND test>=$TEST"
psql -d results -At -c "DELETE FROM test_statements WHERE server='${SERVERNAME}' AND test>=$TEST"
psql -d results -At -c "DELETE FROM test_buffercache WHERE server='${SERVERNAME}' AND test>=$TEST"
popd