- update date values in
work_times.py
- see total hours for the week:
python work_times.py
- ensure
MySQL
is running on your local machine - create new database: {{ YOUR DATABASE NAME }}
- update
MYSQL_DATABASE
variable inwork_times_mysql_cfg.py
- import database schema:
mysql -u root -h localhost {{ YOUR DATABASE NAME }} < work_times.sql
- un-comment calls to
record_time
method inwork_times.py
to save to database - backup database:
mysqldump -u root -p {{ YOUR DATABASE NAME }} > work_times_backup.sql