Export-API

An API to export data from a Postgres DB to Google Spreadsheet using FastApi, Celery, RabbitMq and The google spreadsheet service.

Requirements

Python 3.9+

Installation

Install the required packages in your local environment (ideally virtualenv, conda, etc.).

pip install -r requirements.txt

Setup

1. Duplicate the .env.example file and rename it to .env
2. Ask a teammate for the .env file

Postgres

1. run this query: CREATE EXTENSION IF NOT EXISTS tablefunc;

Project

Run It

1. Start your app with:

source venv/bin/activate;
python3 -m uvicorn app.main:app --reload --port 9009

2. Go to http://localhost:9009/docs.

Launch Rabbit locally

docker-compose up rabbit

Launch Rabbit Worker

Using with virtual environment activated

source venv/bin/activate;
celery -A app.core.celery_worker worker --loglevel=info

Launch update

Using with virtual environment activated

curl -X POST http://127.0.0.1:9009/api/exports