Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revisionNext revision | Previous revision |
| apiload [2025/09/12 09:58] – 159.196.132.18 | apiload [2025/09/12 10:02] (current) – 159.196.132.18 |
|---|
| |
| print("Table created and data inserted successfully!") | print("Table created and data inserted successfully!") |
| | </code> |
| | |
| | Specific database connection details are omitted. |
| | |
| | This python script can be called recursively to load multiple different endpoints, country, or date time. |
| | An example of loading IDX endpoints: |
| | <code bash> |
| | #!/bin/bash python3 load.py 2020-01-01 affected-people/refugees-persons-of-concern IDX_Refugees python3 load.py 2020-01-01 affected-people/humanitarian-needs IDX_Humanitarian python3 load.py 2020-01-01 affected-people/returnees IDX_returnees echo "Loaded 'Affected people'" python3 load.py 2020-01-01 coordination-context/operational-presence IDX_OperationalPresence python3 load.py 2020-01-01 coordination-context/funding IDX_Funding python3 load.py 2020-01-01 coordination-context/conflict-events IDX_ConflictEvents python3 load.py 2020-01-01 coordination-context/national-risk IDX_NationalRisk echo "Loaded 'Coordination Context'" python3 load.py 2020-01-01 food-security-nutrition-poverty/food-security IDX_FoodSecurity python3 load.py 2020-01-01 food-security-nutrition-poverty/food-prices-market-monitor IDX_FoodPrices python3 load.py 2020-01-01 food-security-nutrition-poverty/poverty-rate IDX_PovertyRate echo "Loaded 'Food Security Nutrition Poverty'" python3 load.py 2020-01-01 geography-infrastructure/baseline-population IDX_BaselinePopulation echo "Loaded 'Geography Infrastructure'" python3 load.py 2020-01-01 climate/rainfall IDX_Rainfall echo "Loaded 'Climate Rainfall data'" |
| </code> | </code> |
