Expenses tracker

Run clean docker mysql database

docker run --name mysql-gastos -e MYSQL_ROOT_PASSWORD=pwd -e MYSQL_DATABASE='expenses' -p 3306:3306 -d mysql:5.7.23

Run clean docker metabase

docker run -d -p 3000:3000 --name metabase metabase/metabase

To generate virtual environment

bash venv_creation.sh

This will create a folder named "venv" where a python binary can be found with all the dependencies to run the project

Setting up google sheet acces:

Follow his full instructions on the Google Developers Console web site to create a service account Client ID JSON file. I will call the file gspread-test.json from now on.

After saving gspread-test.json you need to share your document with the given email in the client_email field of the file. Otherwise you’ll get a SpreadsheetNotFound exception when trying to open it.

http://alexsavio.github.io/gspread_oauth2client_intro.html

COnnect to mysql ddbb in terminal

mysql -u user -D expenses -h 127.0.0.1 -p

Roadmap

To generate topics script

venv/bin/python3 generate_topics.py