# Database Automation

This repository contains scripts for performing daily updates to the following database tables:

* [News](https://moshferatu.dev/moshferatu/database/src/branch/main/database/news/create_table.sql)
* [OHLC](https://moshferatu.dev/moshferatu/database/src/branch/main/database/ohlc/create_table.sql)

These scripts are meant to be run as Docker containers, and the necessary Dockerfiles are included.

Docker Compose files are available as well in the [Docker Compose repository:](https://moshferatu.dev/moshferatu/docker-compose)

* [News](https://moshferatu.dev/moshferatu/docker-compose/src/branch/main/update-news-data.yaml)
* [OHLC](https://moshferatu.dev/moshferatu/docker-compose/src/branch/main/update-ohlc-data.yaml)

There are also backfill scripts available for recovering from issues where data was not updated as expected.

## Dependencies

* [Database](https://moshferatu.dev/moshferatu/database)
* [News](https://moshferatu.dev/moshferatu/news-automation)
* [OHLC](https://moshferatu.dev/moshferatu/ohlc)

---