PCSOResultsETL

Extract results from https://pcso.gov.ph/

Steps

Launch browser and open https://www.pcso.gov.ph/SearchLottoResult.aspx (Done)
Search by date range (Done)
Copy values from table (Done)
Transform values (Done)
Save as CSV (Done)
Reset latest flag to 'false' for latest game ids (latest_game_ids.csv) via postman
Run STRAPI locally
Run postman via newman with CSV as input
Run ReactJS app
Test if data was inserted successfully
Upload to S3
Invalidate cache on Cloudfront
Test data on production

Name		Name	Last commit message	Last commit date
Latest commit History 9 Commits
src		src
.gitignore		.gitignore
1_start_servers.sh		1_start_servers.sh
2_start_mvn_and_postman.sh		2_start_mvn_and_postman.sh
3_deploy_to_s3.sh		3_deploy_to_s3.sh
4_stop_all_node.sh		4_stop_all_node.sh
INSERT_GAME_RESULTS.postman_collection.json		INSERT_GAME_RESULTS.postman_collection.json
README.md		README.md
data.csv		data.csv
latest_game_ids.csv		latest_game_ids.csv
pcso.properties		pcso.properties
pom.xml		pom.xml