hackOregonBackEnd/buildOutFromGitRepo.sh at master · stochasticTreat/hackOregonBackEnd · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
#!/usr/bin/env bash
echo "---------------------------------"
echo "buildOutFromGitRepo.sh"
echo "---------------------------------"
echo "This script should be run by entering the command: "
echo "buildOutFromGitRepo.sh"
echo "from the backend git repo's directory."
echo "If the hack oregon back end is in a Vagrant machine, the git directory will be:"
echo " /vagrant "
echo "Current working directory:"
pwd

if [ -e ~/data_infrastructure ]
then
	echo "data_infrastructure folder already exists"
else
	echo "creating data_infrastructure folder"
	sudo mkdir ~/data_infrastructure
fi

echo "current working directory inside buildOutFromGitRepo:"
pwd

sudo chmod 755 hackOregonDbStatusLogger.R
sudo chmod 755 exportTableToTsv.R
sudo chmod 755 ./orestar_scrape/getMissingCommittees.R
sudo chmod 755 addDirectionCodes.sh
sudo chmod 755 buildEndpointTables.sh
sudo chmod 755 buildOutDBFromRawTables.sh
sudo chmod 755 buildScraper.sh
sudo chmod 755 workingTableCreation.sh
sudo chmod 755 makeWorkingCandidateFilings.R
sudo chmod 755 ./endpoints/makeGrassState.R
sudo chmod 755 postSchemaInstallationEndpoints.sh
sudo chmod 755 ./orestar_scrape/bulkLoadScrapedCommitteeData.R
sudo chmod 755 endpoints/candidateByState/buildCandidateByStateEndpoint.sh
sudo chmod 755 makeCCWorkingTransactions.sh
sudo chmod 755 ./orestar_scrape/bulkAddTransactions.R
sudo chmod 755 ./orestar_scrape/getMostRecentTransactions.R
sudo chmod 755 ./endpoints/add_simplified_sub_types.sh
sudo chmod 755 ./endpoints/add_contributor_payee_class_column.sql
sudo chmod 755 ./orestar_scrape/adjustUpdateDates.R
sudo chmod 755 ./orestar_scrape/checkFilesForDlLimit.R
sudo chmod 666 ./orestar_scrape/problemSpreadsheets/errorLog.txt
sudo chmod 755 ./orestar_scrape/adjustUpdateCommitteeScrapeDates.R


#core raw database files
sudo cp -vu ./.Rprofile ~/.Rprofile
sudo cp -vu ./trimTransactionsTable.sql ~/data_infrastructure/trimTransactionsTable.sql
sudo cp -vu ./install.sql ~/data_infrastructure/install.sql
sudo cp -avru ./successfullyMerged ~/data_infrastructure/
sudo cp -vu ./addDocumentationTable.sql ~/data_infrastructure/
sudo cp -vu ./makeImportDatesTable.sql ~/data_infrastructure/
#control script
sudo cp -vu ./buildOutDBFromRawTables.sh ~/data_infrastructure/buildOutDBFromRawTables.sh
sudo chmod 755 getMissingCommittees.sh
sudo cp -vu getMissingCommittees.sh ~/getMissingCommittees.sh
sudo chmod 755 loadEndpoints.sh
sudo cp -vu loadEndpoints.sh ~/loadEndpoints.sh
sudo chmod 755 bulkAddTransactions.sh
sudo cp -vu bulkAddTransactions.sh ~/bulkAddTransactions.sh
sudo chmod 755 ./bulkLoadCommitteeData.sh
sudo cp -vu bulkLoadCommitteeData.sh ~/bulkLoadCommitteeData.sh
sudo chmod 755 loadCandidateFilings.sh
sudo cp -vu loadCandidateFilings.sh ~/loadCandidateFilings.sh
sudo cp -vu exportTableToTsv.R ~/exportTableToTsv.R
sudo chmod 544 dailycron.txt
sudo cp -vu dailycron.txt ~/dailycron.txt
sudo cp -vu hackOregonDbStatusLogger.R ~/hackOregonDbStatusLogger.R
sudo cp -vu hackOregonDbStatusLogger.R ~/data_infrastructure/hackOregonDbStatusLogger.R
sudo chmod 755 ./setPermissionsForCronTab.sh
sudo cp -vu setPermissionsForCronTab.sh ~/setPermissionsForCronTab.sh
sudo chmod 755 ./orestar_scrape/bulkAddTransactionsFromXls.R
sudo cp -vu ./orestar_scrape/bulkAddTransactionsFromXls.R ~/bulkAddTransactionsFromXls.R

#scraper infrastructure
sudo cp -avru ./endpoints ~/data_infrastructure/
sudo cp -avru ./orestar_scrape ~/data_infrastructure/
sudo chmod 755 orestar_scrape/bulkAddTransactions.R


#working tables
sudo cp -vu ./addDirectionCodes.sh ~/data_infrastructure/addDirectionCodes.sh
sudo cp -vu ./moneyDirectionCodes.txt ~/data_infrastructure/moneyDirectionCodes.txt
sudo cp -vu ./workingTableCreation.sh ~/data_infrastructure/workingTableCreation.sh
sudo cp -vu ./workingTransactionsTableCreation.sql ~/data_infrastructure/workingTransactionsTableCreation.sql
sudo cp -vu ./makeWorkingCandidateFilings.R ~/data_infrastructure/makeWorkingCandidateFilings.R
sudo cp -vu ./buildEndpointTables.sh ~/data_infrastructure/buildEndpointTables.sh
sudo cp -vu ./makeCCWorkingTransactions.sh ~/data_infrastructure/makeCCWorkingTransactions.sh
sudo cp -vu ./makeWorkingCommittees.sql ~/data_infrastructure/makeWorkingCommittees.sql
#endpoints
sudo cp -vu ./postSchemaInstallationEndpoints.sh ~/data_infrastructure/postSchemaInstallationEndpoints.sh
sudo cp -vu ./workingCommitteesFromInitialRaw.sql ~/data_infrastructure/workingCommitteesFromInitialRaw.sql


cd
sudo ./setPermissionsForCronTab.sh