opencdms-api

OpenCDMS server uses Python FastAPI to expose a web interface for opencdms-app and other supported CDMSs.

Application architecture

The application is designed to contain smaller child applications with separate set of configuration, i.e. separate database conenction. Routes from this child applications will be combined in src/main.py

Directory structure

The root directory has two main directories:

src : Contains all the applications/CDMS wrappers
tests : Contains all the tests

Apart from these two directories we also have three docker-compose files:

docker-compose.yml For development
docker-compose.prod.yml For production deployment (contains traefik config for https)
docker-compose.test.yml For testing

These docker-compose files have all the necessary services to run opencdms-api

There is also a dockerfile where we have defined the docker image for opencdms-api service

Project root

.
├── create_mch_english_basic_tables.sql
├── docker-compose.prod.yml
├── docker-compose.test.yml
├── docker-compose.yml
├── dockerfile
├── entrypoint.sh
├── init_climsoft_db.py
├── makefile
├── mch.dbn
├── mch.dockerfile
├── MCHtablasycampos.def
├── poetry.lock
├── pyproject.toml
├── README.md
├── requirements-old.txt
├── requirements.txt
├── scripts
│   └── load_initial_surface_data.sh
├── src
│   └── opencdms_api
│       ├── config.py
│       ├── db.py
│       ├── deps.py
│       ├── __init__.py
│       ├── main.py
│       ├── middelware.py
│       ├── models.py
│       ├── router.py
│       ├── schema.py
│       └── templates
├── tests
│   ├── conftest.py
│   ├── __init__.py
│   └── test_router.py
└── traefik
    └── traefik.toml

Running Development Server

The easiest way to go is running docker-compose up -d --build

Also, you can do the following:

$ pip3 install virtualenv 
$ virtualenv venv 
$ source venv/bin/activate
$ pip install -r requirements.txt
$ uvicorn src.main:app --reload --host 0.0.0.0 --port 8000

Note: You have to run database instance separately. Go to this repository for detail. https://github.com/opencdms/opencdms-test-data

Running The Tests

Each master release should pass all the To check if the tests are as expected or to add new feature or to fix some issue, you can run the tests on your own.

To run the tests, you just need to run docker-compose -f docker-compose.test.yml up --build

Check the logs for error.

How to access surface, climsoft, pygeoapi or mch API

OpenCDMS API server is a FastAPI application. surface, climsoft, pygeoapi, mch servers are mounted to this FastAPI application. When mounting these child applications, we also have enforced an Auth Middleware. So, if you want to access the endpoints on these child applications, you have to make authenticated request.

To get an access token using default username and password:

$ curl -X 'POST' \
  'http://localhost:5070/auth' \
  -H 'accept: application/json' \
  -H 'Content-Type: application/json' \
  -d '{
  "username": "admin",
  "password": "password123"
}'

Say, it returns

{
  "access_token": "eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJzdWIiOiJhZG1pbiIsImV4cCI6MTY0MzgzMDUzMiwidG9rZW5fdHlwZSI6ImFjY2VzcyIsImp0aSI6ImEzM2Q4OWMyLTNlNmEtNDJlYS04MGZjLWViZjEzNTcyZjU5MSIsInVzZXJfaWQiOjF9.dp_wPSDZwL4HAN8JWCWyGRlL0s8gRvWKASUeDPQQygY"
}

Now you can make request to protected endpoints using this access token as Bearer token.

Here is an example:

$ curl -X 'GET' \
  'http://localhost:5070/climsoft/v1/acquisition-types/?limit=25&offset=0' \
  -H 'accept: application/json' \
  -H 'Authorization: Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJzdWIiOiJhZG1pbiIsImV4cCI6MTY0MzgzMDUzMiwidG9rZW5fdHlwZSI6ImFjY2VzcyIsImp0aSI6ImEzM2Q4OWMyLTNlNmEtNDJlYS04MGZjLWViZjEzNTcyZjU5MSIsInVzZXJfaWQiOjF9.dp_wPSDZwL4HAN8JWCWyGRlL0s8gRvWKASUeDPQQygY'

which will return something like this:

{"message":"Successfully fetched acquisition types.","status":"success","result":[]}

You can use Postman to make this requests easily.

Improved Swagger Experience for Climsoft

When you go to climsoft swagger doc on your server, follow these steps:

Access Denied

Auth Button

Login Form

Authorized

Success

Repository Settings

To deploy on a server using the deployment scripts (in .github/workflows) we need to setup following action secrets on github:

AWS_PRIVATE_KEY_LATEST [used to login to server]
AWS_PRIVATE_KEY_STABLE [used to login to server]
HOSTNAME_LATEST [ip address/fqdn to ssh into] 
HOSTNAME_STABLE [ip address/fqdn to ssh into]
AWS_ACCESS_KEY_ID [to use with aws boto3]
AWS_SECRET_ACCESS_KEY [to use with aws boto3]
LATEST_HOST_FQDN [ fqdn where you want the api available ]
STABLE_HOST_FQDN [ fqdn where you want the api available ]
USERNAME [username on deployment server]

Note: The deployment scripts deploy to api-latest.opencdms.org whenever a push is made to main branch. The deployment scripts deploy to api.opencdms.org whenever a release is made.

LATEST and STABLE suffix/prefix in the action secrets depicts whether the variable will be used in deployment to latest or stable server.

Setting up host for deployment

To deploy on a server using the deployment scripts (in .github/workflows) we need docker, docker-compose and openssh installed on the server. Also, we are sending some variables to deployment server via ssh. So, you need to edit /etc/ssh/sshd_config file on the deployment server. Find and change this line

AcceptEnv  LANG LC_*

AcceptEnv HOST_FQDN AWS_ACCESS_KEY_ID AWS_SECRET_ACCESS_KEY LANG LC_*

Known issues

Rapidly deploying the code multiple times in a short period of time can cause Let's Encrypt to hit a rate limit - this results in the security certificate not being issued (wait before deploying again).

Best Flask open-source libraries and packages

Opencdms api