Process controller/golbat data for worker, pokemon, quest and spawnpoint (for defined areas) into seperate stats tables.
Processing is done on interval 15/60/1440/10080 minutes and can be displayed by pre-defined grafana templates.

• tested on: mariadb 10.5/10.6, mysql server 8.0.31
• add Golbat/geojson/geofence.json or setup Koji api, containing your mon scan fences. Golbat will use these fences to write raw area mon stats to db.
• enable worker stats on 5m interval in controller config

• clone Blissey, git clone https://github.com/UnownHash/Blissey.git && cd Blissey
• create stats db and user (user needs to have access to stats/controller/golbat db)
• copy and fill out config, cp default_files/config.ini.example config.ini
• execute setting.run
• add content of crontab.txt to your cron

Blissey needs quest and mon fences in order to aggregate data. 2 ways of doing this:
1 Use Koji

• set config.ini accordingly
• grant sql user access to koji db
• project_golbat, this project should contain your mon fences. Ideally this is same project as used for 2nd point in prerequisites to ensure alligment.
• project_controller, this project should contain your quest fences. Again to assure alligment your controller(Flygon) project would be a logical choice. In case all area quest/mon fences are identical both can point to the same Koji project.

insert ignore into geofences (area,fence,type,coords) values
('Newyork','Newyork_centre','mon','lat1 lon1,lat2 lon2,lat3 lon3,lat1 lon1');

insert ignore into geofences (area,fence,type,coords) values
('Newyork','Newyork_south','mon','lat1 lon1,lat2 lon2,lat3 lon3,lat1 lon1');

insert ignore into geofences (area,type,coords) values
('Newyork','quest','lat1 lon1,lat2 lon2,lat3 lon3,lat1 lon1');

- column fence is only used in case you use subfences for an area(town), will default to area when not included
- first and last coordinate must be the same for column coords
- after changing or adding fences always execute setting.run to populate column st

• Install Grafana, more details can be found at https://grafana.com/docs/grafana/latest/installation/debian/#install-from-apt-repository or if you prefer to use docker https://hub.docker.com/r/grafana/grafana
• Create datasource for stats db
• Add datasource name to config.ini
• After executing settings.run, import the dashboards from Blissey/grafana by selecting + and then import

• depending on changes but to be safe, pull+execute settings.run+update crontab
• replace changed grafana templates