Update deploy-on-master-push.yml #12
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| name: Deploy on Master Push v4 | |
| on: | |
| push: | |
| branches: | |
| - master | |
| jobs: | |
| deploy: | |
| runs-on: ubuntu-latest | |
| steps: | |
| - name: Checkout repository | |
| uses: actions/checkout@v2 | |
| - name: Setting up SSH key | |
| run: | | |
| mkdir -p ~/.ssh | |
| echo "${{ secrets.AWS_KEY }}" > ~/.ssh/id_aws.pem | |
| chmod 600 ~/.ssh/id_aws.pem | |
| ssh-keyscan -H ec2-34-224-89-239.compute-1.amazonaws.com >> ~/.ssh/known_hosts | |
| - name: Connect to EC2 and run script | |
| run: | | |
| ssh -i "~/.ssh/id_aws.pem" [email protected] ' | |
| ls; | |
| psql --host=geodb.cfhjsivstphy.us-east-1.rds.amazonaws.com --port=5432 --username=postgres --dbname=geodb; | |
| # echo "Another command"; | |
| # Add more commands as needed | |
| CREATE TABLE khm_geo ( | |
| geo_id VARCHAR NOT NULL, | |
| deped_id VARCHAR, | |
| school_name VARCHAR, | |
| address VARCHAR, | |
| adm0 VARCHAR, | |
| adm1 VARCHAR, | |
| adm2 VARCHAR, | |
| adm3 VARCHAR, | |
| longitude VARCHAR, | |
| latitude VARCHAR | |
| ); | |
| ' |