buildEndpointTables.sh

#!/usr/bin/env bash
echo "----------------------------------------------"
echo "    Running script: buildEndpointTables.sh"
echo "----------------------------------------------"
echo "Building out tables for endpoints..."
echo "This script should be run from the directory"
echo "~/data_infrastructure/"
echo "Current working directory:"
pwd

cd ~/data_infrastructure/
echo "Current working directory:"
pwd
# echo "Calling sudo ./endpoints/makeGrassState.R,"
# echo "the script which orchestrates construction of"
# echo "percent grass roots and percent instate data."
# #build the endpoints table.
# sudo ./endpoints/makeGrassState.R hackoregon
echo "Calling sudo ./endpoints/add_cc_grass_roots_in_state.sql,"
echo "the script which orchestrates construction of"
echo "percent grass roots and percent instate data"
echo "from working_committees and cc_working_transactions"
sudo -u postgres psql hackoregon < ./endpoints/add_cc_grass_roots_in_state.sql

echo "Running ./endpoints/campaign_detail/productionCampaignDetail.sql,"
echo "the script that produces the working campaign detail data."
sudo -u postgres psql hackoregon < ./endpoints/campaign_detail/productionCampaignDetail.sql

#candidateByState
echo "Running ./endpoints/candidateByState/buildCandidateByStateEndpoint.sh,"
echo "the script that produces data for candidates by state."
sudo ./endpoints/candidateByState/buildCandidateByStateEndpoint.sh