#!/bin/bash

function build90()
{
    cat _pgperf_create_role.sql

    echo "BEGIN;"

    cat _pgperf_snapshot_install_common.sql
    
    cd 90
    ../_pgperf.pl pg_stat_bgwriter
    ../_pgperf.pl pg_database_size
    ../_pgperf.pl pg_stat_database
    ../_pgperf.pl pg_relation_size
    ../_pgperf.pl pg_stat_user_tables
    ../_pgperf.pl pg_statio_user_tables
    ../_pgperf.pl pg_stat_user_indexes
    ../_pgperf.pl pg_statio_user_indexes
    ../_pgperf.pl pg_stat_user_functions
    ../_pgperf.pl pg_statio_user_sequences
    ../_pgperf.pl pg_current_xlog
    ../_pgperf.pl pg_stat_activity
    ../_pgperf.pl pg_locks
    ../_pgperf.pl pg_stat_statements
#    ../_pgperf.pl pg_statistic
    ../_pgperf.pl pg_stats
    ../_pgperf.pl pgstattuple
    ../_pgperf.pl pgstatindex
    cd ..
    
    echo "COMMIT;"
}

function build91()
{
    cat _pgperf_create_role.sql

    echo "BEGIN;"

    cat _pgperf_snapshot_install_common.sql
    
    cd 91
    ../_pgperf.pl pg_stat_bgwriter
    ../_pgperf.pl pg_database_size
    ../_pgperf.pl pg_stat_database
    ../_pgperf.pl pg_relation_size
    ../_pgperf.pl pg_stat_user_tables
    ../_pgperf.pl pg_statio_user_tables
    ../_pgperf.pl pg_stat_user_indexes
    ../_pgperf.pl pg_statio_user_indexes
    ../_pgperf.pl pg_stat_user_functions
    ../_pgperf.pl pg_statio_user_sequences
    ../_pgperf.pl pg_current_xlog
    ../_pgperf.pl pg_stat_activity
    ../_pgperf.pl pg_locks
    ../_pgperf.pl pg_stat_replication
    ../_pgperf.pl pg_stat_database_conflicts
    ../_pgperf.pl pg_stat_statements
#    ../_pgperf.pl pg_statistic
    ../_pgperf.pl pg_stats
    ../_pgperf.pl pgstattuple
    ../_pgperf.pl pgstatindex
    cd ..
    
    echo "COMMIT;"
}

function build92()
{
    cat _pgperf_create_role.sql

    echo "BEGIN;"
    
    cat _pgperf_snapshot_install_common.sql
    
    cd 92
    ../_pgperf.pl pg_stat_bgwriter
    ../_pgperf.pl pg_database_size
    ../_pgperf.pl pg_stat_database
    ../_pgperf.pl pg_relation_size
    ../_pgperf.pl pg_stat_user_tables
    ../_pgperf.pl pg_statio_user_tables
    ../_pgperf.pl pg_stat_user_indexes
    ../_pgperf.pl pg_statio_user_indexes
    ../_pgperf.pl pg_stat_user_functions
    ../_pgperf.pl pg_statio_user_sequences
    ../_pgperf.pl pg_current_xlog
    ../_pgperf.pl pg_stat_activity
    ../_pgperf.pl pg_locks
    ../_pgperf.pl pg_stat_replication
    ../_pgperf.pl pg_stat_database_conflicts
    ../_pgperf.pl pg_stat_statements
#    ../_pgperf.pl pg_statistic
    ../_pgperf.pl pg_stats
    ../_pgperf.pl pgstattuple
    ../_pgperf.pl pgstatindex
    cd ..
    
    echo "COMMIT;"
}

function build93()
{
    cat _pgperf_create_role.sql

    echo "BEGIN;"
    
    cat _pgperf_snapshot_install_common.sql

    cd 93
    ../_pgperf.pl pg_stat_bgwriter
    ../_pgperf.pl pg_database_size
    ../_pgperf.pl pg_stat_database
    ../_pgperf.pl pg_relation_size
    ../_pgperf.pl pg_stat_user_tables
    ../_pgperf.pl pg_statio_user_tables
    ../_pgperf.pl pg_stat_user_indexes
    ../_pgperf.pl pg_statio_user_indexes
    ../_pgperf.pl pg_stat_user_functions
    ../_pgperf.pl pg_statio_user_sequences
    ../_pgperf.pl pg_current_xlog
    ../_pgperf.pl pg_stat_activity
    ../_pgperf.pl pg_locks
    ../_pgperf.pl pg_stat_replication
    ../_pgperf.pl pg_stat_database_conflicts
    ../_pgperf.pl pg_stat_statements
#    ../_pgperf.pl pg_statistic
    ../_pgperf.pl pg_stats
    ../_pgperf.pl pgstattuple
    ../_pgperf.pl pgstatindex
    cd ..
    
    echo "COMMIT;"
}

function build94()
{
    cat _pgperf_create_role.sql

    echo "BEGIN;"
    
    cat _pgperf_snapshot_install_common.sql
    
    cd 94
    ../_pgperf.pl pg_stat_archiver
    ../_pgperf.pl pg_stat_bgwriter
    ../_pgperf.pl pg_database_size
    ../_pgperf.pl pg_stat_database
    ../_pgperf.pl pg_relation_size
    ../_pgperf.pl pg_stat_user_tables
    ../_pgperf.pl pg_statio_user_tables
    ../_pgperf.pl pg_stat_user_indexes
    ../_pgperf.pl pg_statio_user_indexes
    ../_pgperf.pl pg_stat_user_functions
    ../_pgperf.pl pg_statio_user_sequences
    ../_pgperf.pl pg_current_xlog
    ../_pgperf.pl pg_stat_activity
    ../_pgperf.pl pg_locks
    ../_pgperf.pl pg_stat_replication
    ../_pgperf.pl pg_stat_database_conflicts
    ../_pgperf.pl pg_stat_statements
#    ../_pgperf.pl pg_statistic
    ../_pgperf.pl pg_stats
    ../_pgperf.pl pgstattuple
    ../_pgperf.pl pgstatindex
    cd ..
    
    echo "COMMIT;"
}

export LANG=C

echo pgperf_snapshot_install90.sql
build90 > pgperf_snapshot_install90.sql

echo pgperf_snapshot_install91.sql
build91 > pgperf_snapshot_install91.sql

echo pgperf_snapshot_install92.sql
build92 > pgperf_snapshot_install92.sql

echo pgperf_snapshot_install93.sql
build93 > pgperf_snapshot_install93.sql

echo pgperf_snapshot_install94.sql
build94 > pgperf_snapshot_install94.sql