db-init.sh

#!/usr/bin/env bash
# TODO: order matters here, also think of a better way of handling this
declare -a table_names=("store" "coffee" "customer" "carries" "sale" "promotion" "promotes")
for name in "${table_names[@]}"
do
    psql -U $POSTGRES_USER -d $POSTGRES_DB -a -f "/db/table/$name.sql"
done

# TODO: order matters here, also think of a better way of handling this
declare -a view_names=("last-quarter-performance" "customer-birthday" "coffee-inventory")
for name in "${view_names[@]}"
do
    psql -U $POSTGRES_USER -d $POSTGRES_DB -a -f "/db/view/$name.sql"
done

# TODO: order matters here, also think of a better way of handling this
declare -a function_names=("avg-customer-per-store" "avg-customer-per-store" "customer-coffee-intensity")
for name in "${function_names[@]}"
do
    psql -U $POSTGRES_USER -d $POSTGRES_DB -a -f "/db/function/$name.sql"
done

# TODO: order matters here, also think of a better way of handling this
declare -a procedure_names=("monthly-coffee-promotion")
for name in "${procedure_names[@]}"
do
    psql -U $POSTGRES_USER -d $POSTGRES_DB -a -f "/db/procedure/$name.sql"
done

# TODO: order matters here, also think of a better way of handling this
declare -a trigger_names=("check-daily-inventory" "coffee-birthday-sale")
for name in "${trigger_names[@]}"
do
    psql -U $POSTGRES_USER -d $POSTGRES_DB -a -f "/db/trigger/$name.sql"
done

psql -U $POSTGRES_USER -d $POSTGRES_DB -a -f /db/seed/$SEED_FILE_NAME.sql