pg_fact_loader-sql-maker.sh

#!/usr/bin/env bash

set -eu

last_version=1.7
new_version=2.0
last_version_file=pg_fact_loader--${last_version}.sql
new_version_file=pg_fact_loader--${new_version}.sql
update_file=pg_fact_loader--${last_version}--${new_version}.sql

rm -f $update_file
rm -f $new_version_file

create_update_file_with_header() {
cat << EOM > $update_file
/* $update_file */

-- complain if script is sourced in psql, rather than via CREATE EXTENSION
\echo Use "CREATE EXTENSION pg_fact_loader" to load this file. \quit

EOM
}

add_sql_to_file() {
sql=$1
file=$2
echo "$sql" >> $file
}

add_file() {
s=$1
d=$2
(cat "${s}"; echo; echo) >> "$d"
}

create_update_file_with_header

# Only copy diff and new files after last version, and add the update script
add_file schema/2.0.sql $update_file
add_file functions/subscription.sql $update_file
add_file functions/subscription_rel.sql $update_file
add_file functions/logical_subscription.sql $update_file
add_file functions/queue_table_delay_info.sql $update_file
add_file views/queue_deps_all.sql $update_file
add_file views/queue_deps_all_with_retrieval.sql $update_file

# make new version file
cp $last_version_file $new_version_file
cat $update_file >> $new_version_file