keykoio/defi-reports repository overview

⁠DeFi reports loader

⁠Project to load data in the database and generate DeFi reports

⁠Prerequisites

Python 3.6

⁠Usage

1. Install dependencies with pip install -r requirements.txt
2. Create the database with docker docker-compose up
3. Connect to the docker container to execute sqls docker exec -it container-id
4. Create tables in the database executing inside the container mysql -uroot -p defi-crawler < ./sql/create-tables.sql
5. Load the necessary data in the tables mysql -uroot -p defi-crawler < ./sql/insert-data.sql
6. Create the env file from the example mv defi-reports/.env.example .env
7. Fill the values in the env file
8. Run the loader python3 defi-reports/src/main