Initial performance improvement, create PL-PGSQL procedure. Modify many models to comply with performance e.g. add new columns, create indexes.
Update test due to model changes.
Update PROCEDURE
Change to high performance dashboard API.
Remove ReportsSymptoms model. Use native pg instead.
Update SQL and PROCEDURE
Unoptimized reportssymptoms trigger
Improve BOE performance.
Fix topSymptoms has no percentage.
Use global `pg` (shared pool). Fix `mock.py` due to model changes.
Fix return `null` value.
Force using server timezone if not specify
Alter locations: add zipcode, remove createdAt, updatedAt
Add DashboardController.now() to show summary for current week
Make dashboard API support lat - lng query
Update locations.sql
Update SQL scripts
Fix column missing
Create ililog table
Update SQL