airflow-api2db-exercise

Prerequisites

• Install docker
• Install docker-compose
• Create docker/airflow-scheduler/mongo.env like below

  MONGODB_USER=airflow
  MONGODB_PWD=airflow
  MONGODB_HOST=mongoservice
  MONGODB_PORT=27017
  

• Create docker/airflow-scheduler/fred.env like below

  FRED_API_KEY=<FRED_API_KEY>
  

• Create airflow.env like below to set an account

  _AIRFLOW_WWW_USER_USERNAME=<AIRFLOW_USER>
  _AIRFLOW_WWW_USER_PASSWORD=<AIRFLOW_PWD>
  

 

How to run

• run docker-compose

  $ docker-compose up
  $ docker-compose up --build --remove-orphans --force-recreate
  $ docker-compose up --build --remove-orphans --force-recreate --detach

• stop docker-compose

  $ docker-compose down
  $ docker-compose down --volumes --remove-orphans

 

Data Time

• Data Request Time
  • Upbit Data : every hour from 00:00 (UCT)
  • Google News : every day from 00:00 (Eastern Time: EST EDT)
  • Fred Data : every day from 00:00 (Eastern Time: EST EDT) (missing on weekend & holidays)

 

Check data

$ docker ps -a --filter name=mongo 
$ docker exec -it <CONTAINER ID> /bin/bash    
$ mongo -u airflow -p airflow
$ show dbs
$ use test_db
$ show collections
$ db["<collection_name>"].find()
$ db["USDT-BTC"].find({}).sort({"candle_date_time_utc":1}).limit(1);
$ db.dropDatabase() # to Drop database
$ db["USDT-BTC"].find({}).sort({"utc_time":-1}).limit(1)
$ db["news"].find({}).sort({"etz_time":-1}).limit(1);
$ db["fred"].find({}).sort({"etz_time":-1}).limit(1);

 

(Optional) Prerequisites for MongoDB on local

• Make mongodb user
  • https://medium.com/mongoaudit/how-to-enable-authentication-on-mongodb-b9e8a924efac
• Connecting from a Docker container to a local MongoDB
  • https://tsmx.net/docker-local-mongodb/
• Make docker/airflow-scheduler-local/.env file on like .env sample
  • change MONGODB_USER, MONGODB_PWD
• Use docker-compose-localdb.yaml as docker-compose.yaml

  $ docker-compose -f docker-compose.localdb.yaml up
  $ docker-compose -f docker-compose.localdb.yaml up --build --remove-orphans --force-recreate
  $ docker-compose -f docker-compose.localdb.yaml up --build --remove-orphans --force-recreate --detach

  $ docker-compose -f docker-compose.localdb.yaml down
  $ docker-compose -f docker-compose.localdb.yaml down --volumes --remove-orphans