DatabaseExporter
Exports data from MySQL database into an Excel Spreedsheet. On the NAU project it is used as a gateway for Google Data Studio data exploration.
Should be run once a day and the .xls file available to the Google Data Studio cloud engine in order for NAU Managers to be able drill down data.
The queries should NEVER have reference to individual users. This means that the .xls file should never have the fields “auth_user.*” or “user_id” directly available.
Usage
- Setup a Virtual Environment
- Set the “config.ini” file based on the “config.init.sample”.
- Execute “report.py”
Activate virtual environment and install its dependencies
virtualenv venv --python=python3
source venv/bin/activate
pip install -r requirements.txt --upgrade
Set the “config.ini” file based on the “config.init.sample”.
cp config.init.sample config.ini
vi config.ini
Execute “report.py”
python report.py