#To setup your application
Some steps may require additional dependencies, the following will be enough to cover the major components and doesn't cover dependencies that might typically already be installed (python for example).
git clone https://github.com/gberl001/coffee_monitor_site.git
You will need MySQL or MariaDB installed
Create the schema for the data itself
CREATE SCHEMA `coffee_scale` DEFAULT CHARACTER SET utf8mb4 ;
Execute the following commands to create a user for the site to access data
CREATE USER 'adminuser'@'localhost' IDENTIFIED BY 'adminPa$$word1!';
GRANT ALL PRIVILEGES ON *.* TO 'adminuser'@'localhost';
FLUSH PRIVILEGES;
pip3 install sqlalchemy
pip3 install mysqlclient
I couldn't get this to work on Windows because it needed me to install all sorts of dependencies. I ended up just installing the wheel file from https://www.lfd.uci.edu/~gohlke/pythonlibs/#mysqlclient
pip3 install <path to wheel>
cd app
python3 CreateDB.py